SQL Queries Advanced Replication Technologies Oracle SQL Tuning Tuning Pack Diagno   Requirement id 61416 Job title Developer Job location in Sacramento, CA Skills required AVSRE Database Developers, Oracle 11g, PL/SQL, SQL Queries Advanced Replication Technol Open Date 31-May-2017 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: AVSRE Database Developers, Oracle 11g, PL/SQL, SQL Queries Advanced Replication Technol Submission Deadline : 6/6/2017 5:00 p.m Client : California Public Employees Retirement System (CalPERS) Description : The California Public Employees Retirement System (CalPERS) Enterprise Solutions Development Division (ESDD) has requested assistance from Contractor to provide database development service to all the applications supported by Enterprise Solutions Development Division (ESDD). As a member of the Application Engineering & Architecture (AEA) unit, the consultant(s) will undertake duties and responsibilities as a database developer on the AVSRE project and work on highly complex data transformation and conversion scripts The work primarily involves the understanding the current and future data models and providing solutions that are technically feasible, aligned with existing CalPERS enterprise architecture and meets the needs of the business users. Additional duties and responsibilities include, but are not limited to: performing analytical work; defining technical requirements; creating or updating existing technical design artifacts for online, batch, report and interface processes, business rules, forms; analyzing data and providing SQL data fixes and database structure changes, and participate in implementation and release communication activities. Consultant responsibilities also include ensuring that all work performed under this agreement will comply with CalPERS Information Technology Services Branch (ITSB) policies, standards, procedures, and guidelines. Consultant support activities include providing solutions to the business problems, application architecture, application development, implementation, and post-implementation release support; triaging complex technical and infrastructure issues, providing automation assembly, system, End-to-End, and CAT testing support. Consultant is to submit to the contract manager a written monthly status report as part of this agreement and provide knowledge transfer to staff before end of contract. MINIMUM QUALIFICATIONS Refer to RFP 2014-7354, Section IV, Vertical 5.0 for minimum qualifications required for this engagement. Database Developer: Functions at the expert level in creation of Oracle SQL packages , procedures and functions. • Must have five (5) years of experience as working Oracle database version 11g or above. • Must have five (5) years of experience creating parallel PL/SQL procedures, packages and functions • Must have five (5) years of experience writing complex SQL queries on very large database 5TB above • Must have five (5) years of experience creating replication/materialized views that can handle 500M rows • Must have five (5) years of in tuning SQL queries using Tuning Pack, Diagnostics Pack and/or Automatic Workload Repository (AWR) • Must have five (5) years of experience creating database triggers • Must have five (5) years of experience in designing a database from a logical data model • Experience leading projects with multiple resource groups • Strong analytical skills for evaluating business needs and developing innovative solutions • Ability to work independently and as part of a team • Ability to work effectively with all levels of technical staff and management DESIRED QUALIFICATIONS • Oracle Certified professional 11g or above • Experience working with public pension systems and Actuarial Systems. • Experience with Programs functions and processes similar to CalPERS • Strong leadership skills with ability to multi-task, to use tact and to employ good judgment   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 61416 while calling.   Other jobs in CA: Anaheim (4), Brea (3), Brisbane (2), Carlsbad (3), Concord (1), Culver City (1), Cupertino (5), Downtown Los Angeles (3), El Monte (3), El Segundo (1), Foothill Ranch (2), Irvine (1), La Jolla (2), Lake Forest (1), Larkspur Landing (1), Long Island (1), Los Angeles (27), Newport (1), Newport Beach (3), Orange (2), Orange County (7), Pasadena (1), Poway (5), Rancho Cordova (1), Redwood City (3), Sacrament (1), Sacramento (19), San Diego (87), San Francisco (24), San Jose (4), Simi Valley (1), South San Francisco (1), Westlake Village (2),         (Developer: AVSRE Database Developers, Oracle 11g, PL/SQL, SQL Queries Advanced Replication Technol in Sacramento, CA)

Featured Jobs ASP.Net Government Developer (Jobs in Madison, Wisconsin) Manual Consultant (Jobs in Columbus, Ohio) IT Specialist (Jobs in Columbus, Ohio) Batch CMDB Management System Administrator (Jobs in Glen Allen, Virginia) - Architect (Jobs in Richmond, Virginia) - Analyst (Jobs in Denver, Colorado) PMP Manager (Jobs in Atlanta, Georgia) Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Javascript Developer (Jobs in Tucker, Georgia)