Senior Database Administrator (Senior Infra Specialist), Delhi, India

Overview

WELCOME TO SITA

At SITA, we keep airports moving, airlines flying smoothly, and borders open. Our technology and communication innovations power the success of the global air travel industry.

You'll find us in 95% of international airports, working closely with over 2,500 transportation and government clients. Each partnership brings unique challenges, and we thrive on delivering fresh solutions and cutting-edge tech to keep operations running like clockwork. We don't just move the world forward-we're proud to be recognized as a Great Place to Work® by 79% of our employees and certified in most of our growing locations. Here, we feel empowered, supported, and inspired to grow.

Are you ready to love your job?

The adventure begins right here, with you, at SITA.

PURPOSE

As a Senior Database Administrator , you have the responsibility of administrating, monitoring, and troubleshooting a 24x7 production environment's database servers and associated infrastructure. This role is with other team members to ensure 100% uptime, plan future capacity requirements, maintain security, and apply updates.

You will also solve exciting technical challenges by analyzing, troubleshooting, and designing vital services, platforms, and infrastructure while always thinking about reliability, scalability, resilience, security, and performance.

What you will do:

• Serve as SME (subject matter expert) for PostgreSQL, Microsoft SQL Server, and other database technologies.
• Responsible for day-to-day activities regarding the upkeep and availability of all Postgres database servers in the environment including lower environments
• Strong and demonstrable experience as DBA in large-scale PostgreSQL environments
• Responsible for database backup and restore functions including scheduled tests of DR availability, including knowledge of PostgreSQL restoration and availability technologies such as Clustering, Replication, Always-On, etc.
• Ensure all database servers are managed to Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
• Participates in SQL code reviews for the application teams to enforce SQL coding standards
• Builds and reports on SQL environment performance and availability metrics and takes appropriate actions to implement best practices and optimize performance.
• Assist in the technical analysis and design for current and future projects.

Qualifications

Who you are:

• Hands-on expertise managing high-volume instances of PostgreSQL Databases
• Demonstration and Knowledge of working in a Database infrastructure administration with Strong problem-solving skills, with the ability to identify and resolve issues quickly
• Developed and established policies and procedures related to data security and integrity; monitor and limit database access as needed.
• Expert in Documenting the company's database environment.
• Experience in writing automation scripts and building application dashboards for proactive monitoring and alerting.
• Experience with database storage engines and master-slave replication principles and practices.
• Experience as Linux systems administrator (e.g. CentOS, RedHat) and command-line system administration such as Bash, VIM, and SSH.
• Experience with CI/CD in cloud environments and container technology, Docker and Kubernetes, Docker Swarm
• Good communicator and coordination skills and able to work efficiently under pressure.

EDUCATION & QUALIFICATIONS

• Master's degree or equivalent preferably in Computer Science Engineering Mathematics or similar.- Where applicable a recognised professional certification is desirable.