Job Requirements
Beaver Creek, OH
Clearance Unspecified Polygraph not specified
Senior Level Career (10+ yrs experience)
Salary not specified
Join Premium to unlock estimated salaries
Job Description
About Stratias
Stratias is a mission-focused digital transformation firm that helps the Department of Defense modernize critical systems at speed and scale. We specialize in program modernization through application rationalization, code refactoring, cloud migration, data pipelining, and SaaS integration. Our teams combine Agile delivery, DevSecOps practices, and deep mission expertise to drive results for the Air Force and across the defense enterprise.
Why Join Us
At Stratias, you won’t be a small cog in a massive machine—you’ll be a core part of a fast-growing team that’s helping shape the future of defense IT. We hire subject-matter experts who understand both the technology and the mission. You’ll get the freedom to innovate, the support of a collaborative team, and benefits designed for real work-life balance.
Description
Stratias is seeking a Senior Oracle PL/SQL Developer with 10+ years of experience in SQL/PLSQL development, performance tuning and database optimization to build and support scalable, high-performance Oracle database solutions. A Senior PL/SQL Oracle Developer designs, develops, and maintains an Oracle RDBMS back-end servicing an ASP.NET Core Blazor front-end running on Microsoft Azure in a cloud environment.
Responsibilities:
• Design, develop, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, cursors and advanced queries
• Analyze business requirements and translate them into efficient database solutions
• Optimize SQL and PL/SQL code for performance, scalability, and reliability
• Develop and maintain database objects, indexes and views
• Perform query tuning and performance optimization using execution plan/indexing strategies
• Collaborate with application developers, business analysts, and QA teams
• Support data migration, data validation, and database deployment activities
• Troubleshoot and resolve production issues related to database performance and data integrity
• Ensure database code follows best practices, standards and security guidelines
• Create and maintain documentation for database designs and application processes
Work Environment:
Senior Oracle PL/SQL developer will work in a team environment, collaborating with project manager and other system developers to deliver high quality software solutions to the government. May work on various projects at once, contributing to projects that enhance system upgrades, data management and application performance. Developers must work well independently and will utilize a help desk tool for task tracking.
Requirements
• 10+ years of hands-on experience in Oracle PL/SQL development
• Strong expertise in SQL and PL/SQL programming
• Experience in Oracle databases technologies, Oracle 21c preferred
• Strong knowledge of performance tuning, query optimization, and indexing
• Experience with data modeling and database design concepts
• Hands-on experience with packages, procedures, functions, and triggers
• Experience with data migrations, ETL processes, and large data volumes
• Experience with version control software, GIT preferred
• Experience working in Agile and Waterwall environments
• Strong analytical, problem solving, and communication skills
• Bachelor’s degree in computer science or related field, will consider job related experience
• Candidates are required to attend Phone/Video/In-Person interviews and after selection candidate should go through all background checks on education and experience
• Candidate must be eligible for full-time in person work at Wright Patterson Air Force Base
• Candidate must be able to obtain and maintain a DOD security clearance (if required)
• US citizenship is required
Stratias is a mission-focused digital transformation firm that helps the Department of Defense modernize critical systems at speed and scale. We specialize in program modernization through application rationalization, code refactoring, cloud migration, data pipelining, and SaaS integration. Our teams combine Agile delivery, DevSecOps practices, and deep mission expertise to drive results for the Air Force and across the defense enterprise.
Why Join Us
At Stratias, you won’t be a small cog in a massive machine—you’ll be a core part of a fast-growing team that’s helping shape the future of defense IT. We hire subject-matter experts who understand both the technology and the mission. You’ll get the freedom to innovate, the support of a collaborative team, and benefits designed for real work-life balance.
Description
Stratias is seeking a Senior Oracle PL/SQL Developer with 10+ years of experience in SQL/PLSQL development, performance tuning and database optimization to build and support scalable, high-performance Oracle database solutions. A Senior PL/SQL Oracle Developer designs, develops, and maintains an Oracle RDBMS back-end servicing an ASP.NET Core Blazor front-end running on Microsoft Azure in a cloud environment.
Responsibilities:
• Design, develop, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, cursors and advanced queries
• Analyze business requirements and translate them into efficient database solutions
• Optimize SQL and PL/SQL code for performance, scalability, and reliability
• Develop and maintain database objects, indexes and views
• Perform query tuning and performance optimization using execution plan/indexing strategies
• Collaborate with application developers, business analysts, and QA teams
• Support data migration, data validation, and database deployment activities
• Troubleshoot and resolve production issues related to database performance and data integrity
• Ensure database code follows best practices, standards and security guidelines
• Create and maintain documentation for database designs and application processes
Work Environment:
Senior Oracle PL/SQL developer will work in a team environment, collaborating with project manager and other system developers to deliver high quality software solutions to the government. May work on various projects at once, contributing to projects that enhance system upgrades, data management and application performance. Developers must work well independently and will utilize a help desk tool for task tracking.
Requirements
• 10+ years of hands-on experience in Oracle PL/SQL development
• Strong expertise in SQL and PL/SQL programming
• Experience in Oracle databases technologies, Oracle 21c preferred
• Strong knowledge of performance tuning, query optimization, and indexing
• Experience with data modeling and database design concepts
• Hands-on experience with packages, procedures, functions, and triggers
• Experience with data migrations, ETL processes, and large data volumes
• Experience with version control software, GIT preferred
• Experience working in Agile and Waterwall environments
• Strong analytical, problem solving, and communication skills
• Bachelor’s degree in computer science or related field, will consider job related experience
• Candidates are required to attend Phone/Video/In-Person interviews and after selection candidate should go through all background checks on education and experience
• Candidate must be eligible for full-time in person work at Wright Patterson Air Force Base
• Candidate must be able to obtain and maintain a DOD security clearance (if required)
• US citizenship is required
group id: 91170810