*Please share Your Profiles to [email protected] <[email protected]>Job Title*: *Database Administrator - **ORACLE Database Developer*
*Duration: 12 months * *Work hours per week: 40* *# of openings: 1* *Location: Columbia, SC* *Rate: $60/hr- 65/hr max* *R2R – Required. * *Skills Metrics – Required.** (See end of this page)* Round 1 – Telephone interview conducted by project staff. Round 2 – Used only if necessary. The State may request that this interview is in person. DAILY DUTIES / RESPONSIBILITIES: The MMIS ORACLE PL/SQL developer is responsible for scoping, designing, developing, and maintaining Oracle 12c database objects including package and package bodies, triggers. The candidate will work in a dynamic environment with strong personalities and will need to be just as assertive. Work on this project includes working with a data model that is still changing and will need to work with the data modeler to identify and fill gaps. Duties and Responsibilities include: • Work with a development team composed of non-database developers to provide any needed interface routines. • Support database operations and work closely with application and infrastructure group for MMIS Replacement initiatives. • Provide formal and/or information training in DBMS administration and maintenance, database design, analysis, and management. • Contribute to service design for a service oriented architecture (SOA)-based system • Ensure ORACLE database security, managing access to PII and PHI • Database planning, scaling, and capacity planning activities • Database design, index creation, database optimization, and performance tuning • Design and implement new data models, tables, and schemas to support new functionality as the business demands, and enforce data integrity • Support the database application programming activities of the development group • Work with developers to move test code into production • Develop PL/SQL stored procedures to support applications • Knowledge and experience with database maintenance • Data Warehousing experience (desired, but not required) • Excellent written and oral communications skills with demonstrated commitment to production of high quality documentation • Professional demeanor and strong work ethic • Self-starter personality requiring minimal supervision • Demonstrated commitment to providing excellent customer service REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE): • PL/SQL: Triggers, Packages, Procedures, Functions, anonymous blocks, etc. • IDE’s; SQL Plus, TOAD, SQL Developer • Oracle database 12c • Basic database design, database optimization, and performance tuning. • Linux (RedHat/Oracle) • Experience with software development life-cycles (SDLC). • Written and oral communication skills • Basic database management and administration • Aversion to Cartesian/cross joins and poorly written queries • ORACLE database architecture • Conviction of principles • Communication and feedback PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE): • Data modeling • Experience in a healthcare insurance environment (Medicaid preferred). • Oracle or SQL certification • Experience in the design and application of service-oriented architectures. • Experience with EDI transactions related to the health insurance industry. REQUIRED EDUCATION: Bachelor’s degree in computer science, engineering, or another related field is required. 5+ years of ORACLE Pl/SQL experience 5+ years of experience working with development teams Exposure to ITIL / ITSM / Managed Services / DevOps / SOA operational models *Category * *Name * *Required * *Importance * *Level * *Last Used * *Experience * Database Platforms Demonstrate practical understanding of ORACLE database physical structure, overall architecture, and database performance analysis Yes 1 Database Platforms Oracle 12 Yes 1 Database Platforms Oracle Architecture No 1 Development Tools SQL Plus Yes 1 Miscellaneous Database Administration Yes 1 MMIS - Medicaid Management Information System Healthcare Insurance Operations No 1 MMIS - Medicaid Management Information System Medicaid No 1 Operating Systems/APIs Linux Yes 1 Programming Languages PL/SQL Yes 1 Software Framework Software development life cycle (SDLC) Yes 1 Specialties Data Modeling No 1 *NOTE:* Please be specific about the “skills last used” because just mentioning year 2015 or 2014 is not correct . (I have to manually feed the info in to the client portal as : current or last 6 month or within 1 year etc). Skills Last used: - Currently using - within 6 months - within 1 year - within 2 years - within 5 years & Skills level also not numbers – you have ask the candidate to use the following to rate themselves. Skill Level: - Entry – - Intermediate – - Advanced – - Expert – - Lead *Sincerely,* *Arjun.* *Pace Computer Solutions Inc (An Inc 500 Company)* Direct : 443-539-0949,Ext : 207 [email protected] www.pace-solutionsinc.com -- You received this message because you are subscribed to the Google Groups "Oracle Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oracle-users. For more options, visit https://groups.google.com/d/optout.
