Lead Database Administrator - PostgreSQL

Role - Lead Database Administrator - PostgreSQL

Overview:

We are seeking an experienced and skilled PostgreSQL and MongoDB Database Administrator (DBA) with a proven track record in setting up and managing databases for large-scale applications. The successful candidate will work closely with stakeholders to understand their business needs, gather requirements, and facilitate solutions that enhance the efficiency and effectiveness of our operations. As a DBA, you will be responsible for designing, implementing, and optimizing infrastructure to ensure high availability, scalability, and performance of PostgreSQL as well as MongoDB databases. You will play a critical role in maintaining data integrity, implementing backup and recovery strategies, and continuously monitoring and tuning the environment.

Key Responsibilities :

• Design, deploy, and manage databases for large-scale applications, ensuring high availability
  and optimal performance.
• Collaborate with development teams to understand application requirements and provide
  guidance on data modeling and database design.
• Implement and maintain database clusters, including replica sets and shared clusters, ensuring data distribution and fault tolerance.
• Perform regular database performance tuning and optimization to maximize query efficiency
  and reduce response time.
• Develop and implement backup and recovery strategies to ensure data integrity and minimize downtime.
• Monitor and troubleshoot database issues, including performance bottlenecks, query
  optimization, and replication problems.
• Implement and manage database security measures, including authentication, authorization,
  and encryption, to protect sensitive data.
• Collaborate with system administrators to ensure adequate hardware resources and
  infrastructure for deployment.
• Stay up to date with the latest features, releases, and best practices, and evaluate their
  applicability to the organizations database environment.
• Document database configurations, procedures, and troubleshooting steps to maintain a
  comprehensive knowledge base.
• Provide guidance and support to development teams on DB-related matters, including data
  access patterns and query optimization.

Required Skills:

1. Analytical Skills : Strong ability to find common problems, provide solutions and automate the
process.

2. Communication Skills : Excellent verbal and written communication skills to convey complex
information clearly to all stakeholders within the organization as well as the customer .Ability
to facilitate discussions and workshops with diverse stakeholders.

3. Technical Skills:

○ Proven work experience as a PostgreSQL and MongoDB Database Administrator or similar
role, with a focus on setting up and managing large-scale MongoDB databases.

○ Strong understanding of PostgreSQL architecture, including replica sets, shared clusters, and
data distribution.

○ Proficiency in PostgreSQL database performance tuning and optimization techniques.

○ Experience with PostgreSQL/MongoDB backup and recovery strategies, including point-in-time

recovery and disaster recovery procedures.

○ Knowledge of DB security features and best practices for securing databases.

○ Strong problem-solving and troubleshooting skills, with the ability to identify and resolve
complex database issues.

○ PostgreSQL and MongoDB certifications (e.g., MongoDB Certified DBA) are highly desirable.

4. Problem-Solving Skills:

○ Strong critical thinking skills to approach challenges with a solution-oriented mindset.

○ Capability to identify root causes and propose actionable solutions.

5. Project Management Skills:

○ Familiarity with project management tools (e.g., JIRA) is a plus.

○ Ability to prioritize tasks and manage time effectively in a fast-paced environment.

6. Interpersonal Skills:

○ Ability to build strong relationships with stakeholders and work collaboratively in a team.

○ Flexibility to adapt to changing priorities and requirements.

Preferred Qualifications :

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