SQL Developer - Database Performance Tuning (5-10 yrs)

About the Role :

We are seeking an experienced and highly skilled SQL Developer with a strong background in PL/SQL, Python, and API development to join our growing engineering team. In this role, you will work on building, optimizing, and maintaining data-driven backend systems, supporting large-scale enterprise applications.

The ideal candidate will bring deep expertise in Oracle RDBMS, data warehouse concepts, and cloud-native technologies like Kubernetes and AWS.

This is a great opportunity for someone who thrives at the intersection of backend development and data engineering, and who can take ownership of database-centric solutions, from design through deployment.

Key Responsibilities :

- Design, develop, and maintain complex SQL and PL/SQL programs (procedures, functions, packages, triggers, and ref cursors).

- Optimize SQL queries for performance, efficiency, and scalability.

- Apply data normalization techniques and implement best practices for Oracle database performance tuning.

- Build and maintain RESTful APIs using Python and frameworks like Flask, Django, or FastAPI.

- Integrate APIs with backend Oracle databases for CRUD operations and analytics.

- Use Python libraries such as Pandas, NumPy, and SQLAlchemy to manipulate and manage data pipelines and interfaces.

- Participate in the design and development of Data Warehouse solutions, including Data Marts and Operational Data Stores (ODS).

- Understand and implement ETL/ELT processes aligned with business logic and data governance standards.

- Ensure high data accuracy and quality for downstream reporting and analytics use cases.

- Implement and maintain API authentication and authorization mechanisms using OAuth2, JWT, or similar technologies.

- Ensure robust access control and data security practices are enforced across the backend systems.

- Work with AWS cloud services such as EC2, S3, RDS, Lambda, etc., for application deployment and data management.

- Deploy and manage backend services on Kubernetes clusters; handle container orchestration and monitoring.

- Use infrastructure-as-code (IaC) tools such as Terraform or CloudFormation for automating cloud resource provisioning.

Required Skills & Qualifications :

Education : B.E. / B.Tech. or MCA in Computer Science or a related discipline from a reputed university.

Experience : 58 years of relevant experience in SQL development, API design, and Python-based application development.

Proficiency in :

- PL/SQL (Oracle stored procedures, functions, cursors, exception handling).

- SQL performance tuning and query optimization techniques.

- Python development, especially using frameworks like Flask, Django, FastAPI.

- Building secure, scalable REST APIs integrated with relational databases.

- Familiarity with data architecture concepts including DWH, ODS, and dimensional modeling.

- Working knowledge of Kubernetes for container orchestration and service deployment.

- Experience with AWS cloud services and IaC tools like Terraform or CloudFormation.

- Knowledge of CI/CD pipelines, version control (Git), and agile development processes.