SUMMARY

• Over 8 years of technical experience as a MS SQL Server DBA, Expertise in Database Administration on Production, Development & Testing Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Extensive experience in Replication, Log shipping, Mirroring, Failover Clustering, AlwaysOn, Backup/Recovery, Disaster recovery, TDE, performance tuning, Clustering, SQL Azure migration, AWS Cloud Formation, EC2 and RDS.
• Excellent experience in creating and maintaining very large and critical databases in SQL Server 2017/ 2016/ 2014/ 2012 / 2008 - R2 / 2005, Optimization, Backups, restore, performance tuning, data partitioning, Security and disaster recovery.
• Excellent experience in Administering SQL Server High Availability and Disaster Recovery strategies.
• Troubleshooting production issues and raising high availability.
• Extensive experience in creating business, functional and technical documentation.
• Excellent verbal, written communication, presentation, problem solving and conflict resolution skills.
• Well versed with open-source database platform like MySQL and PostgreSQL.

TECHNICAL SKILLS

Databases: MS SQL Server 2017, 2016, 2014, 2012, 2008 R2, and 2005, MYSQL 5.6 /5.7, PostgreSQL 9.3/9.4 and 9.5, MYSQL, SQL Azure, AWS EC2/RDS.

Operating Systems: Windows 2016, 2012 R2, 2012, 2008 R2, 2008, 2003, 2000 Windows workstation, Windows 98/95, Windows XP, Millennium, Linux Redhat 6 / 7.

Applications: MS Office, Adobe (Reader, Photoshop, Flash cs3), SQL Mail and Outlook ExpressTools: SSMS, SSDT, Activity Monitor, Extended Event, Column store Index, Performance Monitor, SQL Profiler, SQL Query Analyzer, TSQL, SSIS(Export/Import), SSRS (Report Builder 3.0/2.0), SSAS, DMV, DBCC, Redgate, PowerBI, Erwin, NetIQ.

PROFESSIONAL EXPERIENCE

Confidential

MS SQL SERVER DBA

Responsibilities:

• Responsible to provide 24 X 7 mission critical support to 310 Production and development farms including cluster, Standalone, Virtual (VM) and Cloud (Amazon AWS) Instances
• Successfully upgraded and migrated multiple SQL 2008 R2 to 2012 and SQL 2014/2016/2017.
• Currently, using SQL server 2016 and higher version of SQL server
• Installed multiple standalone, Virtual (VM) and clustered instances.
• Setup and configured HA & DR/ Always On
• Tested and Applied latest service packs and cumulative Hotfix.
• Configured and maintain transactional, merge, peer to peer and snapshot replications.
• Installed, configured, and maintained Log shipping to create Standby Server.
• Experienced in DTS, SSIS, SSRS and SSAS.
• Performed quarterly DR drill across datacenters.
• Experience in using Data Export import feature, SSIS and SQL query for ad-hoc data movement.
• Experience in Install configure and upgrade SQL server, Analysis server and administrate them by provided proper access.
• Experience in SQL server performance tuning resolution using Native tools like query advisory tuner, Execution plan and (DMO) dynamic management objects.
• Experience in Install, configure, upgrade and support SQL server Reporting service and the new Power BI.
• To improve database performance. Studied the characteristics of the database and SQL queries and provide best solution.
• Experienced with Amazon Web Services EC2, Cloud Watch, Cloud Formation and RDS for MSSQL Databases.
• Experience with design, implementation, and migration of databases to AWS.
• Experience with SQL Azure data masking, TDE encryption, security, monitoring.
• Responsible for securing SQL Server environment, involved in creation and granting permissions on various Objects, created the guideline to secure SQL Servers.
• Experience in Data warehouse by cleaning data which received from different source. Facilitating those data for reporting, analysis, and the efforts, focus on data integration after securing them.
• Worked with database Isolation level to get excellent benefits of data accuracy by properly setup the isolation level so that data is not lost during update, data is not read from dirty page, data is not locking reads, there is no fuzzy read or Phantom reads or Non-repeatable read.
• Created the backup and restore strategy for production, development, and test environments.
• Created maintenance plan for database consistency and optimization.
• Experienced with improving server performance using Performance monitor tool by analyzing CPU, disk, and memory devices.
• Involved in tuning the database and server performance. Worked with Profiler to trace and tune the database.
• Responsible for stored procedure optimization, Performance tuning of databases.
• Implemented data partitioning to improve the performance of large table, reduces contention and increases availability of data.
• Experience with SQL Server disaster recovery procedures and created the guidelines for them.
• Experienced in leading DBA team, assign tasks, and interact with the different groups to manage the servers.
• Involved in Change Management, Problem management activities using Service Now and Remedy tool before implementing database changes in production and development activities.
• Determined hardware and software requirements for variety of SQL Server version
• Involved in scripting, security, space management, jobs scheduling and maintenance, etc.
• Experienced in database sizing and capacity planning for new and existing projects.
• Excellent team player and worked on call rotation.
• MySQL 5.6 / 5.7 administration and support experience including backup and recovery, replication, performance tuning, and monitoring in a 24x7 environment.
• Experience with supporting various MySQL versions and Editions (Standard, and Enterprise).
• Experience with MySQL Replication Master/Slave.

Confidential, NY

MS SQL DBA

Responsibilities:

• Worked as a Production and Project support DBA provided 24/7 Production Support for 600 servers out of which 187 servers are production servers.
• Upgraded and migrated multiple SQL server in Datacenters
• Successfully Upgraded SQL 2005 to SQL 2008 R2 and SQL 2012.
• Installed multiple SQL Server 2012/ 2008 R2/ 2005 in stand alone and clustered configuration. Planned, configured, tested and implemented failover cluster.
• Tested and Applied latest service packs and cumulative Hotfix.
• Configured and maintain a Microsoft SQL server2005/2008 R2 fail over clusters.
• Configured and maintain Snapshot, Transactional, Merge replications.
• Installed, configured and maintained Log shipping to create Standby Server.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.
• Created the backup and restore strategy for production, development and test environments.
• Created maintenance plan for database consistency and optimization.
• Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments.
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning
• Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2008 to MSSQL 2012.
• Responsible for securing SQL server environment
• Installed and configured DTS, SSIS, SSRS and SSAS.
• Created custom Performance Analysis reports in SQL 2008 for future hardware and software load/analysis.
• Experience in Install, configure and upgrade SQL server Analysis server and administrate them by provided proper access.
• Experienced in Database Mail, NETIQ Monitoring and Alerts.
• Configured Linked server for application team to run adhoc queries.
• Created DDL triggers for auditing any DDL change in SQL 2008
• Implemented data partitioning to improve the performance of large table, reduces contention and increases availability of data..
• Experience in hardware and software requirements for different SQL Server version and editions.
• Installed and configured IIS web server 6.0 and 7.0.
• Install, configure, patched and managed day to day business operation using PostgreSQL 9.3 on linux centos
• Setup streaming replication / WAL shipping for PostgreSQL standby server.
• Configure cron jobs for backups / restore and maintenance of PostgreSQL cluster database server.

Confidential

MS SQL DBA

Responsibilities:

• Install and configured SQL 2005 and 2008, applied latest service packs and hot fixes
• Facilitated SQL Server 2005 cluster and SQL Server replicating server
• Performed routine maintenance, including backup & recovery in SQL server 2005 and 2008R2
• Created and maintained jobs and maintenance plans
• Responsible for Database tuning, creation & design
• To improve database performance. Studied the characteristics of the database and SQL queries and provide best solution.
• Upgraded from SQL 2000 to SQL 2005 and SQL 2008R2
• Consolidated 10 SQL 2005 server machines into single SQL 2005 cluster environment
• Facilitated SQL server 2005 and SQL 2008 server migration in Datacenters
• Performed analysis on tables, indexes and code in order to optimize query performance
• Used SQL Profiler and performance monitor to trace database performance
• Use table partitioning to improve system performance over all
• Configured SQL 2005 cluster for mission critical application to provide 24*7 up environment
• Setup and configured SSRS (reporting services) for business
• Installed and configured SSAS (analysis service) for data warehousing
• Setup, configured and monitored log shipping for critical databases
• Setup database mirroring in high performance mode to avoid downtime
• Setup policies in SQL 2008 using different conditions, targets and facet. configured and monitored snapshot, transactional and merge replication
• Supported SQL Server production & pre-production release roll-outs
• Administer SQL server security using SQL and windows authentication and setup different proxy account to grant certain permission.
• Configured Linked server for application team to run adhoc queries
• Design & development of preprod/development DB refreshes with Production data
• Transformation and Uploading the information from different platforms into SQL Server databases using DTS, BCP, BULKINSERT and SSIS (integration service) packages.