Senior Oracle Consultant Job at Acrostaff, Bouckville, NY

ejRaejBoaXFBa1c1Sys3SjZMWmpHeVVYQmc9PQ==
  • Acrostaff
  • Bouckville, NY

Job Description

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.

Job Tags

Work at office

Similar Jobs

Mercor

Content Writer | Up to $50/hr Rate Job at Mercor

 ...Benchmark , General Catalyst , Peter Thiel , Adam D'Angelo , Larry Summers , and Jack Dorsey . Position: Transcribing and Writing Expert Type: Contract Compensation: $50/hour Location: Remote Duration: 36 months Role... 

Scalepex

Healthcare Data Analyst Job at Scalepex

About the Role The Data Analyst plays a key role in monitoring, managing, and improving healthcare data file exchanges across clients, vendors, and internal systems. This role sits within a DataOps team responsible for ensuring data pipelines are accurate, reliable...

Ann Taylor

Junior Web Developer Job at Ann Taylor

 ...role This position is responsible for developing, coding, testing, and execution of new business functionality for talbots.com web site and mobile. It requires being fully...  ...role Knowledge and experience at a level normally acquired through the completion of... 

The CAZA Group

Real Estate Agent - Qualified Appointments for Agents Job at The CAZA Group

 ...At The CAZA Group , we're not just building real estate businesses we're building people. Our mission is to help you become your best...  ...is our foundation. The Opportunity As a CAZA Agent , you are the driver of growth for your clients, your business... 

Elite

A-Level Automotive Technician (Union) Job at Elite

 ...partnering with a high-volume, professionally managed union automotive dealership in Staten Island, NY to hire experienced A-Level Automotive Technicians . This is a full-time,...  ...extensive hands-on experience. This is not an entry-level role. Why This Opportunity Stands...