We provide IT Staff Augmentation Services!

Sr. Sql Dba Resume

Austin, TX

SUMMARY

  • Over 19 years IT experience and 13 years of experience in SQL Server DBA, Azure and AWS EC2, RDS.
  • Experience in Database Backup, Recovery and Disaster Recovery procedures.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities, Capacity Planning.
  • Expert in installation, upgrade and configuration of MS SQL Server and databases in clustered and standalone environment.
  • Having very good experience as Lead role for onshore and offshore model.
  • Having very good expertise in windows batch and power shell scripting.
  • Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL server 2005/2017.
  • Experience in Migrations from on premise to AWS and Azure cloud environments.
  • Hands on experience in Machine Learning for data science projects using Python.
  • Implemented Database Mirroring as a High Availability Solution.
  • Implemented different types of Replication Models like Snapshot, Merge and Transactional.
  • Hands - on experience on premise MS SQL Server to AWS/Azure migration.
  • Experience in creating packages, jobs, sending Alert using SQL Mail and Database mail.
  • Creation and Maintenance of Databases, Creating Roles and managing user Permissions, resolving deadlocks
  • Experience in cloud AWS SQL Server installation, maintenance and configuration.
  • Working knowledge on SAN (VNX, EMC, IBM and HP Arrays) for SQL Server Databases and good understanding in capacity planning.
  • Working experience in HPSD, ITSM, VM Service Manager and ITG ticketing tools.
  • Experience in Microsoft SQL Server CLUSTERING and experience in Tracing SQL Server events and SQL Profiler to McAfee monitor events in an instance of Microsoft SQL Server and AWS.
  • Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirements.
  • Experience in upgrading SQL Server, applying service packs/hot fixes and perform unattended Installations.

TECHNICAL SKILLS

Databases: MS SQL Server 2008, 2008 R2, 2012, 2014 and 2016 CTP 2, MySQL and Cosmos

Scripting Languages: HTML, DHTML, JavaScript, VB script

Reporting: SSRS, Crystal Reports XI, Power BI

Tools: SSIS, IIS, SQL Backup, Foglight, Symantec Net backup, Avamar, Commvault, JIRA, SVN, Cherwell, BMC Remedy

Networking: TCP/IP, DNS, WINS, DHCP

Other Tools: Quality Center, MS Project

PROFESSIONAL EXPERIENCE

Sr. SQL DBA

Confidential, Austin, TX

Responsibilities:

  • Day to day Production support of MS SQL Databases
  • Working with Json for data exchange from non sql environments.
  • Perform Installs, System refreshes, Upgrades and Validation of Database systems.
  • Facilitate clear communication within group, others in IT, the Management teams and Project leads.
  • Design and implement High Availability as per the IT requirements.
  • Good understanding on Database security, application interface and user management.
  • Experience in debugging and tracing SQL performance issues using SolarWinds tool.
  • Experience in SQL replication, log shipping, mirroring, and AG groups.
  • Good understanding Physical and Virtual (VMware) infrastructure.
  • Created and Configured Azure Cosmos DB and exposed the service as Web API.
  • Experience in Moving Data in and out of Windows Azure SQL Databases and Blob Storage
  • Experience in TDE and Micro segmentation/Firewall controls in Azure Paas and Iaas.
  • Experience in configuring and optimizing the performance of Databases.
  • Configured Input & Output bindings of Azure Function with Azure Cosmos DB collection to read and write data from the container whenever the function executes.
  • Experience in Azure cloud architecture and security aspects.
  • Administering databases in Azure cloud platform and manage Azure Geo-Replica databases.
  • Expertise in SQL server clustering, Always On (VM level) and replication
  • Ability to interact and influence variety of users.
  • Demonstrate Hands on experience in on premise Power BI report server, Desktop installation and configuration.
  • Write power shell scripts to create database and granting access etc. as part of automation process.
  • Installation and configuration of MySQL and MSSQL server 2017.
  • Responsible for Monitoring and Troubleshooting SQL Jobs, Scheduled Tasks, Disk spaces, Error logs and making recommendations for performance improvement in hosted databases which involved Index creation, Index removal, file group modifications, and scheduling jobs to rebuild/reorg indexes and update statistics.
  • Hands on IIS applications configuration and applying SSL certificate
  • Experience in Microsoft SQL Server Always on as part of HADR solution
  • Hands on Microsoft SQL Server Always on along with TDE configuration for High critical financial data
  • Create the backup and restore strategy for production, development and test environments.
  • Hands on experience in DDM for masking to show confidential data.
  • Troubleshooting DB errors and potentially contacting vendors for technical support in AWS.
  • Involved in Alwayson for High Availability and reporting purpose and created the documentation
  • Hands on BMC Remedy for CR and Work orders to create and implement the changes.
  • Create and maintain AWS SQL Server, migration database from on-premise to AWS EC2.
  • Hands on experience publishing PBIX reports on cloud and granting access as per security policy.
  • Working on database storage migration from 4k block size to 64K block size on sql server 2017.
  • Installing and configuration Python and R features in prod environment.
  • Implement Security policies against all PBIX reports environments.
  • Configure Alwayson with TDE for security prospective and HADR policy.
  • Exposure in Create and deploy Azure Resource Manager templates by using the Azure portal.
  • Automate database refresh from Prod to non-prod environments.
  • Experience in automate the dashboard refreshes, publishing the dashboards to the granted people within the enterprise by publishing the dashboards to the powerbi.com service.
  • Maintenance - Schedule an official maintenance, do all required health checks on all premium databases and servers using windows batch and power shell.
  • Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards, Database Engine Tuning Advisor.
  • Provided Security, consistency, efficiency, track state etc.
  • Working on missing indexes and fine tune the server to access the application using native management task.
  • Check Performance counters on all Production/Non-Production servers and verify that all counters are within the normal range.

Sr. SQL DBA

Confidential, Sunnyvale, CA

Responsibilities:

  • Demonstrate Hands on experience in on premise SSRS and Power BI report server, Desktop installation and configuration.
  • Hands-on experience using JIRA for ticketing and deploy the code from SVN.
  • Write power shell scripts to create database and granting access etc. as part of automation process.
  • Experience working with Azure SQL Database Import and Export Service.
  • Worked on Data exporting form csv and automate the data exporting process.
  • Working with data science team using python and Cassandra for data science (ML) projects.
  • Hands on IIS applications configuration and applying SSL certificate
  • Experience in Microsoft SQL Server Always on as part of HADR solution
  • Hands on Microsoft SQL Server Always on along with TDE configuration for High critical financial data
  • Create the backup and restore strategy for production, development and test environments.
  • Hands on experience in DDM for masking to show confidential data.
  • Troubleshooting DB errors and potentially contacting vendors for technical support in AWS.
  • Involved in Alwayson for High Availability and reporting purpose and created the documentation
  • Installation and configured with Azure Cosmos DB collection to read and write data from the container whenever the function executes along with Web API.
  • Create and maintain AWS SQL Server, migration database from on-premise to AWS.
  • Hands on experience publishing PBIX reports on cloud and granting access as per security policy.
  • Working on database storage migration from 4k block size to 64K block size on sql server 2017.
  • Installing and configuration Python and R features in prod environment.
  • Implement Security policies against all PDWX reports environments.
  • Configure Alwayson with TDE for security prospective and HADR policy.
  • Exposure in Create and deploy Azure Resource Manager templates by using the Azure portal.
  • Automate database refresh from Prod to non-prod environments.
  • Experience in automate the dashboard refreshes, publishing the dashboards to the granted people within the enterprise by publishing the dashboards to the powerbi.com service.
  • Maintenance - Schedule an official maintenance, do all required health checks on all premium databases and servers using windows batch and power shell.
  • Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards, Database Engine Tuning Advisor.
  • Provided Security, consistency, efficiency, track state etc.
  • Working on missing indexes and fine tune the server to access the application using native management task.
  • Check Performance counters on all Production/Non-Production servers and verify that all counters are within the normal range.

Confidential

Lead SQL Server DBA

Responsibilities:

  • Responsible for SQL Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups using Commvault Backup tool.
  • Performed database Storage migration from 4k block size to 64K block size on sql server 2016.
  • Analyzed performance statistics on the databases to provide feedback on database performance. This also includes performance tuning of database at a physical level, through file structure, index rebuilds and hardware modifications as well as at query and index level using tools such as profile, explain/execution plan and SolarWinds tool.
  • Working with ETL team for designing data dictionaries, physical and logical database models.
  • Used automated tool ivanti to schedule sql patching.
  • Check the fragmentation and rebuild/ reorganize the indexes using Idera data tools.
  • Responsible for administering clusters and Always on SQL server 2012 and 2016.
  • Prepared the build release checklist for Non Production and Production environments.
  • Performed health checks on all premium databases and servers using windows batch and power shell.
  • Developed Power BI model used for financial reporting of P & L and Headcount.
  • Designed and documented the entire Architecture of Power BI Report Server.
  • Expertise in writing complex DAX functions in Power BI and Power Pivot.
  • Deploy a dynamic automate migration databases to AWS environment.
  • Working on missing indexes and fine tune the server to access the application Idera quickreindex.
  • Configure Transactional replication on premise and AWS SQL Server.
  • Check Performance counters on all production servers and verify that all counters are within the normal range. Performance analysis and evaluation of queries and databases in a slow running application and monitoring/optimizing/tuning the performance in SSIS and SSRS.

Confidential, West Bend, WI

Sr. SQL DBA

Responsibilities:

  • Designed a procedure that continuously run on all PROD servers and notifies DBA team if any blockings, long running queries/transactions using Idera tool.
  • Working with Microsoft SQL Server Always on, Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server.
  • Responsible for SQL Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups using Avamar Backup tool.
  • Installation and configure SQL Server in AWS EC2 environments for on premise and cloud applications.
  • Successfully migrated databases from SQL Server 2012 to 2014.
  • Check the current queue for requests and identify requests to be processed and work on the issue.
  • Prepare the build release checklist for Non Production and Production environments.
  • Check Performance counters on all production servers and verify that all counters are within the normal range.
  • Performed optimization of T-SQL procedures, removing the deadlocks, Client/Server connectivity.
  • Performance analysis and evaluation of queries and databases in a slow running application and monitoring/optimizing/tuning the performance in SSIS and SSRS.

Confidential, Tampa FL

Sr. SQL Server DBA

Responsibilities:

  • Worked with Microsoft SQL Server Always on, Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Servers.
  • Responsible for SQL Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
  • Check the fragmentation and rebuild/ reorganize the indexes. We can use a native procedure which takes care of the task.
  • Check the current queue for requests and identify requests to be processed and work on the issue.
  • Prepare the build release checklist for Non Production and Production environments.
  • Maintenance - Schedule an official maintenance, do all required health checks on all premium databases and servers using windows batch and power shell.
  • Implemented TDE for few databases in Production Environment.
  • Worked on missing indexes and fine tune the server to access the application.
  • Checked Performance counters on all production servers and verify that all counters are within the normal range. Designed SSRS metrics report to review the counters for every one hour.
  • Responsible for the management of the database performance, backup, replication, capacity planning and giving guidance for the developers.
  • Worked in Tracing SQL Server events and SQL Profiler and McAfee monitor events in an instance of Microsoft SQL Server, involved in Performance Tuning of Code using execution plan and added Indexes to improve performance on tables.

Confidential, Houston TX

Sr. SQL Server DBA

Responsibilities:

  • Worked on data integration (SSIS) with Data HUB team to prepare Data growth report.
  • Responsible for Database & Log Backups, Restoration, Backup Strategies, Scheduling Backups.
  • Manage Storage & IO performance issues related to SQL databases
  • Prepare the build release checklist for Non Production and Production environments.
  • Working on missing indexes and fine tune the server to access the application.
  • Worked on SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.
  • Monitored performance and optimized SQL queries for maximum efficiency, worked with SQL Server 2008 R2 Service Broker Applications and hands on experience in SolarWinds tool.
  • Implementing Log Shipping and Database Mirroring. Monitoring with SQL Profiler to capture and save data about the event to a file or table to analyze later
  • Responsible BMC utilities and the management of the database performance, backup, replication, capacity planning and giving guidance for the developers.
  • Worked in Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server, involved in Performance Tuning of Code using execution plan and added Indexes to improve performance on tables.
  • Performance analysis and evaluation of queries and databases in a slow running application and monitoring/optimizing/tuning the performance in SSIS and SSRS.
  • Checking the status of Backup troubleshooting the failed backups and Restoration of databases

Confidential, PA

Sr. SQL Server DBA

Responsibilities:

  • Worked with MS SQL Server Database Security, SSIS, Encryption Keys and Auditing SQL server Systems.
  • Worked with Microsoft SQL Server clustering, Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server.
  • Creation of schema objects, granting roles and privileges to the users, compilation of procedures.
  • Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups
  • Successfully performed migration from SQL 2008 to SQL 2012.
  • Handling 1.2TB database size and average DB size more than 500GiB.
  • Refreshed databases when necessary, worked in SQL Server Performance Tuning and Query Optimization.
  • Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures
  • Monitored performance and optimized SQL queries for maximum efficiency, worked with SQL Server 2005 Service Broker Applications
  • Implemented Log Shipping and Database Mirroring. Monitoring with SQL Profiler to capture and save data about the event to a file or table to analyze later
  • Responsible for the management of the database performance, backup, replication, capacity planning and security.
  • Worked in Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server, involved in Performance Tuning of Code using execution plan and added Indexes to improve performance on tables.
  • Installed and configured MS SQL Server 2005/2008 and 2012 (Personal, Standard and Developer Editions)
  • Excellent skills in Optimization of T-SQL procedures, removing the deadlocks, Client/Server Connectivity and guidance to developers.

Hire Now