Senior Database Developer - 26-10519

Senior Database Developer

Title/Level: Developer/Programmer Analyst 3
Category: Applications / Software Development

Duration - 12 Months

Location - Austin, TX

Position Overview

We are seeking a highly experienced Senior Database Developer to perform advanced database development and programming work. The successful candidate will independently handle complex programming assignments, evaluate development efforts against system requirements, and contribute to the design, enhancement, and maintenance of enterprise applications.

The role requires strong expertise in Oracle SQL/PLSQL, SQL Server, Jasper Reports, ETL, data integration, and JSON-based data processing, along with the ability to troubleshoot issues involving Java and .NET application code.

The Senior Database Developer will work closely with development, project management, and business teams to deliver high-quality applications and data solutions following an established Software Development Life Cycle (SDLC) and Agile development practices.

Key Responsibilities

• Architect, design, develop, enhance, and maintain database-driven applications.
• Develop advanced solutions using Oracle SQL and PL/SQL.
• Write complex, optimized SQL queries, stored procedures, functions, packages, and views.
• Optimize database queries and stored procedures to improve resource utilization and performance.
• Work extensively with relational databases, including Oracle, SQL Server, and MySQL.
• Design and implement ETL processes, data integration, data transformation, and data mapping solutions.
• Work with structured and JSON-based data stored within relational databases.
• Develop complex queries and views using JSON data.
• Store, query, manipulate, and transform JSON data within Oracle database tables.
• Optimize stored procedures and views that access JSON-based data.
• Develop and maintain Jasper Reports and related reporting solutions.
• Troubleshoot database, application, integration, and data-processing issues.
• Collaborate with Java and .NET development teams to identify and resolve application-related database issues.
• Perform development and unit testing of database and application components.
• Prepare and maintain technical documentation.
• Participate in Agile development activities, sprint planning, code reviews, testing, and releases.
• Follow established SDLC processes and development standards.
• Collaborate with multiple stakeholders to ensure data accuracy, reliability, and effectiveness of reporting and data processes.

Required Qualifications

• 8+ years of strong experience with Oracle SQL and PL/SQL, including advanced concepts such as bulk collection and JSON data handling.
• 8+ years of experience writing complex and optimized Oracle queries with a focus on reducing SGA, PGA, and temporary-space utilization.
• 8+ years of experience working with SQL Server.
• 8+ years of experience with development/unit testing and technical documentation.
• 8+ years of experience working in Agile development environments.
• 4+ years of experience storing, querying, and manipulating JSON data within Oracle database tables.
• 4+ years of experience creating complex queries and views using JSON-based data.
• 4+ years of experience optimizing stored procedures and views that access JSON data.
• Strong experience with relational database development and performance tuning.
• Experience with ETL tools, data integration, and data mapping.
• Strong troubleshooting and analytical skills.
• Ability to work independently on complex technical assignments.

Preferred Qualifications

• 5+ years of experience with JIRA and Bitbucket.
• 2+ years of experience with Nomad.
• 2+ years of experience with student data systems or similar large-scale education data platforms.
• Experience with Jasper Reports.
• Experience troubleshooting Java and .NET application integrations.
• Experience working in large enterprise or public-sector environments.

Technical Skills

• Oracle Database
• Oracle SQL
• Oracle PL/SQL
• SQL Server
• MySQL
• JSON Data Processing
• Stored Procedures
• Functions & Packages
• Database Views
• Query Optimization
• Performance Tuning
• SGA / PGA / Temp Space Optimization
• ETL & Data Integration
• Data Mapping
• Jasper Reports
• Java / .NET Troubleshooting
• Development & Unit Testing
• Agile / SDLC
• JIRA
• Bitbucket
• Nomad

Core Competencies

• Advanced Database Development
• SQL/PLSQL Programming
• Database Performance Optimization
• Data Integration & ETL
• JSON Data Architecture
• Reporting & Analytics
• Application Troubleshooting
• Technical Documentation
• Agile Software Development
• Cross-Functional Collaboration
• Complex Problem Solving