Sr. Database Administrator - Lead

The Senior Database Administrator (DBA) is responsible for overseeing the performance, integrity, security, and scalability of enterprise databases. The role involves managing database architecture, monitoring system health, ensuring high availability, and troubleshooting complex issues. The Senior DBA leads a team of database administrators, collaborates with other IT departments, and provides guidance on database-related tasks to optimize business operations. Expertise in managing various database platforms, including (Oracle, MS SQL, MySQL, PostgreSQL, Teradata) and CI/CD (Continuous Integration/Continuous Deployment) integration tools is a plus.

Principal Duties And Responsibilities

Responsible for the overall operation and maintenance of mission critical production databases:

1. Database Design and Architecture:

- Design, implement, and maintain scalable, high-performance database systems to support business needs.

- Work closely with application developers and IT infrastructure teams to develop database architecture.

- Ensure database structures adhere to best practices and industry standards for optimization and security.

2. Database Management & Maintenance:

- Monitor and optimize the performance of database systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL).

- Implement database changes, upgrades, patches, and security updates in collaboration with the development team.

- Perform capacity planning and growth assessments to support future business needs.

- Maintain high availability and disaster recovery strategies, including backup and restore procedures.

3. Performance Tuning & Optimization:

- Analyze and resolve complex database performance issues, utilizing tools for performance tuning.

- Optimize queries, indexing strategies, and database schemas for enhanced performance.

4. Security & Compliance:

- Ensure databases are compliant with security policies and regulatory requirements.

- Implement and manage database security measures, including user permissions, encryption, and authentication.

- Perform regular security audits and risk assessments to mitigate potential vulnerabilities.

5. Troubleshooting & Support:

- Provide advanced troubleshooting and support for database-related issues.

- Lead incident response for major outages, working with cross-functional teams to minimize downtime.

- Support after-hours or on-call duties as required by the business.

6. Data Integrity & Governance:

- Ensure data integrity, accuracy, and consistency across all systems.

- Develop and enforce policies for data management, data governance, and access control.

- Collaborate with stakeholders on data quality initiatives and ensure compliance with data standards.

7. Automation & Efficiency:

- Automate routine database tasks, such as backups, monitoring, and performance reports.

- Drive innovation through automation and by implementing tools to improve database management efficiency.

8. Leadership & Mentoring:

- Lead and mentor junior DBAs, providing guidance on best practices, tools, and troubleshooting techniques.

- Act as the primary point of contact for database-related inquiries and issues from other IT teams.

9. Project Management:

- Participate in or lead database-related projects, ensuring deliverables are met on time and within budget.

- Coordinate with project managers, developers, and system architects to ensure database solutions align with business goals.

10.Vendor & License Management:

- Manage relationships with database vendors and oversee license compliance.

- Evaluate new database technologies, tools, and solutions, making recommendations to improve infrastructure.

Education and Qualification

• Bachelors degree in Computer Science, Information Technology, or related field.

Training Required

• Certifications like Oracle Certified Professional (OCP) or Microsoft Certified: Azure Database Administrator Associate are a plus.

Experience

• 8+years of experience in database administration, particularly with enterprise-level database systems (e.g., Oracle, SQL Server, MySQL)

Special Skills

- Expertise in database architecture, performance tuning, security practices, and troubleshooting.

- Proficiency in SQL and PL/SQL; knowledge of scripting languages (Python, Shell, etc.) is a plus.

- Hands-on experience with database clustering, replication, and high availability.

- Experience in cloud-based database solutions (AWS, Azure, GCP) is an advantage.

- Strong analytical and problem-solving skills.

- Excellent communication and leadership abilities.

- Familiarity with database management tools (e.g., Oracle Enterprise Manager, SQL Server Management Studio).