Senior Oracle Consultant Job at Acrostaff, Bouckville, NY

akc4Nnl0bDIrM0U3ekd6WlplMkMrV3hXMWc9PQ==
  • 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

Beyond ABA LLC

Registered Behavior Technician (RBT) Job at Beyond ABA LLC

**Job Title: Registered Behavior Technician (RBT)****Job Overview:** We are seeking a passionate and dedicated Registered Behavior Technician (RBT) to join our team. The ideal candidate will support individuals with behavioral needs, working under the supervision of... 

LayerZero Labs

Site Reliability Engineer Job at LayerZero Labs

 ...Coinbase Ventures, Uniswap Labs, Circle Ventures, Delphi Digital, and many more. ABOUT THE ROLE At LayerZero, our Site Reliability Engineering (SRE) team is at the intersection of software and systems engineering, dedicated to crafting and maintaining large-scale... 

Twincraft Skincare

Accounts Receivable Associate Job at Twincraft Skincare

 ...Twincraft Skincare is growing and we are seeking an Accounts Receivable Associate to join out finance team. This role is responsible for managing & collecting payments from customers. This includes issuing invoices tracking outstanding payments and following up with customers... 

Mayer Brown LLP

Knowledge Lawyer (Real Estate) Job at Mayer Brown LLP

 ...clients as strategic partners with deep commercial instincts and a commitment to...  ...receive the opportunity, support, and development they need to grow, thrive, and realize...  ...Houston office, as a Knowledge Lawyer (Real Estate Group). An experienced lawyer who will... 

L'Occitane En Provence

CRM Intern (Summer 2026) Job at L'Occitane En Provence

 ...will support the operational execution of Email, SMS, and Direct Mail programs for North America. This role is focused on reporting, QA, documentation, and workflow support to ensure CRM campaigns launch accurately and on time. The intern will work closely with channel...