Hi
This is Kiran from Invictus Infotech.
One of my client is looking for DB2DBA. Here is the requirement.
Position : DB2 DBA
Location : Greensboro,GC
Duraiton : 6 months
Job Description:
NATURE and SCOPE/PRINCIPAL ACCOUNTABILITIES. List the major duties,
activities, responsibilities and end results for which this position
exists.
DB2/400 - Oracle Database Analyst
o Design database objects (Logical and Physical) and
processes in IDA
o Creation of any database object in DB2/400 Database
o Help resolve RI conflicts and record deadlock problems
in Oracle and DB2/400
o Execute and monitor data fixes as necessary
o Participate in Business Recovery tests at remote sites
for both iSeries and Oracle platforms.
o Communicate effectively with Project Leaders and team
members in IT&S Department
o Mentoring and Cross Training other DBA team members
o Liaison between external resources and internal
resources for database projects.
o Follow current standard Change Management policies for
the department, as well as standards, policies and procedures that are
specific to the Information Management Team.
o Create and implement database portions of project plans.
o Provide project estimates for DBA skills to project
managers.
o Turnover change management promotion process for all
iSeries objects including IFS objects.
o CVS change management processes relating to IDA.
o Manage security on iSeries and Oracle platforms,
including object security and authorization lists
o Creation of any database object in Oracle Database
o Help resolve communication issues between Oracle and
DB2/400 (Access Manager & Oracle Transparent Gateway)
Oracle and DB2/400 Administration
• Job Duties
o Monitor daily Oracle backups
o Monitor Oracle Table Spaces and Data file status for
space constraints
o Monitor Oracle database performance as needed
o Execute and monitor data fixes as necessary
o Troubleshoot remote database connections (to other
Oracles and to iSeries)
o Recover Oracle database from RMAN/TSM system at DR test
site
o Tuning of queries for better performance on iSeries and
Oracle.
o Coordinate multi-platform promotions.
o Maintain appropriate level of communication with UG’s
vendor of choice for Oracle Support
3. KNOWLEDGE, SKILL, EXPERIENCE and MINIMUM EDUCATION
REQUIRED. State the minimum formal education and years of work
experience required to satisfactorily perform the position’s duties.
Include specific educational requirements and list any positions,
which maylead to this position.
A Senior Database Administrator should have the following skills
• DB2/400 experience (5 or more years)
• Relational Modeling Experience
• Experience with both command line and Ops Navigator
database functionality.
• Exposure to Oracle.
• Experience with system and application monitoring
tools.
• Experience in a software development environment.
• Experience with RPG/CL for the iSeries environments.
• Experience with SQL/DDL and DDS for both iSeries and
Oracle environments.
• Experience and knowledge of Change control systems.
• Familiarity with Web Based Development Technologies and
Web Applications
• Must be willing to work on all platforms and databases
in use at United Guaranty
• Ability to adapt to a rapidly changing environment
• Experience mentoring and cross training
• Working knowledge of the IFS on iSeries and
transferring IFS objects using Turnover.
• Working knowledge of journals on iSeries and how to use
them for audit purposes.
• Time management, planning, and organization skills.
• Excellent oral, written communication skills.
General:
• Any DB2 Universal, AIX experience, IDA and TSM
experience a plus
Additional Pluses:
• Oracle Administration experience
• DB2/400 experience
• DB2 Universal
• TSM experience
• Knowledge of J2EE and Java
Kiran
IT Recruiter
Invictus Infotech
732.218.6589
[email protected]
--
You received this message because you are subscribed to the Google Groups
"KNOW.IT" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/know_it_az?hl=en.
