Position Summary:
Responsible for database administration work that includes designing, configuring, and managing databases to ensure the integrity, security and accessibility of the organization's data including:
- Defining standards for physical data storage, maintenance, access, and security administration.
- Performs backup and recovery using Database Management Systems.
- Configures database parameters and defines data repository requirements, data dictionaries, and warehousing requirements.
- Designs and implements approaches to improve database performance, capacity, and scalability.
Knowledge and Job Requirements:
Level I requires:
- Requires a Bachelor of Science in computer science, Information Technology or equivalent occupational/professional qualification.
- Requires 3+ years of experience administering DB2 V11\12 in a z/OS enterprise environment.
- Requires incumbent to be familiar with MS Excel and Access (or similar) for statistical reporting.
- Requires JCL\SQL skills used for database administration.
- Requires knowledge of IBM DB2 Utilities\Compuware File-AID for DB2.
In Addition Level II requires:
- Require 5+ years of experience administering DB2 in an enterprise environment.
- Requires excellent SQL skills with experience in query tuning and index optimization.
- Requires experience with COBOL\VSAM.
- Requires experience with BMC Catalog Manager\Change Manager\Mainview.
- Requires the ability to interpret data/information and provide meaningful presentation of the information.
In Addition Level III requires:
- Master degree preferred, but not required.
- Requires 7+ years of experience administering DB2 in an enterprise environment.
- Requires experience in DB2 system tuning and optimization
- Provides leadership, guidance, training to the team and be a mentor to team members.
#HO
#LI-TH1