Lead Database Administrator

Job Summary

We are looking for a passionate and highly skilled Lead Database Administrator (DBA) with expertise in managing diverse database environments, including Big Data platforms and traditional databases. The ideal candidate will be responsible for building, maintaining, and optimizing databases, ensuring high availability and reliability across all systems. This role includes troubleshooting production issues, performance tuning, collaboration with engineering teams, and continuous improvement through automation and innovation.

The Lead DBA will play a critical role in ensuring efficient database performance, implementing best practices for disaster recovery and backup strategies, and contributing to the technical roadmap and architectural plans for the organization’s database infrastructure.
Key Responsibilities

• Collaborate with development teams to design and implement database solutions that meet business needs.

• Design databases based on business requirements, ensuring scalability and performance.

• Design and maintain database objects such as tables, indexes, constraints, and triggers to ensure data integrity and performance.

• Continuously monitor and optimize database system performance, including query execution time, index usage, and stored procedures.

• Perform database tuning, index maintenance, and data monitoring to enhance performance.

• Oversee the full database lifecycle, from implementation to maintenance, ensuring system reliability and availability.

• Implement disaster recovery and high-availability strategies, including backup/recovery processes, data archiving, and replication.

• Allocate and optimize physical data storage and ensure efficient query and storage processes.

• Coordinate data migrations and upgrades between different systems and platforms.

• Develop and enforce change control processes for database modifications, ensuring proper testing and documentation.

• Set up and manage user access control to ensure data security and compliance.

• Plan, schedule, and document the installation, configuration, and testing of database environments.

• Provide on-call support for production databases, ensuring minimal downtime and quick issue resolution.

• Assist development teams in optimizing queries, stored procedures, and database design to improve application performance.

• Define and implement best practices for disaster recovery (DR) and backups.

• Collaborate with the monitoring team to establish a comprehensive monitoring program, defining metrics and reporting.

• Stay current with industry trends and continuously improve the database environment through automation and new technology adoption.

• Patching and configuring databases to follow security guidelines and fix vulnerabilities.

• B.S. in Computer Science, Information Systems, or a related field.

• Minimum of 3 years of experience as a Database Administrator, with at least 2 years working with MySQL/PostgreSQL. Additional experience with platforms such as SQL Server, Oracle, MongoDB, and MariaDB is preferred.

• Strong understanding of database structures, principles, and best practices.

• Proven experience in designing, building, and supporting database systems in a production environment.

• Hands-on experience with performance tuning, query optimization, and troubleshooting complex database issues.

• Strong SQL scripting skills, including expertise with stored procedures and triggers.

• In-depth knowledge of query execution plans and optimization techniques.

• Proficiency in disaster recovery planning, testing, backup/restoration, and replication strategies.

• Experience with database administration in Linux environments (preferably Ubuntu/CentOS/RHEL).

• Ability to proactively identify and resolve live database system issues under time constraints.

• Strong understanding of database design principles and data modeling.

• Experience with automation tools and techniques to streamline database operations.

• Excellent communication skills with the ability to work effectively both independently and as part of a team.

• Ability to thrive in a fast-paced, dynamic work environment, managing multiple priorities and deadlines.

Seniority Performance Bonus Annual Increment