Oracle Database Developer

Job Summary: The Oracle Database Developer is a member of the project team who takes responsibility for designing, implementing, and maintaining the Oracle database component of the system using best practices. This will include coding, unit and string testing, and learning new technologies. The candidate will also be expected to provide architectural support and advice with database components of the system.

Responsibilities:

• Work with the Business Analyst to gain an understanding of the business and system requirements to determine optimal database design and maintenance
• Provide guidance, technical leadership and technical support to the development team members regarding the database design and maintenance
• Work closely with team leadership and other IT groups to coordinate, plan, and design current and future activities
• Design, create and maintain database objects
• Design and maintain the architecture of logical and physical data models in line with the NIH enterprise architecture standards and guidelines
• Troubleshoot database issues and errors
• Implement integrity constraints and indexes
• Write queries, functions, stored procedures, and triggers
• Conduct performance tuning of queries and other database objects
• Conduct design and code reviews
• Develop applications/tools for internal use as needed
• Estimate level of effort and plan work accordingly.

Qualifications:

• 10+ years of hands-on experience in Oracle SQL, Pl/SQL coding, performance tuning and code review.

• Experience with Oracle version 11g/12c.
• Thorough knowledge of relational database principles, techniques, and best practices
• Strong programming/development skills using PL/SQL (Package, Stored Procedures, functions, triggers, materialized views) and batch coding skills such as Bulk collections, dynamic SQL, and parallel processing.

• Must have experience in writing complex SQL queries and understanding PL/SQL.
• Solid experience designing partitioned and non-partitioned tables, indexes, temporary tables and external tables to maximize storage and performance
• Experience in developing logical and physical data models
• Strong SQL development, SQL analytics and tuning skills
• Involved in all aspects of the software development life cycle; - and demonstrate abilities to learn both the business processes as well as new and existing technologies
• Excellent analytic, troubleshooting and performance tuning skills
• Solid experience designing partitioned and non-partitioned tables, indexes, temporary tables and external tables to maximize storage and performance
• Experience in developing logical and physical data models

• Proven experience in PL/SQL programming, Performance tuning, SQL Optimization
• Hands-on experience developing data integration solution either using a tool or a custom solution.
• Demonstrated ability to work effectively in a fast-paced environment under deadline pressure.
• Demonstrated ability to manage competing priorities.
• Demonstrated ability to build partnerships with various teams.
• Ability to communicate well and work in a collaborative team environment.
• Ability to work independently with minimum supervision.
• Excellent problem-solving abilities.
• Minimum of 5 years of extensive hands-on experience in designing, creating and managing large and complex relational databases
• Experience in TOAD and TOAD Data Modeler.
• Strong understanding of database backups, restores, recovery, data guard, etc.
• Extensive hands-on experience in using data modeling tools, such as ER/Studio.

• Active Public Trust Clearance or ability to get public trust clearance.