- 175652 - DB2 Database Administrator - AL
- Up to $64.94 DOE
- 6 months
The qualified applicant will collaborate with Northrop Grumman's onsite database administration support and services delivery team for our State of Alabama Location Enforcement Collection System (ALECS) where Together Everyone Achieves More (TEAM). The ALECS system is the federally certified system used by the Alabama Department of Human Resources (DHR) to locate absent parents, establish paternity/support, collect and disburse child support payments, enforce child support agreements, and review case situations.
Roles and Responsibilities:
o The ability to work on a diverse team or with a diverse range of people as one of three onsite DB2 z/OS application DBAs for the customer.
o Demonstrate proficiency with the DB2 Relational Database Management System (RDBMS).
o Prepare for, participate in and provide a DB2 and application performance and tuning perspective from initial development design through implementation.
o Use your experience with DB2 to address and resolve problems.
o Tune the SQL statements in application programs for assigned projects from initial design, development through production.
o Logical & physical database design for projects.
o Database maintenance, on-call rotation, problem determination and resolution, database security. Candidate will be part of a 24 hour on call support team and will need to work off hours on some weekends and holidays.
o Evaluate new products and tools, test and implement new or upgraded software.
o Collaborate on annual ALECS Disaster Recovery exercises.
o Design, implement and support database and application backup and recovery solutions using IBM and BMC tools.
o Upgrade and maintain DB2 and related 3rd party software at or above release levels of N-1.
o Adhere to all contract SLAs.
Bachelor Degree in Engineering, Computer Science, Science, Business Administration, Mathematics or related field with 6 years of relevant experience or 10 years of experience to satisfy the degree and experience requirement.
6 years of IT Mainframe experience.
5 years of DB2 zOS mainframe DBA experience.
3 years of COBOL/DB2 mainframe application software development database administration support.
Experience with DB2 Connect.
BMC third party software experience (Catalog, Change, DASD, and Recovery Manager, Load, Unload, Copy, Recover, SQL Explorer, Apptune, Logmaster).
Ability to troubleshoot mainframe and distributed processing problems in a DB2 Connect Enterprise server environment.
Ability to directly interfacing with clients from end users to project management, sensitive to clients' needs, able to develop warm client relationships.
Ability to travel to annual off site disaster recovery exercise.
1 year experience with Power designer or other logical modeling tool.
1 year experience with DB2 COBOL Stored Procedures.
1 year State government customer DBA project experience.
1 year Customer site DBA delivery experience.
1 year 24 x 7 x 365 DBA on call support delivery.
1 year SQL Server DBA experience.
1 year with SQL Server Business Intelligence Development Studio (BIDS) or other ETL tool.
Bachelor Degree in Engineering, Computer Science, Science, Business Administration, Mathematics or related field OR 10 years of experience to satisfy the degree and experience requirement.
Employment will be contingent on clearing a drug screen and background check. Both must clear prior to start date.
420 Culver Boulevard
Playa Del Rey, CA 90293
Phone: (310) 414-7800 x256 or (800) 927-9318 x256
Candidates responding to this posting must currently possess the eligibility to work in the United States. No third parties please.
Employment will be contingent on candidate clearing pre-employment drug screen and background check.
Chipton-Ross provides equal employment opportunities to all employees and applicants for employment without regard to race, color, creed, religion, national origin, sex (including pregnancy), age, disability, sexual orientation, gender identity and/or expression, protected veteran status, genetic information, or any other characteristic protected by Federal, State or local law. This policy governs all areas of employment at Chipton-Ross, including recruiting, hiring, training, assignment, promotions, compensation, benefits, discipline, and terminations.