8 years IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2008, 2005, 2000 in Production, Testing and Development. • Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member. • Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation. • Experience in coordinating with users in gathering source data files, defining data elements, business rules, data and process flow documentation, prepare High level and Low level design documents. • Experience in installation, configuration of MS SQL Server 2000, 2005, 2008, 2008R2 and 2012. • Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor. • Knowledge of Relational Database Management systems. • Experience in Database Backup, Recovery and Disaster Recovery procedures. • Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and exception handlers. • Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables. • Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. • Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization. • Install and Configure SQL Server 2005, 2008, 2008R2 on Virtual Machines. • Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS. • Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management. • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using SSMS on SQL Server 2005/2008/2012 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically. • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities. • Extensively worked on Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts. • Having experience on Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc. • Good experience in creating SQL Server Analysis Projects (SSAS) using SQL Server 2000/2005/2008. • Good Knowledge working with Facts, Dimensions, Multi-Dimensional Cubes. • Experience in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence. • Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill
26 freelance font une offre moyenne de $233 pour ce travail
Hi, I can deliver this project within a good timeframe. I would need to ask a few questions to clarify the scope. Please send me a message if you're interested. Thank you.
Hello, It seems I am the right guy for this job as I have been into data warehousing since 5 years and can surely help you put with a quality solution. Thanks!