Senior Database Administrator

Position Title: Senior Database Administrator

Reports to: Manager – Database Administrator

Shift(s): 08:00 AM to 05:00 PM EST, Rotational on-call support

Location: Greensboro, North Carolina.

Job Title: Senior Database Administrator (MSSQL)

Experience: 10 - 15 years

Job Overview:

We are seeking a skilled and experienced Senior Database Administrator (DBA) with expertise in Microsoft SQL Server (MSSQL) to join our dynamic IT team. The ideal candidate will be responsible for the design, implementation, maintenance, and performance of our MSSQL databases. The successful candidate will work closely with other IT professionals, system administrators, and developers to ensure the integrity, security, and availability of our database systems.

Responsibilities:

1. Database Design and Implementation:

• Design, implement, and maintain MSSQL databases that meet organizational needs.
• Collaborate with application developers to define database structures, tables, and relationships.

2. High Availability Management:

• Implement and manage high availability solutions such as database clustering, mirroring, and AlwaysOn Availability Groups to ensure continuous database access.

3. Monitoring and Alerting

• Set up monitoring systems to track database performance metrics.
• Respond to alerts promptly and proactively address potential issues.

4. Capacity Planning

• Monitor database usage trends and plan for capacity needs.
• Scale resources as necessary to accommodate growing data and user requirements.

5. Backup and Recovery Operations:

• Execute regular database backups and validate their integrity.
• Conduct periodic recovery drills to ensure a quick and effective response in case of data loss.

6. Performance Tuning and Optimization:

• Monitor database performance and optimize queries for maximum efficiency.
• Implement best practices for performance and scalability.
• Identify and resolve performance bottlenecks through query optimization, index tuning, and other performance-enhancing techniques.

7. Security Management:

• Conduct security audits and implement measures to address vulnerabilities.
• Regularly review and update security protocols to protect against unauthorized access.

8. Upgrades and Patch Management:

• Stay informed about the latest MSSQL patches and updates.
• Plan and execute patch deployments in a timely and organized manner.
• Stay current with MSSQL releases and features.

9. Incident Response:

• Respond to and resolve database-related incidents promptly.
• Document incident details and implement preventive measures to avoid future occurrences.

10. Automation and Scripting:

• Develop and implement scripts for routine tasks, automation, and monitoring.
• Explore opportunities for process automation to improve efficiency.

Documentation:

• Create and maintain documentation for database configurations, processes, and procedures.
• Ensure that documentation is up-to-date and accessible to the team.

Collaboration:

• Work collaboratively with cross-functional teams, including developers, system administrators, and network engineers.
• Provide technical support and guidance to team members.

Qualifications:

1. Education:

• Bachelor's degree in Computer Science, Information Technology, or a related field.

2. Experience:

• Proven 10 - 15 years experience as a Database Administrator with a focus on MSSQL.
• Experience in database design, implementation, performance tuning, and troubleshooting.

3. Skills:

• Proficiency in MSSQL administration, including installations, configurations, and upgrades.
• Strong knowledge of database security best practices.
• Excellent problem-solving and analytical skills.
• Familiarity with backup and recovery processes.

4. Certifications:

• Microsoft Certified: Azure Database Administrator Associate (optional but preferred).

5. Communication:

• Strong verbal and written communication skills.
• Ability to communicate technical information to non-technical stakeholders.

Good to have skills, but not mandatory:

• SSIS, SSRS, SnowFlake, t-SQL, PowerBI, PowerShell

If you are a skilled MSSQL Database Administrator looking for a challenging and rewarding opportunity, we invite you to apply and join our team of dedicated IT professionals.