Offer summary

Qualifications:

7+ years of experience in Oracle SQL and PL/SQL, including advanced concepts like bulk collect and JSON/XML handling., Expertise in writing and optimizing complex Oracle queries to enhance database performance., Experience in documentation and unit testing within an Agile development environment., Proficient in manipulating and querying JSON data in Oracle database tables..

Key responsabilities:

Perform advanced analysis and development to support and enhance database performance for a large education data project.

Devise solutions to complex problems and provide thought leadership on database optimization.

Ensure accuracy and efficacy of reports created for multiple agency stakeholders.

Follow a defined software development life cycle (SDLC) process using an Agile-like approach for code changes.

Job description

MKS2 Technologies, LLC, an award-winning high growth small business, creates innovative and customer-centric technology solutions in the areas of Cyber Security, Instructional Design and Training, Software Engineering and IT Support Services to improve the security and well-being of our clients. Our commitment to excellence and our “Mission First” orientation has resulted in steady growth and an expanding client base across government agencies. We have employees nationwide and for the past three consecutive years were named one of the fastest growing Veteran-owned companies in the nation. Please take a moment to browse through our website and learn more about what it means to serve with MKS2.

Title: Software Developer - Sr. Database Developer (Education)

Location: Remote within TX, USA

Pay: $140,000 - negotiable based on qualifications.

Expected start date: 4/16/2025.

Duration: Ongoing yearly contracts through a minimum of 8/2028

Hours: 8AM - 5PM

US Citizenship Required.

The Senior Database Developer will perform advanced analysis and development work involving all aspects of supporting, improving, and enhancing and optimizing the database performance for a large project. This position requires strong Oracle SQL and PL/SQL experience, along with extensive experience in performance tuning of stored procs and views. The developer will also devise approaches to solving complex problems, provide thought leadership, and provide ongoing updates on project status. This position works for section of a statewide education data system. Work assignments follow a defined software development life cycle (SDLC) process using an Agile-like approach for completing code changes for defined releases. This role works across multiple agency stakeholders to ensure the accuracy and efficacy of created reports, in the service of school districts.

REQUIRED QUALIFICATIONS

7+ years of experience:

Expertise working with Oracle SQL and PL/SQL (advanced concepts such as bulk collect, handling data in JSON/XML format)
Expertise with writing complex Oracle queries and optimizing them to reduce SGA/PGA/TempSpace usage
Documentation
Dev/Unit Testing
Participate in Agile development

4+ years of experience:

Proficient in storing, querying, manipulating JSON data in Oracle database tables
Proficient in creating complex queries and views using data stored in JSON format
Proficient in optimizing performance of stored procs and views accessing data stored in JSON format

Diversity creates a healthier atmosphere: MKS2 Technologies is proud to be an Equal Employment Opportunity / Affirmative Action employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

Required profile