Job Title

Summary of This RolePlans computerized mainframe Db2 for zos databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection. Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries. Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system. What Part Will You Play?Performs testing of database software, utilities and fixes within a test (sandbox) environment prior to production roll out. Identifies and resolves issues while in the sandbox environment. Performs the migration of testedapproved software, utilities, and fixes to the production environment. Develops basic to moderately complex database configurations by creating database objects per specified business requirements and the necessary sandbox environments for testing. Works in close liaison with application developers to ensure best practices are applied to mitigate potential impacts to the various user groups andor other database configurations. Coachesmentors less experienced Database Administrators (DBAs) as they begin to perform routinebasic database administration tasks.Schedules database back-up tasks and ensures proper completion of scheduled tasks. Execute database recovery tasks during a disaster recovery andor disaster recovery exercise.Ensure the high availability of the supported database(s) by actively monitoring database performance to identify bottlenecks, such as inefficient queries, inconsistent andor corrupt indexes, database design, and provide recommendations for corrective actions. Applies routine database tuning and optimization techniques, such as rebuilding indexes, to maintain database performance. Perform database statistic reporting on a regularly scheduled basis.Works closely with the Applications Team while performing troubleshooting to determine the source of application failures. Assists in the development of solutions to minimize the potential of future application failures. Supports the implementation of solutions.Produces and maintains operational database documentation, such as Disaster Recovery, Recovery Presentation, Naming Standards, Performance and Tuning, to ensure database configurations are well documented in preparation for disaster recovery.Assists in the training and familiarization of less experienced team members regarding company policies and procedures, techniques and current serverdatabase configurationsWhat Are We Looking For in This Role?Minimum QualificationsBachelor's DegreeRelevant Experience or Degree in: No degree specifiedTypically Minimum 8 Years Relevant Exp in Db2 for zosInstallation, customization, testing, and maintenance of database systems within a production environmentPreferred QualificationsBachelor's DegreeIT related field