Job Listing: DB2 DBA

TEKsystems is looking for an DB2 DBA for an opportunity in Indianapolis, IN.


Candidate will:

- Plans, manages, organizes, and controls all operations and activities of agency database projects;
- Ensures that supported databases have well documented maintenance plans and recovery procedures and that qualified staff are available to maintain current database systems;
- Evaluates and selects infrastructure components;
- Consults with agency users on functional aspects of requirements, schedules, and implementation strategy.
- Determines staffing needs and arranges for manpower assignments to meet schedule requirements;
- Creates and maintains a team atmosphere and work environment to promote project work productivity;
- Ensures concurrence with organization’s standards and procedures including system development methodology, design and programming standards, reporting standards, work standards;
- Reviews and approves database project documentation, measures progress against project schedule and budget, takes corrective action and resolves issues as appropriate;
- Prepares database project activity and status reports regarding the database management section and advises higher level management of problem areas requiring their action;
- Regularly meets with agency management to discuss project status, prioritization of changes and/or enhancements, and project concerns;
- SQL File-tuning of development application code.
- Perform binds and access-path checking of SQL changes in application code.
- Help Development and Maintenance team with SQL standards and efficiencies in application code.
- Capacity planning and reporting including periodic space requirements and growth trending.
- Ad-hoc reporting requests from Management, Development and Maintenance team members.
- Perform OS upgrading including installation and testing. Job Requirements.
- Broad knowledge of cost project management, benefit analysis, risk analysis, risk determination, budgeting, funding, and estimation resources;
- Broad knowledge in the technology of both the DBMS and the operating system chosen for the data warehouse or data mart;
- Broad knowledge in software and utilities related to supported DBMS such as Reorg, Backup, Recovery, Load, Unload;
- Broad knowledge of capacity planning and disaster recovery;
- Broad knowledge of relational database and/or data warehouse design techniques and dimensional modeling processes;
- Broad knowledge of computer hardware/software capabilities and configurations;
- Basic knowledge of computer programming, including computer languages and testing of programs;
- Broad knowledge of data communications, including networking, Mainframe Connectivity, and Communications Server;
- Broad knowledge of the most recent technical developments in the database administration field;
- Ability to perform logic analysis;
- Ability to apply theories, principles and methodologies to existing computer software;
- Ability to communicate effectively orally and in writing;
- Working knowledge of database systems development, information technology, computer terminology, systems analysis and design, programming, and tools and approaches to systems analysis and design;
- Thorough knowledge of database project management theories and practices.
- Knowledge and experience of ASG-TMON.

Required Skills for DB2 DBA Job:

About TEKsystems:

Join TEKsystems® and get your career on the fast track. As the leading technology staffing and services firm, we are passionate about deploying high-caliber IT and communications expertise. To satisfy our constant need for expertise, we actively seek talented Technical Professionals with all levels of information technology and communications skills. TEKsystems knows that every professional has different needs, so we'll work together to determine a suitable benefits package. We offer options to our Technical Professionals that could include: a health plan, 401k, provisions for vacation and holiday pay, and technical and professional training. With a foundation as the nation's largest IT staffing firm, we've become a billion-dollar services company by blending superior client service with an unrivaled ability to source and manage talent to precise specifications, resulting in successful technology executions. Allegis Group and its subsidiaries are equal opportunity employers. M/F/D/V