Talent.com
Lead system engineer - PostgreSQL DBA

Lead system engineer - PostgreSQL DBA

Societe Generale Global Solution CentreBengaluru, Karnataka, India
18 hours ago
Job description

Role / Job Summary : Postgres DBA L2 accountable & responsible for handling global database operations. Candidates must be willing to work in rotational shifts(24

  • 7)

Location : Bangalore

Years of Experience : 8 - 12 years

Key Responsibilities

  • Own 24
  • 7 database support; handling Incidents, Requests, Problems & Changes.
  • Handle on-call database support during week-ends & out of business hours.
  • Own & deliver various client & infra projects.
  • Plan & deliver various projects around database patching, upgrades & migrations.
  • Management of various tools / scripts being used for databases.
  • Managing Primary DBA roles for multiple applications.
  • Contribution towards automation of recurrent tasks.
  • Ticket reduction through problem management.
  • Manage disaster recovery tests & exercises.
  • Identify & deliver various POCs (Proof of concepts) for latest RDBMS features, open source & new technologies.
  • Work closely with application teams to provide solutions across various requirements & problems.
  • Proactively identify the problems and provide solutions to avoid incidents & application outages.
  • Work with other infra teams to optimize databases performance and reduce incidents probability.
  • Profile Required :

    Mandatory Skills and Experience :

  • Hands-on experience with database standards and end user applications.
  • Experience on PG version PG 12, PG 13, PG 14 & PG 15
  • Excellent knowledge of PG RDBMS (all versions) architecture & design.
  • Excellent knowledge of Architecture, Backup, Recovery (PITTR), Replication & Performance Tuning concepts.
  • Experienced in backup and recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in Time Recovery
  • Hands-on experience of using tools / extensions REPMGR, PGBACKREST, pg_repack, pg_crypto, pg_audit, Data Wrapper, pg_bouncer,
  • Good understanding of configuration files such as Pg_hba.Conf, Postgresql.Conf (with knowledge on Parameter values)
  • Scripting knowledge using Ansibel and SHELL
  • Proficient in troubleshooting & solving complex performance problems.
  • Proficient in managing Patching, Upgrades & Migrations.
  • Proficient in monitoring & performance analysis through open source tools
  • Experience in handling Disaster Recovery tests & exercises.
  • Certifications and experience of managing RDS for PostgreSQL on AWS
  • Experience in working on a large-scale environment (at least 1000 + databases with bigger sizes).
  • Working experience in banking domain (preferred).
  • Expert knowledge of ITIL processes around Incident, Problem, Change, Quality Management and CSI.
  • Exceptional coordination, communication and interpersonal skills to work across global teams and clients.
  • Demonstrated ability to analyze, diagnose and assess problems; work with global stakeholders to derive tactical and long-term solutions as appropriate.
  • Demonstrable crisis management skills in a large, globally distributed environment.
  • Experience working with or in an automated operations environment
  • Experience managing operations on core & cloud-based infra environments AaS platform experience ideal.
  • Preferred Education, Skills and Experience :

  • Certifications and experience of managing RDS for PostgreSQL on AWS
  • Hands-on experience of using tools / extensions REPMGR, PGBACKREST, pg_repack, pg_crypto, pg_audit, Data Wrapper, pg_bouncer
  • Good understanding of configuration files such as Pg_hba.Conf, Postgresql.Conf.
  • Experienced in backup and recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in Time Recovery
  • Experience in Ansible, Shell / Perl / Python Scripting
  • Proficient in managing Patching, Upgrades & Migrations.
  • Proficient in monitoring & performance analysis through open source tools
  • Why Join Us :

    We are committed to creating a diverse environment and are proud to be an equal opportunity employer. All qualified applicants receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

    Create a job alert for this search

    Lead System Engineer • Bengaluru, Karnataka, India

    Related jobs
    • Promoted
    Principal Database Reliability Engineer (PostgreSQL)

    Principal Database Reliability Engineer (PostgreSQL)

    Sonata SoftwareBengaluru, Republic Of India, IN
    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: 11 days ago
    • Promoted
    Lead PostgreSQL Database Architect

    Lead PostgreSQL Database Architect

    Sonata SoftwareBengaluru, Republic Of India, IN
    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: 11 days ago
    • Promoted
    Team Lead - PostgreSQL

    Team Lead - PostgreSQL

    MaimsD TechnologyBangalore
    Designation : Team Lead-Postgresql Location : Bangalore Years of Experience : 10+ Years Show moreLast updated: 30+ days ago
    • Promoted
    Senior PostgreSQL DBA Architect

    Senior PostgreSQL DBA Architect

    Sonata SoftwareBengaluru, Karnataka, 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: 11 days ago
    • Promoted
    Lead system engineer - PostgreSQL DBA

    Lead system engineer - PostgreSQL DBA

    ConfidentialBengaluru / Bangalore, India
    Postgres DBA L2 accountable & responsible for handling global database operations.Candidates must be willing to work in.Own 24 • 7 database support. handling Incidents, Requests, Problems & Changes....Show moreLast updated: 4 days ago
    • Promoted
    • New!
    Lead Database Engineer

    Lead Database Engineer

    PRI GlobalBengaluru, Karnataka, India
    Role Discussed : Database Engineering Lead Key Points : Skills Required : PostgreSQL – Min 7 years MongoDB Redis SQL Server Shell scripting Python Ansible, Chef Cloud Exposure : AWS / Azure (Good to h...Show moreLast updated: 13 hours ago
    • Promoted
    Senior PostgreSQL Performance Engineer

    Senior PostgreSQL Performance Engineer

    Sonata SoftwareBengaluru, Republic Of India, IN
    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: 11 days ago
    • Promoted
    Database Systems Engineer

    Database Systems Engineer

    AtosBengaluru, Republic Of India, IN
    Job Location : Pune, Mumbai, Bangalore & Chennai.Primary skills : Oracle DBA, RAC, Dataguard, Performance Tuning, Shell scripting. Kindly share the resume to prabhu.Minimum of 8+ years Database Admin...Show moreLast updated: 21 days ago
    • Promoted
    • New!
    Lead Database Reliability Engineer (PostgreSQL)

    Lead Database Reliability Engineer (PostgreSQL)

    Societe Generale Global Solution CentreBengaluru, Republic Of India, IN
    Postgres DBA L2 accountable & responsible for handling global database operations.Candidates must be willing to work in.Incidents, Requests, Problems & Changes. Handle on-call database support durin...Show moreLast updated: 17 hours ago
    • Promoted
    • New!
    PostgreSQL Database Lead

    PostgreSQL Database Lead

    Societe Generale Global Solution CentreBengaluru, Republic Of India, IN
    Postgres DBA L2 accountable & responsible for handling global database operations.Candidates must be willing to work in.Incidents, Requests, Problems & Changes. Handle on-call database support durin...Show moreLast updated: 17 hours ago
    • Promoted
    • New!
    Lead System Architect

    Lead System Architect

    Altiostar, A Rakuten Symphony CompanyBengaluru, Republic Of India, IN
    Our unique 4G / 5G vRAN solution is designed to improve quality of experience, enhance spectral efficiency, provide flexibility to the operator in hardware selection, provide full network automation ...Show moreLast updated: 17 hours ago
    • Promoted
    • New!
    Senior Database Administrator (PostgreSQL on AWS RDS or Aurora)

    Senior Database Administrator (PostgreSQL on AWS RDS or Aurora)

    CirrusLabsBengaluru, Karnataka, 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 Dev...Show moreLast updated: 18 hours ago
    • Promoted
    PostgreSQL DBA

    PostgreSQL DBA

    LTIMindtreeBengaluru, Karnataka, India
    Location - Bangalore / Hyderabad.Interested candidates please share your updated CV to v.Show moreLast updated: 30+ days ago
    • Promoted
    Lead Systems Development Engineer

    Lead Systems Development Engineer

    JLLBengaluru, Karnataka, India
    Lead Systems Development Engineer.Design and implement cloud infrastructure across Azure, AWS, and GCP environments.Architect, deploy and optimize Azure-based solutions including compute, storage, ...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Postgresql Dba Architect

    Senior Postgresql Dba Architect

    Sonata SoftwareBengaluru, Republic Of India, IN
    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: 10 days ago
    • Promoted
    • New!
    Senior PostgreSQL DBA

    Senior PostgreSQL DBA

    CirrusLabsBengaluru, Republic Of India, IN
    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 Dev...Show moreLast updated: 17 hours ago
    • Promoted
    • New!
    Principal PostgreSQL DBA

    Principal PostgreSQL DBA

    Societe Generale Global Solution CentreBengaluru, Republic Of India, IN
    Postgres DBA L2 accountable & responsible for handling global database operations.Candidates must be willing to work in.Incidents, Requests, Problems & Changes. Handle on-call database support durin...Show moreLast updated: 17 hours ago
    • Promoted
    Adapt Ready - Database Engineer - PostgreSQL

    Adapt Ready - Database Engineer - PostgreSQL

    Adapt ReadyBangalore
    Role : Database Engineer Location : JP Nagar, Bangalore (Work from office) About Us : ...Show moreLast updated: 30+ days ago