Job Seekers, Please send resumes to resumes@hireitpeople.com
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 |