- Responsible for daily maintenance of large environments comprising of over 200 servers, 500+ Instances and 750+ databases
- Enhanced database performance, implemented recovery procedures and achieved 99.9% up time on all SQL Servers.
- Increased efficiency 25% by providing optimum database performance with efficient backup and restore processes.
- Strong Experience with SQL Server 2008 through 2017 Administration standalone and cluster environments
- Configured and supported replication (Snapshot/Transactional/Merge) and log shipping in both SQL 2008 through 2014 Servers.
- High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping.
- Query Store, Import/Export Wizard, SSMS, SQL Server Profiler, Extended Events and Tuning Advisor tools
- Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs.
- Excellent knowledge in trouble shooting complex data issues, complex queries using traditional tools; SQL Server profiler, Execution plan and Extended Event
- Strong Experience with SQL Server 2008 through 2017 Administration.
- Achieved 99.9% uptime on all SQL Servers.
- Installed and configured a SQL 2012 clustered environment with availability groups.
| - Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs, create and maintain documentation.
- Install and Upgrade SQL Server 2008, 2012, 2014, database standalone / cluster instances service packs.
- Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2005, 2008, and 2012, 2014 environments.
- An excellent team player with a very positive can-do attitude.
- Efficient problem solver and decision-making abilities.
- Performed query tuning to improve performance.
- Previous experience in production environments and on-call.
- Financial Oversight
- Budgeting
- Scheduling
- User Interfaces
- Documentation And Reporting
|