Database Administrator

JOB PURPOSE:

Responsible for managing, optimizing, and securing the company's database systems, including relational and NoSQL databases, to support both Business Intelligence (BI) solutions and Enterprise Applications by ensuring high availability, performance, and data integrity using technologies such as SQL Server, Azure SQL services, and Azure Cosmos DB. This role facilitates reliable data storage, retrieval, and maintenance across BI and enterprise systems to enable accurate analysis, reporting, predictive modeling, and seamless application functionality. These capabilities will drive informed decision-making, operational efficiency, and system reliability across the airline.

KEY ACCOUNTABILITIES:

Performance Optimization

Optimize database performance through indexing, query tuning, and resource allocation for relational and NoSQL databases to enhance data retrieval speeds for BI reporting, predictive analytics, and enterprise application processes.

Analyse and troubleshoot performance bottlenecks in relational and NoSQL databases supporting BI and Enterprise Applications, implementing solutions to improve efficiency and scalability.
Security and Governance
Implement and enforce database security measures, including access controls, encryption, and auditing, for relational and NoSQL databases to protect sensitive data in compliance with company policies and regulations.

Ensure data governance standards are upheld by verifying data integrity, consistency, and privacy across relational and NoSQL databases used in BI and Enterprise Applications.

Backup and Recovery

Develop and manage backup and disaster recovery strategies for relational and NoSQL databases to minimize data loss and ensure quick restoration in support of business continuity for BI and enterprise operations.

Test and validate recovery procedures regularly to maintain high availability and reliability of database systems.

Collaboration and Support

Collaborate with BI analysts, Enterprise Applications teams, and other stakeholders to understand database requirements and provide tailored support for data integration, querying, and application development.
Offer technical guidance and training to users on database best practices, tools, and troubleshooting within BI and Enterprise Applications contexts.
Communicate database designs, optimization strategies, and security protocols to technical and non-technical stakeholders.

Operational Excellence

Implement best practices for database management and monitoring tools to optimize performance, availability, and cost-efficiency across BI and Enterprise Applications.
Ensure database systems meet required service level agreements (SLAs) for uptime, performance, and reliability.

Team - Personal and Professional Development

Operate within the IT team, embracing teamwork to collectively achieve high performance standards in database management tasks.
Takes ownership for self-development and knowledge sharing among peers to enhance know-how and overall performance within the team.
Regulatory and Other

Ensure compliance in own area and across Arajet with policies and regulations where applicable in order to safeguard the company from any high-risk audit findings, regulatory breaches and company exposure with negative financial implications.

Any other duties and accountabilities as assigned by the Business Intelligence Vice President.

QUALIFICATIONS, EXPERIENCE, & SKILLS:

Bachelors or Masters degree in Computer Science, Computer Engineering, Information Systems, or related field.
Professional certifications in relevant areas such as Microsoft Certified: Azure Database Administrator Associate, SQL Server certifications (e.g., MCSA: SQL Database Administration).
Azure Cosmos DB Developer Specialty, or Azure fundamentals are preferred.
Experience:
A minimum of 3-5 years of experience in database administration or a related role, with exposure to both relational and NoSQL databases.
Experience with Microsoft SQL Server and Azure database services (e.g., Azure SQL Database, Azure SQL Managed Instance) and NoSQL services like Azure Cosmos DB.
Proven track record of designing, implementing, and optimizing database systems, including schemas, indexing, and performance tuning, and NoSQL data modeling.
Experience in managing and maintaining large-scale databases, including relational and NoSQL, for BI analytics and Enterprise Applications.
Experience in backup, recovery, and disaster recovery planning for relational and NoSQL databases.
Skills:
Proficiency with database management tools such as SQL Server Management Studio (SSMS), Azure Data Studio and Azure Cosmos DB tools. 
Familiarity with cloud-based database technologies, including NoSQL (e.g., Azure Cosmos DB) and big data tools (e.g., Azure Synapse, Hadoop integration).
Strong knowledge of SQL, T-SQL, and NoSQL query languages (e.g., SQL-like queries in Cosmos DB), with experience in data modeling, normalization, and NoSQL design principles.
Expertise in database security, including encryption, access controls, and compliance auditing for relational and NoSQL environments.
Strong problem-solving and analytical skills with the ability to troubleshoot complex database issues and performance bottlenecks.
Excellent organizational and time-management skills with the ability to prioritize tasks and meet deadlines in a fast-paced environment.
Excellent communication and teamwork skills to collaborate with BI analysts, Enterprise Applications teams, and other stakeholders.