SUMMARY:

• IT Professional with over 8 years of experience as DBA. Excellent interpersonal skills in communicating with various business units, IT Teams, and vendors. Strong incident - problem management skills. Exceptional skills in database architecture, performance tuning and optimization, database administration, disaster recovery, backup/restore, and database security
• Over 8 years of experience with MS SQL SERVER 2014, 2012, 2008R2, 2008/2005 Database Development and Administration (DBA) in Windows environment.
• Expert in database server upgrade from lower version (SQL 2005/2008/2008 R2) to higher version (SQL 2012/2014).
• Managed business expectation by providing HA/DR solution like Clustering (active-active, active-passive), AlwaysON (Availability group and WFCI), Mirroring, Log Shipping, Replication to achieve RPO and RTO requirement.
• Management of complex database environment (over 100 SQL database instances) and capacity planning for database growth monitoring.
• Experience in PROACTIVE monitoring which reduced databases related incident count by more than 75%.
• Expert in SSRS, maintained more than 200 reports, scheduled them (data-driven subscription), setup of scale-out deployment, reduced SSRS load by utilizing execution snapshot, created history snapshot for audit purpose.
• Expert in Performance Tuning and Optimization.
• Expert in maintenance (backup, index, checkdb) of VLDB (1TB) database, partition, and compression
• Implemented Resource Governor to control run away queries.
• Experience with daily Change management (CAB) procedure to document changes affecting environment.
• Expert in creating SOP for SQL Installation (Stand Alone, Cluster), SQL Patching, security (enforcing SOX), Mirroring, Log Shipping, AlwaysON.

PROFESSIONAL EXPERIENCE:

Confidential - New Jersey

Sr. SQL Server DBA

Responsibilities:

• Performing SQL Installation, SQL Patching, Security permission (enforcing standards for SOX, PCI applications), Configuration, Always ON.
• Support of regular database release and migration.
• Implemented Database Maintenance tasks to reorganize and rebuild Indexes, implement Database Integrity Checks (DBCC) and Update Statistics on weekly basis.
• Monitoring daily health check reports and taking needed action.
• Working with development team and application team for DR test.
• Upgrading and migrating SQL server from lower version 2008 to SQL 2014 and SQL 2016 and setup always on.

Confidential - New York City

Senior SQL Server DBA

Responsibilities:

• Working on SQL environment (100+ database servers) to reduce licensing cost and leveraging resource governor to provide needed resources in shared infrastructure.
• Experience working with Windows server, including Active Directory and also working with Physical and Virtual Machine.
• Doing weekly DevOPS release by utilizing github and TFS
• Regular code review before pushing any code to prod/ non-prod environment.
• Maintenance of VLDB database of size 3TB
• Creating and Scheduling PowerShell reports on non-prod environment and helping developers to write T-SQL scripts.
• Worked with SSIS ETL data to perform Extract, transform and load data of our data ware house application and also working with SSRS to create reports.
• Create SOP for Standard DBA/Development procedure like Patching, Installing SQL, and Migration.
• Experience with PTO (Performance Tuning and Optimization) and code review.

Confidential - New York

SQL Server DBA

Responsibilities:

• Created SOP for Migration ( ), SQL Installation, SQL Patching, Security (enforcing standards for SOX, PCI applications), Mirroring, Log Shipping, AlwaysON.
• Corrected SQL Licensing model to utilize all available CPU in SQL 2014 cluster.
• Responsible for performance tuning of various application.
• Maintenance of VLDB database of size 3.5TB
• Administration of SSRS report, subscription and security, as well as troubleshooting SSRS issues.
• Responsible for creating SSIS packages according to requirement as well as deploying and monitoring SSIS jobs.
• Created SSIS package to automate some of DBA tasks to collect data to central repository database.
• Managed non-production database servers in AWS to scale up/down on demand.
• Worked with EMR (Electronic Medical Record) and EHR (Electronic Health Record) application. I also have worked with NextGen application and database with database size of 3.5 TB.

Confidential - New Jersey

SQL Server DBA

Responsibilities:

• Consolidating SQL environment to reduce licensing cost and leveraging resource governor to provide needed resources in shared infrastructure.
• Administration of SSRS report, subscription and security, as well as troubleshooting SSRS issues.
• Responsible for creating SSIS packages according to requirement as well as deploying and monitoring SSIS jobs.
• Created SSIS package to automate some of DBA tasks to collect data to central repository database.
• Use of CyberArc for Privileged Account Management (sa, service account, application account) for security audits.

Confidential - New York

SQL Server DBA

Responsibilities:

• Installed/Upgraded and Configured SQL Server for SQL 2014, 2012, 2008 R2, 2008, and 2005 for standalone and cluster environment (active/active, active/passive).
• Maintained and deployed Central Repository databases to gather Server and Database related information to generate Health Check PowerShell Reports on daily basis for complex 40+ production database server (100+ production databases) environment.
• Involved in various Root cause analysis reports for reactive situation and worked on long term resolution for repeating problems.
• Administration of SSRS report, subscription and security, as well as troubleshooting SSRS issues.
• Implemented database compression, partition and resource governor of data warehouse database with size of 2TB with 1TB (3TB total size) of storage savings
• Designed the Backup-Recovery plans to minimize the data loss and faster recovery.
• Troubleshooting Stored Procedures and Queries performances using SQL Server Profiler, Performance Monitor, DBCC Commands and Dynamic Management Views (DMVs).

Confidential - VA

SQL Server DBA

Responsibilities:

• Upgrading from SQL Server 2005 to SQL Server 2008 and 2008 R2 in clustered environment.
• Setup database mirroring with high safety with automatic failover (synchronous).
• Installed Service Packs in Clustered environment in SQL 2008 and 2008 R2.
• Backup, restore and maintenance of VLDB (1.4 Terabyte) database.
• Created partition table using partition functions and partition scheme for VLDB database.
• Setup Transactional Replication from Transaction Server to reporting Server.
• Monitoring and troubleshooting performance during peak periods with more than 800 concurrent connections.
• Maintaining both DEV and PRODUCTION servers in sync with Version control tool VSS.
• Created users/login/roles and assigning minimum level of permissions with proper documentation for security Audits.

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Upgraded SQL Server 2000 to SQL Server 2005.
• Documented and setup log shipping, database mirroring as HA/DR solution and created run book for DR Failover exercise.
• Created stored procedures, triggers, views.