Lead - Database Administrator (PostgreSQL)

4 weeks ago

bangalore, India Fidelity Investments Full time

The Purpose of This Role

Associate will be part of Data Operations COE group within Fidelity Data Architecture & Engineering Division that primarily provides DBA support for multiple RDBMS like Oracle, PostgreSQL, Oracle E-Business Suite, DB2, MongoDB, SQL Server & RDS on AWS. In addition, this team is also responsible for Data Lake Operations on Cloud that supports Nifi (ELT Tool), Collibra Data Governance, Alation Data Catalogue Enterprise Tools & Platform Engineering (Informatica, Middleware), Data masking (TDM) & Enterprise Snowflake Admin Support

The Value You Deliver

Work closely with CTG BU in supporting their databases, ensuring the stability, performance & help migrate them to public cloud as part of the organization data strategy by partnering with Product teams & Architects.

Core duties include:

Work closely with the product development team from the design phase of application & throughout their Agile development journey, the future enhancements & releases

Be part of their Agile Squad planning, understand the priorities & roadmap.

Participate in the application stress/load test & proactively identify & resolve the DB performance (batch/OLTP) issues that can potentially breach the SLA’s when the code moves to production.

Highlight the new DB features to the product teams that could be used in the application as future enhancements & releases.

Support the Database Migration, Upgrades as part of Technology Life Cycle Management to be compliant with organization standards.

Provide DB Capacity Analysis & provide insights to product teams on future storage & hardware requirements based on the current data growth & overall performance.

Identify aging data, propose/develop/implement data archiving, purging & partitioning solutions to manage the data growth.

Handling Database/Schema Refreshes for the lower database environments

Understand the RTO/RPO requirements for the application & databases to define the database backup and restore policy.

Managing Database Security Audit violations & resolving them

DB User/Access/Roles management

Troubleshooting & fixing production DB/SQL performance issues

Providing Oncall support (12/7), working with vendor on DB issues, bugs & provide solution.

Schedule and Co-ordinate various maintenance activities with Support teams.

Work on any new DB technology/new-features, POC requirements from application team

Help the application team in migrating their databases to public cloud (AWS).

The Skills that are Key to this role

Technical / Behavioral

Core PostgreSQL DBA skills (Version 10 & above)

Experience in maintaining development, testing and production environments.

Experience in POSTGRESQL Installation and Configuration, Database Backup and Recovery, SQL Tuning, User maintenance, Tablespace management, Hot Standby and Replication, PITTR and Upgradation.

Thorough knowledge on indexes and rebuild.

Perform maintenance activity in database.

Experienced in Backup & Recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in time recovery.

Monitoring and optimizing the performance of the database.

Creation of Clone Database for Development/Testing Environments.

Up-gradation from 10 to 11 versions and database migration.

Installing and working tools & clients like pgadmin4, Putty.

Basic knowledge in adding and deleting Database in a clone in Replication environment.

Maintain backups and perform disaster recovery.

Maintain the database using different utilities. This includes using like pg_ctl and psql.

Experience in Installation and creating Hot Streaming Replication (Master and Slave).

Problem solving and good analytical skills.

Communication, teamwork, and negotiation skills

Ability to work in tight deadlines under pressure.

Flexible and adaptable to changing business/technology requirements.

A sense of ownership that drives quality in everything you do.

A forward-looking attitude that keeps you aware of the latest in database & cloud technology space.

The Skills those are good to have for this role

AWS or relevant cloud technology experience on DB migration to public AWS/Azure from on-prem.

Knowledge on Oracle DBA.

Working experience on Snowflake Cloud Datawarehouse DB

Python Programming for Automation

Basic knowledge on Tableau/PowerBI for reporting.

AWS/Azure/OCI cloud Certified

  • PostgreSQL Database Administrator

    4 weeks ago

    bangalore, India Wipro Full time

    Experience in PostgreSQL Database AdministrationDesign, configure, test, and support high-availability clustering utilizing PostgreSQL technologiesResponsible for understanding operational requirements including Hardware, Architecture, configuration, Integration and maintaining mission-critical Production PostgreSQL databases.Responsible for all Logical and...

  • Postgresql Database Administrator

    2 weeks ago

    Bangalore City, India Wipro Full time

    Experience in PostgreSQL Database AdministrationDesign, configure, test, and support high-availability clustering utilizing PostgreSQL technologiesResponsible for understanding operational requirements including Hardware, Architecture, configuration, Integration and maintaining mission-critical Production PostgreSQL databases.Responsible for all Logical and...

  • PostgreSQL Database Administrator

    2 weeks ago

    bangalore, India Nutanix Full time

    The Opportunity Are you a highly experienced DBA with a passion for supporting enterprise data needs? Do you have expertise in PostgreSQL or Oracle databases, along with a deep understanding of relational and dimensional database theory? If so, join our team at Nutanix, where you will have the opportunity to work with cutting-edge technologies and...

  • PostgreSQL Database Administrator

    1 week ago

    bangalore, India Gradient Cyber Full time

    Overview:  We are seeking a skilled PostgreSQL Database Administrator (DBA) to manage and optimize our PostgreSQL database infrastructure. As a PostgreSQL DBA, you will be responsible for ensuring the performance, availability, and security of our databases. You will collaborate with our development, operations, and security teams to design and implement...

  • Database Administrator

    4 weeks ago

    Bangalore,Hyderabad,Kolkata,Coimbatore,Pune, India NexWave Talent Management Solutions Pvt Ltd Full time

    Job Description : We are hiring for Postgresql Database Administrator with CMMI Level 5 Organization. - Strong experience as a Postgresql Database Administrator / DBA including performance tuning and optimisation . - Responsible for the monitoring and uptime of Production and non-production PostgreSQL database. - Estimate PostgreSQL database...

  • Database Administrator

    3 weeks ago

    Bangalore, Karnataka, India One Degree North HR Services Full time

    Responsibilities : - Ensure data integrity and security through regular backups and recovery procedures and be equipped to design and implement disaster recovery, fixing database corruption issues, and performance tuning.- Monitor and resolve performance bottlenecks and recommend optimizations for efficient query execution.- Requirements: adequate experience...

  • Database Administrator

    4 weeks ago

    Bangalore, India One Degree North HR Services Full time

    Responsibilities : - Ensure data integrity and security through regular backups and recovery procedures and be equipped to design and implement disaster recovery, fixing database corruption issues, and performance tuning. - Monitor and resolve performance bottlenecks and recommend optimizations for efficient query execution.- Requirements: adequate...

  • Database Administrator

    3 weeks ago

    Bangalore/Hyderabad/Pune/Vijayawada, IN Change leaders Full time

    Role : PostgreSQL DBAExperience : 5 - 8yearsLocations : Hyderabad, Bangalore, Pune, VijaywadaPrimary Skills : Postgresql DBA, Performance tunning, Migration, Upgradation , Backup and recoveryDesired Skills & Responsibilities :- Minimum 5 years of experience in database administration or database architecture- Implementing Postgresql database clusters with...

  • Database Administrator

    4 weeks ago

    Bangalore,Hyderabad,Pune,Vijayawada, India Change leaders Full time

    Role : PostgreSQL DBAExperience : 5 - 8yearsLocations : Hyderabad, Bangalore, Pune, VijaywadaPrimary Skills : Postgresql DBA, Performance tunning, Migration, Upgradation , Backup and recoveryDesired Skills & Responsibilities :- Minimum 5 years of experience in database administration or database architecture- Implementing Postgresql database clusters with...

  • PostgreSQL Developer

    3 weeks ago

    Bangalore, Karnataka, India Cortex Consulting Pvt. Ltd. Full time

    We are seeking a highly skilled PostgreSQL Developer with 5+ years of experience to join our growing team. In this role, you will play a critical role in designing, developing, implementing, and maintaining robust and scalable database solutions using PostgreSQL. You will work closely with engineers, analysts, and other developers to ensure efficient data...

  • PostgreSQL Developer

    4 weeks ago

    Bangalore, India Cortex Consulting Pvt. Ltd. Full time

    We are seeking a highly skilled PostgreSQL Developer with 5+ years of experience to join our growing team. In this role, you will play a critical role in designing, developing, implementing, and maintaining robust and scalable database solutions using PostgreSQL. You will work closely with engineers, analysts, and other developers to ensure efficient data...

  • Database Administrator

    3 weeks ago

    Bangalore, Karnataka, India Dream Careers Services Full time

    Job Description : - Overall 8 plus years in DBA Administration- 3 to 4 years' experience in MySQL dba mandatory- Overall 2 plus years of experience in Database administration on AWS cloud preferred- 2+ years hands-on experience in managing MySQL Aurora Databases will be added advantage- 1+ years hands-on experience in managing PostgreSQL Aurora...

  • Database Administrator

    2 weeks ago

    Bangalore, India Dream Careers Services Full time

    Job Description : - Overall 8 plus years in DBA Administration- 3 to 4 years' experience in MySQL dba mandatory- Overall 2 plus years of experience in Database administration on AWS cloud preferred- 2+ years hands-on experience in managing MySQL Aurora Databases will be added advantage- 1+ years hands-on experience in managing PostgreSQL Aurora...

  • Database Administrator

    1 week ago

    bangalore, India Dream Careers Services Full time

    Job Description : - Overall 8 plus years in DBA Administration- 3 to 4 years' experience in MySQL dba mandatory- Overall 2 plus years of experience in Database administration on AWS cloud preferred- 2+ years hands-on experience in managing MySQL Aurora Databases will be added advantage- 1+ years hands-on experience in managing PostgreSQL Aurora Databases.-...

  • Database Administrator_ PostgreSQL

    1 week ago

    bangalore, India Novo Nordisk Full time

    The position Key responsibilities: Strong proficiency in Oracle, PostgreSQL database administration and management. Load Balancing and High availability. Ensure system optimization, by improving and restructuring the databases. Perform database updates and Migrations. Synchronize multiple databases in various branches. Thorough understanding of...

  • Database Administration Lead

    3 weeks ago

    Bangalore, Karnataka, India ALP Consulting Full time

    One of our leading MNC client is looking for DB Admin Lead.Please find the details of the position here below.Job Title : DB Admin Lead. Job Role : Permanent with the client (on client payroll), client details will be shared upon your response.Location : Hebbal, Bangalore. Experience : 7 to 10 years. Job Description :- We are looking for an experienced...

  • Database Administration Lead

    4 weeks ago

    Bangalore, India ALP Consulting Full time

    One of our leading MNC client is looking for DB Admin Lead.Please find the details of the position here below.Job Title : DB Admin Lead. Job Role : Permanent with the client (on client payroll), client details will be shared upon your response.Location : Hebbal, Bangalore. Experience : 7 to 10 years. Job Description :- We are looking for an experienced...

  • Database Administrator

    3 weeks ago

    Bangalore, Karnataka, India Domniclewis Full time

    Role : Database AdministratorResponsibilities :- Manage SQL Server and PostgreSQL databases efficiently.- Configure and maintain database servers and associated processes.- Proactively monitor system health and performance.- Facilitate database patches, upgrades, and migrations.- Uphold high standards of performance, availability, sustainability, and...

  • Database Administrator

    4 weeks ago

    Bangalore, India Domniclewis Full time

    Role : Database AdministratorResponsibilities :- Manage SQL Server and PostgreSQL databases efficiently.- Configure and maintain database servers and associated processes.- Proactively monitor system health and performance.- Facilitate database patches, upgrades, and migrations.- Uphold high standards of performance, availability, sustainability, and...

  • Database Administrator

    3 weeks ago

    Bangalore/Hyderabad, Karnataka, India Swift Strategic Staff Solutions INC Full time

    Notice period : 45 Days or less,Job Description :Must Have : - Deep Knowledge in Database (PostgreSQL , MYSQL and MariaDB)- Expert level understanding of Azure Networking, and Services.- Knowledge on Performance Tuning and High Availability.- Should know Azure Fundamentals (IAAS/PAAS)- Excellent Communication Skills Good to Have :- Incident Management-...