OVERALL, PURPOSE OF JOB:
• Perform Database Administration functions with administrator rights
• Performs Release Management and Version Control function
• Support both the BAS production environment users and the development environment on DB2 for z/OS, MVS and CICS. Provide reports and recommendations to supervisor and management, on system performance and improvements.
• Provide guidance to developers on sql coding. Report risks and Database unavailability to Supervising DBA.
MAIN RESPONSIBILITIES/TASKS:
Day-to-Day Activities:
• Authorization of TSO user-ids and granting of the relevant privileges to specific tables within certain production departments’ databases.
• Monitoring of production reports to ensure that all scheduled reports not exceed the agreed execution time and to improve the throughput of reports on the BAS system.
• To provide support to end users of the MVS environment.
• Working effectively as part of the team and seek to support team’s goals.
• Identifying problems and bringing them to supervisor’s attention with sufficient lead in time to avert crises.
• DB2 performance and tuning suggestions
• Release Management functionality
Administration Responsibilities:
• Database Quality Assurance and reviews of all SQL Code for programs destined for release to production.
• Periodically perform standby duty – Respond to any DB2/CICS/VSAM problems experienced by production departments, as well as the maintenance team members.
• Extents setup and analysis of DB2 tables and VSAM files in Production and the continuous monitoring and rectification thereof.
• Monitoring and suggest possible optimization ideas of online transactions.
• Continuous improvement of any procedures used within platform support and operations support.
• Creation and setup of new DB2/CICS/VSAM objects whether a new department is implementing the BAS system.
• Monitoring of VSAM splits and scheduling of VSAM and database reorganizations whenever the need arises.
• Setup and perform database refreshes from production database tables to non-production databases.
• Creation of new database tables, table spaces and indexes as well as altering the structure of existing database tables as agreed with senior DBA.
• Perform release management and version control tasks when required.
• Peer review other team members procedural documents.
Supervision Responsibilities:
• Able to Supervise small DBA team if required
• Complete weekly status feedback and reporting
• Assist team members in DBA/Release Management task
• Attend client meetings and workshops representing the project
PART 2: JOB REQUIREMENTS
KNOWLEDGE AND SKILLS:
Required:
• Minimum 3 years’ experience as DB2 DBA or Senior Operator in a z/OS environment
• Working knowledge of Mainframe (MVS), DB2 for z/OS, WINDOWS Operating systems, SQL, CICS, REXX and JCL.
• Batch operations and MVS architectures
Preferred Skills:
• DB2 V12 or higher in a z/OS environment
• Understanding of a database management tools e.g. Performance monitor, schedulars, e.g.
o CONTROL-M/R/O/T
o DB2 Query Monitor for zOS
o DB2 SQL Performance Analyser
o OPTIM query Workload Tuner
o DB2 Administrator Tool for zOS
o DB2 for zOS
o DB2 Log Analysis Tool for zOS
o QMF for Workstation
o QMF for zOS
o CICS DBUG Tool
o TMON
o DB2 Data studio
o DB2 Omegamon
o DB2 IDZ and IDAA
• SQL and/or Rexx coding to automate routing tasks.
• A DBA with experience in Oracle is an advantage.
EDUCATION, QUALIFICATIONS, EXPERIENCE NECESSARY:
• Minimum 3 years’ tertiary qualification in information technology.
• Database planning and design (logical and physical), tuning, maintenance and recovery.
• Ability to support application development teams in database design and alterations as well as general database and system related issues and questions as well as work with system administrator in dealing with database related system issues.
as per spec
About Accenture
Accenture is a leading global professional services company that helps the world’s leading businesses, governments and other organizations build their digital core, optimize their operations, accelerate revenue growth and enhance citizen services—creating tangible value at speed and scale. We are a talent- and innovation-led company with approximately 791,000 people serving clients in more than 120 countries. Technology is at the core of change today, and we are one of the world’s leaders in helping drive that change, with strong ecosystem relationships. We combine our strength in technology and leadership in cloud, data and AI with unmatched industry experience, functional expertise and global delivery capability. Our broad range of services, solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Song, together with our culture of shared success and commitment to creating 360° value, enable us to help our clients reinvent and build trusted, lasting relationships. We measure our success by the 360° value we create for our clients, each other, our shareholders, partners and communities.
Visit us at www.accenture.com
Equal Employment Opportunity Statement
We believe that no one should be discriminated against because of their differences. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, sexual orientation, gender identity or expression, marital status, citizenship status or any other basis as protected by applicable law. Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities.