Job Description
Role: DBA LEAD
Experience: 8-10 Years
Location - Chennai (IIT Research Park) -WFO
Mandatory Skills - PostgreSQL, Linux, C, C++
Job Description:
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 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 C,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
• Familiarity with automation tools (Ansible, Terraform).
• Hands-on in data warehousing and ETL processes.
• Knowledge of data security best practices.
• Strong communication and interpersonal skills.
• Experience with cloud database platforms
• Knowledge of DevOps practices and CI/CD pipelines
