Urgent Position for Mainframe IMS/DB2 Administrator in Torrance, CA. Only US Citizens, GC and EAD/TN are eligible. Interested candidates can send your resume to frank@enablingsi.com or call me at 732-645-7140.

Job Title: Mainframe IMS/DB2 Administrator
Location: Torrance, CA - 90502
Duration: 6 Months Contract
Start: ASAP

MUST HAVE:
· Eight to ten years experience in Mainframe Database Administration
o DB2
o IMS
· Prior experience on projects that requires understanding of a software development life cycle and methodology
· At least four years experience in the design, development and support of both large OLTP and Data Warehousing related databases and applications
· Good Written and Verbal skills
· Works well with teams
· Familiarity with Mainframe tools, programs, utilities as well as DBA tools:
o TSO
o ISPF
o Clist
o DFDSS/ABARS
o Omegamon for DB2/IMS
o Cobol
o CICS
o MQSeries
o Librarian
o Erwin
o DBArtsisan
· UDB on AIX is a plus
· SQL Server is a plus

DUTIES:
The Mainframe DBA’s typical responsibilities include the following:
· Working with developers to implement application/database enhancements
· Consulting/reviewing developers’ SQL or DL/1 code
· DB2 and IMS Performance tuning
· DB2 and IMS Performance monitoring
· Database maintenance – Reorgs, backups, etc.
· Production on-call – The production on-call responsibility is rotated every 2 weeks between the 3 dba’s.
· Their responsibility is to be available to respond to any production DB2 and/or IMS problems.
· This may include assisting application developers to de-bug application programs that have abended in production against either DB2 or IMS databases.
· Creating and populating test environments, DB2 and IMS, in test regions for applications testing.
· DB2 and/or IMS version upgrade testing
· Works closely with Data Architects, ETL team, application development and information delivery teams.
· Suggests and implements departmental standards and procedures for Database administration.
· Work with database vendors and external support on issues such as upgrades, technical problems and solutions
· Develops, tests and implements backup and recovery strategy

Thanks & Regards

Frank Williams
Team Lead
Enabling Solutions, inc.
1501 Sequoia Rd
Naperville, IL 60540
732-645-7140
frank@enablingsi.com
www.enablingsi.com