We provide IT Staff Augmentation Services!

Sql Dba Resume

Memphis, TN

PROFESSIONAL SUMMARY:

  • Around 8 years of experience in DEVOPS, Administration and Development using SQL server 2005/2008/2008 R 2/2012/2014/2016 systems in OLTP and OLAP environment.
  • Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
  • Worked on setting up Jenkins for deployments over lower environments like UAT’s, Stage, Qa and Dev machines
  • Implemented side by side and In place Migration of MS SQL server R 2/2012/2014/2016 and applied Patches and Service packs to update different versions of MS SQL server.
  • Proficient in SQL server 2008 features like Data compression, Resource Governor, Backup Compression, Mail setup, Jobs, Alerts and Database Tuning Advisor.
  • Experience in implementing and setting up Disaster Recovery and High availability solutions like different Clustering (Active - Active) and Replication
  • Experience in regular maintenance activities like Query Tuning , statistics update, Index rebuild , log file monitoring, temp DB monitoring, handling blocking, deadlock resolutions , and fragmentation issues.
  • Explicitly used third party tools like Lite speed and SQL sentry
  • Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
  • Hands on experience in implementing Managed Service Accounts MSA’s on SQL services.
  • Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and Windows logs for hardware related errors.
  • Experience on creating and migrating Databases to DR sites on Azure Platform.
  • Experience in documenting the Root Cause Analysis for various issues like memory and outage of database and related hardware failure.
  • Auditing of database for user’s transaction, login, database action and removing orphan users.
  • Cleared HIPPA certification for PHI related compliance.
  • Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting .
  • Extensively used Repositories like Team Foundation Server (TFS) and Clear Case for Data Archival.
  • Handled numerous Change Management requests on production servers.
  • 24 X 7 Production Database on Call Support.
  • Flexible, Enthusiastic and project oriented team player with excellent communication skills and analytical skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

Operating Systems: Cloud, VM, MDOS, Windows NT/ 2008/2010/2012 R2/2016/2019

Databases: MS SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000, MS Office, Access 97/2000/2003

SQL Server Integration Services: (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data transformation services (DTS), SMTP server services

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, perfmon counters

Third Part Tools: Jenkins, Bamboo, Boomi, Spotfire, Lite speed, Fog lite, Red gate, Web services, SQL sentry, DbAmp.

T: SQL, SAS, XML, Python, Shell, Linux & Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

SQL DBA

Environment: MS SQL Server 2008R 2/2012/2, Windows 2008/2010/2012 R2/2016 SQL, MS Access, ETL, TFS, Spotfire, Spot light, DbAmp.

Responsibilities:

  • Migrating Databases from Sql server 2008 to Sql server 2014\2016.
  • Analyzing long running slow queries and fine tune the same to optimize application and system performance.
  • Used Enterprise Libraries (Application Blocks) and ADO.NET for connecting to the database.
  • Migrating into Hadoop and Salesforce cloud for flexible, cost- effective, reliable, scalable, high-performance and security
  • Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
  • Experience in identifying root cause analysis and fixing the Windows/IIS Web Server Related issues.
  • Implementation of SQL server logins, Roles and Authentication modes as a part of security policies
  • Work on weekly Issues reports which are generated as a part of infrastructure setup
  • Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans
  • Configured Database mail, linked servers
  • Extensively worked on Transparent Data Encryption (TDE) and Auditing
  • Performance tuning of databases by windows performance monitor and SQL Profiler
  • Used Index tuning wizard to redesign and created the indexes for better performance
  • Fine-tune Stored Procedures using Execution Plan in T-SQL for better performance.
  • Documenting all the processes for above, issues, root cause analysis and its solutions in timely manner.

Confidential, St louis, Missouri

DEVOPS\SQL DBA

Environment: MS SQL Server 2008/2008R 2/2012/2014/16, Windows 2003/2007/2010/2012 R2, SQL, MS Access, ETL, TFS, Jenkins, Fog light.

Responsibilities:

  • Integrated Subversion and SQL agent jobs with Jenkins to implement the continuous integration\daily operational process.
  • Migrating Databases from Sql server 2008 to Sql server 2014\2016.
  • Provide 24*7 Application availability using Autoscaling Services, including configuring, defining and testing auto scaling policies and created alarms to call scale up/down policy.
  • Installation of packages, patches, maintenance on production application.
  • Analyzing long running slow queries and fine tune the same to optimize application and system performance.
  • Deploy, monitor and manage applications in Azure cloud using Team foundation server (TFS) into Development, Test and Production web and application server environment.
  • Used Enterprise Libraries (Application Blocks) and ADO.NET for connecting to the database.
  • Migrating into Azure cloud for flexible, cost- effective, reliable, scalable, high-performance and security
  • Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
  • Automating backups using python scripts to transfer data in DR bucket.
  • Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
  • Creating alarms in Cloud and production environments watch service for monitoring server’s performance, CPU Utilization, disk usage etc.
  • Identified and resolved database performance issues, database capacity issues and other distributed data issues.
  • Experience in working on source controller tools like TFS, CVS, IBM Clear case, and GIT.
  • Experience in installing, configuring and deploying Jenkins .
  • Experience building infrastructure as code.
  • Creating scripts that generate reports to proactively monitor the environment
  • Migrating databases to datacenters to Azure (cloud), while maintaining them on daily activity basis
  • Extensive experience PHI related issues and handling them with emergency rebases.
  • Responsible to apply SQL Server quarterly patch on 300 databases including production (before deadline), while still adequately attending to other business needs.
  • Creation of cloud formation Templates of existing environments to use in building similar environments in the same or different regions for High Availability
  • Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
  • Experience in IaaS and PaaS in a hybrid cloud environment working with private and public cloud service providers
  • Created a discussion group for cloud support team in shared point and maintained all documentations in SharePoint .
  • Key member of a Managed Services team that installs, configures and maintains Software, Databases and Web applications .
  • Experience working with Agile/Scrum environment.
  • Perform software installation , upgrades/patches, troubleshooting, and maintenance of Windows SQL environments (Dev, QA, SIT, UAT, Stage, DR and Prod)
  • Providing 24/7 on-call support on a monthly rotational basis
  • Automating database backups using third party monitoring tool with encryption enabled.
  • Documenting all the processes for above, issues, root cause analysis and its solutions in timely manner.

Confidential, Atlanta, GA

SQL Server DBA

Environment: MS SQL Server 2008/2008R 2/2012/2014/16, Windows 2003/2007/2010/2012 R2, SQL, MS Access, SQL sentry, Lite Speed V8.2.1.

Responsibilities:

  • Installed and Upgraded from Sql Server 2008 to Sql server 2014 & 2016 on various Production Servers R2 and upgraded to their respective Service Packs & cumulative upgrades.
  • Implemented Sql Data Compression using Sql server 2008 for compressing data and Log Files, Back Up Level.
  • Installed SQL Server 2014 Failover cluster.
  • Worked on Azure SAAS and PAAS platforms.
  • Worked on Cross Platform Migrations from SQL to Teradata, Oracle, Redshift AWS, Netezza and DB2
  • Worked on various ASP.NET 2.0 web server controls that included Site Map Path, Menu, Tree View, Grid View and Details View to develop web forms.
  • Migrating Databases from Sql server 2008 to Sql server 2014\2016.
  • Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
  • Extensive experience with clinical (Patient, Pay) data
  • Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
  • Identified and resolved database performance issues, database capacity issues and other distributed data issues.
  • Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
  • Analyzing long running slow queries and fine tune the same to optimize application and system performance.
  • Used Power BI for data warehousing concepts
  • Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
  • Scheduled jobs for backup, and created alerts for error reporting.
  • Solving Tickets on Daily Basis for Production Issues.
  • Performed Backups, restores of databases using Lite Speed tool.
  • Checking Database Health by using DBCC Commands.
  • Supporting production team & developers while being On Call DBA.

Confidential, Columbus, Ohio

SQL Server DBA

Environment: MS SQL Server 2005/2008/2008 R2/2012, Windows 2003/2008R2/2010, SSRS, SSIS

Responsibilities:

  • Managed and administered SQL server 2005\2008\R2\2012 servers
  • Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012
  • Configured Windows Fail Over Clustering and SQL Clustering on Multi Subnet Cluster
  • Migrating Databases from SQL Server 2008R2 to Teradata and Netezza DB systems.
  • Create various reports using data sources including AWS- Redshift.
  • Worked on good standard T-SQL queries by using different store procedures, Triggers, Indexes, Views.
  • Configured Active Directory to create users and login groups to access failover clustering
  • Deployment of databases, jobs from pre-production to production
  • Performed installations of SQL 2005\2008\2012\2014 on clustered and standalone servers
  • Worked on moving SQL databases to DR location on Azure Cloud.
  • Upgradations of sql server versions and applying patches and hot fixes
  • Adding nodes to already existing clustered servers as a part of data load\High availability
  • Configured Transactional Replication and Log Shipping with SQL Server Management
  • Implementation of SQL server logins, Roles and Authentication modes as a part of security policies
  • Work on weekly Issues reports which are generated as a part of infrastructure setup
  • Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans
  • Configured Database mail, linked servers
  • Extensively worked on Transparent Data Encryption (TDE) and Auditing
  • Performance tuning of databases by windows performance monitor and SQL Profiler
  • Used Index tuning wizard to redesign and created the indexes for better performance
  • Fine-tune Stored Procedures using Execution Plan in T-SQL for better performance.
  • Write T-SQL Scripts for database backup jobs and daily/weekly jobs
  • Tune slow running queries using SQL Server Profiler
  • Worked with database tuning advisor, SQL server profiler, Performance counters and activity monitor for Performance tuning
  • Used DBCC and DMV commands for day-to-day troubleshooting tasks
  • Import data across multiple instances using BULK INSERT and BCP Utility
  • Involved in Capacity Planning, Database Normalization and De-normalization process
  • Optimize the database server using DMV’s and DMF’s and performed a code review and tuning for the best performance of the application
  • Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.

Confidential

SQL DBA

Environment: SQL Server 2005(Enterprise Manager, DTS, IIS(Internet Information Service) Performance monitor and System monitor, Profiler, QA, Analysis Services), Windows 2003 Advanced Server.

Responsibilities:

  • Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
  • Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
  • Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
  • Experience in identifying root cause analysis and fixing the Windows / IIS Web Server Related issues.
  • Scheduled the backups for Databases and Transaction log. Performed restoration operations.
  • To set up SQL Server configuration settings.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies
  • Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Hire Now