PostgreSQL Database Administrator

7 - 12 years

30 - 40 Lacs

Posted:3 hours ago| Platform: Naukri logo

Apply

Work Mode

Hybrid

Job Type

Full Time

Job Description

PostgreSQL expert

Key Responsibilities

  • Migration Strategy & Execution

    • Design and implement a robust migration plan from Oracle to AWS PostgreSQL.
    • Analyze existing Oracle schemas, stored procedures, triggers, and optimize for PostgreSQL compatibility.
    • Ensure data integrity, minimal downtime, and rollback strategies during migration.
  • AWS Integration

    • Configure and manage PostgreSQL on AWS (RDS/Aurora).
    • Implement high availability, disaster recovery, and backup strategies using AWS services.
    • Optimize cost and performance leveraging AWS features (e.g., IAM, VPC, CloudWatch).
  • Database Development

    • Develop and maintain complex PL/pgSQL functions, triggers, and stored procedures.
    • Implement advanced indexing, partitioning, and query optimization for large datasets.
    • Collaborate with application teams (.NET, ReactJS) for seamless integration.
  • Performance & Security

    • Conduct performance tuning and query optimization.
    • Implement robust security measures including encryption, access control, and auditing.
    • Monitor and troubleshoot database issues proactively.
  • Collaboration & Documentation

    • Work closely with architects, developers, and DevOps teams.
    • Document migration steps, best practices, and operational guidelines.

      Role & responsibilities


Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Sapient (publicissapient) logo
Sapient (publicissapient)

Digital Consulting, IT Services

New York

RecommendedJobs for You