Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

SQL Developer (Sybase - Oracle Conversion)

Expired Job

Voca Frederick , MD 21701

Posted 3 months ago

Voca Technology has immediate openings available for SQL Developers on a Sybase to Oracle Conversion working out of your choice of Charlotte, NC or Frederick, MD.
Voca connects professionals in Technology with fantastic companies nationwide. Our goal is full partnership with our employees, providing the tools, guidance, and opportunities to help reach their individual goals. Voca provides benefits including insurance, 401k, and dedicated support. We look forward to hearing from you.
Position Details
Notes from the Team:
The project is currently underway, with 6,500 stored Sybase T-SQL procs to be converted to Oracle PL/SQL procs by the end of 2019.

The retirement system is a complex suite of applications comprised of 24 databases, 3,000 database tables and 6,500 stored procedures all hosted in Sybase ASE 16. We are migrating to ORACLE 12c on EXADATA.

We have over 40 TB of data and performance can be an issue. The ideal candidate will be able to quickly be able to analyze and understand the existing Sybase stored procedures and data models for the various subject matter areas. This is not just a simple translation, but a complex transformation taking Sybase code and creating optimal Oracle code.

Oracles SQL Developer tool is not capable of correctly translating the code nor is it capable of creating optimal code. The ideal developer will understand code patterns, be able to identify those patterns in our code and translate them to efficient ORACLE code that meets all SLAs.

Job Description:
Convert existing Sybase T-SQL stored procedures and queries to ORACLE PL/SQL. The PL/SQL code will attempt to eliminate the temporary tables used by Sybase. All Oracle PL/SQL code must be performance tuned and optimized. The developer will assist in creating technical documentation, test and use cases, and creating a jUnit harness used to test stored procedures. The stored procedure test cases must include injectable data that allows the test case to be rerun even if it includes temporal data. All test cases must be automated.
Qualifications
5-7 years working with T-SQL
5-7 years working the PL/SQL
3-5 years tuning PL/SQL with knowledge at the expert level
Basic understanding of Oracle EBR is required.
Ability to read, analyze, interpret business requirements and prepare technical documents
Strong written and verbal communication skills
Ability to work independently with minimal supervisor and assistance.
Qualifications
Knowledge of big data a plus.
Retirement domain expertise is a plus (e.g. practical knowledge of how a retirement plan/401k/etc. works)
Voca: The Spirit of Work
IND-RS



See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Software Engineer/Applications Developer

Caci International Inc.

Posted 1 week ago

VIEW JOBS 12/4/2018 12:00:00 AM 2019-03-04T00:00 Software Engineer/Applications Developer Req #: 214486 Location: Frederick, MD US Job Category: Engineering Security Clearance: Secret Clearance Status: Must Be Current Job Description What You'll Get to Do: CACI has an immediate need for a Software Engineer/Applications Developer to collaborate with the technology development team to assess new products/solutions that will enhance program of record capabilities / systems. The Software Engineer will also collaborate with the technology development team to design, develop and test new products/solutions that will enhance program of record capabilities/systems. More About the Role: * Collaborate with the technology development team on the level of effort required for solutions, to include planning, test readiness levels, and project scheduling * Lead small projects, providing direction, training, and guidance to other team members as needed; contributing to assurance of security and accuracy of solutions provided by the team, while operating according to project schedules, with ability to work on multiple tasks. * Provide expertise in assessing and /or developing new technologies that are in line with current capability gaps * Provide expertise on technology, standards, and medical IT industry trends * Develop documentation for new technology insertion * Provide support to management in areas of technical expertise and information gathering You'll Bring these Qualifications: * 7 plus years of General IT / Software development experience * Bachelor's degree from an accredited college or university in Computer Science or Engineering * 8570.01 Compliance: Security+, Windows 10 CE * Active Secret Security Clearance * Software Development Life Cycle (SDLC) * Desktop application development * Windows 10 * C# (Visual Studio .NET / Team Foundation Server (TFS) * Windows Presentation Foundation (WPF) * JSON, XML, SQL / SQLLite, Web Services, SignalR, Entity Framework, AES Encryption * Programming Languages: C#, JSON, ASP.NET * Applications, Databases, and Tools: Visual Studio, Team Foundation Server (TFS), Android SDK, SQLite, CCL, FHIRS * Interfaces: XML, XAML, HTML, SGML, HL7 * Other: DHA electronic health record, MHS Genesis, CERNER electronic health record, EHR terminology, EHR standards, DoD encryption standards, Cyber Security requirements, Eclipse, Git, SVN, CVS, Android SDK, Entity Framework, Illustrator, Photoshop, Oracle These Qualifications Would be Nice to Have: * Medical Systems Architecture * Network Architecture and Engineering * Citrix * Hyper-V * Virtualization * Windows Server 2012 * Orion Rhapsody * MIRTH * Oracle database * Health Level 7 (HL7) * Risk Management Framework (RMF) What We Can Offer You: * We've been named a Best Place to Work by the Washington Post. * Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. * We offer competitive benefits and learning and development opportunities. * We are mission-oriented and ever vigilant in aligning our solutions with the nation's highest priorities. * For over 55 years, the principles of CACI's unique, character-based culture have been the driving force behind our success. Job Location US-Frederick-MD-FT. DETRICK CACI employs a diverse range of talent to create an environment that fuels innovation and fosters continuous improvement and success. At CACI, you will have the opportunity to make an immediate impact by providing information solutions and services in support of national security missions and government transformation for Intelligence, Defense, and Federal Civilian customers. CACI is proud to provide dynamic careers for employees worldwide. CACI is an Equal Opportunity Employer - Females/Minorities/Protected Veterans/Individuals with Disabilities. Caci International Inc. Frederick MD

SQL Developer (Sybase - Oracle Conversion)

Expired Job

Voca