Description

You will focus on hands-on database software development, design, and execution excellence.

Responsibilities

• Design and develop database schemas, stored procedures, functions, views, and triggers using Oracle and DB2.
• Optimize database performance by tuning SQL queries and PL/SQL code.
• Develop and execute test plans to ensure the quality and accuracy of code.
• Troubleshoot and resolve issues related to PL/SQL code.
• Manage database procedures including upgrades, backups, recovery, and migrations.
• Establish best practices, clean code, and design patterns while preparing technical documentation.

Required Skills

• 5+ years of professional experience in database development.
• Extensive experience with SQL, PL/SQL, and triggers.
• Expertise in performance tuning.
• Deep understanding of database concepts including normalization, de-normalization, schemas, tablespaces, temporary tables, views, indexes, sequences, and partitioning.
• Proficiency in Oracle and DB2.
• Bachelor’s degree in Computer Science, Engineering, or a related field.
• Strong critical thinking and problem-solving skills.
• Ability to collaborate effectively within a team environment.

Preferred Skills

• Knowledge of design patterns, architecture, and Java.
• Experience with Unix, shell scripts, and version control systems.
• Understanding of test-driven development and build tools.

Key Skills

Education

Bachelor’s degree in computer science