Logo of Huzzle

Home

Matches

Explore

Manage

PostgreSQL Database Administrator

image

FIS

1mo ago

  • Job
    Full-time
    Senior & Expert Level
  • Data
    IT & Cybersecurity
  • Pune

AI generated summary

  • You must have 7+ years of hands-on cloud support in PostgreSQL on Azure and AWS, with expertise in SQL tuning, data modeling, and managing availability, backups, and disaster recovery.
  • You will design, manage, and support database performance, backups, and disaster recovery, optimize SQL queries, troubleshoot issues, and provide 24/7 on-call production support.

Requirements

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

Responsibilities

  • 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

FAQs

What is the job title for this position?

The job title is PostgreSQL Database Administrator.

What is the experience level required for this position?

The position requires 7 to 13 years of experience.

Which locations are available for this role?

The role is available in Bangalore, Pune, and Mumbai.

Is a Bachelor's Degree required for this position?

Yes, a Bachelor's Degree is desired.

What are the main responsibilities of the PostgreSQL Database Administrator?

The main responsibilities include managing and supporting PostgreSQL databases, performance analysis, SQL query optimization, backup/restore/recovery setups, and providing 24 x 7 operation and on-call production support.

What kind of technical expertise is required for this role?

The candidate must have deep knowledge of PostgreSQL, experience with cloud infrastructure support in Azure and AWS, and expert-level skills in writing and tuning SQL queries.

Will the candidate work with Microsoft for any specific tasks?

Yes, the candidate will work with Microsoft to design, manage, and support High Availability, Reliability, Backup/Restore, GEO redundancy, and Disaster Recovery scenarios.

What kind of team will the candidate be working with?

The candidate will be part of the Global Infrastructure and Cloud services PostgreSQL database team that supports clients in North America and EMEA regions.

What opportunities for personal and professional development does FIS offer?

FIS offers a broad range of professional education and personal development possibilities, making it a great place to build a career in the core banking/payments domain.

Is there any requirement for on-call support?

Yes, the position requires providing 24 x 7 operation and on-call production support.

image

FIS

Finance
Industry
5001-10,000
Employees
1968
Founded Year

Mission & Purpose

FIS is at the heart of the commerce and financial transactions that power the world’s economy. We are passionate about helping businesses and communities thrive by advancing the way the world pays, banks and invests, serving more than 20,000 clients and more than one million merchant locations in over 130 countries.