Postgres DBA +SRE

The Database Platform team ensures plant stability across multiple distributed database platforms for internal business units and provides support and consultation to application development groups for design, development, implementation, and monitoring. While the teams core responsibilities are to maintain day-to-day support of MS critical database plant, the team also provides engineering support to regularly improve and enhance the functionality of DB platforms.

Position is for a Greenplum/Postgres database engineer which is part of core DB-Platform Operations team. This position is based in the Mumbai office. Team is responsible for providing day to day database platform support ex : Greenplum software installation, patch upgrades, performance monitoring, change implementation, performance tuning, user maintenance, new database setup, educating users, troubleshooting user issues, etc.

Team is responsible for coordinating all hardware changes with respective Infrastructure teams and performing software changes/patch upgrades/major upgrades.

Role & responsibilities

• Provide consultation/support to application development groups?
• Maintain day to day support of mission critical database plant and ensure plant stability/modernization using industry standard devops practices.
• Showcase expertise to regularly improve and enhance the plant functionality of associate DB platforms
• Provide 24x7 firm-wide support for distributed databases including occasional weekend rotational on-call
• Candidate will contribute in creation of operational best practices and automation of operational tasks related to the existing Postgres DBaaS plant, as well as provide training, guideline and establish procedures for L1 and L2 teams globally
• Performance tuning and troubleshooting user issues with deep dive-in issues
• Candidates must be well organized, have strong communication and interpersonal skills, should be confident working independently.
• Ability to diagnose problems and triage / resolve issues across various tiers (application, network, database, server, or storage tiers)
• Ability to implement automation to reduce manual administrative.
• Strong troubleshooting/performance tuning skills required. Must be able to improve SQL performance
• Strong communication skills and ability to work effectively across multiple business and technical teams
• Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
• Plans and coordinates the administration of databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation and follow existing operational guidelines.
• Proficiency/Familiarity in Linux/Unix OS fundamentals including kernel and os tunning related to DB performance/security , ansible and shell/perl/python scripting
• Familiar with Cloud Based Architectures /Data-Warehousing Platforms, prior experience / knowledge in Snowflake Design Patterns and migration workflow would be a plus.
• Operational Experience and Understanding of large-scale Infrastructure-as-a-service Platforms preferred (Azure/AWS) would be a plus
• Prior experience managing /deploying Geo Redundant database using 3rd party cluster manager like Patroni/Golden Gate etc.
• Prior exposure to Cloud Platforms & Architecture is favourable such as Azure , Identity

Preferred candidate profile

• Bachelors in engineering degree in computer science or masters degree in related field with 5+ years of work experience as DBA.
• Experience in Greenplum Database version 5,6 or higher
• Strong experience with Postgres V12+ , Greenplum version 6+
• Hands on exposure in Installing and Configuring HADR/Replication Clusters in Postgres for High Availability .
• Postgres database administration including installation of database software, configuration, troubleshooting, database object creation, routine maintenance tasks
• Greenplum Database Design, Command Center, Workload Management, Query Tuning, Data Loading using gpload/external tables, backup and restore
• Strong troubleshooting/performance tuning skills required. Must be able to improve SQL performance
• Strong Organizational Skills, ability to work/collaborate with different cross functional teams/projects.
• Database performance monitoring and troubleshooting
• Proficiency in Unix OS, ansible and shell/perl/python scripting and keen on automation
• Effective written & verbal communication skills: ability to communicate with clients, partners, and peers clearly and concisely at all level of the organization (external and internal alike)