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