Lead – Database Administrator (PostgreSQL)
Bangalore, Karnataka
Job Description:
Job Title – Lead – Database Administrator (PostgreSQL)
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
How Your Work Impacts the Organization
Helping the product teams to migrate their databases to public cloud & achieving the organization’s data strategy on having 70% applications migrated to cloud by 2024
The Expertise we’re looking for
-
5 to 8 years of DBA (IT) experience
-
3 + years of experience on PostgreSQL DB/SQL Performance Tuning
-
Experience on automation using shell scripting or python programming.
-
Bachelor’s degree in any technology related field (e.g, Engineering, Computer Science, Maths, etc.) required.
-
PostgreSQL Certification or other RDBMS certifications
Location: Bangalore – Manyata
Shift timings: 11 AM to 8 PM
Certifications:
At Fidelity, building a better financial future— for everyone— is our mission. For the last 75+ years, our privately-held company has remained committed to supporting our clients throughout their lifelong financial journeys.
Our formula is simple: we support our team, and they support our customers. That culture begins with our employees, whose personal and professional growth is key to our collective success. In keeping with that legacy, our privately-held company offers associates career stability and security, while at the same time encouraging your professional exploration and growth. At Fidelity India, we are proud to continue that legacy. With offices in Bangalore and Chennai, our Indian branch is now celebrating 20 years as a Global Capability Center. To find out more, visit India.Fidelity.com, or our global site at fidelitycareers.com.
Fidelity Investments is an equal opportunity employer, and whenever possible we accommodate applicants with disabilities who need adjustments to complete the application or interview process. Please email us at accommodations@fmr.com or call 800-835-5099 for more information
Benefits Developed for You
From the little things that make every day better to those big-picture, life-changing tools. That’s exactly what you’ll get at Fidelity. We have an amazing package of benefits and programs designed to help you thrive both at and outside of work.
Insurance
Affordable and accessible healthcare benefits for you and your loved ones.
- Coverage of up to INR 300,000 for you along with your spouse/partner, with additional top-up options available
- Insurance covers for parents/in-laws made available at subsidized costs
- Personal accident insurance cover of six times your annual basic salary
- Life insurance cover of eight times your annual basic salary
Wellness
We invest in nurturing healthy habits and promoting overall wellness of our associates through three pillars – Physical, Emotional, and Financial wellness.
Parenting
To help you through the exciting yet demanding times of parenthood, avail of time off and other benefits such as childcare allowance and access to daycare.
Transport
You will have access to free transport services to and from work, subject to residing within our pre-defined boundary limits
Retirement
Finally, like the icing on the cake, we offer benefits that will help you contribute to and invest towards your retirement.
- National Pension System (NPS) offered at Fidelity:
- At Grade 6 and below, Fidelity will match your NPS contribution up to 5% of your basic salary
- At Grade 7 and above, Fidelity contributes 10% of your basic salary towards NPS as part of your compensation structure
- Avail of other statutory benefits such as EPF, VPF and Gratuity
Read more about our Benefits program.
Committed to Continuous Learning
At Fidelity, we are constantly adapting to the changing needs of our customers, new technologies, and better ways of working. And we empower our associates to do the same, with an emphasis on developing skills that will help propel you forward in your career while being able to make an impact for Fidelity’s customers around the world.
We offer a wide range of options including online, in-person, and mentor driven solutions – as well as learning days and job shadow opportunities to expose you to new elements of our business to broaden your experience.
Ongoing Opportunities for Growth
- Free access to thousands of online training resources
- Internal clubs focused on trending topics and associate interests
- Ability to pursue online or in-person technical certifications
Read more about our Learning & Development program.
Connected to Our Communities
At every level of our organization, you’ll find people who are committed to doing their part to make the world a better place. We host events and conduct volunteering activities, encouraging associates across the organization to get involved and make an impact on the lives of people in the communities where we live and work.
Fidelity Cares
- Through our community relations program, we provide associates with several opportunities to actively volunteer and create an impact
- Host numerous company-wide volunteering and awareness events.
- Partner with a number of not-for-profit organizations to benefit our local communities
Year-Round Volunteer Opportunities
- Partner with schools and our not-for-profit organizations on financial literacy programs, career counselling, and online tutoring for students
- Teach employability skills to youth from low-income backgrounds, and conduct mock interviews to prepare them for corporate jobs
- Create joyful learning experiences for primary school children through the ‘Art in Education’ program
- Plant urban mini forests and participate in local cleanup efforts
Read more about our Fidelity Cares community relations program..
