Database Engineer

Big Data DBA OPS

Job Profile 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 team?s 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.

Job 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 Management Qualifications –

External Skills Required:

Bachelor's 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 together 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 clearly and concisely communicate with clients, partners, and peers at all level of the organization (external and internal alike)