Dear Partners, Please send the matching profiles to ah...@radiansolutions.com or reach me at 724-599-1698
Title : Senior DB2/DATA Analyst Location: Sacramento ca Duration: 9 months State Govt project The Senior DB2/DATA Analyst will provide senior level AIX database administration and application programming will: • Perform database administration for DB2 UDB on AIX. This includes assisting in configuring, troubleshooting, performance monitoring, account administration, log reviews, and archiving • Support the administration of Business Objects Universes on AIX. This includes configuring, troubleshooting, performance monitoring, account administration, log reviews, and archiving • Support developers and users in designing, creating, and publishing reports with Business Objects • Analyze information needs, extract appropriate source data, transform extracted data to meet business needs, and load into reporting database • Perform programming, analysis, and testing functions for the WIC ExtraNet and ISIS • Participate in an established change management process that includes: documenting requirements; developing software solutions; testing (unit, system, and integration testing); and implementation Minimum Qualifications 1. Possess IBM Certified Specialist – DB2 User certification. (Pass/Fail) (1 pt) 2. Two years experience as a database administrator with at least 60% of time each year dedicated to supporting DB2 UDB on AIX databases. This includes AIX system administration, configuring, troubleshooting, performance monitoring, account administration, log reviews, and archiving. All two years of experience must include support of a database similar in size to the ISIS AIX reporting database. 2 Years (Pass/Fail) (1 pt) // 3 Years (3 pts) // 4 Years (5 pts) 3. Two years experience in a database support or programming position with at least 20% of time each year dedicated to developing reports in an OLAP environment. 2 Years (Pass/Fail) (1 pt) // 3 Years (2 pts) // 4 Years (3 pts) 4. Two years experience in a database support position with at least 20% of time each year dedicated to performing ETL (extract, transform and load) process using SQL, COBOL, and JCL. 2 Years (Pass/Fail) (1 pt) // 3 Years (2 pts) // 4 Years (3 pts) 5. Two years experience programming using DB2 and SQL in a SDLC environment with at least 25% of time each year dedicated to coding. 2 Years (Pass/Fail) (1 pt) // 3 Years (2pts) // 4 Years (3 pts) 6. Two years experience programming using JCL and COBOL in a CICS environment with at least 25% of time each year dedicated to coding. 2 Years (Pass/Fail) (1 pt) // 3 Years (2pts) // 4 Years (3 pts) 7. Two years experience developing database or software solutions using an established change management process that included change request analysis, documenting requirements, developing database or software solutions, testing (unit, system, and integration testing), and implementation. 2 Years (Pass/Fail) (1 pt) // 3 Years (2pts) // 4 Years (3 pts) 8. Two years experience performing in a lead position with at least 5% of time each year dedicated to mentoring/training staff on AIX database operations and support. 2 Years (Pass/Fail) (1 pt) // 3 Years (2pts) // 4 Years (3 pts) Total Minimum Qualifications points available for this position: Minimum points to pass: 8 Maximum points available: 24 Desired Qualification 1. One year experience working with or as a part of a project or program associated with the federal program having gained knowledge specific to state and federal policies and procedures such as: client categories, program qualifications, food prescriptions, and vendor authorization. 1 Year (1 pt) 2. One year experience in a database support position with at least 25% of time dedicated to designing, creating, and publishing Business Objects reports. 1 Year (1 pt) 3. One year experience programming using VISGEN in a SDLC environment with at least 40% of time dedicated to coding. 1 Year (1 pt) 4. Possess IBM Certified Solutions Expert DB2 UDB certification. (1 pt) 5. Prior familiarity and experience with State of California IT projects and knowledge State policies and procedures (1 pt) Total Desirable Qualification points: 5 *Ahmed Ali * Recruitment Executive Radian Solutions Inc. ah...@radiansolutions.com 724-599-1698 www.radiansolutions.com To unsubscribe from this group, send email to tek-professionals+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.