Senior Platform Engineer - Database Administration; AWS Focus

Position: Senior Platform Engineer - Database Administration (AWS Focus)
Our Purpose

Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we're helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships and networks combine to deliver a unique set of products and services that help people, businesses and governments realize their greatest potential.

Title and Summary

Senior Platform Engineer - Database Administration (AWS Focus)

Overview

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 Responsibilities

Cloud & Platform Engineering

* Design, 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 Administration

* Administer 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 & Reliability

* Monitor database performance using AWS Cloud Watch, 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 & Dev Ops

* Build and maintain automation for database provisioning, patching, backups, and failover using tools such as:

o Terraform / Cloud Formation (IaC)

o Ansible / scripting (Python, Bash)

* Enable CI/CD pipelines for database changes and schema deployments.

* Drive standardization and process automation across environments.

High Availability & DR

* Implement and manage high availability configurations:

o Aurora multi-AZ, RDS Multi-AZ

o PostgreSQL replication and failover

* Design and execute backup, recovery, and disaster recovery strategies in AWS.

* Validate DR through regular testing and failover drills.

Security & Compliance

* Implement 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 & Operations

* Collaborate 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 Skills

AWS & Cloud Platforms (Primary)

* Hands-on experience with:

o Amazon RDS (PostgreSQL)

o Aurora PostgreSQL

o EC2-based database deployments

* Strong understanding of:

o VPC, networking, security groups

o IAM roles and policies

o Cloud Watch, Cloud Trail monitoring

* Experience with Infrastructure as Code (Terraform / Cloud Formation)

Database Platforms

* Strong expertise in PostgreSQL DBA (mandatory)

* Experience in Oracle DBA (add-on / good to have)

* Database platform engineering and lifecycle management

Performance & Reliability

* Query optimization and performance tuning

* Monitoring and alerting

* Troubleshooting and RCA

* High availability and resilience design

* Backup and disaster recovery strategies

Automation & Engineering

* Scripting:
Python, Bash

* Automation frameworks and tooling

* CI/CD integration for database deployments

* Configuration management

Systems & Infrastructure

* Linux/Unix administration

* Networking fundamentals

* Virtualized and distributed environments

Security & Risk

* Database and cloud security best practices

* Encryption, access control, auditing

* Risk mitigation and compliance adherence

Ways of Working

* Agile methodology

* Cross-functional collaboration

* ITSM practices (incident, change, problem management)

* Strong communication and stakeholder management skills

All About You

Experience

* 7+ years in database administration / platform engineering

* Strong experience with PostgreSQL in AWS environments

* Experience managing production database systems in 24x7 environments

* Hands-on experience with AWS…