Aurora PostgreSQL Database Administrator
- PRI Global
- 5 - 8 years
- Mumbai
- 1 day ago
- Email to a friend
- Report this job
Job Description
Key Responsibilities
Aurora PostgreSQL Administration
- Own the design, implementation, and operation of Amazon Aurora PostgreSQL databases supporting data engineering
workloads.
- Define, review, and evolve database schemas, data models, and access patterns optimized for downstream consumption.
- Be accountable for database lifecycle activities including provisioning, upgrades, patching, backups, and high availability.
- Ensure consistent standards and configurations across Dev, NonProd, and Prod environments.
Performance, Reliability & Scalability
- Take responsibility for database performance tuning, including query optimization, indexing strategies, and connection
management.
- Monitor database health, capacity, and growth trends, and proactively drive scaling and optimization activities.
- Design, validate, and maintain highavailability and disasterrecovery strategies using native Aurora capabilities.
Security, Governance & Compliance
- Own implementation of secure, leastprivilege access models and rolebased controls for database access.
- Enable and maintain audit logging and integrations with centralized SOC platforms.
- Ensure databases comply with organizational security standards and regulatory requirements (e.g., GDPR).
- Act as a key technical contributor during SOC reviews, audits, and security investigations.
Data Engineering Enablement
- Work to support and optimize ETL/ELT pipelines, batch and nearrealtime ingestion workloads. Provide guidance on data access patterns, schema evolution, and performance best practices. Support integrations with platforms such as Databricks, S3based data pipelines, and analytics tools. Automation & Operational Excellence Drive automation of routine operational and database tasks using scripts, AWSnative services, InfrastructureasCode, and AIassisted tools to streamline repetitive activities such as performance analysis, log review, and incident investigation. Own troubleshooting and resolution of complex data platform issues, including participation in oncall rotations and production support. Create, maintain, and continuously improve runbooks, SOPs, and operational documentation for data platforms. MustHave Skills 6+ years of strong experience as a Senior Data Engineer with deep handson expertise in Amazon Aurora PostgreSQL. Advanced PostgreSQL knowledge (query optimization, indexing, vacuuming, replication concepts). Experience owning and supporting dataintensive platforms in production environments. Solid understanding of AWS services related to data platforms (Aurora/RDS, IAM, CloudWatch, S3). Proven ability to independently troubleshoot and resolve complex production issues. GoodtoHave Skills Experience with Amazon Aurora MySQL and MongoDB Atlas. Familiarity with Databricks or similar analytics/lakehouse platforms. Understanding of modern data engineering patterns (ETL/ELT, batch vs streaming). Working knowledge of AI/ML concepts. Experience in regulated industries such as fintech, payments, or financial services. Preferred Qualifications Experience with InfrastructureasCode tools (Terraform, CloudFormation). Exposure to CI/CD practices for data platforms. AWS certifications related to data or solutions architecture.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Administration & FacilitiesRole Category: AdministrationRole: Head - AdministrationEmployement Type: Full timeContact Details:
Company: PRI GlobalLocation(s): Mumbai+ View Contact
Keyskills: Postgresql Aws Aurora Troubleshooting
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
PRI Global
Founded in 1997 and headquartered in St. Louis, Missouri, PRI Global has a strong presence across the USA, India, and the Philippines. We provide cutting-edge IT consulting, software engineering, and workforce solutions across industries such as financial services, healthcare, retail, engineering, a...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in