What are the responsibilities and job description for the Database Administrator position at The Intersect Group?
Position Overview
The Database Administrator (DBA) is responsible for installing, configuring, and maintaining enterprise database systems to ensure high performance, availability, and reliability. This role plays a critical part in safeguarding data integrity by establishing and enforcing database standards, security controls, and operational procedures.
The DBA will lead performance tuning efforts, monitor database health, troubleshoot complex issues, and manage backup and disaster recovery strategies. This position also supports cloud-based database platforms, particularly Microsoft Azure, to enable scalable and resilient data environments.
Key Responsibilities
- Administer, maintain, and optimize database platforms including SQL Server, Azure SQL, MySQL, and Databricks
- Diagnose and resolve performance issues across OLTP and data warehouse environments
- Design and implement high availability and disaster recovery (HA/DR) solutions (AlwaysOn, clustering, replication, failover groups)
- Develop and implement monitoring, automation, and proactive performance tuning strategies
- Lead database migrations, upgrades, and modernization initiatives
- Collaborate with engineering, DevOps, analytics teams, and external vendors on integrations and enhancements
- Ensure database security, compliance, backup, and recovery processes meet enterprise standards
Required Qualifications
- Deep expertise in SQL Server and Azure SQL environments
- Advanced skills in query tuning and performance optimization
- Strong experience with HA/DR strategies and database security best practices
- Expert-level knowledge of database design, including schema architecture, data modeling, and indexing strategies
Preferred Qualifications
- Experience with Microsoft Fabric, Power BI, or other analytics platforms
- Hands-on experience with Databricks
- Familiarity with DevOps pipelines and CI/CD processes
- Strong scripting and automation experience (e.g., PowerShell, Python)
Key Skills & Competencies
- Strong analytical and problem-solving skills
- Ability to work cross-functionally with technical and non-technical stakeholders
- Effective communication and documentation skills
- Proactive mindset with a focus on performance, scalability, and continuous improvement
Education & Certifications
- Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience)
- Relevant certifications (e.g., Microsoft Azure Database, SQL Server) are a plus
Salary : $90,000 - $120,000