We provide IT Staff Augmentation Services!

Sr. Sql Dba Resume

Columbus, OH

SUMMARY:

  • 9 + Years’ of IT experience as SQL Server Database Administrator.
  • Experience in supporting Very Large databases (VLDB).
  • Extensive experience with SQL Profiler/Extended Events.
  • Extensive experience with regulatory compliance audits such as PCI, SOX.
  • Expertise in query tuning, performance tuning.
  • Extensive experience in Configuration, Implementation and Maintenance of Disaster Recovery solutions using Log Shipping, Mirroring, Replication and Clustering.
  • Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services ( SSAS ).
  • Involved in authoring, deploying of reports using SSRS.
  • Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
  • Extensive experience as a SQL/Oracle DBA.
  • Expertise in Always on Availability Groups (AAG) and HA/DR Troubleshooting.
  • Expertise in writing, troubleshooting, modifying complex PowerShell/T - SQL scripts.
  • Hands on experience with SQL Azure.
  • Expertise in Cloud migrations.
  • Performed Migration across cross platforms.
  • 24/7 Production Database on Call Support.

TECHNICAL SKILLS:

Operating Systems: Linux, UNIX, Windows

Programming Languages: Java, C, C++, C#.Net on IIS, Flex 3

Web Technologies: HTML, CSS, Servlets, JSP, JavaScript, ASP

Database: DB 2 9.5/ 9.7/ 10.1/ 10.5 , SQL Server 2016/ 2014/ 2012/ 2008/ 2005 , MY SQL 4.1/ 5.0/ 5.1/ 5.5/ 5.6 , PL/SQL, Oracle 10g/ 11g

Networking: IPV4, IPV6, TCP, HTTP, DNS

Tools: Quest Central, Ignite, Toad, Flex Builder 3, Visual Studio 2005/2008, Adobe Dream Weaver, SQL* Plus, SQL* Loader, SQL Developer

Methodologies: UML, Model driven, Agile and Scrum

IDES: Eclipse, NetBeans, My Eclipse

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. SQL DBA

Responsibilities:

  • Involved in extensive performance tuning as part of the DLP (Data Loss Prevention) scans.
  • Performing in-depth RCA on various SQL server related issues.
  • Involved in multiple SQL server builds.
  • Configured 4-node Always On.
  • Responsible for deploying code changes, code review and code releases in all environments
  • Involved in multiple patching activities.
  • Developed and deployed SSIS packages.
  • Extensive experience with deploying and scheduling reports using SSRS to generate daily, weekly, quarterly reports.
  • Written PowerShell scripts to automate admin tasks like backups, re indexing, database integrity checks.
  • Expertise in scheduling backup jobs through SQL server agent using Ola Hallengren scripts
  • Extensively worked on OLAP cubes using SSAS.
  • Implemented TDE (Transparent Data Encryption)
  • Generated quarterly SOX auditing reports.
  • Extensive experience with GMSA (Group Managed Service Accounts).
  • Documented the build procedures and was involved in capacity planning for all the new build servers.
  • Documented the backup and recovery policies at Huntington bank.
  • On call Support.

Confidential, MA

Sr. SQL DBA

Responsibilities:

  • Involved in multiple P2V (Physical to virtual) migrations.
  • Performed business analysis, technical analysis and system design.
  • Provided on call support for multiple application releases.
  • Extensively worked on query tuning, application performance issues with the application owners and suggested measures for better performance.
  • Developed and deployed SSIS packages.
  • Design and development of logical model and physical database structures involving Normalization techniques
  • Configured Always on SQL 2016.
  • Hands on experience in PCI compliance standards.
  • Lead multiple projects, designed and implemented comprehensive backup plan and disaster recovery strategies.
  • Extensive experience with Guardium.
  • Generated quarterly SOX audit reports.
  • Documented the Avamar backup procedure.
  • Extensively used monitoring tools like Spotlight, SolarWinds.
  • Configured Transactional Replication.

Confidential

Sr. SQL DBA

Responsibilities:

  • Configured Always on SQL 2012/2014
  • Performed multiple PMM activities, applied patches.
  • Recommended strategies for better performance of the application.
  • Upgrading of SQL servers from .
  • Developed multidimensional objects using SSAS
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
  • Installation, maintenance and administration of SQL 2016 servers.
  • Installed SQL service packs based on the errors and flaws that were found in the application.
  • Experience with Azure migrated on-premise databases to Azure as part of a POC.
  • Configured log shipping on multiple servers.

Confidential

SQL DBA

Responsibilities:

  • Migrated over 500 databases from the HPE domain to the HPI domain.
  • Managed the servers that were under Veritas Clustering environment.
  • Worked with the development team on query optimization for better performance of the databases.
  • Resolving all kinds of performance issues after the migration is done.
  • Worked on logical and physical database modelling with UML and Erwin Tools.
  • Involved in major production issues and provided the client with root cause analysis.
  • Configured Log shipping on production servers and performed role reversal of the primary and the secondary log shipped database.
  • Responsible for maintenance and administration of SQL server 2016 servers.
  • Capacity planning.
  • Extensively worked on change, release, incident and configuration management.
  • Documented the migration activity, backup and restore procedures being used at HP.
  • Documented RCA (root cause analysis) for many major production issues.

Confidential - Columbus, OH

SQL DBA

Responsibilities:

  • Involved in upgrading of several SQL servers from .
  • Configured Replication, Database Mirroring and Clustering.
  • Developed and deployed multiple SSIS packages.
  • Involved in multiple patching activities.
  • Experience working with monitoring tools like SCOM, IGNITE and Solar winds
  • Involved in Data archiving and purging process as a part of maintenance.
  • Suggested better strategies to avoid slow performance of the database.
  • Resolved issues which involved high usage of system CPU, Disk, Deadlocks and other performance related issues.
  • 24x7 production Support.

Confidential - WI

SQL DBA

Responsibilities:

  • Involved in Migrating SQL Server 2005 Servers to SQL server 2008, SQL server 2008 to SQL Server 2012.
  • Installed and Configured MS SQL Server 2012, and responsible for configuration, tuning and provide support to all Production and development servers.
  • Converted several DTS packages into SSIS packages.
  • Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes.
  • Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server 2005/2008/2012.
  • Written PowerShell scripts to automate DBA tasks.
  • Configured Always on on SQL 2012(3 replicas)
  • Configured Transactional replication between Primary Server and three Read-Only servers, with separate Distributor server and experience in troubleshooting replication problems.
  • Used SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
  • Responsible for monitoring and making recommendations for performance improvement in hosted Databases. This involved index creation, index removal, index modification, file group Modifications and updating statistics in databases.
  • Handled up to 5 TB Size databases with clustered and replication environment
  • Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
  • Handled issues in Replication like Replication Agents Failure, Subscription failure etc.
  • Created SQL Server audits and policies to monitor activity on SQL databases to ensure databases complied and met the Service Level requirements of our clients.

Hire Now