Infrastructure Database Senior Engineer

Infrastructure Domain Manager

As one diverse, high-performing team dedicated to technical excellence, you will focus relentlessly on delivering unrivaled digital products that drive a more reliable and profitable airline.

The Infrastructure Domain in Information Technology is dedicated to managing and maintaining the client/server hardware and software that underpins an organization's computing environment. This domain covers various responsibilities, from IT logistics to data center management. It supports various technologies, including VDI, API management, and infrastructure tools and processes to ensure business systems operate efficiently, reliably, and securely.

Responsibilities

• Plan and implement database designs, including the creation and maintenance of cloud databases
• Allocate resources such as Storage / Compute / Memory. Implement strategies for HA, Failover DR and Replication.
• Fine-tune database systems to enhance performance, scalability, and reliability - including monitoring and optimizing database query performance, indexing etc.
• Establish access and authentication controls to secure data, setup encryption, masking as required.
• Manage and monitor performance, security, and availability of databases
• Implement database backup and disaster recovery procedures
• Work with development teams to optimize database usage and query performance
• Coordinate and manage migration of databases to Azure platform
• Perform capacity planning and demand forecasting for database systems
• Identify and troubleshoot any database-related issues in a timely manner
• Stay current with the latest Azure technologies, trends, and techniques

Minimum Qualifications- Education & Prior Job Experience

• Bachelor's degree in Computer Science, Computer Engineering, Technology, Information Systems (CIS/MIS), Engineering or related technical discipline, or equivalent experience/training
• 4 to 5 or more years of Database Administration experience. with any of the database management systems (Microsoft SQL Server, DB2 LUW, Oracle, PostgreSQL etc.).
• 4 to 5 or more years of experience working with large database / large scale projects.
• 4 to 5 years of experience with cloud-based database technologies (Azure SQL, Azure SQL MI, Azure SQL for PostgreSQL.
• Knowledge of cloud computing concepts, virtualization, and infrastructure-as-a-service (IaaS) platforms.
• Proficiency in SQL Server and Microsoft Azure cloud technologies.
• Is a self-starter with the ability to work with little management supervision.
• Has the ability to multi-task, be flexible and deal with interruptions and change.
• Can co-ordinate the triage, identification and resolution of complex production and non-production issues
• Proficient in SQL language, database principles, and data modeling
• Must be willing to work varying shifts (Day, Night, Slit, or weekends)

Additional Skills or Prior Job Experience

• 1 to 3 years experience with NoSQL database systems (MongoDB, DynamoDB, Azure Cosmos DB, Neo4j, Neptune etc.).
• Familiarity with Microsoft DevOps and PowerShell scripting.
• Expertise in utilizing IaaS and PaaS services, including database services and Kubernetes.
• Understanding of IP subnetting, Network Security Groups, routing, Azure Firewall, load balancing, DNS, and other networking concepts and protocols.
• Experience with Azure SQL, PostgreSQL and other Azure data services
• Knowledge of Power Shell or other scripting languages
• Basic understanding of containers and virtualization technologies( Kubernettes, VMWare)

Skills, Licenses & Certifications

• Familiarity with workflow and ITSM tools and ticketing systems
• Excellent customer service skills with the ability to interface at all levels of the organization.
• Excellent verbal and written communication skills
• Ability to work independently and perform in a collaborative, team-based environment.
• Experience with monitoring and alerting tooling