DB2/WebSphere Database Administrator-1 Position, Chicago, IL

Job Title: DB2/WebSphere Database Administrator-1 Position

Location: Chicago, IL 

Duration: 1-3 years

Job Description:

A Database Administrator (DBA) is responsible for the documentation, design, implementation, and maintenance of the databases underlying the IBIS system. The DBA will support multiple instances of the IBIS database in several environments that are used throughout the application development and deployment lifecycle. In addition to the usual DBA skills, such as object design and creation, back-up and recovery, and bufferpool tuning, the DBA should be very familiar with database tools and utilities, physical data modeling, and SQL optimization and performance. Work with internal and external customers to analyze and determine information needs and elements; data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities. Proven ability to take project requirements and the logical data model and create the following: A physical data model optimized for DB2/zOS and Websphere environment A document representing details how the implementation will conform to required agency standards In response to changes to the IBIS application the DBA will collaborate with the IBIS development team and be responsible for detailed DB design, implementation, testing, and deployment ensuring the technical integrity of the project. Provide SQL performance tuning on both OLTP and Data warehouse environments. Optimize DB2 Specialist utilization by tuning queries (static and dynamic), recommending indexes, and configuring database parameters. Engage in data mining activities needed to support management requests for information, assist in analysis of application errors, and define and execute queries needed to repair data in support of problem resolution. Provide trend analysis to management team to enable them to make informed decisions regarding Specialist management.  Responsibilities will span all aspects of DB design, maintenance, performance optimization, monitoring, and operational support. This includes DB disaster recovery and development of backup and archiving solutions. Provide on-call rotational 24/7 Incident Response to database alerts from production monitoring tools and Command Center personnel.

MANDATORY REQUIREMENTS:

Requires a Bachelor’s Degree with course work in computer science or directly related technical fields.  Please provide the relevant information below that fulfills this requirement.  Please provide information about any specialized training or certificates received in relation to this requirement. Requires at least six years of professional DB2 zOS database experience and production support in MVS z/OS environment within the last 9 years.  Please provide the job title and the description of the job duties or practical example during which the candidate utilized this skill to substantiate candidate claims of requisite knowledge/experience and technical expertise.  Please provide name of company or companies, title(s) of candidate, period(s) of employment, and roles and responsibilities. Please provide information about any specialized training or certificates received in relation to this requirement. Technical expertise in MVS-2 – z/OS.  Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill. Technical expertise in DB2 Version 8 and above.  Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill detailed knowledge of logical and physical DB design, performance-monitoring and tuning, definition of alert thresholds.  Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill. Detailed knowledge of stored procedures (COBOL and NATIVE), triggers and UDFs, RMF, and use of SMF data.  Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill.

PREFERRED  REQUIREMENTS:

Strong experience with DB2 Utilities, SPUFI, QMF, OSC, BMC-DB2Mon, PowerDesigner, and WebSphere.  Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill. Experience with J2EE environments and UDB on LUW. 
Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill. Previous experience with IDES/Agency Systems, methodologies.   Please provide all job title(s) for work performed within the last 9 years in which the candidate utilized this skill.

We have a very good relationship with the Hiring Manager and for the right candidate we can arrange an interview within a few days.

Look forward to connecting with you.

Thanks & Regards

Aravind

COMPQSOFT, Inc.

HUB Zone, SDB, MBE Certified

An ISO 9001:2008 & ISO 27001:2005 Certified

Phone: 281-978-4434  І  Fax: 281-657-6717

Email: aravind.k@compqsoft.com