Job Requirements
Washington, DC
Secret Polygraph not specified
Mid Level Career (5+ yrs experience)
Salary not specified
Join Premium to unlock estimated salaries
Job Description
Oracle Database Developer
Arlington, VA (Hybrid- 1 day onsite/week)
Full time
Secret clearance
Database Developer with a strong background in Oracle database development and PL/SQL to join a fast-paced agile team. This role works closely with .NET software engineers on the development of search and ETL applications, requiring both deep database expertise and the ability to collaborate across a multi-disciplinary development team. The ideal candidate brings hands-on experience with Oracle Golden Gate and Oracle AQ, or a demonstrated ability to learn these technologies quickly in a complex production environment.
Responsibilities
• Design, develop, test, maintain, and enhance applications
• Develop complex SQL queries for data analysis
• Develop and maintain PL/SQL procedures, functions, and packages for data population and manipulation per business requirements using Oracle Database, TOAD, and SQL*Plus
• Create Ansible playbooks to manage ops configuration and database infrastructure
• Develop and manage the implementation and maintenance of CI/CD pipelines for code deployment using Jenkins to automate deployment processes
• Develop and maintain release notes and feature enhancements
• Identify and address performance bottlenecks in applications to ensure they are more efficient and responsive
• Provide support to end-users in addressing their inquiries and resolving their technical issues with the applications
• Develop database objects including tables, views, stored procedures, and packages using PL/SQL, TOAD, and SQL*Plus
• Work in a scrum-based agile development process which plans and builds features targeted to a release; maintain Git / GitLab workflows for version control
• Prepare reports, manuals, and other documentation for the operation and maintenance of applications
• Guide other team members on patterns and practices to produce high quality software
• Analyze and resolve technical and application problems in support of Tier III Operations
Requirements
• Bachelor’s degree in Computer Science, Information Technology, or equivalent experience
• Must have an active DoD Secret (or higher) Clearance
• Minimum 5+ years of experience in Oracle database development and PL/SQL
• Strong hands-on experience with Oracle Database, PL/SQL, TOAD, and SQL*Plus
• Experience developing complex SQL queries, stored procedures, functions, and packages for data population and manipulation
• Experience with Oracle Golden Gate and/or Oracle Advanced Queuing (AQ), or a demonstrated ability to learn these technologies quickly
• Experience developing and maintaining ETL applications and search application integrations in collaboration with .NET software engineers
• Experience creating Ansible playbooks for configuration management and database infrastructure automation
• Experience implementing and maintaining CI/CD pipelines using Jenkins
• Proficiency with Git / GitLab version control workflows in an agile scrum environment
• Familiarity with IIS and .NET application hosting environments
• Experience with project tracking and agile workflow tools such as Jira
• Strong analytical and problem-solving skills with the ability to identify and resolve performance bottlenecks
• Ability to clearly communicate technical concepts and guide team members on database patterns and best practices
• Ability to work in a fast-paced agile development environment and collaborate effectively with software engineers and cross-functional teams
Arlington, VA (Hybrid- 1 day onsite/week)
Full time
Secret clearance
Database Developer with a strong background in Oracle database development and PL/SQL to join a fast-paced agile team. This role works closely with .NET software engineers on the development of search and ETL applications, requiring both deep database expertise and the ability to collaborate across a multi-disciplinary development team. The ideal candidate brings hands-on experience with Oracle Golden Gate and Oracle AQ, or a demonstrated ability to learn these technologies quickly in a complex production environment.
Responsibilities
• Design, develop, test, maintain, and enhance applications
• Develop complex SQL queries for data analysis
• Develop and maintain PL/SQL procedures, functions, and packages for data population and manipulation per business requirements using Oracle Database, TOAD, and SQL*Plus
• Create Ansible playbooks to manage ops configuration and database infrastructure
• Develop and manage the implementation and maintenance of CI/CD pipelines for code deployment using Jenkins to automate deployment processes
• Develop and maintain release notes and feature enhancements
• Identify and address performance bottlenecks in applications to ensure they are more efficient and responsive
• Provide support to end-users in addressing their inquiries and resolving their technical issues with the applications
• Develop database objects including tables, views, stored procedures, and packages using PL/SQL, TOAD, and SQL*Plus
• Work in a scrum-based agile development process which plans and builds features targeted to a release; maintain Git / GitLab workflows for version control
• Prepare reports, manuals, and other documentation for the operation and maintenance of applications
• Guide other team members on patterns and practices to produce high quality software
• Analyze and resolve technical and application problems in support of Tier III Operations
Requirements
• Bachelor’s degree in Computer Science, Information Technology, or equivalent experience
• Must have an active DoD Secret (or higher) Clearance
• Minimum 5+ years of experience in Oracle database development and PL/SQL
• Strong hands-on experience with Oracle Database, PL/SQL, TOAD, and SQL*Plus
• Experience developing complex SQL queries, stored procedures, functions, and packages for data population and manipulation
• Experience with Oracle Golden Gate and/or Oracle Advanced Queuing (AQ), or a demonstrated ability to learn these technologies quickly
• Experience developing and maintaining ETL applications and search application integrations in collaboration with .NET software engineers
• Experience creating Ansible playbooks for configuration management and database infrastructure automation
• Experience implementing and maintaining CI/CD pipelines using Jenkins
• Proficiency with Git / GitLab version control workflows in an agile scrum environment
• Familiarity with IIS and .NET application hosting environments
• Experience with project tracking and agile workflow tools such as Jira
• Strong analytical and problem-solving skills with the ability to identify and resolve performance bottlenecks
• Ability to clearly communicate technical concepts and guide team members on database patterns and best practices
• Ability to work in a fast-paced agile development environment and collaborate effectively with software engineers and cross-functional teams
group id: 10529568