What are the responsibilities and job description for the Senior MS SQL Database Administrator - (Local or Near by states only - 12+Y) position at Cortex Consultants LLC?
Description:
Title: MS SQL Database Administrator
Location: Onsite - Farmington, CT and King of Prussia, PA
Exp: 12 Yrs (Must)
Need a candidates from near by states of Pennsylvania and Connecticut
Job Description:
The ideal candidate will have extensive experience with the following:
- SQL Versions: 2012, 2014, 2016, 2017, and 2019
- Operating Systems: Windows Server 2012, 2016, 2019
- Cloud Platforms: On-Prem, Azure IaaS, Azure PaaS
- Installation, configuration, and maintenance of MS SQL Server instances
- Database upgrades, patching, and performance monitoring
- Implementing high availability, disaster recovery solutions, and backup strategies
- Database performance optimization, health monitoring, and security
- Working with HA, replication, clustering, and mirroring
- Real-time issue resolution and automation of regular processes
Roles and Responsibilities:
- Design and manage physical database architecture and capacity planning
- Conduct SQL Code Reviews to maintain best practices
- Attend Change Advisory Board (CAB) meetings for approval of database changes
- Document operational solutions and educate clients and team members
- Develop custom scripts, stored procedures, and triggers to automate tasks
- Prepare technical and root cause analysis (RCA) documentation
- Troubleshoot and resolve P1 (SEV1) and P2 (SEV2) incidents
- Performance tuning, including index creation and stored procedure optimization
Key Qualifications:
- Proven leadership experience managing L1 and L2 teams
- Strong problem-solving skills and ability to work under pressure
- Excellent written and verbal communication skills
- Availability for 24x7 critical production support and after-hours maintenance