Oracle Database Developer

Intelligence And National Security Alliance - Boston, MA

Full-time - Mid Level

Boston, MA

Religious, Grantmaking, Civic, Professional, and Similar Organizations

About the position

The Oracle Database Developer position is a hands-on role focused on database design, development, and optimization. The ideal candidate will have a strong background in database software development, particularly with Oracle and DB2, and will be responsible for ensuring the stability, reliability, and performance of database applications. This role requires a proactive approach to problem-solving and a commitment to delivering high-quality services.

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.
• Representing the team on all major technical upgrades and large technical efforts.
• Providing direction and technical expertise in database design.
• Taking ownership of tasks and seeing them through to completion.
• Establishing best practices, clean code, and design patterns.
• Preparing documentation and specifications.
• Handling common database procedures such as upgrade, backup, recovery, migration, etc.

Requirements

• Bachelor's degree in Computer Science, Engineering, or a related field.
• 5+ years of professional experience in Database development.
• Extensive experience in SQL, PLSQL, Triggers, and performance tuning.
• Extensive understanding of database concepts such as normalizations/de-normalizations, schemas, table spaces, temporary tables, views, indexes, sequences, partitioning, etc.
• 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.

Nice-to-haves

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