Senior Database Administrator(PostgreSQL / AWS RDS)

About the role

WebSenor is hiring for Remote
Position:- Senior Database Administrator (PostgreSQL / AWS RDS)
Experience:- 7+ Years

Shift Time: 3:00 PM – 12:00 AM IST
Location: Remote

Job Role:-

We are seeking a highly experienced Senior Database Administrator (PostgreSQL / AWS RDS) to manage, monitor, optimize, and evolve PostgreSQL database environments. This role involves supporting high-load on-premises PostgreSQL systems as well as AWS RDS PostgreSQL deployments.

The ideal candidate must bring deep expertise in query performance tuning, database upgrades, and cloud database operations, with hands-on experience in migrations, optimization, and high-availability architecture.

Key Responsibilities

PostgreSQL Administration (On-Premise & Cloud)
• Monitor and tune heavy SQL queries across PostgreSQL environments
• Identify and resolve performance bottlenecks
• Optimize database performance through indexing and query tuning
• Configure PostgreSQL settings (memory, vacuum, autovacuum, checkpoints)
• Ensure database availability, reliability, and data integrity
• Manage backup, restore, and disaster recovery strategies

Database Version Upgrades & Compatibility Testing
• Lead PostgreSQL version upgrades (On-Prem & AWS RDS)
• Perform pre-upgrade assessments and compatibility checks
• Execute upgrade testing plans and validate performance
• Ensure application compatibility and system stability

AWS RDS PostgreSQL & Cloud Operations
• Design and manage AWS RDS PostgreSQL instances
• Configure high availability, backups, and security
• Monitor RDS performance and scalability
• Collaborate with DevOps and infrastructure teams

Database Migration & Modernization
• Lead migrations from On-Prem PostgreSQL to AWS RDS
• Execute migrations with minimal downtime
• Perform validation and performance testing post-migration
• Recommend modernization and architecture improvements

DevOps & Automation
• Automate database provisioning and maintenance
• Support CI/CD pipelines involving database changes
• Use scripting and infrastructure-as-code practices

Required Qualifications

• 7+ years as Database Administrator (PostgreSQL)
• Deep PostgreSQL performance tuning expertise
• Experience with PostgreSQL version upgrades
• Strong AWS RDS PostgreSQL experience
• Linux/Unix system knowledge
• DevOps tools and automation experience
• Strong troubleshooting and analytical skills
• Experience supporting large-scale PostgreSQL environments
• AWS services experience (VPC, IAM, EC2, S3)
• Scripting skills (Bash, Python, or similar)

Must Have

✅ Worked on very large databases (100TB+)
✅ End-to-end migration experience
✅ Strong AWS RDS / Aurora practical experience
✅ Deep DBA knowledge (performance, tuning, backup, vacuum)
✅ Real production experience

Salary: As per industry standards. No bar for the right candidate.

What you'll do

• Own delivery for client-facing web, mobile, AI, cloud or digital transformation work based on the role.
• Collaborate with project managers, designers, QA and client stakeholders through discovery, build, launch and support.
• Write clear documentation, communicate risks early and keep delivery quality high.
• Contribute to reusable engineering practices, reviews and mentoring inside the WebSenor team.

What we're looking for

• Strong hands-on experience relevant to this role and a portfolio of shipped production work.
• Clear communication, ownership mindset and ability to work with global clients.
• Comfort with delivery discipline: estimation, reviews, testing, documentation and release readiness.
• Ability to learn fast and work across modern product, engineering and AI-enabled workflows.

What you'll get

• Work on real enterprise client projects with measurable business outcomes.
• Collaborate with experienced engineering, design, QA and delivery teams.
• Growth through mentoring, project ownership and exposure to global clients.
• HR-approved compensation, benefits and policies as finalized during the offer process.

About the team

You will work with WebSenor project managers, UI/UX designers, QA engineers, cloud specialists and senior developers focused on quality delivery for enterprise clients.

Our hiring process

• Application Review: HR and delivery leadership review your profile for role fit.
• Technical Discussion: Meet the technical team for skill, communication and project-readiness evaluation.
• Final Conversation: Discuss compensation, joining timeline and team fit.
• Offer and Onboarding: Receive the offer, documentation checklist and onboarding plan.