Senior Platform Engineer - Database Administration (AWS Focus)

Senior Platform Engineer – Database Administration (AWS Focus)The Senior Platform Engineer – Database Administration is responsible for designing, implementing, and managing scalable, secure, and highly available database platforms on AWS Cloud, supporting critical business applications. This role emphasizes PostgreSQL as the primary database platform, with Oracle expertise as a strong advantage.The position focuses on cloud-native database engineering, automation, platform reliability, and operational excellence, ensuring modern, resilient data platforms in a 24x7 enterprise environment.Role ResponsibilitiesCloud & Platform EngineeringDesign, implement, and manage AWS-based database solutions, including Amazon RDS, Aurora PostgreSQL, EC2-hosted databases, and hybrid architectures.Build and maintain cloud-native, scalable, and highly available database platforms aligned with enterprise standards.Collaborate with architecture teams to design secure and resilient cloud database architectures.Database AdministrationAdminister and support PostgreSQL databases (primary focus) in production environments.Support Oracle database environments (on-prem / cloud) as an additional skillset.Manage database lifecycle activities including provisioning, patching, upgrades, and migrations.Performance & ReliabilityMonitor database performance using AWS CloudWatch, Performance Insights, and native tools.Perform query tuning, indexing strategies, and performance optimization.Conduct root cause analysis (RCA) for performance and availability incidents.Implement capacity planning and scaling strategies for cloud-based workloads.Automation & DevOpsBuild and maintain automation for database provisioning, patching, backups, and failover using tools such as:Terraform / CloudFormation (IaC)Ansible / scripting (Python, Bash)Enable CI/CD pipelines for database changes and schema deployments.Drive standardization and process automation across environments.High Availability & DRImplement and manage high availability configurations:Aurora multi-AZ, RDS Multi-AZPostgreSQL replication and failoverDesign and execute backup, recovery, and disaster recovery strategies in AWS.Validate DR through regular testing and failover drills.Security & ComplianceImplement AWS and database security best practices, including IAM, encryption (KMS), and network isolation (VPC, SGs).Ensure compliance with organizational and regulatory policies.Proactively identify and mitigate risks related to database security and access.Collaboration & OperationsCollaborate with application, analytics, and infrastructure teams to optimize data solutions.Support release and deployment activities, including schema changes and validations.Participate in incident management, on-call rotation, and continuous improvement initiatives.Provide technical guidance and mentoring to team members.Required SkillsAWS & Cloud Platforms (Primary)Hands-on experience with:Amazon RDS (PostgreSQL)Aurora PostgreSQLEC2-based database deploymentsStrong understanding of:VPC, networking, security groupsIAM roles and policiesCloudWatch, CloudTrail monitoringExperience with Infrastructure as Code (Terraform / CloudFormation)Database PlatformsStrong expertise in PostgreSQL DBA (mandatory)Experience in Oracle DBA (add-on / good to have)Database platform engineering and lifecycle managementPerformance & ReliabilityQuery optimization and performance tuningMonitoring and alertingTroubleshooting and RCAHigh availability and resilience designBackup and disaster recovery strategiesAutomation & EngineeringScripting: Python, BashAutomation frameworks and toolingCI/CD integration for database deploymentsConfiguration managementSystems & InfrastructureLinux/Unix administrationNetworking fundamentalsVirtualized and distributed environmentsSecurity & RiskDatabase and cloud security best practicesEncryption, access control, auditingRisk mitigation and compliance adherenceWays of WorkingAgile methodologyCross-functional collaborationITSM practices (incident, change, problem management)Strong communication and stakeholder management skillsAll About YouExperience7+ years in database administration / platform engineeringStrong experience with PostgreSQL in AWS environmentsExperience managing production database systems in 24x7 environmentsHands-on experience with AWS database services and cloud-native architectureExperience with database migrations (on-prem → AWS)Good to HaveOracle DBA experience (RAC, Exadata, OEM)Experience with PostgreSQL on Aurora vs self-managed comparisonExposure to multi-cloud or hybrid environmentsExperience with Redis / caching technologiesKnowledge of data replication and distributed database systemsExperience driving standardization, compliance, and operational excellence initiativesPreferred QualificationsExperience architecting large-scale AWS database platformsAdvanced PostgreSQL performance tuningExperience with database observability toolsStrong background in automation and DevOps practicesUnderstanding of microservices and cloud-native application architecture