Ms Sql Database Administrator/operation Analyst Resume
4.00/5 (Submit Your Rating)
Pittsburgh, PA
Objective
- Accomplished and highly qualified DBA wif over 4 years of hands - on experience and extensive database administration.
- My career goal is to be a part of a growing organization and aid in accomplishment of organizational objectives by utilizing my knowledge wif what I have learned and is still learning.
- I is equipped wif an excellent work ethic, possesses a strong sense of responsibility and teamwork wif a track record of dependability.
SUMMARY
- Working Experience as a Database Administrator.
- Responsible for daily maintenance of environments comprising of over 40 servers, 250+ Instances and 500+ databases.
- Planned and executed database migration.
- Enhanced database performance by implementing recovery procedures and achieved 99.9% up time on all SQL Servers.
- Increasing efficiency by 25% using optimum database performance wif efficient backup and restore processes.
- Strong Experience wif SQL Server 2016 through 2019 Administration standalone and cluster environments.
- Configured and supported replication (Snapshot/Transactional/Merge/Peers to Peers) and log shipping in both SQL 2016 through 2019 Servers.
- Production level support for onsite and offshore - On Call 24/7 environment.
- Configured and Managed High Availability (HA) and Disaster Recovery (DR) Solutions (Log Shipping, Always On, Clustering, and Replication).
- Interacts wif clients, application team and project managers to design, implement and support solutions to meet client needs.
PROFESSIONAL EXPERIENCE
Confidential, Pittsburgh, PA
MS SQL Database Administrator/Operation Analyst
Responsibilities:
- Upgrade SQL in our environment.
- Windows and SQL patching.
- Responds to ticket queue (refreshing databases, creating logins and users).
- Perform all day-to-day aspects of MS SQL database administration such as database design, installation, security, managing users and logins, performance monitoring and tuning, database availability, backup and recovery, troubleshooting and problem resolution.
- Configure High Availability Solution- Always On Cluster, Traditional Failover Clustering and Log Shipping.
- Involve in ensuring data recovery, maintenance, and data integrity and space requirements for physical database.
- Creating and Modifying Tables, Views, Indexes, and Triggers etc. as requirement on SQL Server Environments.
- Respond to and resolved all database access and performance issues.
- Install SQL Server 2012, 2014, 2016 and 2017 on servers, applied security fixes.
- Daily Health Check-up of all Databases.
Confidential, McKees Rocks, PA
MS SQL Database Administrator
Responsibilities:
- Provided DBA support and technical expertise for multiple applications in development, test, QA and production SQL Server, 2005, 2008, and 2012, 2014,2016,2017 environments.
- Upgraded Databases from lower versions of SQL to a higher version
- Administered, Managed, Developed, and configured SQL Server database design following best practices.
- Involved in troubleshooting and resolving issues that may arise wif SQL Server
- Performed Database Migration from an On-Premises SQL environment to Azure Database in teh cloud.
- Developed and Implemented Disaster Recovery (DR) Plan.
- Tested, Implemented different Physical and Logical Backup and Recovery methods - Point-in Time, Media Recovery.
- Implemented maintenance jobs.
- Daily Health Check-up of all Databases.
- Database Design/Data Modeling.
- Documented all my processes in a step- by -step manner to keep up wif a good knowledge sharing policy wifin teh team and teh entire company.
Confidential
Team lead
Responsibilities:
- Planned, prepared, and implemented a schedule/roster for teh day-to-day operation of teh NOC.
- A comprehensive schedule/roster that ensured teh NOC is covered 24 hours a day, 7 days a week and 365-days a year.
- Developed accurate weekly NOC clear shows resolved and pending issues.
- Status report on pending issue that clearly. shows issue pending on spare parts, logistics, and resources.
- Followed up wif trouble ticketing system to ensure 100% fault resolution.
- From customer escalation, trouble ticket. creation, assignment, tracking, fault detection, fault reporting, and fault resolution.
- Monitored teh ticket queue/reports to ensure tickets never exceed company’s SLA agreement policy.
- Coordinated both internal and external fault escalations, followed up wif external customers/subscribers after fault. resolution to ensured 100% customer satisfaction.
- Planned and organized customer service in-house training to increase NOC employee’s productivity and confident.
- Supported field technicians on nodes and equipment troubleshooting process to ensured 100% fault resolution.
- Maintained a 0.5% threshold downtime on all teh nodes, worked closely wif teh field technician to restore node failures.
- Maintained 100% positivity, empathetic and professional attitude toward customers always.
- Kept and updated records of customer interactions, transactions, comments, and complaints.
