Database Administrator Resume
2.00/5 (Submit Your Rating)
TX
SUMMARY
- Database Administrator utilizing over4+years of experience in teh Relational Database Management System.
- Strategic and innovative Database Administrator wif proven ability to develop business solutions that improve performance, productivity, profitability and growth.
- Ability to ensure teh technical integrity of corporate databases by protecting against theloss or misuse of information and designing backup/recovery strategies
- Experience in troubleshooting and problem solving of SQL Server
- Database administration including installation, configuration, upgrades, capacityplanning, performance tuning and optimization, backup and recovery in managingclusters of SQL servers.
- Experience wif High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server: Clustering, AlwaysON, Replication, Log shipping and Database mirroring.
- Solid experience in Eliminating Blocking issues, performance monitoring wif Activitymonitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs andDMFs, SQL Diagnostic Manager
- Troubleshoot databases and custom application issues for 2005, SQL Server 2008 R2, SQL Server 2012, 2014 and 2016.
TECHNICAL SKILLS
- SQL Database Security
- Microsoft SQL Server
- SSIN
- Unix
- Relational Database
- Microsoft Access
- Disaster Recovery and Backup
- Database Performance tuning
- Database Replication
- Maintaining High Availability Solutions
- Database upgrades and patches
- Windows
PROFESSIONAL EXPERIENCE
Confidential, TX
Database Administrator
Responsibilities:
- Ensure database performance monitoring and tuning is regularly accomplished.
- Troubleshoot databases and custom application issues
- Develop recovery procedures for each database.
- Provide constant remote support to SQL Servers on customer sites of variousCompanies to prevent downtime.
- Rebuilding teh indexes at regular intervals for better performance.
- Establish standards and schedules for database backups by making sure that thebackup schedules meet teh recovery requirements on a daily, weekly, and monthlybas
- Proactively monitoring teh entire instances and databases for any abnormalities.
- Standardize processes wifin teh data ops department including creatingdocumentations for installations, migrations, upgrades, backups, restores, indexMaintenance, etc.
- Create database design for new projects support.
- Coordinate team meetings wif groups for new design/strategies.
- Design backup and restore strategies and Disaster Recovery Solutions.
- Create logical and physical data models based on approved business requirements.
- Monitor and maintain database performance; identify and recommend areas thatneed improvement.
- Work wif a team of DBAs to implement and maintain database mirroring
- Established and enforced controls to ensure database integrity.
Confidential, GA
Database Administration
Responsibilities:
- Worked wif SQL Server tools like Enterprise Manager and SQL Query Analyzer.
- Provided technical assistance to computer user in training room networks.
- Designed and implemented comprehensive Backup plan and disaster recoverystrategies.
- Analyzed long running slow queries and tuned same to optimize systemperformance.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Rebuilding teh indexes at regular intervals for better performance.
- Develop and implement project work plans and review as appropriate to meetchanging needs and requirements.
- Evaluate project and recommend report to identify issues and opportunities toimprove performance going forward.
- Interact clearly, constructively and positively wif all organizational departments toensure projects are completed TEMPeffectively and wif minimal disruption to plannedproject.
- Preparation of data extracts and narrative report for managerial reporting standard.
