UBD DB2 DBA

E*Pro Inc; Phoenix (AZ); On-site; USD 80,000 - 100,000; Full time

Job summary

A renowned IT consulting firm is seeking an experienced Database Administrator to provide design and support services for DB2 UDB Data Warehouse environments. Responsibilities include implementing backup procedures, monitoring database performance, and providing 24x7 on-call support. The ideal candidate has over 5 years of experience and strong SQL tuning skills. Excellent communication is essential for collaboration with application teams. This position is based in Phoenix, Arizona.

Qualifications

• 5+ years of experience as a database administrator with DB2 UDB.
• Experience in a 24x7 support environment is essential.
• Excellent oral and written communication skills.

Responsibilities

• Provide DBA design and support for DB2 UDB environments.
• Implement backup and recovery procedures for database systems.
• Monitor and ensure performance and uptime of production databases.
• Provide after-hours on-call support for critical issues.

Skills

DB2 UDB Data Warehouse

Database administration

SQL statement tuning

AIX operating environment

Monitoring scripts

Excellent communication skills

Job description

E*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website www.epro-tech.com

We have been retained for providing recruiting assistance, for direct hires, by one of the world-leading information technology consulting, services, and business process outsourcing organization that envisioned and pioneered the adoption of the flexible global business practices that today enable companies to operate more efficiently and produce more value.

Job Description

Required Skills:

• 5 years of experience (minimum) as a database administrator with DB2 UDB Data Warehouse Enterprise Edition within an AIX operating environment.
• Provide primary DBA design and support services for establishing, upgrading and maintaining the DB2 UDB Data Warehouse environments.
• Implement backup and recovery procedures for DB2 UDB Data Warehouse databases and test regularly in conjunction with Operations.
• Create, maintain and refresh required DB2 UDB Data Warehouse instances/databases for development, test and production environments.
• As required, help resolve application problems. Act as liaison between application programmers to assist with resolving problems.
• Monitor security breaches, error log(s), database and log space, user activity and resource utilization of production environment. Work with application programmers to insure that application problems do not adversely affect production operations.
• Monitor system resources of database servers to assure production systems meet performance & availability requirements and hardware enhancements are scheduled in a timely fashion.
• Provide after hours on-call support for deployments and critical database issues.
• Provide expert assistance in database and SQL statement tuning to improve performance. This includes, but is not limited to, re-writing SQL statements, creating new indexes and altering existing indexes.
• Following standards, write, maintain and document monitoring scripts needed in support of applications.
• Monitor disk usage; plan acquisition and replacement of disk devices as needed.
• Act as project liaison and coordinate with AIX system administrators for application of OS patches and maintenance required for database servers.
• Provide DB2 UDB database administration on servers for mission critical applications.
• Development, maintenance and documentation of procedures and standards for effective database software use.
• Analysis and management of DB2 UDB Data Warehouse problems/defects with IBM and installation of patches.
• Use of software and locally developed tools to monitor DB2 UDB Data Warehouse databases.
• Communicate and collaborate effectively with staff of varying technical expertise.
• Excellent oral and written communication skills.
• Experience supporting 24x7 environments.

Additional Information

All your information will be kept confidential according to EEO guidelines.