PL/SQL Developer

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).