Database Administrator at Accenture

Job Description

Responsibilities:

• As a Database Administrator, you will be responsible for administering, optimizing, monitoring, and finetuning databases on DB2 for z/OS mainframe.
• You will perform various related database functions across multiple teams or clients, including designing, implementing, and maintaining new databases, backup/recovery, and configuration management.
• Additionally, you will install database management systems (DBMS) and provide input for the modification of procedures and documentation used for problem resolution and day-to-day maintenance.
• You will also engage with multiple teams and contribute to key decisions. Furthermore, you will provide solutions to problems for your immediate team and across multiple teams.
• Master proficiency in IBM DB2 Database Administration is required.
• Advanced proficiency in IBM z/OS, Database Optimization & Tuning, and Database Performance Management, as well as intermediate proficiency in IBM Db2 Query
• Management Facility (QMF) and Job Control Language (JCL), are recommended.
• Develop and implement innovative strategies for optimizing database performance and tuning.
• Conduct regular database performance monitoring and analysis to identify areas for improvement.
• Collaborate with cross-functional teams to design and implement database solutions that meet business requirements.
• Stay up-to-date with the latest trends and advancements in database administration to ensure best practices are followed.
• Provide technical guidance and support to team members on database-related issues.
• 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.
• Assist with Release Management functionality
• 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.
• 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.

Qualification

Job Qualifications

Required:

• z/OS DB2 DBA Certification
• Minimum 3 years' experience as DB2 DBA in an IBM® z/OS environment
• Working knowledge of Mainframe (MVS), DB2 for z/OS, WINDOWS Operating systems, SQL, CICS and JCL.
• Batch operations and MVS architectures

Preferred Skills:

• DB2 v11 or v12 or v13 in a z/OS environment Certification
• Understanding of a database management tools e.g. Performance monitor, schedulers, e.g.
• CONTROL-M/R/O/T
• DB2 Query Monitor for zOS
• DB2 SQL Performance Analyser
• OPTIM query Workload Tuner
• DB2 Administrator Tool for zOS
• DB2 for zOS
• DB2 Log Analysis Tool for zOS
• QMF for Workstation
• QMF for zOS
• CICS DBUG Tool
• TMON
• IDZ
• SQL and/or Rexx coding to automate routing tasks.