Talent.com
No longer accepting applications
Lead system engineer - PostgreSQL DBA

Lead system engineer - PostgreSQL DBA

Societe Generale Global Solution CentreBengaluru, India
1 day 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, 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: 12 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: 12 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: 12 days ago
    • Promoted
    System Engineer

    System Engineer

    ACL DigitalBengaluru, Karnataka, India
    Information Security and Infrastructure.Should be familiar with PKI (Public Key Infrastructure) and primary skill in Digicert, Hashicorp, Veritas, Key management. Candidates with coding experience i...Show moreLast updated: 1 day 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: 6 days 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: 12 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: 23 days ago
    • Promoted
    Lead Systems Development Engineer

    Lead Systems Development Engineer

    IvantiBengaluru, Republic Of India, IN
    C++, Python, Linux, Microservices and Cloud Technologies.We are seeking a skilled development engineer with strong expertise C++, Python, Linux, Kubernetes, PostgreSQL, Redis and Elasticsearch and ...Show moreLast updated: 1 day ago
    • Promoted
    Senior System Engineer

    Senior System Engineer

    TRUGlobalBengaluru, Karnataka, India
    Bangalore, India (Hybrid - at least 3 days in office for now).Environment (Need to be active at least until 2 AM IST to coordinate with PST Stakeholders). We are seeking an experienced Senior System...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)

    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: 2 days 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: 12 days ago
    • Promoted
    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: 2 days ago
    • Promoted
    Database Reliability Engineer (PostgreSQL)

    Database Reliability Engineer (PostgreSQL)

    LTIMindtreeBengaluru, Republic Of India, IN
    Location - Bangalore / Hyderabad.Interested candidates please share your updated CV to v.Show moreLast updated: 30+ days ago
    • Promoted
    Lead Engineer Database Engineer - DevOps

    Lead Engineer Database Engineer - DevOps

    Spigot SoftwareBangalore
    Description : The Lead Engineer Database Engineer - Devops will design and detail the strategies for backup ...Show moreLast updated: 8 days ago
    • Promoted
    Sr. AWS PostgreSQL DBA

    Sr. AWS PostgreSQL DBA

    ConfidentialBengaluru / Bangalore, India
    Labcorp is recruiting a Senior AWS PostgreSQL DBA for a dynamic team in either the RTP or Burlington, NC area.Get ready to redefine what's possible and discover your extraordinary potential at Labc...Show moreLast updated: 6 days ago