What are the responsibilities and job description for the Programmer Analyst 6 - Data Developer position at My3Tech?
About My3Tech:
My3Tech is a CMMI Level 3, ISO 27001:2022, ISO 9001:2015 and SOC 2 Type II certified IT solutions and services firm with 16 years of experience empowering 25 state governments and commercial clients through precision engineering and advanced technology ecosystems. Operating as a direct system integrator and staffing partner, we support mission-critical modernization programs across application development, cloud, cybersecurity, Health, Human Services and Medicaid/MMIS ecosystems. We deploy specialized professionals to seamlessly integrate with client teams, providing the experienced resources needed to drive digital transformation.
Job Title: Programmer Analyst 6 - Data Developer
Location: Lansing, MI
Contract
Responsibilities:
- Design, develop, and maintain database objects (tables, views, indexes, triggers, and 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, and 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.