Sql Server Dba Resume
Omaha, NebraskA
PROFESSIONAL SUMMARY:
- Reliable, Result Oriented, Dedicated to Problem Solving, Responsible, Trusted & Proactive SQL Server Database Administrator with expertise in crisis management, performance tuning, and high availability (HA) to increase reliability, maximize productivity and ensure system efficiencies. Adept at all stages of project lifecycle, from business requirements and technical definitions to testing, documentation, production support, training and completion.
- 8 + years of experience supporting SQL server database production environments.
- Provide 24x7 on - call support in SQL Server production databases with VLDBS of multi-terabytes sizes
- Installation and configuration of SQL Server 2008, 2008R2, 2012, 2014 and 2016.
- Experience with implementation of disaster recovery (DR) and strategic planning and testing.
- Implemention of high availability (HA) solutions like AlwaysON, Clustering, Mirroring, Log Shipping.
- Experience with periodic database upgrades; applying patches and hotfixes
- Experience in implementation of backup and recovery strategies.
- Strong database capacity planning and troubleshooting skills.
- Experience monitoring and diagnosing databases for performance issues and tuning for optimazition.
- Good experience in creating packages, stored procedures and functions using T-SQL and PL/SQL.
- High level of self motivation and the ability to work well under pressure.
- Excellent written and verbal communication skills.
- Strong analytical and problem solving skills.
- Good team player with an easy going attitude.
- Enthusiasm to learn new things.
TECHNICAL SKILLS:
OPERATING SYSTEMS: Windows NT, Window 7, 8 and 10. UNIX - Sun Solaris, HP-UX, Linux and AIX.
DATABASES (RDBMS): SQL Server 2005, 2008, 2008R2, 2012, 2014, and 2016. Oracle 10G. Oracle 11Gr1 & Oracle 11GR2.
LANGUAGES: SQL, T SQL, PL/SQL, Shell Scripting.
TOOLS: SQL Server Profiler, Performance Monitor, Activity Monitor, SP WHOisACTIVE, SP WHO2, SSIS, SSRS, SSMS, HP Service Manager, DBboost, SCOM, SQL Sentry, CMDB, ATLAS, ASMS, SQL*Plus, Enterprise Manager, SQL Loader,, RMAN, AWR, Scheduler, Data Pump, RAC,, Active Data Guard, UNIX Shell Scripting, ASM,.
PROFESSIONAL EXPERIENCE:
Confidential, Omaha, Nebraska
SQL Server DBA
Responsibilities:
- Performed SQL Server database design and implementation of the physical and logical layout.
- Installed, configured and upgraded SQL Server softwares and related products.
- Performed capacity planning for all SQL Server databases that ensures stability and reliability.
- Established and maintained good backup and recovery policies and procedures in accordance with the Service Level Agreement (SLA) with our clients.
- Performed the daily maintenance health checks of all SQL Server databases.
- Helped implement and support a reliable and stable High Availability 3 nodes failover clustered production environment with very large databases (VLDBS)
- Provided a Zero down time production database environment to clients by implementing and configuring ALWAYSON High Availabilty solution with primary and multiple secondary replicas with associated availability groups (AG) across multiple cluster nodes using Sql Server 2016
- Monitoring and diagnosing database for performance problems and resolutions.
- Implemented database security in all SQL server databases using privileges, roles and profiles.
- Implemented SQL Server high availability solutions like failover clustering, Mirroring, and replication.
- Supported SQL Server production environment in a 24x7 oncall rotation to provide off hours support.
- Worked with developers team to test and tune SQL queries and T-SQL coding.
- Worked with the application team to deploy changes in the production databases.
Confidential, Atlanta, Georgia
SQL Server DBA
Responsibilities:
- Provide 24x7 oncall support in SQL Server 2005. 2008, 2008R2, 2012, 2014 and 2016 production environments.
- Installation and configuration of multiple SQL Server instances in production environments to meet company’s business needs.
- Helped company meet and exceed SLA to provide a Zero down time production database to clients. I accomplished this by implementing and configuring ALWAYSON high availability solution with primary and secondary replicas with associated availability groups (AG) across multiple cluster nodes using Sql Server 2016.
- Implemented and supported high availability solutions like clustering, log shipping and mirroring.
- Helped implement and support a reliable and stable clustered production environment with very large databases (VLDBS) in a SQL Server ACTIVE/PASSIVE 4 nodes failover clustering.
- Delivered a disaster recovering strategy that saved the company from data loss in our service deliverables to the clients and as such prevented any penalties and fines from clients.
- Successfully implemented backup and recovery strategies and practices that ensure that company maintain successful database backups daily that meet the recovery requirements as SLA stipulate
- In critical situation helped to restore corrupted databases to a point in time with zero data loss.
- Performed database refreshes to meet customers demand as needed.
- Effectively maintain over 800 production databases to deliver a very stable production environment.
- Maintained stable environment by automating various maintenance tasks like backups, index reorg, index rebuild, daily health checks in all production databases.
- Promote and ensure best SQL Server database security practices by developing very controlled and monitored strategies to managing users access, roles and privileges to resources.
- Proactively engage in various tuning techniques to deliver a high performance production database environment with minimal to zero down time.
- Deployed effective changes to our environments by engaging in the practice of obtaining change control approvals prior to database maintenance.
- Ensured that all database related incident tickets are resolved on time as stated in the SLA.
- Identify issues mitigating against project goals, develop and implement corrective solutions.
- Interfaced with Microsoft and other vendors for technical support via service request tickets and technical assistance (TARs).
Confidential, Atlanta, Georgia
Oracle DBA / SQL Server DBA
Responsibilities:
- Involved in 24x7 support of SQL and Oracle production database platforms.
- Install and configure multiple SQL Server instances in production environment.
- Migrate databases from MySql and SQL Server 2005 to SQL Server 2008R2.
- Design and implement disaster recovery for SQL Server production databases.
- Create and maintain database tables, stored procedures and indexes
- Implement Mirroring and LogShipping to ensure database high availability.
- Embark on upgrades and deployed service packs and hot fixes on production servers.
- Implemented security management policy by creating and managing users, roles and permissions.
- Effectively manage the ticket queue and a balance work load among the DBAs continually