We provide IT Staff Augmentation Services!

Senior Sql Dba Consultant Resume

New, YorK

SUMMARY:

  • A Confidential Certified (MCDBA, MCSE) and Senior SQL DBA with a Master’s Degree and 14+ years of Total IT Experience in Production Support Database Administration in Windows Environments and also Application support experience using Confidential SQL Server 7.0, 2000, 2005, 2008/2008 R2, 2012, 2014, 2016, and 2017.
  • Worked on SQL Server Upgrades from 2000/2005 to SQL Server 2008 RTM/R2 to SQL Server 2012 and to SQL Server 2014. Both Side - by-Side and in-place upgrades.
  • Specialist in resolving issues relating to SQL Server Install/Upgrade failures.
  • Installed/upgraded 800+ SQL Instances of 2005/2008/2008 R2/2012/2014 Clustered Servers of Dev/QA/UAT/Production Environments till date.
  • Installed and Maintained Multi-Node SQL clusters. Max being 12-Node Windows Cluster with 20 SQL Clustered Instances on it.
  • Deployed SQL on Azure and configured Always-on in Azure and testing.
  • Handled and maintained the largest database of 9 TB in size.
  • Extensively worked on Database Backups, Restores, and Disaster Recovery procedures .
  • Created scripts to automate tasks like Creation of Always-On using Powershell (Type 1, 2, 3, and 4 AO configuration).
  • Enabled and configured more than 100+ Always-On feature in both same subnet and multisubnets on SQL 2012, SQL 2014, 2016, and 2017 . Configured Always-On in multi domain SQL Instances .
  • Dogfooding done using SQL 2016 CTP1 and CTP2 for testing stretch databases with Azure SQL databases
  • Created and updated KB Articles to help team resolve issues at the L1/L2/L3 level.
  • Escalation support provided to customers within MSIT.
  • Tested and worked on DB HealthCheck feature of Always-On and QueryStore in SQL Server 2016.
  • Implemented encryption using symmetic keys and also Always-Encrypted (Determinstic) to protect critical user data in Confidential Company.
  • Automation of creation/switchover of Alwayson Group using Powershell.
  • Extensively used Powershell for proactive and reactive management of SQL Server DBA tasks .
  • Worked on Distributed Availability Group in SQL Server 2016. Implemented Distributed Availability Group techonology as a HA/DR solution in UPS Project.
  • Worked on Table Partitioning and used SQL 2016 feature in the script to automate sliding paritioning as SQL Agent job.
  • Implemented Deterministic Encryption using SQL Server 2016 Always Encrypted feature in Confidential Project.
  • Worked closely with customers to help them in setting their migration plans.
  • Experience in implementing different types of Replication modes like Snapshot, Transactional, and Transactional with Subscriber Updates, and merge .
  • Worked extensively and implemeted Transparent Data Encryption (TDE) on databases as per customer requirements.
  • Worked extensively on Performance Tuning and Query Optimization of TSQL queries/procedures and troubleshooting.
  • Worked extensively on SSIS Package designs for Import/Export from various data source like flat file and Excel to MS SQL Server and vice versa. Created ETL (Extraction Transformation and Loading) Packages using SSIS and migrated data between enrivornments as per the client needs.
  • Created Windows Batch Files and automated tasks as per customer requirements.
  • Extensively worked with storage team relating to SQL server storage architecture for VM/Hyper-V environments.
  • Worked extensively on SSRS reports , designed and deployed the reports into the Reporting Server and automating the e-mails to the customer.
  • Backup of SSAS Cube and Restoration of the Cubes, assigning permissions on the cubes.
  • Installation and configuration of SSIS, SSRS, and SSAS Servers .
  • Installation and configuration of SSAS PowerPivot and integrating with Sharepoint 2010.
  • Mentoring Junior DBA’s and taking bootcamp sessions with off shore team members.
  • Working knowledge of ASP/VB.net and assisted development team in building/modifying application features.
  • Worked extensively with Modelling team on Data Modelling, ER Diagrams (ERD), Conceptual, Logical and Physical Data to help with Data Model evaluation, Referential Integrity of tables. Data provenance and lineage. Metadata enrichment and management
  • Worked extensively wi th Storage Team related to SAN provisioning for SQL Server drives for data/log/tempdb.
  • Working knowledge in Linux, Shell and Perl scripting, and Sybase Database Servers.
  • Individual Contributor and good team player, strong interpersonal and Communication skills combined with self motivation, initiative and ability to think outside the box. Quick learner and good team player.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2000/2003/2008 R2/2012/2012R2, Unix/Linux Virtual Environments: VM Ware/Hyper-V/AWS/Windows Azure

RDBMS: MS SQL Server 7.0/2000/ 2005/2008/2008 R 2/2012/2

Languages: T-SQL, PowerShell, HTML, DHTML, C and C++, JSON

Development Tools: PowerBuilder, Erwin Data Modeler tools

SQL Server Tools: Enterprise Manager, Profiler, Query Analyser, Export & Import (DTS), SSIS, SSRS, SSAS, SSRS SharePoint Powerpivot, Symantec Netbackup, DPM Backup tool, FogLight, SQL Sentry, LightSpeed, BMC Remedy, Idera SIMS, Idera WorkLoad Anaysis, Idera Diagnostic Manager

PROFESSIONAL EXPERIENCE:

Confidential, New York

Senior SQL DBA Consultant

Environment: SQL SERVER 2008 R 2/2012/2

Responsibilities:

  • Handling day-to-day Alert and failures/tickets.
  • Migration of SQL Server 2008/2008R2 to SQL Server 2016
  • Database refresh on a regular basis from Production environment to Dev, QA, and Staging Environments for testing and code enhancement by the application team.

Confidential, Lincoln RI

Senior SQL DBA Consultant

Environment: SQL SERVER 2008 R 2/2012/2

Responsibilities:

  • Handling day-to-day Alert and failures.
  • Database refresh on a regular basis from Production environment to Dev, QA, and Staging Environments for testing and code enhancement by the application team.
  • Worked on Table Partitioning and used SQL 2016 feature in the script to automate sliding partitioning as SQL Agent job.
  • Implemented Deterministic Encryption using SQL Server 2016 Always Encrypted feature in Confidential Project.
  • Designing and Architectural work involved in migration of databases from DB2 to SQL Server as part of Mainframes Sunsetting projects.
  • Part of data modelling team in designing using Erwin tool for creation tables, views, schemas, and security with referential integrity.
  • Worked extensively with Modelling team on Data Modelling, ER Diagrams (ERD), Conceptual, Logical and Physical Data to help with Data Model evaluation, Referential Integrity of tables. Data provenance and lineage. Metadata enrichment and management.
  • Migration of databases from SQL 2008/2008R2/2012 to new SQL 2016.
  • Worked extensively on Performance Tuning and Query Optimization of TSQL queries/procedures and troubleshooting.
  • Performance tuning of queries and troubleshooting issues relating to performance.
  • Worked with DataWarehouse teams in Data profiling by examining, analyzing and reviewing data to collect statistics surrounding the quality and hygiene of the dataset. Make sure the Data quality is achieved with accuracy, consistency, validity and completeness of data.Supporting HealthCare Insurance applications for Amica Life Insurance.
  • Setting SQL Standards across SQL Servers in the environment.
  • Creation of reports on SSRS as per customer requirements.
  • Creation of packages using SSIS as per customer requirements and created automated reports relating to SQL Environments.
  • Worked with storage team relating to SQL server storage architecture for VM/Hyper-V environments.
  • Upgraded Idera SQL Server Inventory Manager and created SP’s
  • Mentoring Junior DBA’s and taken bootcamp sessions
  • Part of Modelling Team in designing tables and migration data from DB2 Databases to SQL Server 2016/2017. Handled issues relating to it by changing the Stored Procedures, table structures, schemas, data types, referencial intergrity and indexing.

Confidential, Mahwah NJ

Senior SQL DBA Consultant

Environment: SQL SERVER 2005/2008/2008 R 2/2012/2014/2016

Responsibilities:

  • Handling day-to-day Alert and failures.
  • Database refresh on a regular basis from Production environment to Dev, QA, and Staging Environments.
  • SQL Upgrades from SQL 2008 to SQL 2014.
  • Designing and Architectural work involved in migration of databases from nonSQL environments like DB2. Worked extensively with Modelling team on Data Modelling, ER Diagrams (ERD), Conceptual, Logical and Physical Data to help with Data Model evaluation, Referential Integrity of tables. Data provenance and lineage. Metadata enrichment and management.
  • Performance tuning of queries and troubleshooting issues relating to performance.
  • Resolving issues relating to cardinality issues after the migrating to SQL 2016 from SQL 2008/2008R2/2012.
  • Worked extensively on Performance Tuning and Query Optimization of TSQL queries/procedures and troubleshooting.
  • Automation of switchover of Alwayson Group using Powershell.
  • Database support for Purchase to Pay (P2P) Applications at UPS
  • Supporting HealthCare applications.
  • Setting SQL Standards across SQL Servers in the environment.
  • Creation of reports on SSRS as per customer requirements.
  • Creation of packages using SSIS as per customer requirements.
  • Worked with DataWarehouse teams in Data profiling by examining, analyzing and reviewing data to collect statistics surrounding the quality and hygiene of the dataset. Make sure the Data quality is achieved with accuracy, consistency, validity and completeness of data.
  • Mentoring Junior DBA’s and taking bootcamp sessions
  • Migration of DB2 application Database to SQL Server 2012. Handled issues relating to it by changing the Stored Procedures, table structures, schemas, data types, referencial intergrity and indexing.
  • Implemented/enabled DB HealthCheck feature of Always-On and QueryStore in SQL Server 2016.
  • Implemented/configured Distributed Availability Group on critical databases as HA/DR solution using SQL Server 2016 .

Confidential

Senior Escalations Engineer (SQL DBA Services)

Environment: SQL SERVER 2000/ 2005/2008/2008 R 2/2012/2014/2016

Responsibilities:

  • Handling day-to-day Escalations from Customers within Confidential and from our Vendor Teams.
  • Working on Azure technologies and testing SQL features on Azure.
  • Configuring Always-on on Azure and testing failover/failback scenarios.
  • Collaboration with SQL Engineering team in identifying issues in SQL space.
  • Defect remediation and setting standards for SQL.
  • Automated Always-On using Powershell Script to reduce time and efforts.
  • In regular search for opportunities for Automate and work on Automation Projects to reduce time and human efforts.
  • Worked extensively on Performance Tuning and Query Optimization of TSQL queries/procedures and troubleshooting.
  • Part of dogfooding of SQL 2016 CTP releases before release to market (RTM)
  • Worked extensively on SQL 2014 Cardinality issues.
  • Ad-Hoc support to Business Units within Confidential and help them with planning in migrations/Upgrades/new projects/DR setups.
  • Designing and Architectural work involved in migration of databases from nonSQL and MSAccess environments. Worked extensively with Modelling team on Data Modelling, ER Diagrams (ERD), Conceptual, Logical and Physical Data to help with Data Model evaluation, Referential Integrity of tables. Data provenance and lineage. Metadata enrichment and management.
  • Providing Training to L1/L2/L3 vendor teams (TechMahindra and Infosys Teams).
  • Proactive Deep dives to eliminate errors across the BU Platforms relating to SQL Server.
  • Worked with DataWarehouse teams in Data profiling by examining, analyzing and reviewing data to collect statistics surrounding the quality and hygiene of the dataset. Make sure the Data quality is achieved with accuracy, consistency, validity and completeness of data.
  • Dogfooding new Versions and Setting up Standards for SQL Server.
  • Technical Audits to improve quality of L1/L2/L3 support teams.
  • Specialist in resolving issues relating to SQL Install/Upgrade failures.

Confidential

Lead DBA

Environment: SQL SERVER 2000/ 2005/2008/2008 R2, MySQL 5.1/5.5

Responsibilities:

  • Managing Team and assigning tasks.
  • Monitoring work quality and timely response to the client.
  • Interaction with the application team to understand their requirements and helping in migrating databases from MYSQL/Oracle/DB2 environments to SQL Server. Worked extensively with Modelling team/Application Team on Data Modelling, ER Diagrams (ERD), Conceptual, Logical and Physical Data to help with Data Model evaluation, Referential Integrity of tables. Data provenance and lineage. Metadata enrichment and management.
  • Worked extensively on Performance Tuning and Query Optimization of TSQL queries/procedures and troubleshooting.
  • Worked with DataWarehouse teams in Data profiling by examining, analyzing and reviewing data to collect statistics surrounding the quality and hygiene of the dataset. Make sure the Data quality is achieved with accuracy, consistency, validity and completeness of data.
  • Running of Profiler to capture Trace for Smoke Tests by the Development Team on Dev, QA, Staging, and Production Environment and providing the results for their perusal.
  • Configured of Log shipping as per client requirements as a part of DR strategy and implemented alert mechanisms for any failures of the same.
  • Configured of Mirroring (High Performance/High Safety/High Availability) as per client requirements as a part of DR strategy and implemented alert mechanisms for any failures of the same.
  • Handling Onsite and On-call requests.
  • 24/7 support (Weekends On-Call Support).
  • Database bifurcation tasks.
  • Working in Clustered Environment active/active, Active/Passive nodes.
  • Installation and configuration of MySQL on Windows.
  • Automating backup jobs on MySQL Servers.
  • Implemented replication in MySQL on Windows Environment.
  • Creation of Events in MYSQL to automate the job schedules.
  • Creation of Users and assigning roles for the same in the MySQL.
  • Backup and Restore task of MySQL.

Confidential

Senior SQL DBA

Environment: SQL SERVER 2000/ 2005/2008/2008 R2

Responsibilities:

  • Handling day-to-day Alert and failures.
  • Copying data from one table of the instance to another.
  • Database refresh on a regular basis from Production environment to Dev, QA, and Staging Environments.
  • Worked extensively on Performance Tuning and Query Optimization of TSQL queries/procedures and troubleshooting.
  • Implemented Transactional replication with Updatable Subscription between Singapore and Jakarta, UK and US Servers belonging to different domains (cross-domain Implementation).
  • Installation and configuration of New SQL Servers 2008/2008 R2 both clustered and stand-alone on VM’s.
  • Installation of SSIS, SSRS, and SSAS.
  • Deploying of SSIS packages and creating the jobs for the same (DTS and DTSX packages).
  • Worked with DataWarehouse teams in Data profiling by examining, analyzing and reviewing data to collect statistics surrounding the quality and hygiene of the dataset. Make sure the Data quality is achieved with accuracy, consistency, validity and completeness of data.
  • Deploying of .rdl files in SSRS.
  • Backups and restore of SSAS cubes.
  • Monitoring data and log files.
  • Migration of databases from SQL 2000/2005 to SQL 2008/2008R2 Versions.
  • Upgrading SQL instances using side-by-side or in-place upgrades
  • Running of Profiler to capture Trace for Smoke Tests by the Development Team on Dev, QA, Staging, and Production Environment and providing the results for their perusal.
  • Configured of Log shipping as per client requirements as a part of DR strategy and implemented alert mechanisms for any failures of the same.
  • Configured of Mirroring (High Performance/High Safety/High Availability) as per client requirements as a part of DR strategy and implemented alert mechanisms for any failures of the same.
  • User creation and assigning roles in all Environments.
  • Handling Tickets and requests.
  • Handling Onsite and On-call requests.
  • 24/7 support (Weekends On-Call Support).
  • Database bifurcation tasks.
  • Working in Clustered Environment active/active, Active/Passive nodes.
  • Installation and configuration of MySQL on Windows.
  • Automating backup jobs on MySQL Servers.
  • Implemented replication in MySQL on Windows Environment.
  • Creation of Events in MYSQL to automate the job schedules.
  • Creation of Users and assigning roles for the same in the MySQL.
  • Backup and Restore task of MySQL.
  • Maintained and monitored PostgreSQL Databases.
  • Backup and restore of databases in PostgreSQL environment.

Confidential

SQL DBA

Environment: SQL SERVER 2000/ 2005/2008/2008 R2, MySQL 5.1/5.5

Responsibilities:

  • Automated and Manual FULL backups of databases on a daily basis on different instances.
  • Copying data from one table of the instance to another.
  • Checking the data consistency after loading from DB2 to SQL through SSIS packages.
  • Taking care of log files and disk space.
  • Log shipping of databases between the instances and restoring the databases in different environments (DEV, QA, UAT).
  • Worked extensively on Performance Tuning and Query Optimization of TSQL queries/procedures and troubleshooting.
  • User creation and assigning roles.
  • Worked in HealthCare project (i.e. St. Jude Hospital)
  • Creation of Reports and deploying them in Reporting Server.Handling Onsite requests.
  • Extensively worked on Products and Bundles.
  • Query tuning for EIM tasks.
  • Worked on DB2 procedures to make them compatible to MSSQL.
  • Working on Data Migration related issues with DM Team.
  • Handled Siebel Admin works like Repository Migration, List of Values, Sales Agent, PDQ, System Preferences, Data Administration - Order Type, Personalization Administration, Audit Trail, Data Maps, Business Services, Business Service Simulator, Workflows, Web Services, State Model, Organizations, Divisions, Positions, Access Groups, Responsibilities, Views, Responsibility - View, Employees exported from DEV Environment and Imported into UAT Environment.
  • Handling Onsite requests regarding Asset Migration and analyzing data for Data Migration.
  • 24/7 support to the Siebel, BizTalk, and DM teams.
  • Created SSIS packages to load data from flat files, excel spreadsheets, and DB2 Data Source.
  • Running of Profiler to capture Trace for Smoke Tests by the Development Team on Dev, QA, Staging, and Production Environment.
  • Handling Tickets and requests.
  • Handling Onsite and On-call requests.
  • 24/7 support.
  • Configured Mirroring in Asynchronous High Performance mode and monitoring and handling the issues related to mirroring.
  • Database bifurcation tasks. Worked in Clustered Environment active/active nodes.

Confidential

SQL DBA

Environment: SQL SERVER 2000/ 2005/2008/2008 R2, MySQL 5.1/5.5

Responsibilities:

  • Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
  • Created DTS Packages to upload test data from Text files. Text files use to come from those locations where caller application is not used.
  • Used SQL Server Profiler to monitor and record database activities of particular users and applications.
  • Worked extensively on Performance Tuning and Query Optimization of TSQL queries/procedures and troubleshooting.
  • Experienced in Creating SSIS packages to integrate the data coming from various data sources.
  • Maintaining the jobs Scheduled during the night for the Backup of Databases.
  • Taking care of the replication between the LIVE servers and the Central Server on an hourly basis.
  • Supported 24 X 7 production environment.

Hire Now