The Role
Develops advanced PL/SQL database solutions, including procedures, packages, functions, views, triggers, schemas, and ETL routines. Tunes query and database performance using indexes, optimizer hints, AWR, Explain Plan, and profiling tools. Performs data modeling and migration from flat files and legacy systems. Collaborates with analysts, engineers, and stakeholders in Agile teams while applying automated testing and CI/CD practices to database development.
Summary Generated by Built In
Job Description:
- Database Development: Design and write efficient PL/SQL code, including stored procedures, packages, functions, views, and database triggers.
- Performance Tuning: Analyze complex queries, build strategic indexes, use optimizer hints, and utilize tools like AWR (Automatic Workload Repository), Explain Plan, and Profiler to eliminate database bottlenecks.
- Data Architecture & Modeling: Manage and design database schemas, tablespaces, entity-relationship diagrams (ERDs), and overall data structures to maintain data integrity.
- ETL and Data Migration: Build automated batch jobs using data transformation routines to extract, transform, and load (ETL) data from external flat files or legacy systems into target databases.
- Collaboration: Work alongside data analysts, software engineering teams, and business stakeholders in an Agile environment to map business requirements into technical SQL logic.
Requirements
Qualifications:
- Core Languages: Mastery of advanced SQL (joins, subqueries, window functions) and expert-level PL/SQL programming.
- Database Management Systems: Strong knowledge of Oracle Database Architecture. Familiarity with alternate relational databases (e.g., Microsoft SQL Server, PostgreSQL, MySQL) is often a plus.
- Development Tools: Proficiency using Integrated Development Environments (IDEs) like Oracle SQL Developer, TOAD, or ERwin for data modeling.
- Automation & Build Tools: Experience with Unix/Linux shell scripting, scheduler tools (like Autosys), and ETL frameworks (like Informatica).
- Methodologies: Practical understanding of Agile delivery frameworks, automated testing for database code, and CI/CD pipelines.
Skills Required
- Advanced SQL proficiency, including joins, subqueries, and window functions
- Expert-level PL/SQL programming experience
- Strong knowledge of Oracle Database Architecture
- Proficiency with Oracle SQL Developer, TOAD, or ERwin
- Experience with Unix/Linux shell scripting
- Experience with scheduler tools such as Autosys
- Experience with ETL frameworks such as Informatica
- Understanding of Agile delivery frameworks
- Experience with automated testing for database code
- Experience with CI/CD pipelines
- Familiarity with Microsoft SQL Server, PostgreSQL, or MySQL
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Your trusted business partner for IT solutions and services. Questronix has grown to be one of the largest IT solutions and service providers and systems integrator in the Philippines since 1987 that has earned awards and certificates through its focused professional team of experts
