SUMMARY

• Responsible for troubleshooting and problem solving of SQL database Servers.
• Experience writing, and tuning Transactional SQL stored procedures.
• Ability to ensure teh technical integrity of corporate databases by protecting against teh loss or misuse of information and designing backup/recovery strategies.
• Experienced in configuring HADR using SQL Server 2008, 2008R2, 2012, 2014, 2016
• Experienced in setting up partially contained databases using SQL server 2012, 2014, 2016.
• Experienced in deploying SQL server 2008, 2008r2, 2012, 2014 and 2016 cluster solutions.
• Experience managing multiple MS SQL 2008, 2008R2, 2012, 2014, 2016 RDBMS on web - based, transactions.
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers.
• Maintenance and tuning of teh databases and Replication.
• Experience with setup and administration of SQL Server Database Security environments using Profiles, database Privileges and Roles.
• Provide SQL Server database physical model creation and implementation (data type, indexing, and table design).
• Management of multi-terabyte production clustered systems using ACTIVE-PASSIVE and ACTIVE-ACTIVE Clustering.
• Experience with SQL Server 2008, 2008R2, 2012, 2014 and 2016 on Windows NT, Server 2008, 2008R2 and 2012.
• Proficient in performance of SQL Server software new installation and upgrades.
• Proficient in Backup/recovery strategies implementation.
• Proficient in maintaining and supporting SQL Server Transactional and merge Replication.
• Expert in reviewing overall physical database structure for overall stability.
• Proficient in use of tools like extended events, DMVs, SQL Server profiler and Windows performance monitor.
• Experience with implementing Database Disaster Recovery and Planning.
• Experienced with teh design, implementation, and administration of SQL Server database solutions.
• Have good understanding of Disk and Server configuration for SQL Server.
• Experience with network connection tuning using SQL Server 2008, 2008R2, 2012, 2014, 2016.
• Proficient in writing and optimizing T-SQL codes and stored procedures.
• Experience with monitoring and troubleshooting 24x7 operations.

TECHNICAL SKILLS

RDBMS: SQL 2008, 2008R2, 2012, 2014, and 2016 Database Administration, Data Modeling, Enterprise Environments, Mirroring, Log shipping, Clustering, Replication, Always-On Availability Groups (AAG), Performance Tuning, SQL Profiler, Database Engine Tuning Advisor.

Operating systems: Windows 2008/2008R2/2012/XP/Vista/Linux;

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server Database Administrator

Responsibilities:

• Responsible for promoting team bonding among members of my team.
• Responsible for scheduling and presiding over team meetings and making notes to senior management on teh progress of my team.
• Participating in SQL Server database systems design and operations.
• Installing and configuring multiple SQL Server 2012, 2014 and 2016 Multi-Node Geo-Clusters for Mission critical production databases.
• Participating in upgrade and migration efforts for various clients from SQL Server 2008 and 2008R2 to SQL Server 2012, 2014 and 2016 as teh need arose.
• Participating in teh managing of entire project to which were assigned in accordance with teh Service Level Agreement (SLA) and Statement of Work (SOW) to ensure all departmental related cost and expenses are kept on track with teh project schedule.
• Revising current DR and HA strategies and improving them, theirby reducing downtime in teh event of any failure.
• Managing an entire database environment visibility and accountable for every database decision made to upper level management.
• Utilizing expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration to improve uptime as well as reduce RPO and RTO of business.
• Standardizing processes for teh Infra DB team by creating documentations for installations, migrations, upgrades, backups, restores, index maintenance, etc.
• Working with developers to improve query execution times and boost performance.
• Supporting and stabilizing spiral of production environment; leading to business continuity.
• Participating in teh Configuration of various logical database structures such as table spaces to store application objects and rollback segments for transaction processing.
• Participating in teh Configuration of teh physical design of teh database by implementing a flexible Architecture compliance dat suites both OLTP and Data warehouse applications.
• Performing periodic database maintenance on all databases across all environments.
• Ensuring dat all configurations are properly implemented and working based on teh client’s needs (Resource Governor, Policy based management etc.)
• Proactively monitoring teh entire instances and databases for any abnormalities.
• Mentoring younger DBAs in teh company.
• Implementing SQL Server best Practices for Installing, Configuring, Troubleshooting, Querying, etc. on all Sql server databases across teh enterprise.
• Implementing, monitoring and troubleshooting SQL Server Replication and Mirroring across all Sql database servers in teh enterprise.
• Providing off-hour support for all production databases.
• Participating in periodic database refresh operations for lower environments.
• Managing datacenter and setting up various measures to manage teh said data including; partitioning, transactional and peer to peer Replication, log shipping, Mirroring and Clustering.
• Participating in root cause analysis of performance issues within teh environment.
• Participating in Project and SQL Team meetings on a regular basis. successfully engaging in various DR (Disaster Recover) efforts.
• Utilizing experience in various virtualization technologies to manage multiple Sql server on Virtual appliances.
• Performing other duties as assigned.

Confidential

MS SQL Server Database Administrator

Responsibilities:

• Working with a team of 8 DBAs supporting in-house SQL Server database systems on various infrastructure projects, improving service level agreements by reducing time to deliver database solutions to business.
• Troubleshooting issues and carrying out root cause analysis on teh issues as well as finding lasting solutions to those problems and documenting findings.
• Performing frequent health checks for all backups and productions (mission-critical) databases.
• Setting up and managing Replication, Mirroring and log shipping.
• Building out new clusters to handle mission-critical databases.
• Participating in on-call rotation with teh team.
• Improving CPU consumption for all critical production database servers by tuning queries, databases, instances, etc. theirby reducing teh CPU workload from a steady 90% to 10% and resulting in a 300% increase in transaction processing.
• Designing teh backups and recovery strategies for SQL Server databases to meet our customer SLA requirements.
• Participating in software upgrades, revisions, patches, and fixes mandated by teh vendor.
• Assisting in teh resolution of complex problems in support of production; including on call support.
• Ensuring dat teh detailed physical design of database and data structures comply with data policies, standards, principals, and meets teh established level of service agreements/goals for teh system.
• Maintaining solid technical skills in R/DBMSs, products, utilities, protocols, and techniques.
• Managing and monitored SLAs for uptime and performance of SQL Server databases.
• Demonstrated experience in working on root cause analysis for SQL Server database issues.
• Flexible, adaptable, and able to manage multiple tasks in a dynamic environment.
• Proactively monitoring teh database systems to ensure secure services with minimum downtime.
• Project management for Database technical projects.
• Upgrading client RDBMS to SQL server 2012 and installed Windows server 2012 as well as SQL server 2012 clusters.
• Implementing SQL Server 2012 and 2014 Always-ON Availability Groups and Listeners for HA and DR purposes.
• Set up monitoring and alerting for SQL Server Always-ON as well as other SQL Server conditions.
• Supporting production environments and mission critical databases on a 24/7/365 basis including on-call responsibilities.
• Performing various data migration tasks for mission critical databases.
• Working with a team of 8 to manage over 2000 databases ranging from 350GB to 2.3TB.
• Utilizing teh “Partially contained database” feature of SQL server 2012 to ease migration and database refreshes for clients.
• Performing DBA duties including: database backups, restores, performance tuning, and capacity analysis.
• Designing, implemented and upgraded SQL Server 2008, 2008R2 and 2012 databases for mission-critical business
• Working with BI team and Reporting group in generating teh weekly, monthly, and quarterly report by using SQL Reporting Services.
• Managing teh products and development databases including performance tuning, capacity planning, SQL Server Clustering, database security configuration, and database continuity
• Troubleshooting databases and custom application issues
• Other duties as assigned.