We provide IT Staff Augmentation Services!

Sr. Sql Dba Resume

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.

Hire Now