SUMMARY:

• A Microsoft certified professional, SQL Server Database Administrator with more than 6+ years of experience with a total of 9 years of IT experience.
• I have been working in data Migration, Consolidation, troubleshooting and supporting production environment of SQL Server 2016/2014/2012/2008 R2/2008.
• Worked on different high availability and disaster recovery solutions.
• In addition, I have been working in stressed and multi - tasked environments in timely manner.
• I am a keen, hard worker and self-motivated professional looking for a stable position in a growing organization to utilize my experience and knowledge.
• Installed, configured, deployed and administered SQL Server
• Upgrade and migration,Apply Patches & Hot fix of databases
• SQL Server security, ensuring database integrity, stability and system availability
• High availability solutions mainly mirroring, Windows Azure, replication, log shipping, clustering and AlwaysOn.
• Performance tuning, Physical Data modeling with DBMS
• SQL Server backup, cloning and restoring of databases.
• SQL Server Error log, Activity Monitor, Mirroring monitor and others.
• Third party tools like Ignite, Avamar, OEM, Zenoss and solar wind
• SSIS and SSRS package Deployments, Data transformation system (ETL).
• SQL Environment Capacity building
• Maintenance plan, database mail, database operators and alerts.
• Documentations including the baseline for SQL server, High Availability and disaster recovery plans documentation
• Storage area network (SAN)
• Window Server 2016/2012 R2/2012/2008R2/2008
• 24/7 On call support

TECHNICAL SKILLS:

Databases: MS SQL Server 2016, 2014, 2012, 2008/R2, 2008

Programming Language: Transact SQL

GUI: Import/Export, SQL Server Integration Services.

SQL Server Tools: SQL Profiler, Query Analyzer, Export & Import, DTS, SSIS, SSRS

Operating System: Windows server 2016/2012 R2/ 2012/2008, NT & Windows

Third party Tools: Ignite, Avamar, OEM, Zenoss and solar wind

PROFESSIONAL EXPERTISE:

Confidential, Pittsburgh, PA

SQL DBA

Environment: -MSSQL Server 2014/2012/2008/2005 , Windows Server 2008/2012/2012 R2 Operating systems, SSIS and SSRS.

Responsibilities:

• Monitor database performance and identify areas for optimization.
• Experienced in high availably solution, including Mirroring and clustering
• Database migration to SQL Server 2012, 2014 and 2016
• Experience in performance tuning, troubleshooting and query optimization
• Installation and configuration
• Deploying software updates and patch management
• Maintenance plans, Back-up and recovery strategies
• Dynamic management views (DMV) and dynamic management functions(DMF)
• Database Tuning Advisor (DTA), profiler, extended events, Activity Monitor and Perfmon
• Database and schema management
• Configured database mail, alert and jobs for the various backup, restore, maintenance plans
• Respond to email and tickets in a professional manner and resolve issues
• On call 24/7 support to databases on weekly rotation.

Confidential, Pittsburgh, PA

SQL DBA

Environment: MSSQL Server 2016/2014/2, Windows Server 2008/2012/2012 R2 /2016, Operating systems, SSIS and SSRS.

Responsibilities:

• Monitor database performance and identify areas for optimization.
• Experienced in high availably solution, including Mirroring, clustering and AlwaysOn.
• Database migration to SQL Server 2012, 2014 and 2016
• Experience in performance tuning, troubleshooting and query optimization
• Installation and configuration of Clustering and SQL server
• Deploying software updates and patch management
• Managing data and log files
• Maintenance plans
• Back-up and recovery strategies
• Dynamic management views (DMV) and dynamic management functions(DMF)
• Database Tuning Advisor (DTA), profiler, extended events, Activity Monitor and Perfmon
• Used third party tools such as Ignite, Avamar, OEM, Zenoss and solar wind
• Database and schema management
• Configured database mail, alert and jobs for the various backup, restore, maintenance plans
• Respond to email and tickets in a professional manner and resolve issues
• On call 24/7 support to databases on weekly rotation.

Confidential, Philadelphia, PA

SQL Server DBA

Environment: SQL Server 2012/ 2008R2/2008/2005, Windows 2008R2/2008/2003 Server, Clustered

Responsibilities:

• Determining permission for effective Security
• Backup, restore and maintenance plan
• High availability and disaster recovery solutions like clustering, replication, mirroring and log shipping
• Installation of new servers and upgrade of existing servers with regard to service packs
• Data migration and upgrade
• Stored procedures and functions in test and non-production environments
• SQL Server policy based management System
• Managed snapshot and merge replication
• Rebuild and reorganized fragmented indexes using DBCC and stored procedures
• Managed database mail and created job
• On call 24/7 support to databases on weekly rotation.

Confidential

Junior SQL Server DBA

Environment: MS SQL Server 2008/2005, Windows Server 2003/2008

Responsibilities:

• Supported deployment of modules on Staging and then promoted to production servers
• Gathered end user requirements through meetings with manager and users
• Utilized joins and functions as appropriate to achieve project requirement
• Created triggers and constrains for the purpose of meeting business needs
• Communicated with other staff to improve processes, solve problems and resolve conflict
• Administered Production, development and test servers
• Identified all issues and reported to the project manager for resolution
• Worked in a large team environment, people with mixed skills
• Ensures successful, daily backups and guaranteed recoverability Responds to monitoring alerts and high severity problem tickets, applying analytical, problem solving, and resolution skills to handle scenarios
• Imported and Exported data from Excel, SQL server and text files
• Performed Data Scrubbing and Validation for implementation in production environment
• Produced custom reports as per business requirement for users at various levels
• Implemented auto alerts, messaging & notifications