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