Lead - Database Administrator (PostgreSQL)

1 week ago


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

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


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


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


  • Bengaluru, Karnataka, India Nutanix Full time

    Apply for PostgreSQL Database Administrator, Career Progress Consultants in Bengaluru/ Bangalore for 8 - 9 Year of Experience on


  • Bengaluru, Karnataka, India Nutanix Full time

    Apply for PostgreSQL Database Administrator, Career Progress Consultants in Bengaluru/ Bangalore for 8 - 9 Year of Experience on


  • Bengaluru, Karnataka, India Nutanix Full time

    Apply for PostgreSQL Database Administrator, Career Progress Consultants in Bengaluru/ Bangalore for 8 - 9 Year of Experience on


  • Bengaluru, Karnataka, India Jobs for Humanity Full time

    Job DescriptionPosition Type :Full timeType Of Hire :Experienced (relevant combo of work and education)Education Desired :Bachelor's DegreeTravel 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 challenging and...


  • Bengaluru, Karnataka, 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 in...


  • Bengaluru, Karnataka, India Jobs for Humanity Full time

    Company DescriptionJobs for Humanity is collaborating with FIS Global to build an inclusive and just employment ecosystem. We support individuals coming from all walks of life.Company Name: FIS GlobalPostgreSQL Database Administrator


  • Bengaluru, Karnataka, 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/Mumbai Are you curious, motivated, and forward-thinking? At FIS you'll have the opportunity to work on some of the most...


  • Bengaluru, Karnataka, India GWC Technologies Full time

    PostgeSQLLocation: Bangalore, Hyderabad, RemoteClient:HCLExperience: 6+Years Must have expertise on managing PostgreSQL in onpremises and Azure PostgreSQL in PaaS and IaaS. Must have knowledge on PostgreSQL Installation and configuration using automation script in all versions. Must have knowledge on database security patch upgrade with least possible...


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


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


  • Bengaluru, Karnataka, India Zycus Full time

    Zycus is looking out for Database Administrator having expertise in PostgreSQL Database solutions including, database installation, configuration, performance tuning, troubleshooting, and backups, monitoring and enhancements.Responsibilities: The DBA will be responsible for handling operational tasks including Hardware, Architecture, configuration,...


  • Bengaluru, Karnataka, India Synechron Full time

    Good-day, We have an immediate opportunity for a technology engineer in PostgreSQL Job Role: PostgreSQL Job Location: Bangalore BCIT Experience- 5 to 10 years Notice : Upto 30 Days. About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative...


  • Bengaluru, Karnataka, India Synechron Full time

    Good-day,We have an immediate opportunity for a technology engineer in PostgreSQLJob Role: PostgreSQLJob Location: BangaloreBCITExperience- 5 to 10 yearsNotice : Upto 30 Days.About Company:At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to...


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


  • Bengaluru, Karnataka, 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 onpremises...


  • Bengaluru, Karnataka, India Recruiter Wings Consultancy Full time

    Position: Senior Database Administrator – PostgreSQL Specialist (5 years experience)Location: Bangalore (remote work) – 5 daysDatabase Administration: Manage, monitor, and maintain PostgreSQL database systems for optimal performance, reliability, and security.Performance Tuning: Proactively address performance bottlenecks, optimize SQL queries, and...


  • Bengaluru, Karnataka, India Unilog Full time

    We are seeking a skilled PostgreSQL Database Administrator with a minimum of 5 years of hands-on experience to join our team.The successful candidate will be responsible for managing and maintaining our PostgreSQL database systems, migrating our existing databases to PostgreSQL, ensuring high performance, availability, and Database Installation and...