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
27 freelance ont fait une offre moyenne de 235 $ 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!
Hello Sir, We are an Indian development company here. we have checked your posted details here and want more clarification in it, so message us to discuss on it more then we will able to move on it. Thanks