Role Purpose
The SQL Developer is responsible for supporting the development, maintenance, and optimization of operational database solutions. The role involves creating and maintaining database objects, supporting application integrations, troubleshooting production issues, and assisting with deployment activities across development, testing, and production environments. Working closely with senior developers, business analysts, QA teams, and support teams, the incumbent will contribute to delivering reliable database and integration solutions that support airline operations.
Key Responsibilities
Database Development & Maintenance
- Develop, maintain, and optimize database objects including:
- Tables
- Stored Procedures
- Functions
- Views
- Indexes
- Triggers
- Support database schema modifications and deployment activities.
- Ensure data integrity, performance, and security of database solutions.
- Assist in troubleshooting database-related issues.
Application Integration Support
- Work with data exchange formats such as:
- XML
- JSON
- SOAP
- REST APIs
- Assist in integrating airline systems with external applications and enterprise platforms.
- Support API and middleware-based integration initiatives.
Testing & Quality Assurance
- Perform unit testing and integration testing of developed solutions.
- Validate database functionality and integration services before deployment.
- Support defect resolution and quality improvement initiatives.
Production Support & Incident Management
- Analyze application and integration logs.
- Investigate and troubleshoot system failures and performance issues.
- Assist with production incident resolution.
- Participate in root cause analysis activities and implement preventive solutions.
Cloud & Emerging Technologies
- Build foundational knowledge of cloud platforms such as Azure and AWS.
- Support cloud-related application development initiatives.
- Continuously learn modern integration and database technologies.
Documentation & Compliance
- Prepare and maintain technical documentation.
- Adhere to coding standards, security requirements, and development best practices.
- Support audit and governance requirements where applicable.
Stakeholder Collaboration
- Work closely with:
- Business Analysts
- Senior Developers
- QA Teams
- Infrastructure Teams
- Support Teams
- Translate business requirements into technical solutions under guidance from senior team members.
Technical Competencies
Core Skills (Required)
- SQL
- PL/SQL
- Database Design Fundamentals
- Database Development and Maintenance
- Query Optimization
- Stored Procedure Development
- Data Modelling Basics
- Database Deployment and Version Control
Integration Technologies
- XML
- JSON
- SOAP Web Services
- REST APIs
- Basic System Integration Concepts
Cloud Technologies (Preferred)
- Microsoft Azure Fundamentals
- AWS Fundamentals
- Cloud-based Application Services
- Database Services in Cloud Environments
Additional Technologies (Desirable)
- IBM ACE (App Connect Enterprise)
- IBM Integration Bus (IIB)
- IBM MQ
- Enterprise Integration Patterns
Education
Required
- Bachelor's Degree in:
- Computer Science
- Information Technology
- Software Engineering
- Information Systems
- Related Technical Discipline
Experience
Required
- 0-2 years of experience in:
- Software Development
- Database Development
- System Integration
Fresh Graduates
- Strong academic background in database technologies.
- Demonstrated project or internship experience in SQL and programming.
Behavioral Competencies
Problem Solving
- Strong analytical thinking.
- Ability to investigate and resolve technical issues.
Learning Agility
- Quick learner with interest in new technologies.
- Willingness to learn cloud and integration platforms.
Communication
- Effective verbal and written communication skills.
- Ability to explain technical concepts clearly.
Teamwork
- Collaborative mindset.
- Ability to work effectively with cross-functional teams.
Attention to Detail
- Accuracy in coding, testing, and documentation.
Preferred Certifications
- Microsoft Azure Fundamentals (AZ-900)
- AWS Cloud Practitioner
- Oracle SQL Certification
- Oracle PL/SQL Developer Certification
- IBM ACE Fundamentals (if applicable)
