Oracle SQL Developer – PL/SQL, ETL & Query Optimization
Synechron
Get more replies from employers
Send a job-specific resume in minutes.
Job summary
Synechron is seeking an Oracle SQL Developer to design, develop, and optimize Oracle SQL/PL-SQL based solutions supporting business applications and data warehousing. The role emphasizes performance tuning, data integrity, and scalable data management practices.
The position requires 4+ years of hands-on Oracle SQL/PL-SQL experience and familiarity with ETL, data warehousing concepts, and large dataset handling. Join a dynamic team focused on delivering robust database solutions.
Qualifications
- Minimum 4+ years of hands-on experience with Oracle SQL and PL/SQL.
- Experience using current and supported Oracle Database versions and development tools.
- Strong ability to write complex SQL queries, including analytical functions and joins.
- Experience developing and maintaining stored procedures, functions, packages, triggers, views, and other database objects.
- Knowledge of query performance optimization, execution plans, indexing, partitioning, and database performance analysis.
- Experience working with large datasets and data manipulation techniques.
- Familiarity with ETL processes, data extraction, transformation, loading, and validation.
- Knowledge of data warehousing concepts, including fact tables and dimension tables.
- Familiarity with source control, documentation, issue tracking, and change management tools.
Responsibilities
- Develop, enhance, and maintain complex SQL queries, PL/SQL code, and database objects.
- Perform data extraction, transformation, loading, reconciliation, and validation activities.
- Optimize SQL queries and database performance for large datasets.
- Analyze execution plans and implement tuning solutions.
- Collaborate with analysts, developers, and data teams to understand data requirements.
- Support data modeling, data warehouse development, and data integration activities.
- Investigate and resolve production data accuracy and performance issues.
- Participate in code reviews, testing, and change implementation.
- Maintain documentation for database processes, data flows, and SQL logic.
Skills
Education
Job description
Synechron is seeking an Oracle SQL Developer with 4+ years of experience in Oracle SQL, PL/SQL, database development, performance optimization, and data management.The role will design, develop, maintain, and optimize database solutions that support business applications, reporting, data warehousing, and operational processes. The position will contribute to business objectives by improving data accuracy, query performance, database reliability, and the efficiency of data extraction and transformation activities.
Minimum 4+ years of hands-on experience with Oracle SQL and PL/SQL.
Experience using current and supported Oracle Database versions and development tools.
Strong ability to write complex SQL queries, including:
Experience developing and maintaining stored procedures, functions, packages, triggers, views, and other database objects.
Knowledge of query performance optimization, execution plans, indexing, partitioning, and database performance analysis.
Experience working with large datasets and data manipulation techniques.
Familiarity with ETL processes, data extraction, transformation, loading, and validation.
Knowledge of data warehousing concepts, including fact tables, dimension tables, data marts, and data models.
Familiarity with source control, code review, documentation, issue tracking, and change management tools.
Ability to support production issues and investigate data accuracy, integrity, and performance concerns.
Ability to use current and supported versions of relevant SQL development, database administration, ETL, reporting, and monitoring tools.
Experience with enterprise data warehouses and investment or financial data platforms.
Exposure to positions-related data views or equivalent financial data warehouse structures.
Experience with ETL tools and data integration platforms.
Knowledge of reporting and business intelligence tools.
Experience with query tuning, execution plan analysis, indexing strategies, partitioning, and workload optimization.
Familiarity with Agile/Scrum development teams.
Exposure to incident, change, and service management processes.
Experience with automated database testing and data quality validation.
Develop, enhance, and maintain complex SQL queries, PL/SQL code, stored procedures, functions, packages, views, triggers, and other database objects.
Perform data extraction, transformation, loading, reconciliation, and validation activities.
Optimize SQL queries and database performance for large-scale datasets.
Analyze execution plans, identify performance bottlenecks, and implement appropriate tuning solutions.
Apply indexing, partitioning, query refactoring, and data-access improvements where required.
Work with Business Analysts, developers, data teams, reporting teams, and stakeholders to understand data requirements.
Support database design, data modeling, data warehouse development, and data integration activities.
Investigate and resolve production issues involving data accuracy, performance, database objects, and ETL processes.
Participate in code reviews, technical design discussions, testing, release activities, and change implementation.
Maintain accurate documentation for database processes, data flows, data models, SQL logic, dependencies, and changes.
Ensure data solutions meet requirements for accuracy, integrity, performance, availability, security, and maintainability.
Identify opportunities to improve database development standards, automation, data quality, and operational efficiency.
Support Agile delivery practices, sprint activities, estimation, backlog refinement, and retrospective actions where applicable.
Consider efficient use of database and computing resources when designing queries, data processes, and database solutions.
Oracle SQL using a current and supported database version.
PL/SQL development, including procedures, functions, packages, triggers, cursors, exception handling, and bulk processing.
Strong understanding of SQL joins, subqueries, analytical functions, common table expressions, aggregations, and data manipulation.
Ability to write readable, maintainable, reusable, and testable database code.
Understanding of database programming principles and transaction management.
Shell scripting for database automation, batch processing, and operational support.
Familiarity with scripting used for ETL, reporting, data validation, or deployment activities.
Experience developing reusable SQL and PL/SQL utilities.
Strong knowledge of relational database concepts.
Understanding of tables, views, indexes, partitions, constraints, keys, relationships, and transactions.
Experience with data modeling and database design.
Knowledge of data warehousing concepts, including fact tables, dimension tables, data marts, and historical data.
Experience working with large datasets and data manipulation techniques.
Understanding of data quality, data integrity, reconciliation, validation, and data lifecycle management.
Ability to analyze data structures, dependencies, and data flows.
Experience with enterprise data warehouses and financial data models.
Exposure to positions, holdings, transactions, accounting, or investment-related data structures.
Knowledge of data lineage, metadata management, and data governance.
Experience with data migration, data reconciliation, and data quality frameworks.
Familiarity with SQL and NoSQL database technologies.
Awareness of database deployment, connectivity, availability, monitoring, and security in cloud and on-premises environments.
Understanding of database performance, scalability, backup, recovery, and operational support requirements.
Ability to support database solutions across development, testing, and production environments.
Experience working with Oracle databases in cloud environments.
Familiarity with cloud-based data warehouses, data integration, storage, and monitoring services.
Knowledge of cloud database security, identity management, encryption, and access controls.
Awareness of cost-efficient and sustainable use of database and computing resources.
Experience with Oracle database development and PL/SQL programming practices.
Knowledge of ETL processes and data integration patterns.
Understanding of data transformation, validation, reconciliation, and error-handling techniques.
Ability to work with database connectivity, reporting, and data-processing components.
Familiarity with development standards for reusable database code and controlled releases.
Experience with enterprise ETL frameworks or data integration platforms.
Knowledge of data warehouse loading patterns and incremental processing.
Familiarity with reporting, business intelligence, or data visualization frameworks.
Experience with database testing, automated validation, and data quality tools.
Familiarity with software development lifecycle practices, including requirements analysis, design, development, testing, deployment, maintenance, and support.
Experience with source control, branching, merging, code reviews, and controlled database releases.
Knowledge of defect management, issue tracking, documentation, and change management processes.
Experience supporting production incidents and resolving database-related issues.
Ability to participate in technical reviews, testing, release planning, and implementation activities.
Experience working in Agile or Scrum teams.
Familiarity with CI/CD processes for database code and ETL solutions.
Exposure to service, incident, and change management processes.
Experience with automated testing, regression testing, performance testing, and data validation.
Knowledge of database monitoring, alerting, and operational dashboards.
Understanding of secure database development and data protection principles.
Knowledge of authentication, authorization, role-based access, encryption, secure connectivity, and audit logging.
Ability to apply appropriate access controls to database objects, data, scripts, and environments.
Understanding of data privacy, data integrity, confidentiality, and secure handling practices.
Experience with data masking, encryption, privileged access management, and security reviews.
Familiarity with database vulnerability management and secure configuration practices.
Knowledge of access segregation, audit requirements, and compliance controls.
Experience supporting security validation during database changes, releases, and production issue resolution.
Minimum 4+ years of experience in Oracle SQL development, PL/SQL development, database engineering, or related roles.
Experience developing complex SQL queries, stored procedures, functions, packages, views, triggers, and database objects.
Experience with Oracle database performance optimization and execution plan analysis.
Experience working with large datasets, data manipulation, data validation, and data integrity.
Experience with ETL processes, data extraction, transformation, loading, and reconciliation.
Experience with data warehousing, data marts, dimensional modeling, fact tables, and dimension tables.
Experience supporting production issues and resolving database or data-related defects.
Experience collaborating with Business Analysts, application developers, data teams, reporting teams, and business stakeholders.
Experience with financial services, investment data, banking, accounting, or other data-intensive industries is preferred.
Experience with enterprise data warehouse platforms or financial data views is preferred.
Candidates may also qualify through equivalent practical experience, relevant database certifications, professional training, or demonstrated delivery of complex Oracle SQL and PL/SQL solutions.
Develop and optimize SQL queries, PL/SQL programs, stored procedures, database objects, and ETL processes.
Collaborate with Business Analysts, developers, data teams, and stakeholders to clarify data requirements and solution outcomes.
Analyze execution plans, validate data, investigate production issues, participate in code reviews, and support testing and release activities.
Maintain database documentation, track changes and defects, recommend performance improvements, and make implementation decisions within established technical and security standards.
Bachelor’s degree in Computer Science,
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
