Sr Database Administrator

Responsibilities· Debug system software problems and communicate with Tech Support to resolve these problems.· Take lead during incidents and drive incident management effort to restore service and lead postmortem discussions and actions.· Support the career growth of junior members by providing technical guidance & mentoring.· Participate in Production on call support (24×7).· Utilize Agile Framework to manage tasks and your workload· Working knowledge of Datacom/DB architecture.· DataDictionary – Maintain Datacom object definitions includes adding, changing, updating, and retiring objects:§ Database, Areas, Tables, Keys, and Elements.§ DataDictionary maintenance via online (DDOL) and/or batch.§ DataDictionary Utilities, DDBTGLM, DDUPDATE, DDRMFLM, and VLS files.· Working knowledge of change impact and doing impact assessments – steps that must be completed after a changes to the dictionary are made.· Understanding Copybooks and how they can be defined and used in a COBOL environment.· Logging and Recovery, understand the LXX, the active log and the RXX the archive log and how to use them for forward and backward recovery.· Understanding of the Dynamic System tables and how to query them via SQL queries.· DB Utility DBUTLTY used to produce CXX reports, manage backup and recovery, perform 24×7 tools for on-line-area-moves (OAM), online reorgs of data, TM24 to move and reorganize data and remain on-line, TM24 used to add or remove data compressions without taking table offline.· Understanding of Datacom Accounting tables and how to review data to assist programmers with tuning programs or problem solving.· URTs – User Requirements Tables role in batch and on-line access.· Understanding of basic problem solving, evaluating error conditions, and problem resolution· Working knowledge/understanding of new Datacom enhancements for partitioning large tables, converting BDAM datasets to Linear VSAM to improve performance and resource usage, and using online area move to re-allocate datasets without taking them offline.· CICS Service Facility· Basic understanding of module DBCVTPR and its assembly· Monitoring throughput via Sysview – this can be learned.· Reviewing CICS output for problem solving and resolution.· Basic understanding of Inter-Product Components (IPC)· Programmer and Datacom System Support· Ability to review customer requests and/or assistance with problem solving. Review failed job and assist with providing corrective measures.· Ability to assist with tuning application code or assist with reducing run time for long running batch jobs.· Mainframe Knowledge/Skills· Working knowledge of JCL to run batch jobs, allocate and manage Datacom datasets, output files, etc.· Ability to review job output to help resolve error conditions or problems.· Understand DASD management for the Datacom environments.Qualifications· 5+ years in Datacom Technology performing Datacom DBA and/or Database Engineering duties. To include knowledge of Mainframe internals like SMP/E, TSO/E, ISPF/PDF, JCL, z/OS Utilities, etc.· Effective problem determination and resolution skills· Excellent communication (oral and written) skills with the ability to influence· Demonstrated change management skills· Ability to multi-task, work effectively and collaboratively in a team environment, and demonstrated ability to provide quality client support· Experience with Agile Practices and Agile Service Management a plus#zrtech#vipstaffing