SUMMARY:

• 7+ years of IT experience in Development, Database Administration, Design, Support of MS SQL Servers 2012/2008R 2/2008/2005/2000 in Production, QA, Development environments & Replication and Cluster Server Environments.
• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, running Database Consistency Checks using DBCC commands.
• Extensive experience in implementing high availability solutions like different replication models (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines.
• Implemented clustering in VMware environment.
• Hands on configuring Always on Availability groups.
• Overall database design, such as creating normalized databases, tune queries, assigning proper indexes, creation of triggers and stored procedures.
• Experience in Data Modeling using ERWIN.
• Experience with Database Backup, Recovery and Disaster recovery procedures.
• Experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services.
• Excellent knowledge in RDBMS concepts and constructs.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages
• Experience in working with version controlling tools for managing SQL scripts and changes that are going to production.
• Experienced in importing and exporting the data between homogenous and heterogeneous systems using various Extraction Transformation and Loading (ETL)
• Import & Export of various data formats using DTS, BCP, Bulk Insert and SQL 2005 Integration Services.
• Transformed data from one server to other servers using Bulk Copy Program (BCP) and Data Transformation Services (DTS).
• Documented disaster recovery plans and participated disaster recovery drills.
• Good understanding of capacity planning.
• Experience in using the stored procedures, INFORMATION SCHEMA, System views and in - built Global variables for the instant analysis.
• Good knowledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, effective querying and Business Analysis Requirements.
• Good knowledge of Data modeling including Physical and logical data modeling using ERWIN, VISIO.
• Experience in configuring IIS and XML.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Hands on experience in working with System Center Operations Manager (SCOM) and Ignite.
• Used third party tools like Litespeed, Red gate, Idera and diagnostic manager and Veritas netbackup.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer
• Derived and documented the root cause analysis for production issues.
• Flexible and versatile to adapt to any new environment and work on multiple projects.
• Provided 24/7 support for Production, Development & Test Servers of MS SQL Servers.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2012/2008/2005/2000/7.0 Windows XP Professional, Vista and Windows 7

Databases: MS SQL Server, 2012, 2008R2, 2008, 2005, 2000, MYSQL, Oracle, MS Office Access 97/2000/2003.

ETL TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Data Modeling Tools: Erwin, Red gate, Litespeed, Idera

Languages: T-SQL, C/C++, C#, JavaScript, Visual Studio2005/2003, ASP.NET, VB.NET

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator

Responsibilities:

• Experience in Data Modeling using ERWIN.
• Experience with Database Backup, Recovery and Disaster recovery procedures.
• Experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services.
• Excellent knowledge in RDBMS concepts and constructs.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages
• Experience in working with version controlling tools for managing SQL scripts and changes that are going to production.
• Experienced in importing and exporting the data between homogenous and heterogeneous systems using various Extraction Transformation and Loading (ETL)
• Import & Export of various data formats using DTS, BCP, Bulk Insert and SQL 2005 Integration Services.
• Transformed data from one server to other servers using Bulk Copy Program (BCP) and Data Transformation Services (DTS).
• Documented disaster recovery plans and participated disaster recovery drills.
• Good understanding of capacity planning.
• Experience in using the stored procedures, INFORMATION SCHEMA, System views and in - built Global variables for the instant analysis.
• Good knowledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, effective querying and Business Analysis Requirements.
• Good knowledge of Data modeling including Physical and logical data modeling using ERWIN, VISIO.
• Experience in configuring IIS and XML.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels