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
