Description
Agile is looking for a skilled Oracle Developer. The Oracle developer will be responsible for designing, developing, and maintaining applications using Oracle. You will collaborate with various teams to understand business requirements and deliver effective technical solutions. In addition, you may work with the team to convert on-premises Oracle Database to AWS GovCloud in an Oracle RDS platform.
Location: Washington D.C. Metro Area
Responsibilities:
Work with the existing team to become familiar with the ongoing Decennial Budget Integration Tool (DBIT) Oracle Database and System On-Premises.
Work on maintaining and enhancing DBIT features and designing/implementing new features using a combination of APEX, JavaScript, SQL, PL/SQL.
Integrate third-party APEX Plugins and JavaScript libraries.
Evaluate recent technology options, recommending the adoption of recent technologies into the solution.
Collaborate with the existing team to potentially convert our On-Premises Oracle Database over to AWS GovCloud in an Oracle RDS platform.
Create tables, views, materialized views, indexes, constraints, and PL/SQL-based ETL routines in support of our business intelligence platform.
Apply changes to objects and code to keep pace with the yearly changes in the system and ensure that the ETL runs efficiently and often as possible.
Work in an Agile environment within JIRA for your sprint workload and backlog grooming of future stories and tasks.
Must Haves:
Minimum 10 years of hands-on information technology implementation experience.
Have increasing responsibility administering, optimizing, and maintaining Oracle database and PostgreSQL.
Bachelor’s degree in computer science, information systems or equivalent.
Must be able to attain a Public Trust Clearance.
Extensive knowledge of coding languages, including Linux, Java, XML, and SQL.
Understanding of BI and Reporting Platforms along with industry trends and direction in BI/reporting.
Knowledge of current and emerging IT (Information Technology) products, services, and processes.
Knowledge of Source Control and Project Management tools like JIRA.
Experience with Confluence, collaborative workplace with the team to create, edit, and organize information together.
Demonstrated skill of database operations, including backup strategy, data security and cloud platform.
Experience building data warehouse fact and dimension tables, views, materialized views, and bitmap/b-tree indexes.
Solid experience using PL/SQL code to perform ETL for both full loads and incremental loads from an OLTP system to a Dimensional Data Warehouse.
Experience in designing & implementing Logical & Physical Data Model on Oracle/SQL Server & platform for Data Warehouse & Data Marts.
Strong Data Modeling experience using ER diagram, Dimensional data modeling, star schema modeling, and snow-flake modeling.
Experience programming with Oracle PL/SQL, SQL Server, Linux, etc.
Experience designing and developing web applications using Oracle APEX.
Ability to deliver modern elegant web applications using a combination of APEX and JavaScript.
Oracle SQL / Oracle PL/SQL programming experience.
Experience in managing web page layouts with APEX templates and themes.
HTML5 / CSS knowledge.
QA (testing and documentation) experience for PL/SQL development and peer reviews.
Must have AWS Cloud Database Technologies (DynamoDB, AWS CLI, EC2, EBS, S3, Lambda, Aurora, EMR, DMS data migration, Athena, Glue, Kinesis, SQS/SNS, etc.)
Experience with designing, configuring, and managing cloud infrastructure using Amazon Web Services (AWS, including EC2, Elastic Beanstalk, S3, CloudFront, RDS, VPC, CloudWatch, CloudTrail, CloudFormation and IAM).
Strong experience in Automation tools such as Ansible.
Experience with converting PL/SQL ETL to other options available in AWS (GovCloud preferred) such as Glue or equivalent.
Preferred experience for Oracle to Redshift/Aurora conversions where the majority of the conversion is not automatable.
Familiarity with AWS and Azure services for cloud.
Experience in log analysis, database cloud observability/monitoring tools (Splunk, solar winds).
Good knowledge of Python and Big Data technologies.
Experience working within an Agile teaming environment with multiple vendors and stakeholders.
Ability to interact with business users for new project development and enhancements and converting the non-technical into technical.
Experience collaborating effectively with team members and partners in a distributed project environment.
Problem Solving: Ability to analyze and resolve complex infrastructure resource and application deployment issues.
Nice to Have:
USCB experience or working in the federal sector.
Other Jobs from Agile Defense
Journeyman Software Developer
Remote
Washington, D.C.
Network Engineer II
Alexandria, VA
Network Engineer II
Alexandria, VA
Senior Full Stack Engineer
Remote
McLean, VA
Network Engineer III
Alexandria, VA
Similar Jobs
Specialist Big Data Software Engineering
Bengaluru, India
Salesforce Developer
Pune, India
Senior Salesforce Developer
Pune, India
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got about 70,000 jobs from 5,000 vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 5,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. đź“…
What Fellow Engineers Say
