We provide IT Staff Augmentation Services!

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.

We'd love your feedback!