SUMMARY

• Senior SQL Server DBA with 10 years of experience in SQL Server 2019, 2016/ 2014/2012/2008/2005 , Mysql 5.8, Oracle 11G and Sybase database administration, Security, database development, database troubleshooting, performance tuning, database design and ETL design.
• Worked at Confidential, Confidential, Confidential Corporation, and other clients on various production and development DBA roles involving clustering, replication, log shipping, Always On, ETL development and administration, mirroring, backup and recovery,Point in time recovery, production support, database design, performance tuning, etc. for multiple SQL server database servers.
• Has also worked on Large Datawarehouse projects and has Used ETL and BI tools like SSIS, DTS, PowerBI, SSRS.
• Extensive Scripting experience using Powershell
• Migrated Database from inhouse servers to cloud using MS Azure and performed Devops work for continuous integration and continuous deployment using VSTS

TECHNICAL SKILLS

DBMS: MS SQL Server 2019,, 2016, 2014, 2012/2008R 2/ 2008/2005/2000 , MYSQL 5.8, Sybase 10/11, Oracle 11G

OS: Openstack Cloud on RHEL7, Windows, UNIX, Linux, AIX

Tool: /Languages Python 3.7, Cassendra 3.10, POWERBI, DTS, SSIS, SSRS, AlwaysOn, Ms Azure, VSTS, SQL, TSQL, ASPVB, COM, .NET, SalesForce, SnowFlake.

PROFESSIONAL EXPERIENCE

Confidential

Sr SQL DBA

Responsibilities:

• Migration of SQL Servers to cloud environemnt MSAzure
• Worked on Administration and maintainace of SQL ServerDatabase systems for various applications.
• Database administration activities as an on call production support DBA for SQL Server .
• Used VSTS for continuous integration and continuous deployment
• Worked on SQL Server AlwaysOnto provide a high - availability and Disaster-recovery solution
• Meetings with system architects, design analysts to understand business requirements.
• Designing multiple SSIS packages for retrieving data from heterogeneous systems.
• Involved in SQL Server 2017, 2016, 2014, 2012, 2008 database installation (cluster\standalone), maintenance and follow guidelines as per Confidential standards and SOX security guidelines.
• Performance tuning of high volume OLTP databases and SQL queries using large tables (> 50 million rows).
• Resolved blocking and deadlocking issues in concurrent queries.
• Implementaion of best practices for Database modeling, Database architecture and normalization techniques.
• Setup backup and recovery strategies for SQL server databases.
• Adminstering Snowflake. Graning rights, Created SAS keys, implement the changes on snowflake.

Confidential

Senior SQL server DBA

Responsibilities:

• Migration of SQL Servers to cloud environemnt MSAzure
• Database administration activities as an on call production support DBA for SQL Server.
• Used VSTS for continuous integration and continuous deployment
• Worked on SQL Server AlwaysOnto provide a high-availability and Disaster-recovery solution
• Meetings with system architects, design analysts to understand business requirements.
• Designing multiple SSIS packages for retrieving data from heterogeneous systems.
• Involved in SQL Server 2019, 2016, 2014, 2012, 2008 database installation (cluster\standalone), maintenance and follow guidelines as per Confidential standards and SOX security guidelines.
• Performance tuning of high volume OLTP databases and SQL queries using large tables (> 50 million rows).
• Resolved blocking and deadlocking issues in concurrent queries.
• Implementaion of best practices for Database modeling, Database architecture and normalization techniques.
• Setup backup and recovery strategies for SQL server databases.

Environment: SQL Server 2017, 2016, 2014, 2012, AlwaysOn, MS Azure, ERwin, SSIS, PowerBI, VSTS, Git, OS Windows Server 2012

Confidential

Sr. SQL Server

Responsibilities:

• SQL Azure, SQL Server (2008, 2012, 2014 & 2016 Versions),
• Designing and Maintenance of data and database solutions
• Migration of SQL server database from on premise to Azure IAAS/PAAS
• Migration using Azure Site Recovery(ASR)
• Setting up and testing HA & DR(ASR)
• Experience in implementing multi-node windows/SQL HA
• Always on implementation with multi instance availability group(SQL 2012/2014/2016 )
• Performance Tuning & System Optimization
• Database Health, Security
• Data Analysis, Problem Analysis
• Database installation, backups, Replication, Server Procurement, validation and Patching (as needed)
• Configure & Maintain Always On, Mirroring, log shipping, Replication management, Linked Servers and Security
• Ensure and maintain a highly available and secure database environment
• Analyzing and Upgrading to On-premise & Azure from lower versions of SQL Server
• Troubleshooting and fine-tuning of databases for its performance and concurrency
• Implementaion of best practices for Database modeling, Database architecture and normalization techniques.
• Setup backup and recovery strategies for SQL server databases.
• Deployment of Confidential standard maintenance jobs for optimization of databases like re-indexing, index defrags, updates statistics.
• Perform capacity planning and disk configurations for new hardware infrastructure.
• Develop common reporting tool set to enable significant efficiency improvement in overall data management and reporting across the global material delivery, logistic cost allocation and budgeting.
• Translate business goals into strategy and actionable objectives.
• Implement & configure DB appropriate to business requirements.
• Create and generate various database reports to generate various metrics in powerbi
• Perform analysis and determination of database performance characteristics, data relationships and attributes, data flow, data output and reporting capabilities.
• Investigates and resolves technical database issues.
• Write Scripts (Data modeling, Complex query, Stored procedures, views) using SQL, TSQL and Python
• Participate in Root Cause Analysis reviews when applicable.

Confidential

Senior SQL server DBA

Responsibilities:

• Migration of SQL Servers to cloud environemnt MSAzure
• Worked on Administration and maintainace of SQL ServerDatabase systems for various applications.
• Database administration activities as an on call production support DBA for SQL Server \MYSQL databases.
• Used VSTS for continuous integration and continuous deployment
• Worked on SQL Server AlwaysOnto provide a high-availability and Disaster-recovery solution
• Meetings with system architects, design analysts to understand business requirements.
• Designing multiple SSIS packages for retrieving data from heterogeneous systems.
• Involved in SQL Server 2017, 2016, 2014, 2012, 2008 database installation (cluster\standalone), maintenance and follow guidelines as per Confidential standards and SOX security guidelines.
• Performance tuning of high volume OLTP databases and SQL queries using large tables (> 50 million rows).
• Resolved blocking and deadlocking issues in concurrent queries.
• Implementaion of best practices for Database modeling, Database architecture and normalization techniques.
• Setup backup and recovery strategies for SQL server databases.

Environment: SQL Server 2017, 2016, 2014, 2012, AlwaysOn, MS Azure, ERwin, SSIS, PowerBI, VSTS, Git, OS Windows Server 2012

Confidential

Sr. SQL server DBA

Responsibilities:

• Working as Primary SQL Server DBA and Secondary Oracle/MySQL DBA on 24x7 production support.
• Configuring an AlwaysOn Availability Group for Read-only Routing and high availability on classic failover cluster and GeoCluster configuration.
• Database migration to SQL Server 2016
• Experience in creating new policies and facets to enhance security as per Confidential best practices.
• Analyzing existing tier on an ongoing basis and making recommendations about scalability and high availability changes.
• Understanding of database architecture and design including: scalability, backups, performance Database experience, including database design, implementation, and optimization with NoSQL (Cassandra) databases
• Proficiency configuring, implementing and support high availability solutions for SQL Server including clustering, replication, mirroring and log shipping for disaster recovery.
• Setup and troubleshoot replication and mirroring issues.
• Performance recommendations which include Data compression, index recommendation and table partition strategies
• Handle SQL 2012/2014 cluster installations and latest service pack and hot fix upgrade for GeoCluster configuration.
• Manage database maintenance plan activities including backups, rebuild indexes, statistics check, integrity and consistency checks, etc.
• Experience with database monitoring tools including Quest Foglight, EMC Networker, and Windows Perfmon tools.
• Automation scripts using PowerShell.
• Build ETL processes utilizing SSIS/DTS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting.
• Develop reports using SQL server reporting services and utilizing SQL queries and stored procedures.
• Experience with planning and disk configurations for new hardware infrastructure and performance tuning of large size databases of terabytes.
• Performance tuning for slow running queries
• Follow SDLC, Change Control Management of the daily deployment of database code to UAT and production environment.
• Work in rotating shift for on-call production support

Confidential

Responsibilities:

• Database administration activities as an on call production support DBA for SQL Server and part of MMS DBA account managers’ team supporting SharePoint servers.
• Involved in installing SQL server 2005 and 2008 single instance and multi instance Clusters with active/active or active/passive configuration. Built 2 node, 3 nodes and 4 nodes clusters.
• Upgraded from SQL server 2000 and 2005 to SQL Server 2008
• Involved in SQL server 2005 and 2008 synchronous/asynchronous mirroring from scratch. As per the Confidential MMS standards all the production databases should mirrored to mirror node as a part of disaster recovery.
• On boarding new servers from different BUITS as per the MMS standard including disk offset for better I/O
• Configuring production servers as per Confidential standards to improve performance.
• Deployment of Confidential standard maintenance job suite for optimization of databases like re indexing, index defrags, updates statistics and partitioning large tables.
• Performed capacity planning and disk configurations for new hardware infrastructure.
• Handling SQL 2008/2005/2000 Installations (Cluster and Standalone) and latest service pack and hot fix upgrade.
• Troubleshooting and Diagnosis of SQL server alerts.
• Performance tuning and optimization (rebuild index/index defrag/update statistics) of large databases up to 4 terabytes.
• Setting up Mirroring, Replication and Log shipping for SQL Server 2005.
• Disaster Recovery Planning, Backup, Restoration and Recovery in different scenarios.
• Development of DTS and SSIS packages.
• Creation of database schemas, managing user creations, assigning roles to SQL databases.
• Maintaining database documentation at team site.
• Part of tier3 problem management team and account manager for tier1 offshore team (MACSMON).