SUMMARY

• Over 10 years of experience as a Database Administrator.
• System analysis, design and development and support of MicrosoftSQL Server 7.0,2000,2005,2008,2012, 2016, 2017.
• Performance tuning and capacity monitoring.
• Data Security, Replication, Backup & Recovery
• Standby/Failover Administration
• SQL Always On administration/AG installation
• SQL Profiler, trace and Extended Events administration

TECHNICAL SKILLS

Programming Languages: PL/SQL, T - SQL, JAVA, C++, HTML, PHP, XML

Tools: Talend, SSIS, SSRS, Performance Monitor, SQL Profiler, SQL Diagnostic Manager, SQL Tuning, PowerShell scripting, MySQL Workbench, Idera tools

Operating Systems and Servers: Windows 95, 98, 7, 8, 2000, 2005, 2008, XP, NT, Linux

Applications: SharePoint, Microsoft Office Suite

Databases: MS SQL 7, 2000, 2005, 2008, 2012, 2018, MS Access, MySQL and Oracle

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL DBA

Responsibilities:

• Administration of several databases
• Performance monitoring and tuning of development, test and production environments including identification and tuning of poor-performing application code and/or database configuration
• Migrated Databases fromSQL Server 2008 toSQL Server 2016.
• Supporting Very Large Database (VLDB) more than 4TB and troubleshooting problems.
• Migrated databases from Raid 1 to Raid 5
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in UAT, Test and Production environments.
• Created complex stored Procedures, Triggers, Cursors, Tables and otherSQLJoins and Statements for Applications by using T- SQL.
• Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications using Idera tools.
• Wrote the auditing scripts for SQL Server
• Prepared Documentation for the Disaster Recovery plan.
• RoutineDBA jobs like Backups, Restores and PowerShell scripting
• Worked in an Agile setup.

Confidential, GA

SQL DBA Manager

Responsibilities:

• Installed and Upgraded from SQL Server2005, 2008 and 2008 R2 to 2016 and some serverupgrades Standard to Enterprise edition.
• Worked on Always-On High Availability and AG
• Administration of several databases and Replication
• Created SQL queries to perform several CRUD operations.
• Migrated Databases fromSQL Server 2008 toSQL Server 2016.
• Supporting Very Large Database (VLDB) more than 4TB and troubleshooting problems
• Worked with the table partitioning (SQL Server 2008) mechanism to allow theSQL Server engine to escalate locks to the partition level before the table level.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Created complex stored Procedures, Triggers, Cursors, Tables and otherSQLJoins and Statements for Applications by using T- SQL.
• Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications
• Wrote the auditing scripts for SQL Server
• Prepared Documentation for the Disaster Recovery plan.
• RoutineDBA jobs like Backups and Restores
• 1st level Aveva Application support

Confidential, GA

SQL DBA Manager

Responsibilities:

• Installed and Upgraded from SQL Server2005, 2008 and 2008 R2 to 2016 and some serverupgrades Standard to Enterprise edition.
• Responsible for parlayingdatabasearchitecture, modeling, design, installation, configuration, and implementation expertise to achieve large-scale corporate objectives.
• MigratedSQL Server from ON-Prem to Azure
• Azure Database Troubleshooting as well as Replication and Administration.
• Installation and configuration of Azure Database.
• Migrated Databases fromSQL Server 7, 2000 toSQL Server 2005, 2008, 2012 and 2016.
• Experience in supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems
• Worked with the table partitioning (SQL Server 2008) mechanism to allow theSQL Server engine to escalate locks to the partition level before the table level.
• Worked in Active-Passive, Active-Active Cluster and DB Mirroring environment as a High availability solution and Always on
• Worked with Transparent Encryption, table compression, database compression, replication and merge statements usingSQL Server 2008.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Created complex stored Procedures, Triggers, Cursors, Tables, PowerShell scripting and otherSQLJoins and Statements for Applications by using T- SQL.
• Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications
• Expert to write the auditing scripts for SQL Server
• Prepared Documentation for the Disaster Recovery plan.
• Daily routineDBAtasks like handling user's permissions and space issues on Production and Semi-ProductionServers and handling maintenance Jobs.
• Managed monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• RoutineDBA jobs like Backups and Restores
• Migrated data from Oracle 9 to MS-SQL 2008

Environment: MSSQL Server 2012, 2008, 2005 and 2000, T-SQL, Talend, Windows 2003 and 2008Servers.

Confidential

Snr SQL DBA

Responsibilities:

• Installed and Upgraded fromSQL Server 2005 toSQL Server 2008 on Various ProductionServers.
• ImplementedSQLData Compression UsingSQL Server 2008 For Compressing Data and Log Files, Back Up Level.
• Used Policy Based Administration feature (SQL Server 2008).
• Setting up and Monitored transactional replication, Database mirroring on Production and QA server.
• Generated periodic reports based on the statistical analysis of the data usingSQL Server Reporting Services (SSRS).
• Migrated data using SSIS and assisted in implemented a Data warehouse.
• Worked closely with onshore and offshore development teams and QA to define technical stories and acceptance criteria for data mapping.
• Analyzed queries using Execution Plans and Implemented Performance Tuning and Query Optimization.
• Conducted Root Cause Analysis and usedSQL Server Profiler, DMVs and Error Logs for Troubleshooting.
• Created and Managed Databases,SQLjoins, views, triggers, sub queries, Tables, Indexes, Views, trigger and Store procedures.
• Provided a 24x7 dedicated support for users in Production, Development and Testingservers and Responded on Tickets based on Requirements.

Confidential

SQL DBA

Responsibilities:

• Participating Weekly Status calls and discuss about Value add-ons to deliver in-order to improve the customer satisfaction.
• Provided on-call support during weekday nights and weekends.
• Provided Database support for Financial and Operations sectors of Total up to databases of size 6 TB
• Backup/restores, HA Configuration, Database design, Error handling and troubleshooting database issues.
• Monitor and Troubleshoot Blocking, Deadlock and resource contention issues. Troubleshooting backup failure issues.
• Installation and maintenance ofSQL Server Databases.
• Planning and Implementing the database changes within the downtime schedule.
• Assisted in the creation of user training and access manuals.
• Plan/Perform major changes and participate in Change Management calls.