Job Description
Interview Process: There may be two rounds of interviews. Interviews will be held in person. Candidates MUST be available for an in-person interview.
Hybrid Work Schedule: Resource will be working a hybrid schedule. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. Tuesdays and Wednesdays are required onsite days.
Local candidates vs non-local: Local candidates (strongly preferred) or non-local (must be willing to relocate at their own expense from acceptance with no delays & follow the hybrid schedule).
Key Responsibilities
- Design, develop, and maintain database objects (tables, views, indexes, triggers, constraints) to support application and integration requirements.
- Develop and optimize PL/SQL packages, procedures, and functions to support business logic, data services, and ETL processes.
- Support data design and modeling activities, including logical and physical data models and normalization.
- Lead and execute data migration and data conversion tasks for new implementations, upgrades, and system integrations.
- Develop and consume web services (SOAP/REST) used in data integrations between internal systems and vendor‑hosted COTS solutions.
- Analyze data and metadata to ensure accuracy, integrity, and compliance with agency standards.
- Work closely with Data Architects and DBAs on performance tuning, code reviews, and database best practices.
- Troubleshoot data issues, identify root causes, and implement corrective solutions.
- Participate in planning, estimation, documentation, and technical design sessions for both new projects and ongoing maintenance efforts.
Required Skills and Experience
- Oracle PL/SQL development (packages, procedures, functions) 8+ years
- Use of Oracle development tools such as Toad or SQL Developer 8+ years
- Designing, creating, and maintaining Oracle database objects 8+ years
- Logical and physical data modeling; database normalization 8+ years
- Data analysis, data quality, and metadata management 8+ years
- Developing and integrating web services (SOAP and/or REST) 8+ years
- Database programming for data migration and data conversion 8+ years
- Experience supporting or integrating vendor‑hosted or COTS systems.