The Database Architect will determine database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
Support and enhance IDMS/ADS & COBOL based applications. This includes Billing which incorporates multi-system data feeds to bill a variety of payors including Medicare, & Medicaid for services rendered as well as human resource applications.
location: Albany, New York
job type: Contract
salary: $45 - 50 per hour
work hours: 8am to 6pm
responsibilities: Daily Tasks will include but are not limited to the following: 1. Execute full software development life cycle (SDLC). 2. Check daily maintenance for IDMS. Resolve and notify responsible persons of problems from IDMS nightly maintenance jobs, IDMS aborts, Initial Program Loads, and Applications Development (APPDEV) program runs. 3. Resolve ITSM Service Now calls directed to Data Administration for IDMS. Complete HELPDESK IDMS printer requests for end users. 4. Monitor IDMS application database areas growth. Enlarge areas when they are over 75% full. Work with APPDEV staff to purge and archive data as needed. Schedule data archive jobs with Production Control Unit. 5. Provide support to IDMS APPDEV staff. Complete special requests as needed. 6. Co-ordinate and implement IDMS database changes with APPDEV staff when necessary. 7. Maintain/Support IDMS security. Process security requests for access (RFAs) to complete IDMS users security update. 8. Use IBM COBOL, JCL, CA-IDMS, CA-ADS to develop/maintain batch/online applications in an IBM z/OS environment. Perform analysis, design, coding, and testing of changes based on State/Federal mandates or requests from the OMH State Operations Finance Group. 8. Support billing of Medicare, Medicaid, Third Party Health Insurance (TPHI), & individuals (private parties). Monitor batch production jobs, analyze results, and address any aborts/system failures as needed. Diagnose and debug production issues reported via ITSM. 9. Work with members of the Billing unit, DBA unit, and the office for Information Technology Services to migrate batch and online application changes to the QA and Production platforms following standard migration procedures. 10. Work with Business Solutions and technical support staff to identify changes that are needed and the solution for implementing them. 11. Mentor and assist other programmers and architects, both state and consultant, providing guidance for debugging, troubleshooting, securing and deploying applications, data access, data communications and system architecture configurations. 12. Report status of current tasks and outstanding issues to supervisor and other management as requested.
- Experience level: Experienced
- Minimum 7 years of experience
- Education: Bachelors
- SQL Database developer (7 years of experience is preferred)
- SQL Server developer (7 years of experience is preferred)
- SQL Server (7 years of experience is preferred)
- IDMS (7 years of experience is preferred)
- Software Architecture
- Database Administration
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.