Senior Database Administrator

Senior Database Administrator (PostgreSQL / AWS RDS)

Shift timings : – 2 pm to 11 pm IST (Mon to Fri)

Contract duration – Till Feb 2027 ( for 6 months, and extend it as needed)

Number of interview rounds involved – Typically 2

Job Summary:

-We are seeking a highly experienced Senior Database Administrator (DBA) t

omanage, monitor, optimize, and evolve our PostgreSQL database environments. Thi

srole is responsible for supporting high-load on-premises PostgreSQL systems as wel

las AWS RDS PostgreSQL deployments

.The ideal candidate will bring deep expertise in query performance tuning, databas

eversion upgrades, and cloud database operations, with a proven ability to plan, test

,and execute PostgreSQL upgrades and migrations while ensuring applicatio

ncompatibility, data integrity, and system stability

.
Key Responsibiliti

esPostgreSQL Administration (OnPremise & Clou

d) Monitor, analyze, and tune heavy and longrunning SQL queries acro

ssPostgreSQL environmen

ts Identify and resolve performance bottlenecks using PostgreSQL statistics, log

s,and system metri

cs Optimize database performance throug

h:o Index design and optimizati

ono Query analysis and rewriti

ngo PostgreSQL configuration tuning (memory, vacuum, autovacuu

m,checkpoint

s)o Detect and propose data archival mechanism for unused da

ta Ensure database availability, reliability, and data integri

ty Manage backup, restore, and disaster recovery strategi

es
Database Version Upgrades & Compatibility Test

ing Lead and execute PostgreSQL database version upgrades in onpremises

andAWS RDS environme

nts Perform preupgrade assessments to identi

fy:o Deprecated features and breaking chan

ges
o Extension, stored procedure, and function compatibility is

sueso Query behavior and performance changes between vers

ions Design and execute comprehensive upgrade testing plans to ens

ure:o Stored procedures, functions, triggers, and views remain compat

ibleo Existing SQL queries execute correctly and efficie

ntlyo Applications function as expected on the upgraded database ver

sion Validate data integrity, performance, and stability postupg

rade
AWS RDS PostgreSQL & Cloud Opera

tions Design, provision, and manage AWS RDS PostgreSQL inst

ances Spin up and configure RDS environments following best practices

for:o Security and access co

ntrolo Performance tuning and scalab

ilityo High availability, backups, and snap

shots Monitor RDS performance using AWS and PostgreSQL monitoring

tools Partner with DevOps and infrastructure teams on cloud database archite

cture
Database Migration & Moderni

zation Lead and support database migrations between onpremises PostgreS

QL andA

WS RDS Plan and execute migrations with minimal downtime an

d risk Perform data validation and performance testing after mig

ration Provide strategic recommendations for PostgreSQL modernization, archit

ectureimprovements, and version ad

option
DevOps & Aut

omation Apply DevOps principles to database ope

rations Automate database provisioning, configuration, monitoring, and main

tenance Support CI/CD pipelines involving database schema and data

changes Use scripting and infrastructureascode approaches to improve oper

ationaleff

iciency
Required Qualif

ications Minimum 7 years of experience as a Database Administrator, with stro

ng focuson Po

stgreSQL Deep handson knowledge of PostgreSQL internals, performance tun

ing, andquery opti

mization Proven experience planning and executing PostgreSQL version u

pgrades,in

cluding:o Compatibility testing of stored procedures, functions, and SQL

querieso Managing risks, rollback plans, and production

cutovers Strong experience managing AWS RDS PostgreSQL envi

ronments Solid understanding of Linux/Unix operating

systems Experience working with DevOps tools, automation, and modern infras

tructurep

ractices Excellent troubleshooting, analytical, and problemsolvin

g skills Experience supporting largescale or hightraffic PostgreSQL envi

ronments Strong communication and technical documentatio

n skills Ability to work independently and take ownership of complex database p

latforms Comfortable collaborating with application, DevOps, and infrastructu

re teams Proactive, improvementdriven mindset focused on performance, stabil

ity, andsca

lability Familiarity with PostgreSQL monitoring and diagnost

ic tools Knowledge of highavailability, replication, and failover st

rategies Experience with AWS services such as VPC, IAM, EC2

, and S3 Scripting skills (Bash, Python, or

similar)

interested candidate share CV at amita@source