Sql Server Database Administrator
Resume:
Lakshmi G
MS SQL Server Database Administrator
Profile
An experienced MS SQL Database Administrator with detail oriented, analytical, and troubleshooting, installing maintaining and upgrading various servers and databases, simplifying administration process, implementing security checks. Experience Summary
• Microsoft SQL Server DBA with 7+ years of IT experience in Database Administration, Design, Development, Installing and Support of MS SQL Server 2014/2016/2017/2019 in Production, Test and Development and UAT Environment’s.
• Hands on Experience in configuring clustering in Active-Active and Active-Passive nodes. Implemented High Availability and Disaster Recovery by configuring AlwaysON availability groups.
• Implemented Backup and Restore in SQL Server using Native SQL Backups and using Third party tool Netbackup., Extensive Monitoring of SQL Server with DMVs and Third-Party Tools like FOGLIGHT.
• Expert in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities and Dynamic management Views (DMV’s).
• Strong interpersonal skills, written and verbal communication Strong decision- making, problem-solving skills, critical thinking, and testing skills.
• Provided 24/7 database maintenance and production support. Professional Experience
MS SQL Database Administrator
Client Name: Bank of America. NJ 07/2022 – 01/ 2024
• Configuring Always ON availability groups for high availability on same subnet or different subnet nodes.
• Applied SP (Service Pack)/ Hot Fixes on SQL Server instances to address security and upgraded related issues. Drivers and software installation based on application requirement.
• Manage SQL Server databases, Configure and maintain database servers and processes. Monitor system’s health and performance. Ensure high levels of performance, availability, sustainability and security. Analyze, solve, and correct issues in real time.
• Health checks of the Database, Analyze and generate of all tables and index statistics, reorganize indexes, Update statistics, Monitoring data lock issues, review all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes
• Run regular maintenance processes, DBCC, DB Backups and restore, proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner.
• Service account migration to group managed service account using Active Directory Service Credentials Manager. NetBackup configurations, backup and recovery using Veritas client. Backup and restore setup with Cohesity for SQL server 2022.
Contact
*******.****@*****.***
Education
Cerfications
Skills
• Bachelor of Technology
(Computer Science and Engineering)
from Jawaharlal Nehru technological
university Hyderabad, India.
• Master of Technology
(Computer Science and Engineering)
from Jawaharlal Nehru technological
university Hyderabad, India.
• Microsoft Azure Fundamentals
• Administering Microsoft Azure SQL
Solutions
• Database Expertise: MS SQL Server
2014,2016, 2017 and 2019
• Languages: T-SQL, XML, HTML, DHTML
• Ticketing Tools: Service now, JIRA,
ITSM, MySQL Workbench
• Third Party Tools : Foglight, Veritas
NetBackup,Cohesity
• ETL/Data Warehouse Tools:
SSIS/DTS, BCP
MS SQL Database Administrator
WELLPOINT, Baltimore, MD 11/2019 – 04/2022
Responsibilities:
• Over 100+ SQL instances which include SQL 2019/2016/2014/2012
• Managed over 300 Production SQL Servers with zero downtime and no loss of data during time of responsibility from
(MS SQL Server 201/2014/2016/ 2019).
• Implemented Always ON availability groups for high availability.
• Applied SP (Service Pack)/ Hot Fixes on SQL Server instances to address security and upgraded related issues.
• Worked on developing, monitoring, extracting, and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Extensive Monitoring of SQL Server with DMVs and Third-Party Tools like FOGLIGHT.
• Implemented Backup and Restore in SQL Server using Native SQL Backups and using Third party tool LITESPEED.
• Installed and upgraded 2012,2016 versions, Migrated Databases, Agent jobs, Maintenance plans, SSIS packages from 2008/2008R2/2012/2014 to latest MS SQL servers, Involved in patching Service packs and CUs
• Associating with infrastructure team, Application team for efficient database applications.
• Controlling database access permissions, privileges to maintain database security.
• Monitoring MSSQL servers for transaction latency and blocking issues.
• Extensively work in querying and stored procedure and fine tuning the stored procedures.
• Worked on to setup Transactional replication in Prod, QA, and dev environment in 2016, 2019.
• Handling day to day SQL Agent job failures, Maintenance plan and any backup failure.
• Involved in Partitioning Databases and Tables for better Performance.
• Played active role in deployment activities in all environments.
• Handling SQL server securities, roles and permission for SQL users and Logins.
• Administer and monitor 24/7 applications and systems, developing automated alerts to warn of failure MS SQL Database Administrator
National Institute of Health, MD 06/2016 – 10/2019 Responsibilities:
• Involved in 24x7 on call support.
• Managed over 250 Production SQL Servers with zero downtime and no loss of data during time of responsibility from
(MS SQL Server 2016).
• Implemented Always ON availability groups for high availability
• Worked on developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Handling day to day SQL Agent job failures, Maintenance plan and any backup failure.
• Worked on Monthly Deployment from Prod to QA and QA to Dev.
• Worked on third party tools LightSpeed for maintaining Backup and restore in SQL Server.
• Handling SQL server securities, roles and permission for SQL users and Logins
• Production support for SQL server environment.
• Managing server logins, database users and permissions.
• write stored procedures, enable security, and to create and develop best practice databases.
• Maintenance, Support, Backups, Recovery: Monitored daily and weekly maintenance jobs (Backups Jobs, run
• Played active role in deployment activities in all environments.
• DBCC run Rebuild Indexes, run update statics, run audit jobs),
• Created proactive scripts to monitor SQL Servers and generate alerts which monitor backup, drive space, log, DB size and service status monitoring
• Created, Enabled SQL SERVER Audits and reviewed Audit logs
Contact this candidate