Senior Oracle Consultant

Position Title: Senior Software Engineer – Oracle/COBOL/.NETLocation: Albany, NY (Onsite/Hybrid as required by the State)Client: State of New York – Office of Information Technology Services (ITS)Project: WRTS Performance & Enhancement Phase 2 (PRJ00013132)Duration: 1+year Project Overview:The ITS Human Services Cluster is undertaking a major infrastructure upgrade of the WRTS System, focusing on both hardware and software modernization. This includes installing new servers, upgrading database and application software, and implementing multiple instances of the WRTS database across distributed environments. The position involves active participation in system design, development, and enhancements using Oracle, COBOL, .NET, and Microsoft technologies.Responsibilities:Lead and support Oracle 11g (or higher) database administration including performance tuning, storage management, table/index design, and user managementDevelop, optimize, and maintain PL/SQL code: functions, stored procedures, triggers, sequences, and packagesInstall, configure, and maintain Micro Focus COBOL Runtime environments in both production and development settingsPerform .NET development (C#/CLS languages) using Visual Studio for WRTS-related applicationsDesign and implement Microsoft SQL Server (T-SQL/SSIS) solutions, including stored procedures, DDL/DML, and integration servicesProvide unit and integration testing, documentation, and implementation of structured programming solutionsMentor junior developers and provide technical guidance within a collaborative team environmentParticipate in project coordination meetings, requirement analysis, and provide system and application design documentationMinimum Qualifications (Mandatory):Candidates must meet all of the following requirements to be considered:84+ months (7+ years) working directly with Oracle 11g or higher in an enterprise environment, including partitioned tables, indexes, and synonyms84+ months PL/SQL development experience (Functions, Stored Procedures, Sequences, Table Design, and Tuning)84+ months of hands-on experience installing and maintaining Micro Focus COBOL Runtime environments84+ months Oracle DBA experience (Performance tuning, Storage, Table design, User Administration)84+ months in C#/CLS development using Visual Studio84+ months working with Microsoft T-SQL and SSIS, including development of stored procedures, functions, DDL/DML scripting. Preferred Skills:Experience with large-scale government projectsStrong understanding of structured software development life cyclesExcellent communication and documentation skillsPrior experience mentoring or guiding other developers in a matrixed teamExperience working with multiple database instances across multiple servers. Additional Information:This position supports the WRTS modernization effort – a critical system for the Human Services ClusterWork may involve collaboration with multiple state agencies and vendorsCandidates may be required to attend onsite meetings and interviews at the client's discretionLet me know if you’d like this converted into a PDF or tailored for submission to a specific state vendor portal.