Senior Database Administrator

Job Summary

We are seeking an experienced Senior Database Administrator (DBA) to lead and manage our database infrastructure, ensuring optimal performance, security, and scalability. The ideal candidate will have extensive experience with SQL Server, PostgreSQL, and MongoDB, along with a strong background in database architecture, performance tuning, and disaster recovery planning. This role requires a proactive leader capable of mentoring junior staff and collaborating with cross-functional teams to align database solutions with business objectives.

Key Responsibilities

Database Architecture & Design

• Lead the design, implementation, and maintenance of complex database systems.
• Ensure database solutions align with business requirements and industry best practices.
• Collaborate with development teams to optimize database schemas and queries.

Performance Tuning & Optimization

• Monitor and analyze database performance, implementing tuning strategies to enhance efficiency.
• Identify and resolve performance bottlenecks, ensuring high availability and reliability.
• Utilize advanced indexing, partitioning, and query optimization techniques.

Security & Compliance

• Implement and enforce database security policies, including access controls and encryption.
• Ensure databases comply with industry standards and regulatory requirements.
• Conduct regular audits and vulnerability assessments to maintain data integrity.

Disaster Recovery & High Availability

• Develop and maintain comprehensive backup and recovery strategies.
• Implement and manage high availability solutions, such as Always On Availability Groups and replication.
• Lead disaster recovery planning and testing to ensure business continuity.

Automation & Scripting

• Automate routine database maintenance tasks using PowerShell, T-SQL, and other scripting languages.
• Develop and maintain scripts for database deployment, monitoring, and alerting.

Mentorship & Collaboration

• Provide guidance and mentorship to junior DBAs and development teams.
• Collaborate with infrastructure and application teams to ensure seamless database integration.
• Participate in on-call rotation to provide 24/7 support for critical database issues.

Requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum of 5 years of experience in database administration, with a focus on SQL Server.
• Proven experience with PostgreSQL and MongoDB in a production environment.

Technical Skills:

• Expertise in SQL Server 2012 and later versions, including Always On Availability Groups, replication, and SSRS/SSIS.
• Strong knowledge of PostgreSQL and MongoDB administration, including performance tuning and backup strategies.
• Proficiency in scripting languages such as PowerShell and T-SQL for automation tasks.
• Familiarity with cloud platforms (e.g., AWS RDS, Azure SQL Database) and containerization technologies (e.g., Docker, Kubernetes).

Soft Skills:

• Lead, coach, and develop team members to ensure strong performance and continuous growth.
• Strong analytical and problem-solving abilities.
• Excellent communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Detail-oriented with a proactive approach to identifying and resolving issues.

Preferred Qualifications:

• Certifications such as Microsoft Certified: Azure Database Administrator Associate or MongoDB Certified DBA.
• Experience with database migration and upgrade strategies.
• Familiarity with DevOps practices and CI/CD pipelines related to database deployments.