Database Engineer at iEnergizer | US shifts | Noida | HR Sharan

Ienergizer; Dadri; Presencial; INR 2 600 000 - 4 200 000; Tempo integral

Resumo da oferta

iEnergizer is hiring a Database Engineer to manage Postgres databases in US shifts from our office. You will handle AWS RDS, on-prem migrations, tuning, and health checks, while ensuring security and reliability across Linux environments and OpenShift clusters.

The role requires strong experience with PostgreSQL, cloud services, and automation tools. US shift timing and on-site work will apply. Contact HR for details.

Qualificações

• 8+ years of experience managing Postgres databases in production environments.
• Hands-on AWS RDS and OpenShift/Kubernetes experience.
• Experience with PostgreSQL on Linux (RHEL) and cloud migrations (on-prem to AWS and back).
• Strong knowledge of performance tuning, indexing and query optimization.
• Familiarity with CI/CD and automation tools (GitLab, Ansible, Terraform).

Responsabilidades

• Manage Postgres databases end-to-end in AWS and on-prem environments.
• Install, configure, patch, migrate and maintain PostgreSQL and AWS RDS.
• Oversee health checks, SOP updates, and day-to-day tasks.
• Apply secure, maintainable coding practices for database software.
• Evaluate patch releases and coordinate deployment timelines with teams.
• Support automation via Jira, GitLab, Ansible and Terraform.

Conhecimentos

PostgreSQL administration

AWS RDS

PostgreSQL performance optimization

Partitioning & sharding

Linux (RHEL)

Kubernetes/OpenShift

CI/CD pipelines

Patching & patch management

SQL scripting

Security & IAM

Ferramentas

Jira

GitLab

Ansible

Terraform

PgBouncer

PgPool

RDS Proxy

Descrição da oferta de emprego

Greetings from iEnergizer

Hiring for Database Engineer (US Shifts)

Contact Person: HR Sharan - 9266364422

Summary Of Essential Job Functions

• 8 years of experience in managing Postgres databases (EDB Eco system). 5 years of experience should be on the cloud, preferably AWS, with expertise in managing databases such as RDS services in AWS, security policy, user authentication, IAM, and database administration in AWS.
• Install, configure, patch, Migrate, Maintain, and upgrade Open-source Database platforms Databases like PostgreSQL, and AWS RDS.
• Hands-on experience with managing EDB, Postgres Distributed (PGD) and AWS RDS Day to Day activities including health checks, assigning tasks, updating SOPs etc.
• Should be able to implement effective and maintainable database coding practices that form an architectural foundation.
• Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
• Experience in Postgres SQL performance improvement, indexing/other approaches.
• Good experience in Partitioning & Sharding databases.
• Must be knowledgeable and experienced in managing PostgreSQL on multiple operating systems including Linux (RHEL) and Kubernetes in OpenShift platform.
• Experience in Postgres SQL migration approach from on-prem to AWS and vice versa, estimating it, and technically managing it.
• Advanced understanding of Linux OS, use SSH to connect to remote systems with password & public/private keys
• Ability to efficiently write database code without compromising data quality, privacy, or security.
• Hands-on Experience in Jira, GitLab, Ansible & Terraform.
• Good understanding of CI/CD, Pipelines & automations using GitLab
• Good understanding of the Batch process and Job scheduling automation
• Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels. Clear understanding of ACID & BASE principles.
• Good troubleshooting skills, Ability to evaluate alternative solutions and/or workarounds, Strong analytical, and interpersonal communication skills
• Must possess good communication skills, both in verbal and in written form, and be Proficient in identifying, analyzing, and solving problems for Client facing experience

Position Requirements

• AWS RDS, EDB EPAS & Postgres Distributed hands-on experience
• Capacity planning, performance assessment of AWS RDSs & Postgres Distributed.
• Strong EDB Postgres administration experience in production environments
• Configuration and support of complex RDS Databases in AWS environment, Configuring and managing high availability, resiliency solutions leveraging Aurora Read replicas & Global Database.
• Experience in managing multiple RDS, database versions on large systems
• Practical experience in monitoring & Observability.
• Knowledge of reporting, query tools and SQL best practices
• Experience in using Performance Insights, RDS KPI, design and management.
• Working knowledge of Lambda, Python, Ansible & Terraform
• Strong technical and functional experience in PostgreSQL Administration and associated tools like PgBouncer, PgPool, RDS Proxy, PGD Proxy and other related binaries.

Important Note

Shifts: US

Working Days: 5

Working Mode: From office only (No WFH/ No Hybrid/ No Remote)

No Cabs