Key Responsibilities:
Database Administration:
- Installation & Configuration: Install, configure, patch, and maintain SQL Server instances (2008, 2012, 2014, 2017, 2019, 2022).
- Management & Monitoring: Oversee database performance, manage daily operations, and monitor system health to ensure optimal performance.
- Troubleshooting: Diagnose and resolve issues related to SQL Server, including performance bottlenecks and system outages.
Data Management & Analysis:
- Daily Operations: Perform daily data updates, reviews, and evaluations.
- Code Management: Revise queries and stored procedures, and handle data scrubbing and code modifications as needed.
Reporting:
- Report Design: Design, implement, and enhance operational progress reports.
- Quality Assurance: Review and inspect the quality of daily and ad hoc reports.
Database Design & Deployment:
- Structure Maintenance: Support the design, implementation, and maintenance of database structures.
- Source Code Deployment: Manage source code deployment from Team Foundation Server (TFS).
Team Collaboration:
- On-Call Support: Participate in on-call rotation with availability for after-hours and weekend work.
- Teamwork: Collaborate effectively within a team environment and also work independently when required.
- Knowledge Sharing: Contribute to team knowledge and help others by sharing expertise and assisting in problem-solving.
Multitasking & Attention to Detail:
- Fast-Paced Environment: Demonstrate the ability to multitask and manage priorities effectively in a dynamic, fast-paced environment.
Qualifications:
- Experience: 7-10 years of recent, contiguous experience as an MS SQL Server DBA.
- Enterprise Experience: Experience working in medium to large-sized enterprises.
- Technical Expertise: Proficiency with SQL Server versions 2008 through 2022.
- Skills: Strong skills in data management, analysis, reporting, and database design.
- Team Skills: Proven ability to work as a team player, lead initiatives, and collaborate across teams.
- Detail-Oriented: High attention to detail and ability to handle multiple tasks efficiently.