PostgreSQL DBA

The AWS RDS/Postgres EDB Database Engineer performs independently or as a critical multifunctional

team member in identifying planningdeveloping and deploying database applications and other

technology solutions that can involve multiple physical locations and business units.The engineer also

acts as the single point of contact for Postgres database administration and escalations for the Banking

Industry project.

Summary Of Essential Job Functions

1012 years of experience in managing Postgres databases (EDB Eco system). 5 years of experience

should be on the cloud version preferably AWS with expertise in managing databases as RDS services

in AWS security policy user authentication IAM and database administration in AWS.

• Install configure patch Migrate Maintain and upgrade Opensource Database platforms
  

• Databases like PostgreSQL and AWS RDS.
  

• Hands on experience with managing EDB and AWS Day to Day operations including S3 EC2 etc
  

• Should be able to implement effective and maintainable database coding practices that form an architectural foundation.
  

• Experience in Postgres SQL performance improvement indexing/other approaches
  

• Good experience in partitioning database
  

• Experience with message queuing fulltext indexing and other highperformance data concepts.
  

• Experience in AWS environment management and knowledge of different tools for the same.
  

• Experience in Postgres SQL migration approach from onprem to AWS and vice versa estimating itand 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.
  

• Handson Experience in Jira GitHub Ansible & Terraform.
  

• Good understanding of CI/CD 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
  

• Good troubleshooting skills Ability to evaluate alternative solutions and/or workarounds 1 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
  

• Proficient in identifying analyzing and solving problems and Client facing experience
  

Requirements

Position Requirements

• AWS RDS handson experience
  

• Capacity planning performance assessment of AWS RDSs
  

• Strong Postgres/SQL Server DB 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
  

• Knowledge of reporting and query tools and practices
  

• Experience in using Performance Insights RDS KPI design and management.
  

• Working knowledge of Lambda Python
  

• Strong technical and functional experience in PostgreSQL Administration and associated tools like PgBouncer PgPool and other related binaries.
  

Physical Requirements

• Sitting for extended periods of time
  

• Dexterity of hands and fingers to operate a computer keyboard and mouse
  

• Physically able to participate and lead training sessions presentations and/or meetings.
  

• Reasoning and analyzing complex information
  

• Regularly required to talk and hear
  

• Overtime may be required to meet deadlines
  

Mandatory skills:

EDB AWS RDS Ansible/Terraform

Educational background: Grad from CS/ EE or Eng. Equivalent