PostgreSQL DBA

We are looking for a PostgreSQL DBA who wants to learn and transform his career.

Requirements:

• Strong hands‑on experience as a PostgreSQL DBA
• Practical experience with AWS RDS for PostgreSQL and EC2‑hosted PostgreSQL
• In‑depth knowledge of PostgreSQL architecture (WAL, MVCC, vacuum, autovacuum)
• Experience with backup, recovery, and PITR
• Strong skills in performance tuning and query optimization
• Good understanding of replication, HA, and DR architectures
• Working knowledge of AWS services: RDS, EC2, CloudWatch, IAM, S3
• Proficiency in SQL and PostgreSQL utilities
• Experience with Linux/Unix systems
• Familiarity with parameter groups, maintenance windows, and storage management
• Exposure to security and compliance best practices
• Ability to support large, mission‑critical production environments
• Good communication, documentation, and troubleshooting skills

Key Responsibilities:

• nstall, configure, and administer PostgreSQL databases on AWS RDS and EC2
• Manage day‑to‑day PostgreSQL operations across Dev, Test, UAT, and Production
• Monitor database health, availability, and performance using CloudWatch, Performance Insights, and native PostgreSQL tools
• Perform backup and recovery using RDS automated backups, snapshots, pg_dump, pg_basebackup, and WAL archiving
• Design and maintain High Availability and Disaster Recovery solutions using RDS Multi‑AZ, Read Replicas, and EC2‑based standby setups
• Perform database performance tuning, including query optimization, indexing, vacuuming, and configuration tuning
• Troubleshoot database issues such as slow queries, locks, deadlocks, replication lag, and connection problems
• Manage PostgreSQL replication (RDS read replicas, logical replication, streaming replication on EC2)
• Handle database upgrades, patching, and migrations (major and minor versions)
• Manage database security, including users, roles, privileges, SSL, parameter groups, and IAM‑based access (where applicable)
• Implement and maintain monitoring, alerting, and capacity planning
• Support database scaling activities (vertical and horizontal scaling on AWS)
• Coordinate with application, DevOps, and infrastructure teams during releases and incidents
• Automate routine DBA tasks using shell scripting / Python
• Troubleshoot and resolve production incidents; perform root cause analysis
• Maintain DBA documentation, SOPs, and runbooks
• Participate in 24x7 on‑call and production support

What do we offer?

• Health insurance
• Dental Plan
• Life insurance
• Meal/Food Voucher
• Childcare assistance
• Total Pass
• Free 0800 that provides psychological assistance (24 hrs/day), legal, social and financial assistance to associates
• Partnership with SESC
• Reimbursement of Certifications
• Learning Portal – Online courses and live training
• International experience opportunity
• Discount Partnership with Universities and Language Schools
• Bring Your Buddy – By referring people you become eligible to receive a bonus for each hire
• Recognition for performance
• Xcelerate – Free Mentoring Career Platform