Senior Database Developer Data Warehousing & BI

Role Overview We are seeking a highly skilled Senior Database Developer to join our team, focusing on the architecture and maintenance of enterprise-grade data warehouse solutions. You will be instrumental in bridging the gap between complex backend database systems and high-impact business intelligence. The ideal candidate will excel at designing scalable data models, optimizing high-volume query performance, and maintaining robust ETL/ELT pipelines within an AWS ecosystem. Key Responsibilities Database Architecture: Design, develop, test, and maintain enterprise database and data warehouse solutions that drive business intelligence, analytics, and operational reporting. Advanced Development: Develop, optimize, and document complex stored procedures, packages, functions, triggers, and views to support core business logic. Data Engineering: Build and maintain scalable ETL/ELT processes to integrate data from diverse sources, ensuring data quality, lineage, and integrity. Performance Engineering: Lead performance tuning, query optimization, indexing, and partitioning strategies for high-volume, mission-critical environments. Automation: Utilize Python and PySpark to automate database processes, data integration workflows, and monitoring solutions. Cross-Functional Collaboration: Partner with BI analysts, data engineers, and stakeholders to translate business requirements into technical specifications for tools such as Power BI, MicroStrategy, or Tableau. Production Excellence: Manage deployments, conduct rigorous code reviews, and provide 24/7 production support, including incident management, troubleshooting, and root cause analysis (RCA). Leadership: Mentor junior developers, contribute to technical strategy, and uphold development best practices within an Agile framework. Nice-to-Have Domain Expertise: Prior experience in the airline or aviation industry (specifically dealing with PNR, booking, revenue, or flight data systems). Big Data: Exposure to Hive, Spark, or other distributed Big Data technologies. Certifications: Active AWS or Oracle Professional certifications. Leadership: Demonstrated experience leading technical initiatives or formal mentorship. What We Offer Global Mobility: Visa sponsorship/Work Visa support for qualified candidates. Travel

Benefits

• Annual air tickets to support your work-life balance
• Comprehensive Health: Full medical insurance coverage
• Financial Security: End-of-service gratuity scheme
• Time Off: Competitive paid time off and leave policies
• Work Visa, Annual Air Tickets, Medical Insurance, Gratuity & Paid Time Off

Experience

7+ years of hands-on database development, with a minimum of 5 years specifically in Oracle SQL/PLSQL. Technical Expertise: Strong proficiency in Amazon Redshift and AWS data services (S3, Glue, EMR). Data Proficiency: Proven experience in Dimensional Modeling and managing high-volume data integration pipelines. Programming: Hands-on experience with Python/PySpark for data processing and workflow automation. Version Control & Agile: Proficiency with Git and experience delivering features within Agile development teams. BI Tooling: Practical experience with BI/Reporting platforms (Power BI, MicroStrategy, or Tableau). Support: Proven ability to manage production-critical systems, including on-call rotations and incident management.