Database Engineer (Postgres + EDB + AWS) | US shifts | Noida | 8+ Yrs

Greetings from iEnergizer

Hiring forDatabase Engineer

Location: Noida Sec 60

Shifts: US (Night)

Working Mode: 5 Days from Office

Contact Person:HR Sharan - 9266364422

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 P

  ostgreSQL Administration and associated tools like PgBouncer, PgPool, RDS Proxy, PGD Proxy and other related binaries.

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.
• I

  nstall, 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 t

  o 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
• K

  nowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels. Clear understanding of ACID & BASE principles.

Thanks & Regards

Team iEnergizer

Noida