Database Core Architect

Confidential; Chennai; On-site; INR 3,502,626 - 6,129,596; Full time

Job summary

A leading company in IT Services is seeking a PostgreSQL Subject Matter Expert in Chennai. The role involves providing expert guidance on database architecture and optimization, mentoring teams, and ensuring best practices in PostgreSQL management. Ideal candidates will have in-depth knowledge and experience with large-scale implementations within enterprise environments.

Qualifications

• Deep expertise in PostgreSQL internals, architecture, and performance optimization.
• Experience with automation tools such as Ansible and Terraform and scripting languages like Python.
• Effective communication and mentoring skills.

Responsibilities

• Provide expert advice on PostgreSQL architecture and best practices.
• Lead complex database projects and mentor junior database professionals.
• Analyze and optimize database performance, including query tuning.

Skills

PostgreSQL internals

Performance optimization

Query tuning

Automation tools

Cloud database platforms

SQL

Data warehousing

Education

Bachelor's or master's degree in computer science

Tools

pgAdmin

Datadog

Ansible

Terraform

AWS RDS

Azure Database for PostgreSQL

Job description

3 days ago Be among the first 25 applicants

We are seeking a PostgreSQL Subject Matter Expert (SME) with in-depth knowledge of PostgreSQL internals, and extensive hands-on experience with enterprise-level PostgreSQL implementations. The ideal candidate will provide expert guidance, drive best practices, and contribute to the optimization and scalability of our PostgreSQL database systems. The SME will be responsible for guiding complex database projects, offering strategic insights, and ensuring best practices are followed in all aspects of database management.

· Should be able to provide advanced expertise in PostgreSQL internals, including storage, indexing, query optimization, and memory management.

· Provide expert advice on PostgreSQL architecture, design, and best practices to internal teams and stakeholders.

· Oversee the installation, configuration, upgrading, and maintenance of PostgreSQL databases and related applications.

· Lead and mentor development and database administration teams in PostgreSQL best practices and advanced features.

· Analyse and optimize database performance, including query tuning, indexing strategies, and hardware utilization.

· Design and implement high availability and disaster recovery solutions, such as replication, clustering, and failover strategies.

· Troubleshoot and resolve complex database issues, ensuring minimal downtime and optimal performance.

· Develop and enforce database standards, security policies, and compliance measures.

· Create and maintain detailed documentation on PostgreSQL database configurations, procedures, and architectural decisions.

· Develop automation scripts and tools to streamline database operations, including backups, maintenance, and monitoring.

· Mentor junior database professionals and provide training on advanced PostgreSQL topics.

· Stay current with PostgreSQL advancements and incorporate relevant technologies and methodologies to improve database systems.

· Actively participate in Postgres communities and forums for the contribution to the Postgres ecosystem.

Skills:

· Proven experience in designing and managing large-scale PostgreSQL databases.

· In-depth knowledge of PostgreSQL architecture, replication, partitioning, and indexing.

· Proficiency in SQL and PL/pgSQL programming.

· Strong understanding of database performance optimization techniques.

· Experience with database monitoring tools (e.g., pgAdmin, Datadog, Nagios).

· Familiarity with automation tools (e.g., Ansible, Terraform).

· Hands-on in data warehousing and ETL processes.

· Knowledge of data security best practices.

· Excellent problem-solving and analytical skills.

· Effective communication and interpersonal skills.

· Experience with cloud database platforms (e.g., AWS RDS, Azure Database for PostgreSQL).

· Familiarity with other database technologies (e.g., MySQL, Oracle) and data warehousing solutions.

· Knowledge of DevOps practices and CI/CD pipelines.

· Experience with automation tools and scripting languages (e.g., Python, Bash, Ansible).

Qualifications:

Education: Bachelor's or master's degree in computer science, Information Technology, or a related field.

Summary

· PostgreSQL Internals & Architecture: Deep expertise in PostgreSQL storage, indexing, query optimization, and memory management.

· Performance Optimization: Proficiency in query tuning, indexing strategies, and database performance optimization techniques.

· High Availability & Disaster Recovery: Experience with replication, clustering, and failover strategies for high availability.

· Automation & Scripting: Experience in automation tools (Ansible, Terraform) and scripting languages (Python, Bash).

· Cloud Platforms & DevOps: Experience with cloud database platforms (AWS RDS, Azure) and knowledge of DevOps practices and CI/CD pipelines.

Seniority level

• Seniority level

  Not Applicable

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Confidential by 2x

Get notified about new Database Architect jobs in Chennai, Tamil Nadu, India.

Full Stack Developer - Web & Mobile Apps

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.