Job ID :
3690
Company :
Commonwealth of Pennsylvania
Location :
harrisburg, PA
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
5 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

 

Short Description:

The DBA is responsible for data analysis and database management.  DBAs typically are involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning.

 

Complete Description:

Work will involve DB2 Database Administration Duties on AIX and Windows platforms.

 

            This person will be required to perform the following:

-           Install, configure and tune DB2 databases running on AIX and Windows platforms.

-           Design and develop DB2 database procedures, views, functions, constraints, triggers and scripts.

-           Develop and maintain database backup and recovery systems and procedures for recovery of lost or damaged data.

-           Perform database reorganizations and performance tuning regularly and proactively.

-           Ensure availability and performance of the databases that support the system.

-           Monitor the development and organization of the databases.

-           Analyze and identify problem conditions that could be attributed to database design, structure or software.

-           Provide technical assistance to systems designers and application programmers in the efficient use of databases.

-           Support installation of database releases into production as directed.

-           Perform DBMS version migrations and upgrades

-           Assess and implement new technologies as directed.

-           Execution of all responsibilities with little direct supervision of Team Lead.

-           Research problems before approaching the Team Lead for assistance.

-           Operating System expertise sufficient to perform performance and tuning diagnostics.

-           Generally aware of new developments in industry and process and has ability to apply them to work as appropriate.

-           Troubleshooting and problem solving of DB2 AIX and Windows development.

-           Set up and configure ODBC connections and troubleshoot ODBC issues.

-           Determine time estimates and schedule for own work and resolve issues in a timely manner.

-           Ability to work in a team environment as well as independently.

-           Communicate accurate and useful status updates.

-           Strong communication skills; both written and spoken.

 

In accordance with the terms of Contract No. 4400007198 and the duties of staff augmentation personnel outlined therein, staff augmentation personnel shall provide complete knowledge transfer to the Department of all tasks and projects assigned by the Department. Knowledge transfer includes complete written documentation including systems design, technical design and specifications, and coding to the Department for all tasks and projects to which personnel are assigned.

 

 

Skills:

 

Skill

Required / Desired

Amount

of Experience

 

DB2 DBA Experience (specifically on AIX and Windows platforms) in a 24x7 production environment

Required

2

Years

Experience developing and maintaining database backup and recovery systems and procedures for recovery of lost or damaged data.

Required

2

Years

Performance monitoring and tuning of DB2 specifically on AIX and Windows platforms

Required

2

Years

Extensive knowledge and use of SQL language

Required

2

Years

Shell Scripting for task automation

Required

2

Years

Unix

Required

2

Years

DB2/SQL Programming Experience

Highly desired

1

Years

Data warehouse experience

Highly desired

1

Years

Experience using Sybase IQ

Highly desired

1

Years