DB2 Admin
RJT Compuquest Inc - Raleigh, NC

This job posting is no longer available on RJT Compuquest Inc. Find similar jobs: DB2 Admin jobs - RJT Compuquest jobs

DB2 Administrator

Subject matter expertise in DB2 Linux Unix Windows with great communication skills to assist a team of IT Professionals to implement solutions and support a SAP ERP solution project.

Job Duties:

- Implement DB2 version 9.7 – 10.1

- Work on DB2 & SAP

- Work on database projects.

- Work on automation and scripting

- Work on improving database performance by implementing advance infrastructure level tuning.

- Coordinate resources to implement DB2 environment improvements

- Coordinate resources to implement DB2/SAP patching as necessary

- Meet with internal developers and project office personnel to ensure we have the necessary infrastructure in place to support upcoming projects and application development efforts

- Provide third level support for DB2 LUW and application issues

Primary Duties

- Design fault tolerant DB2 environments for SAP Financials.

- Design and implement automation using scripts, must be proficient in scripting

- Design and implement replication and backups for mission critical/tier 1 databases

- Recommend and implement in depth tuning for infrastructure and applications

- Review databases and determine compliance with IBM best practices

- Review existing DB infrastructure and determine areas of improvement

- Implement software lifecycle method to ensure we are always running a supported release

- Responsible for all aspects of database configuration, maintenance, backup, tuning, patching and restoration.

- Review IBM fix list to determine when its necessary to apply patches

- Coordinate patch implementation and post patch testing/validation

- Design a robust monitoring and event notification system utilizing existing monitoring software

- Consults with Systems Development, DBA Staff and Technical Support on technical problems, methods, directions and data access methods like SQL, Stored Procedures, Triggers and User Defined Functions.

- Directs and participates with team members in the analysis, development and delivery of all support and project work for assigned function(s). Provides mentoring, knowledge, skills transfer and training to staff. Performs resource planning, deployment, tracking and reporting for all assigned team members.

- Consults with the DBA staff and Technical Support groups in the tuning and upgrading of database management system software.

- Confers with and advises others in the use and applicability of database systems and supporting products.

- Creates database schemas and sub-schemas to support the logical database model. Develops, monitors, and maintains backup and recovery for all assigned databases.

- Provides requirement analysis and evaluations for proposed data management software products and solutions. Develops or directs the development of utilities used for the monitoring, tuning and analysis of database systems. Stays current on data management technologies and directions.

- Projects long-range requirements for database administration and design in conjunction with other managers in the information systems function.

- Consults with application programmers, technical staff and end users in troubleshooting and improving application response time and availability. Performs database performance monitoring and analysis and proactively implements needed adjustments.

Skills Required

8+years Database administration experience, preferably in a large IT organization

- DB2 database certifications.

- SAP on DB2 certification is a major plus

- 2 – 6 years Database administration experience using SAP.

- Understanding of SAP Architecture.

- Understanding of Open SQL for ABAP, SAP Security for databases and SAP dictionaries.

- Understanding and use of the SAP DBA Cockpit.

- Problem determination and solving skills. Understanding of how to take DB2 traces, db2pd, explain tools, etc

- Familiarity with the SAP tools that perform database maintenance.

- Working knowledge of Java – Ability to troubleshoot Java application issues

- Scripting experience highly preferred.

- Understanding of SAP DB2 UDF maintenance.

RJT Compuquest Inc - 13 months ago - save job - block
Recommended Jobs
SAS Administrator
Piper Enterprise Solutions - Raleigh, NC
Piper Enterprise Solutions - 30+ days ago

CICS Admin
Apex Systems Inc - Durham, NC
Apex Systems Inc - 16 days ago
Easily apply

Valleysoft Inc - Raleigh, NC
Valleysoft Inc - 30+ days ago