PL-SQL Developer - Performance Tuning (5-7 yrs)

About the job

This is a hands-on development position for a candidate with a proven record of DB software development and execution excellence.

The ideal candidate should be proficient in designing databases and ensuring their stability, reliability, and performance.

Key Responsibilities :

- Designing and developing database schemas, stored procedures, functions, views, and triggers using Oracle and DB2.

- Developing and maintaining Oracle database applications using PL/SQL.

- Optimizing database performance by tuning SQL queries and PL/SQL code.

- Developing and executing test plans to ensure the quality and accuracy of PL/SQL code.

- Troubleshooting and resolving issues related to PL/SQL code.

- Represent team on all major technical upgrades and large technical efforts.

- Good understanding of industry-leading practices and independently derive solutions.

- Provide direction and technical expertise in database design.

- Responsible for taking ownership of tasks and seeing them through to completion.

- Responsible for establishing best practices, clean code, and design patterns.

- Prepare documentation and specifications.

- Handle common database procedures such as upgrade, backup, recovery, migration, etc.

Preferred Skills :

- Good understanding of design patterns and architecture.

- Knowledge of Unix, and shell scripts.

- Knowledge of performance optimization, test-driven development, build tools, and version control systems.

- Proficiency in Java

Required Skills And Qualifications :

- Bachelor's degree in computer science, Engineering, or a related field.

- 5+ years of professional experience in Database development.

- Extensive experience SQL, PLSQL, Triggers, performance tuning.

- Extensive understanding of database concepts i.e, normalizations/de-normalizations, schemas, table spaces, temporary tables, views, indexes, sequences, partitioning, etc is required.

- Strong communication and interpersonal skills, with the ability to collaborate effectively in a team environment.

- Strong critical thinking and problem-solving skills.

- Focus and desire to deliver high quality services