Hi, Hope you are doing great, This is Syed Layeeq from New York Technology Partners. We have a requirement for *PL/ SQL Developer at St Paul, MN.* Please review the Job description below and if you’d like to pursue this, please include a word copy of your latest resume along with a daytime phone number and rate in your response. You can also reach me at (201) 680-0200 x 7027.
*Send profiles to s...@nytpartners.com <s...@nytpartners.com>* *Job Title: PL/ SQL Developer - 8+ years* *Location: St Paul, MN* *Business Need* Two (2) Procedural Language/Structural Query Language (PL/SQL) Developers-Programmers with experience in large and complex systems development projects. The PL/SQL Developers will provide technical support. This includes changes required due to modifications or newly introduced code from adjoining systems such as Cúram, Connecture, EngagePoint product suite and other work. The PL/SQL Developers must be able to provide diagnostic analysis as issues are reported. *Project Deliverables * - The PL/SQL Developers-Programmers, in collaboration with other stakeholders, will: - Review functional requirements. - Validate or revise initial schema design holding approximately 100 fields of insurance plan enrollment data in 10-15 normalized table structures for approximately 3,000,000 member/records. - Design PL/SQL solutions to implement a data cleansing/reconciliation process, which will: - Identify matches, prospective matches, etc., - Remove duplicates, - Report non-matched/problem cases for evaluation, - Support re-incorporation of externally modified/marked up data. - Prepare solutions to load “final/cleansed” data into the primary set of tables. - Implement PL/SQL solutions to support/replace/update processes on the enrollment tables. - Implement PL/SQL solutions to support efficient common queries of enrollment data. - Implement PL/SQL solutions to support regular exports of selected enrollment data for use in downstream systems (reporting, etc.). - Write PL/SQL code and documentation to support the “reconcile” functionality. - Write PL/SQL code and documentation to support updated logic and related functionality. - Document and unit test all code. - Provide Knowledge Transfer on solution implemented *Project Environment * - The PL/SQL Developers/Programmers will need to collaborate with a variety of individuals both on the project team and individuals outside the project team that may have a vested interest and can offer information pertaining to the project, including: - Other Developers/Programmers; - Project Managers; - Business Analysts; - Database Administrators; - Information Technology Group; - System Architects; - All members of the QA staff (Managers, Supervisors, Leads, other QA Analyst); - Business staff; - employees; - External vendors; - Stakeholder community including the counties and health care provider organizations; and - Other team members. *Project Requirements* Resource must be able to work independently, with little or no supervision. Resource must be able to drive to resolution in situations with high ambiguity and confusion. *Successful Responders will be expected to: * - Provide development of and production maintenance support, in support of the IT solution. - Assist in development of and direct strategies, approaches, and procedures for the IT Solution. - Communicate and incorporate business owner’s visions, business plans, and key objectives. - Provide updates as required for leadership. - Foster a culture that supports and drives staff engagement and collaboration in support of objectives. - Establish, manage, and leverage business and technology relationships both internal and external to the IT Solution. - Transfer knowledge to staff. *Mandatory qualifications * - At a minimum, a proposed resource must meet the following mandatory qualifications. Resource submissions that do not clearly demonstrate that these mandatory qualifications are met will not be considered under this RFO. - B.S. or B.A. degree (4 year) OR - Associate’s degree (2 year) with 5 years’ experience in PL/SQL Programming/Development. - A minimum of five (5) years of experience in designing, developing, and testing applications utilizing PL/SQL or Oracle (10g, 11g, or 12g). - 2 years’ experience incorporating WCAG 2.0 into projects. *Desired Skills * - In addition to the Mandatory Qualifications, the proposed resource(s) will be evaluated on the following Desired Skills. - Computer Science or Information Technology degree - Experience in all aspects of the Software Development Life Cycle (SDLC) - Hands on experience working on health insurance programs which may be at the business or technical level - Experience in PL/SQL related to enrollment systems - Experience working with the following: - Data Architecture, Data Analysis, Data Modeling - Enterprise Data Warehousing - Oracle Database Administration - Account Creation, password reset - Role management - Oracle Audit Vault - Oracle Data Vault - Oracle Database Firewall - Advanced SQL and Oracle PL/SQL Development and experience with functions, procedures, packages and triggers, such as: - Oracle Job Scheduler - Oracle performance tuning, including: - Query tuning - Index tuning - Partitioning - Experience with Oracle Fine Grain Access Control (FGAC) development, configuration, and troubleshooting, which includes the following: - Forensic data analysis/troubleshooting - Oracle 11g - Hadoop - Subversion - Toad - JIRA - Confluence - Experience utilizing migration and version control systems. - Experience with secure coding principals such as OWASP Top 10, SANS Top 25. - Experience with IRS Pub 1075 and NIST 800-53 rev4. Thanks and Regards, Syed Layeeq New York Technology Partners – Rochester 332 Jefferson Rd. Rochester, NY 14623 T1: (201) 680-0200 x 7027 Fax: (201) 474-8533 s...@nytpartners.com www.nytp.com Yahoo&Gtalk: Syedstaffing -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at https://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
