Talent.com
Senior PostgreSQL Database Administrator

Senior PostgreSQL Database Administrator

ConfidentialKarnataka, India
19 hours ago
Job description

Senior PostgreSQL DB Admin

About the Role :

We are seeking a highly skilled Senior PostgreSQL Database Administrator to setup, manage, optimize, and support our PostgreSQL databases in a mission-critical, high-performance environment. The ideal candidate will have deep expertise in database tuning, backups, high availability, monitoring and automation.

As a key member of the data team, you will collaborate closely with business stakeholders, cross-functional data teams, and subject matter experts (SMEs) to implement data solutions that support data-driven decision-making at scale.

Key Responsibilities :

PostgreSQL Management :

  • Work with very large datasets (hundreds of millions of records) efficiently and reliably.
  • Expertise in PostgreSQL clustering, replication and high-availability configurations
  • Familiarity with PostgreSQL backups, recovery procedures and disaster recovery strategies.
  • Experience in managing and optimizing PostgreSQL database performance, including query optimization, indexing and partitioning.
  • Lead efforts to harden PostgreSQL environments against internal and external threats
  • Define and enforce database security policies, including role-based access control, encryption, and auditing

Governance & Standards :

  • Promote and enforce Data Governance , Data Quality , and Model Governance practices across critical data projects.
  • Work with stakeholders to ensure the application of Data Architecture Policies , Standards , and Guiding Principles in all data-related projects.
  • Ensure the Reference Architecture is adhered to by all teams.
  • Collaboration & Consultation :
  • Act as a Data and Model Governance Consultant , educating internal teams on data governance, architecture principles, and best practices.
  • Provide technical guidance and support to data engineering teams to ensure compliance with Data & Analytics Principles in areas like new dataset creation, pipeline design, and data integration.
  • Technical Documentation :

  • Write detailed design specifications and documentation to clearly communicate architectural and modelling decisions.
  • Demonstrate design and technology approaches through prototypes and proofs of concept.
  • Continuously assess and recommend opportunities for Database Optimization to Ensure Low Latency
  • Work closely with cross-functional data owners, SMEs, and teams to monitor and manage Data Health .
  • Cloud and AI / ML Exposure (Nice to Have) :
  • Work on cloud-based data architectures, ensuring integration and alignment with modern cloud technologies (AWS, Azure, or GCP).
  • Exposure to AI / ML frameworks and support integration of advanced analytics into the data platform.
  • Experience with Modern data platforms such as Databricks, Snowflake.
  • Stakeholder Management :

  • Strong Communication skills and ability to Build strong relationships with business and technical stakeholders to understand business needs and deliver data solutions that support organizational goals.
  • Communicate complex data architecture concepts clearly and effectively to both technical and non-technical stakeholders.
  • About Candidate :

    You are an experienced PostgreSQL Database Administrator with a proven track record of designing implementing, maintaining and optimising data solutions at an enterprise scale. You are a problem solver who thrives in a collaborative environment and can effectively manage multiple stakeholders across the organization.

    Qualifications : Experience :

  • Minimum of 10+ years of experience in data, digital, technology or analytical roles.
  • Expertise in installing, configuring, securing and maintaining PostgreSQL databases.
  • Deep understanding of networking concepts, including setting up PostgreSQL replication (master-slave, master-master), failover and clustering.
  • Expertise in query performance tuning, using tools like pg_stat_statements, EXPLAIN ANALYZE and server settings to optimize database performance. Experience with PostgreSQL-specific tools such as pgAdmin, pgBouncer, pgBadger, pg_repack etc.
  • Install and configure new database servers using best practices. Knowledge of High Availability (HA) and Disaster Recovery (DR). Upgrade minor and major versions.
  • DB Backup and Recovery Activities such as Ensure all database servers are backed up. Perform restoration testing. Follow Industry Best Practices.
  • Define and implement maintenance plans for database systems. Standardize maintenance approaches across systems. Index and statistics maintenance.
  • Proactively identify, troubleshoot, and resolve live database system issues. Capacity planning and forecasting. Creating and reviewing data access audits. Tracking and reporting on Recovery Point Objectives (RPO) metrics.
  • Identification of queries having the largest performance impact.
  • Improvements to indexes and execution plans. Troubleshoot transaction and concurrency issues. Assist developers with query optimization.
  • Create documentation on processes and procedures. Providing training for developers and other technical resources.
  • Collaborate with DevOps and application teams to optimize query performance and database architecture
  • Conduct regular security assessments, patching, and vulnerability remediation
  • Provide expert-level troubleshooting and root cause analysis for database-related incidents
  • Experience in Cloud Architecture (Azure)
  • Technical Skills :

  • Strong knowledge of Database Administration, Governance a nd Data Modelling best practices.
  • Hands-on expertise in Cloud-based Architecture on Azure.
  • Experience in integrating AI / ML frameworks into data platforms. (Good to have)
  • Ability to write clear design specifications and technical documentation.
  • Proven ability to mentor and guide teams on Data Architecture Principles .
  • Certifications :

    Relevant certifications in Cloud-based Architecture (Azure) are a plus.

    Create a job alert for this search

    Senior Database Administrator • Karnataka, India

    Related jobs
    • Promoted
    Oracle Database Administrator

    Oracle Database Administrator

    Tehno RightKarnataka
    Role : Oracle Database Administrator (Full Time - Onsite) Job description : Roles and Responsibilities : - Perform database administra...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle SOA Developer

    Oracle SOA Developer

    Tata Consultancy ServicesKarnataka, India, India
    Oracle SOA 12c\OSB 12c development.Experience with ORACLE DB environment.In depth knowledge in SOA suite infrastructure and architecture. Deep understanding of OSB and BPEL.Experience in deployment ...Show moreLast updated: 25 days ago
    • Promoted
    Oracle ADF Developer

    Oracle ADF Developer

    Tata Consultancy Serviceskarnataka, karnataka, in
    Design, develop, and maintain web-based enterprise applications using.ADF task flows, page templates, bindings, managed beans. ADF Business Components (Entity Objects, View Objects, Application Modu...Show moreLast updated: 24 days ago
    • Promoted
    • New!
    DB2 LUW administrator

    DB2 LUW administrator

    VARITE INCKarnataka, India
    Don’t miss your chance to land your dream role — register now!.Experience on installation of different versions of DB2 on Redhat Linux Environment. Scheduling shell scripts on LINUX environments.Goo...Show moreLast updated: 2 hours ago
    • Promoted
    Senior System Administrator

    Senior System Administrator

    Sonata SoftwareKarnataka, India
    In today's market, there is a unique duality in technology adoption.On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital store...Show moreLast updated: 13 days ago
    • Promoted
    Data Architect

    Data Architect

    BrillioKarnataka, India
    Architecting, designing and implementing Modern Data Platforms and Solutions using Microsoft Azure Cloud and understands reference architectures. Deep understanding Data Migration Strategies with 2+...Show moreLast updated: 4 days ago
    • Promoted
    Senior Software Engineer - Databricks, Global Converse,ITC

    Senior Software Engineer - Databricks, Global Converse,ITC

    NIKEKarnataka, Karnataka, India
    You will be part of the Digital Design & Merchandising, Product Creation, Planning, and Manufacturing Technology team at Converse. You will take direction and work primarily with the Demand and Supp...Show moreLast updated: 30+ days ago
    • Promoted
    Postgres SQL Developer

    Postgres SQL Developer

    ACL DigitalKarnataka, India
    We are looking for ideal candidate with below expertise as must.Strong SQL (PostgreSQL is mandatory).Develop and optimize complex SQL queries in PostgreSQL. Knowledge of aggregate function, Windows ...Show moreLast updated: 4 days ago
    • Promoted
    Websphere Administrator

    Websphere Administrator

    LTIMindtreeKarnataka, India, India
    Chennai, Bengaluru, Mumbai, Pune, Hyderabad.Notice Period : Immediate to 30 days.Please do not apply Notice Period with more than 30 days of Notice Period. Mandatory Skills : WebSphere Application Ser...Show moreLast updated: 6 days ago
    • Promoted
    Oracle EBS Technical

    Oracle EBS Technical

    Tata Consultancy ServicesKarnataka, India, India
    Extensive Experience in Oracle EBS R12 Implementation projects involving AR,GL,AP modules.Good Analytical, communication, presentation, client interaction skills. Good Knowledge on O2C and P2P Cycle...Show moreLast updated: 25 days ago
    • Promoted
    • New!
    Oracle Database Administrator- Golden Gate

    Oracle Database Administrator- Golden Gate

    LTIMindtreeKarnataka, India
    Role - Oracle DBA with Golden gate.Experience-5 years to 10 Years.Identify and resolve performance bottlenecks, tune SQL queries, optimize database parameters, and monitor system resource utilizati...Show moreLast updated: 19 hours ago
    • Promoted
    Cloud Data Architect (Azure / AWS)

    Cloud Data Architect (Azure / AWS)

    BrillioKarnataka, India
    The ideal candidate is passionate about learning, data, scalability, and agility.You'll leverage your strong collaboration skills and data architecture expertise, along with a deep understanding of...Show moreLast updated: 1 day ago
    • Promoted
    Database Architect

    Database Architect

    RAPIDD TechnologiesKarnataka, India
    We are seeking a talented and experienced Database Architect to join our international development team.You will work on development of solutions for various industries such as news and media, spor...Show moreLast updated: 1 day ago
    • Promoted
    Senior PostgreSQL DBA Architect

    Senior PostgreSQL DBA Architect

    Sonata SoftwareKarnataka, India
    In today's market, there is a unique duality in technology adoption.On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefron...Show moreLast updated: 4 days ago
    • Promoted
    Senior Data Analyst

    Senior Data Analyst

    Publicis ProductionKarnataka, India
    We’re looking for a Senior Data Analyst with strong technical and analytical skills to join our data team in production technology. In this role, you'll use tools like BigQuery, PostgreSQL and P...Show moreLast updated: 4 days ago
    • Promoted
    Senior Backend Engineer (Java + SQL)

    Senior Backend Engineer (Java + SQL)

    Rainmaker GroupKarnataka, India
    Job Title : Senior Backend Engineer (Java, SQL) - SDE IV.US-based enterprise software product company.AI-driven data connectivity and integration platforms. Their products help global enterprises con...Show moreLast updated: 1 day ago
    • Promoted
    SAP HANA DBA

    SAP HANA DBA

    Tata Consultancy ServicesKarnataka, India, India
    Analyze and implement SAP support methodology.Bring comprehensive knowledge on SAP S / 4HANA architecture, conversion, and migration path. Understand the SAP high availability or disaster recovery arc...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Database Administrator (PostgreSQL on AWS RDS or Aurora)

    Senior Database Administrator (PostgreSQL on AWS RDS or Aurora)

    CirrusLabsKarnataka, India
    As a senior database administrator, you will be responsible for the administration, optimization, and reliability of Liongard's core platform database. You will work closely with development and...Show moreLast updated: 4 days ago