SUMMARY

• Microsoft certified senior SQL Server database Administrator with 5+ years of experience in planning, designing, implementing SQL Server databases, performance tuning, setting up and managing high availability and disaster recovery (HADR) solutions.
• 5+ years of hands on experience in SQL Server database administration with various industries like communication, Banking and IT Consulting Companies.
• Provided 24 X 7 dedicated supports for production database servers.
• Installed and configured different versions of SQL Server (SQL Server 2005, SQL Server 2008R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016) in non - prod and prod environments.
• Monitored, fine-tuned and trouble shot performance issues in test, development and production servers.
• Configured and applied SQL Server Service Packs and Hot Fixes to all Production and non-prod database servers.
• Created maintenance plans for consistency checks, and maintained indexes and statistics.
• Planed, designed and Implemented two and three node clusters and configured MS SQL on the clusters.
• Worked on daily activities like jobs monitoring, space alerts, troubleshooting, backup verification and jobs scheduling.
• Planned, Implemented and managed HADR solutions like log shipping, mirroring, clustering, Replication and Always on.
• Implemented and configured transactional replication for reporting instance as subscriber for production use.
• Have an excellent experience in Creating Views, stored procedures and other database objects using T-SQL.
• Created SSIS packages for maintenance and data extraction, transformation and loading (ETL).
• Created reports using SSRS for different purposes.
• Worked with SQL server Profiler, and generated traces to optimize the performance of the database.
• Have extensive experience in using several third party tools to monitor and optimize the performance of prod and Non-prod servers.
• Performed index maintenance based on the fragmentation level of various tables.
• Resolved locking and blocking issues and worked on active directory.
• Planned and modified permission issues in the production servers and provide only the minimum required permission to the users on production database systems.
• Assisted other teams in pointing out bottlenecks, and recommended solutions.
• Profound understanding of Software Development Life Cycle.
• Implemented and maintained policies, procedures and standards to ensure security and integrity non-prod and production data.
• Experience in upgrading and migration from MS SQL Server 2005 to MS SQL Server 2008R2, MS SQL Server 2008R2 to MS SQL Server 2012 and MS SQL Server 2012 to MS SQL Server 2014.
• Deployed different applications using PowerShell.
• Worked on virtualizing the physical servers using VM-ware.

TECHNICAL SKILLS

Database Admin: PowerShell, Database Engine Tuning Advisor, SQL Execution Planer

Relational DBMS: Microsoft SQL Server 2008/2008R 2/2012/2014/2016 , Microsoft Access.

Server operating systems: Windows Server 2003/2008/2008 R2/2012

Database Programming: T-SQL, PL/SQL.

ETL tools: MS SQL Server integration services /SSIS/.

Reporting: Power BI, SQL Reporting Service /SSRS/.

Third party tools: Spotlight, Red Gate, Idera SQLdm.

Microsoft office tools: Microsoft Word, Microsoft PowerPoint, Microsoft Excel

PROFESSIONAL EXPERIENCE

Confidential, Rockville MD

SQL Server DBA/Developer

Responsibilities:

• Providing 24 x 7 support for a highly transactional production environment.
• Monitoring, fine-tuning & trouble shooting Database Server performance and Windows server issues.
• Installing and configuring SQL Server in a Test, Development and Production Environment
• Applying SQL Server Service Packs and Hot Fixes periodically to Production and non-production servers.
• Creating maintenance plan for database backups, optimizing (update statistics and reorganize index), checking database consistency and performing maintenance cleanup tasks.
• Planning database deployment and configurations.
• Configured SQL server on two and three node clusters in a production environment.
• Performing regular database administration activities such as jobs monitoring, troubleshooting, backup verification and jobs scheduling as well as responding to disk space alerts on a daily basis.
• Implementing HADR solutions including log shipping, mirroring, clustering, replication and Always-On Availability Groups.
• Implemented cluster based mirroring from one data center to another data center.
• Developing SSIS packages to extract, transform, and load (ETL) data from different sources.
• Used MSSQL Profiler and generated traces to optimize the performance of the database.
• Solving performance issues associated with missing or fragmented indexes.
• Occasionally work on Active directory such as adding new users and managing permissions.
• Automating maintenance activities on Database tuning by setting configuration parameters using PowerShell.
• Implemented and maintained policies, procedures and standards to ensure security and integrity of test and production data.
• Performing index rebuilding on a weekly basis due to high volume of I/O.
• Resolving different performance issues like high usage of system CPU, Disk, Deadlocks and transaction per/sec.
• Monitoring and tuning the performance of the server using third party tools like Spot light and IDERA diagnostic manager.
• Work on virtualizing the physical servers using VM-ware; Installed and configured windows server and SQL server on the virtual machines.
• Document information about the configuration and organization details about all the servers in an organized manner.

Confidential, Washington, DC

SQL Server DBA/Database Analyst

Responsibilities:

• Designed and implemented multiple systems using MS SQL Server
• Prepared Estimates for Database, table size growth.
• Installed and Configured MS SQL Server, applied Service Packs and Hot Fixes.
• Provided 24×7 dedicated support to all Production, development and clustered servers.
• Installed and configured Microsoft Clustered SQL Servers.
• Responsible for backup, restoration, maintenance plans and database security.
• Configured High Availability and Disaster Recovery (HADR) methods including Mirroring, log shipping, clustering, and Always on availability groups.
• Maintained file groups for VLDB’s and the transaction log monitoring for VLDB’s.
• Created Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Developed database monitoring and tuning strategies.
• Implemented MSSQLServer security policies and granted object level permissions.
• Loaded data using BCP utility.
• Configured Log shipping and created Standby server.
• Involved in Upgrading the MS SQL Server 2008R2 to MS SQL 2012.
• Configured Log shipping from the production server to the reporting server.
• Migrated DTS packages used for executing the required tasks to SSIS packages of a current SQL version.
• Scheduled Jobs and Maintenance Plans for Development & Production environment for backup and recovery, replication verification, database integrity verification and updating indexes.
• Implemented and configured Transactional replication.
• Created documentation to install SQL Server, apply service packs, hot fixes and clustering installation.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Involved in database builds and change control process.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Automate DBCC maintenance activities on Databases, Tuning of Server by setting Configuration parameters.

Confidential, Silver Spring, MD

Database Administrator (DBA)/Developer

Responsibilities:

• Installed and Configured SQL Server.
• Updated MS SQL Server 2012 to MS SQL Server 2014.
• Migrated data from old version of MS SQL to latest version.
• Created Tables, Views, Indexes and otherSQLjoins.
• Developed T-SQL(DDL, DML) statements, and Data Integrity constraints.
• Conducted Performance Tuning and Query Optimization.
• Solved Validation issues.
• Used Index Tuning Wizard,SQLProfiler and Windows Performance Monitor for monitoring and tuningSQLServer Performance.
• Worked on maintenance tasks like Patching, running Scripts and scheduling them in Task Manager.
• Created Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Migrated Data from old versions of MS SQL.
• Implemented Load balancing Replication across the Databases.
• Performed Database Refresh tasks from Production to Development and Staging Servers.
• Configured High Availability and Disaster Recovery (HADR) methods including Mirroring, log shipping, clustering, and Always on availability groups.
• Connected, imported, shaped, and transformed data using SSIS for business intelligence (BI)
• Deployed the created SSIS packages in Development and Testing environments.
• Created SSRS reports using complex SQL Queries/Stored Process which have sub-reports, Drill-Down reports and charts.
• Visualize data, author reports, and schedule automated reports using SSIS/SSRS.
• Performed index maintenance at regular intervals for better performance.
• Developed SSIS packages to extract, transform, and load (ETL) data from/into different sources.
• Created data sources, connection strings and defined the datasets for generating reports report.
• Created Views, stored procedures and other database objects using T-SQL.