PL/SQL Developer (SQL Optimization & ETL)

Job Description: Synechron is seeking a skilled PL/SQL Developer to design, develop, and maintain SQL and PL/SQL code for database applications. The ideal candidate will have strong technical expertise in relational databases, performance tuning, and ETL processes. This role involves collaborating with cross-functional teams, troubleshooting database issues, and optimizing code for efficiency.

Software Requirements:

• Proficient in SQL and PL/SQL.
• Strong understanding of relational database management systems (RDBMS) such as Oracle, MySQL, or SQL Server.
• Experience with query optimization, indexing strategies, and analyzing execution plans.
• Knowledge of ETL tools and processes (optional).
• Familiarity with DevOps technologies such as Jenkins, Ansible, SonarQube, Bit Bucket, Artifactory (optional).
• Knowledge of scheduling tools and defect management tools (mandatory).
• Proficiency in programming languages like Python, Perl, or VB Script (optional).

Overall Responsibilities:

• Design, develop, and maintain SQL and PL/SQL code for database applications.
• Analyze query performance and provide tuning suggestions to improve overall efficiency and speed.
• Develop ETL processes for data migration and integration with other systems.
• Identify and resolve issues in database operations and scripts.
• Create and maintain documentation for SQL and PL/SQL code, database structures, and any modifications made.
• Work closely with application developers, database administrators, and other IT staff to meet project goals.
• Develop stored procedures to build reports for end-users using SQL 2016.
• Mentor new team members and optimize code.
• Learn and understand reconciliation concepts, ETL tools, reconciliation tools like IntelliMatch, and scheduling tools like Autosys.
• Contribute to reconciliation development activities using IntelliMatch tools and ETL workflow setup and scheduling tool configuration.
• Involvement across all stages of the Software Development Life Cycle (SDLC).
• Analyze and develop test strategies, design test plans, and execute test cases.
• Perform enhancements and deliver quality code.
• Guide support teams and propose improvements related to development and support activities.

Technical Skills:

• Primary Skills:
  • Advanced skills in SQL queries, stored procedures, packages, functions, and triggers.
  • Experience with query optimization and performance tuning.
  • Proficiency in ETL tools and processes.
  • Knowledge of scheduling tools.
  • Strong analytical and troubleshooting skills.
• Secondary Skills:
  • Familiarity with DevOps technologies (optional).
  • Experience with defect management tools (optional).
  • Knowledge of programming languages like Python, Perl, or VB Script (optional).

Experience:

• Minimum of 9 years of experience in SQL and PL/SQL development.
• Prior experience with relational databases and performance tuning.
• Experience in ETL processes and tools (optional).

Day-to-Day Activities:

• Write, maintain, and execute SQL and PL/SQL code.
• Troubleshoot and debug database scripts.
• Collaborate with cross-functional teams to meet project goals.
• Analyze query performance and provide optimization suggestions.
• Develop and maintain ETL processes.
• Create and maintain documentation for database code and structures.
• Mentor team members and guide support teams.
• Participate in agile sprint planning and retrospectives.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Relevant certifications in SQL and PL/SQL (preferred).

Soft Skills:

• Strong communication and interpersonal skills.
• Ability to work effectively in a team environment.
• Strong organization and prioritization skills.
• Pragmatic approach to problem-solving.
• Willingness to improve functional knowledge and technical skills.
• Ability to work closely with end-users and developers.
• Expected to work in European business hours (including holidays and weekends).

S​YNECHRON’S DIVERSITY & INCLUSION STATEMENT
 

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice