Senior Oracle Consultant Job at Acrostaff, Bouckville, NY

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

GDIT

Enterprise Storage Engineer Job at GDIT

 ...analysis, and lifecycle management Utilize NetApp ONTAP, SAN/NAS technologies, NFS, CIFS/SMB, iSCSI, Fibre Channel, SnapMirror/SnapVault,...  ...Engineer must have: Education: Bachelor's degree in Information Technology, Computer Science, or related field (or equivalent... 

Gpac

Legal Assistant/Secretary (Hybrid) Job at Gpac

Legal Assistant/Legal Secretary Established law firm is seeking an experienced Legal Assistant/Legal Secretary for their firm! Ideal candidate will have at least 3 years experience in a legal assistant or legal secretary role and be able to work in a fast-paced, professional... 

Kaizen Advance

Non Profit Donation Specialist Job at Kaizen Advance

Still stuck working a schedule that doesnt fit your life This opportunity gives you the ability to work from home choose your hours and build consistent income by supporting major nonprofit fundraising campaigns. We are seeking individuals who are reliable...

SiteWorks Inc

Excavator Operators Job at SiteWorks Inc

 ...offering a Sign on or Relocation Bonus Positions Available Pipe Foreman Project Manager Pipe Layers Laboreres Operators (Excavator, Loader, Dozer) Truck Driver Benefits ~ Industry Leading Pay ~100% Paid Health Insurance ~ Retirement ~ PTO ~... 

SPINUTECH LLC

Senior Director of Paid Media & Social Job at SPINUTECH LLC

 ...We are seeking an experienced Senior Director of Paid Media & Social to join our growing team. In this role, you will oversee the day...  ...campaign strategy integrating paid Search and Social for maximum impact on client goals Drive adoption of AI and automation tools (NinjaCat...