Lead - Database Administrator (PostgreSQL)

2 months ago

Bengaluru, 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

    Bengaluru, India Nutanix Full time

    The OpportunityAre 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 support...

  • PostgreSQL Database Administrator

    4 weeks ago

    Bengaluru, Karnataka, India Nutanix Full time

    **_Hungry, Humble, Honest, with a Heart. _** **The Opportunity**: **Your Role**: The role requires the administration of a highly available Database system, and interaction with business users across the company to support their Enterprise data needs. The DB administrator will work with the ETL team for data ingestion and quality. **What you'll bring**: -...

  • PostgreSQL Database Administrator

    1 month ago

    Bengaluru, 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...

  • Database Administrator

    2 days ago

    Bengaluru, India Squareroot Consulting Pvt Ltd Full time

    Role/Job Title : PostgreSQL Database Administrator (DBA)Experience : 10+ years (with at least 4 years of relevant PostgreSQL DBA experience)Location : Bangalore (work from 10+ years of overall IT experience with at least 4 years of hands-on experience as a PostgreSQL DBA.- Proven experience in configuring and maintaining PostgreSQL databases in on-premises...

  • Database Administrator

    1 week ago

    Bengaluru, India Whizz HR Full time

    We are seeking an experienced and highly skilled PostgreSQL Database Administrator to join our IT team. The ideal candidate will have 5 to 8 years of experience managing PostgreSQL databases, with a strong focus on performance tuning, backup and recovery, and high availability. You will be responsible for ensuring the stability, reliability, and performance...

  • PostgreSQL Database Administrator

    3 weeks ago

    Bengaluru, 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...

  • PostgreSQL Database Administrator

    3 weeks ago

    Bengaluru, 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...

  • PostgreSQL Database Administrator

    1 month ago

    Bengaluru, India FIS Full time

    Position Type :Full timeType Of Hire :Experienced (relevant combo of work and education)Education Desired :Bachelor's DegreeTravel Percentage :0%PostgreSQL Database Administrator - 7 to 13yrs-Bangalore/Pune/MumbaiAre you curious, motivated, and forward-thinking? At FIS you’ll have the opportunity to work on some of the most challenging and relevant issues...

  • PostgreSQL Database Administrator

    3 weeks ago

    Bengaluru, India Jobs for Humanity Full time

    Job Description Position Type : Full time Type Of Hire : Experienced (relevant combo of work and education) Education Desired : Bachelor's Degree Travel Percentage : 0%PostgreSQL Database Administrator - 7 to 13 yrs-Bangalore/Pune/MumbaiAre you curious, motivated, and forward-thinking? At FIS you’ll have the opportunity to work on some of the most...

  • PostgreSQL Developer

    2 months ago

    Bengaluru, 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

    4 weeks ago

    Bengaluru, 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...

  • Lead - Database Administrator (PostgreSQL)

    1 month ago

    Bengaluru, India Fidelity Investments Full time

    The Purpose of This RoleAssociate will be part ofData Operations COEgroup withinFidelity Data Architecture & EngineeringDivision that primarily providesDBA supportfor multiple RDBMS like Oracle, PostgreSQL, Oracle E-Business Suite, DB2, MongoDB, SQL Server & RDS on AWS. In addition, this team is also responsible forData Lake Operationson Cloud that supports...

  • Database Administration Lead

    2 months ago

    Bengaluru, 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

    2 months ago

    Bengaluru, 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...

  • PostgreSQL Database Consultant

    2 weeks ago

    Bengaluru, India Pythian Full time

    PostgreSQL Database Consultant Bengaluru / HyderabadOracle / Postgresql – Postgresql /Full Time /HybridPostgreSQL Database ConsultantIndiaAvailable Shifts PST TZ Why you? Are you a PostgreSQL who lives in Hyderabad OR Bangalore? Are you community minded? Do you blog, contribute to the Open Source community? Are you inspired by ever-shifting...

  • PostgreSQL Database Consultant

    7 days ago

    Bengaluru, India Pythian Full time

    PostgreSQL Database ConsultantBengaluru / HyderabadOracle / Postgresql – Postgresql /Full Time /HybridPostgreSQL Database ConsultantIndiaAvailable Shifts PST TZWhy you?Are you a PostgreSQL who lives in Hyderabad OR Bangalore? Are you community minded? Do you blog, contribute to the Open Source community? Are you inspired by ever-shifting challenges,...

  • SQL Database Administrator

    6 days ago

    Bengaluru, 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...

  • IBM DB2, PostgreSQL, Cassandra Database Administrator

    7 days ago

    Bengaluru, India 5100 Kyndryl Solutions Private Limited Full time

    Who We AreAt Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities.The RoleWithin...

  • Database Administrator

    4 weeks ago

    Bengaluru, India People Maketh Full time

    Must Haves: - highly skilled NoSQL & SQL Database (specifically in MongoDB, Redis, Memcached, Amazon ElastiCache, ElasticSearch, PostgreSQL **(EDB)**) Administrator - Have to maintain the database infrastructure in On-Prem & AWS/GCP cloud. **Key Responsibilities and requirements**: - Bachelor's or Master's degree in Computer Science, Information...

  • PostgreSQL Dba

    1 month ago

    Bengaluru, India Renovision Automation Services Pvt. Ltd Full time

    Location - Mumbai, Noida, Pune, Bangalore, Chennai JD - You previously worked as a DB administrator in PostgreSQL/Oracle - Hands on experience in PostgreSQL management and administration - Good knowledge on Security in PostgreSQL - Good hands-on experience with SQL/No SQL - Able to fix complex queries and make them performant - Good knowledge in Performance...