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 challenging and relevant issues in financial services and technology. Our talented people empower us, and we believe in being part of a team that is open, collaborative, entrepreneurial, passionate and above all fun.
About the team
We are the Global Infrastructure and Cloud services PostgreSQL database team. We manage a wide range of database support services such as setup, config, manage and support PostgreSQL databases on-prem and on-Cloud. Our team is supporting clients in North America and EMEA regions.
What you will be doing
Work with Microsoft to design, manage and support High Availability, Reliability, Backup/Restore, GEO redundancy and Disaster Recovery scenarios
Perform performance analysis, review parameters and tune / optimize SQL queries. Work closely with application teams to create database objects to ensure performance optimization.
Write or Tune SQL queries, review data model and structures and provide recommendation for database table structures.
Write KQL queries, Query store, Intelligent tuning, and query stats, stored procedures, functions, triggers, and views. Identify potential issues in database and SQL issues to solve them early.
Analyze and coordinate with application development teams fixing technical SQL problems.
Setup and perform Backup/restore/recovery. Setup Read Replica, perform failover and failback PostgreSQL between zones and regions.
Plan and coordinate with Microsoft for data backups, DR restore/recovery and setup vendor escalation procedures.
Troubleshot and fix database and SQL performance slowness
Provide 24 x 7 operation and on-call production support
What you bring:
We require a professional role of high level of proficiently. The candidate must work independently and display ability to overcome most obstacles and drive solutions.
Must have deep knowledge and 7+ years of hands-on cloud infrastructure support in PostgreSQL Azure and AWS handling Availability, Reliability, Backup/Restore, GEO redundancy and Disaster Recovery scenarios.
Must have application, data model knowledge and have expert level in writing and tuning SQL queries in PostgreSQL.
What we offer you
An exciting opportunity be a part of World’s Leading FinTech Product MNC
To be a part of vibrant team and to build up a career on core banking/payments domain
A broad range of professional education and personal development possibilities – FIS is your final career step!
Privacy Statement
FIS is committed to protecting the privacy and security of all personal information that we process in order to provide services to our clients. For specific information on how FIS protects personal information online, please see the Online Privacy Notice.
Sourcing Model
Recruitment at FIS works primarily on a direct sourcing model; a relatively small portion of our hiring is through recruitment agencies. FIS does not accept resumes from recruitment agencies which are not on the preferred supplier list and is not responsible for any related fees for resumes submitted to job postings, our employees, or any other part of our company.
#pridepass