Overview

Looking for an Applications Database Administrator for IBM DB2 or i. The duties include plan, coordinate, develop, implement and support database solutions, including database definition, structure, replication strategies, documentation, requirements, guidelines and security. Troubleshoot technical issues related to IBM DB2 for i database development and assist development teams with technical issues and questions.
Responsibilities
Team collaboration with the design, development and deployment of physical database models to IBM DB2 for i
Assist with IBM DB2 for i database modernization, SQL performance monitoring and query optimization
Review SQL statements and refactor statements as required
Proactively monitor IBM DB2 for i health and provide recommendations to improve operational efficiencies
Ownership and remediation of production IBM DB2 for i issues
Ownership and management of DB2 for i technical issues using the IBM Problem Management Report (PMR) process
Create IBM DB2 for i database objects as required
Monitor database journaling and remediate issues
Assist with the design, implementation and enforcement of database access security models
Collaborate with IBM DB2 for i administration team to provide updates to database coding standards, naming standards and best practices to improve and maintain operational consistencies
Collaborate with and mentor other administration team members
Maintain current knowledge of IBM DB2 for i version enhancements and best practices
Problem-solving, organize and prioritize tasks, effective communication and produce required documentation
Rotate weekly on-call responsibilities
Qualifications
Education:
Bachelor s Degree in Computer Science or related field or equivalent education and experience
Experience:
4+ years of IBM DB2 for i experience in an enterprise heterogeneous environment
Experience with IBM DB2 for i tools: Visual explain, Database navigator, Navigator for i
Experience collaborating with and working in a team environment
Experience with Microsoft Office applications: Outlook, Word, Excel and Visio
Good verbal and written communication skills
Preferred:
Experience with Rocket Aldon Lifecycle Manager (IBM i Edition)
Experience with Syncsort MIMIX Availability for IBM i
Experience with IBM i Access Client Solutions
Experience with DB2 Database (LUW)
Experience with Oracle GoldenGate for DB2 for i
Experience with IBM iDoctor tools: Plan Cache Analyzer, Job Watcher and Disk Watcher


More Jobs: