Postgres Dba Sre

**Req ID**: 336226

We are currently seeking a Postgres DBA cum SRE to join our team in Bangalore, Karnātaka (IN-KA), India (IN).

Position is for a Greenplum/Postgres database engineer which is part of core DB-Platform Operations team.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.

**Responsibilities**:
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

Performance tuning and troubleshooting user issues with deep dive-in issues

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 Management Qualifications
- **External Skills Required**:
Bachelor's in engineering degree in computer science or master's 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)

**About NTT DATA