Database Engineer

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)