Associate Senior Mainframe Database Administrator

Job Description

Description

Minimum Qualifications:

• Bachelor's Degree
• Relevant Experience or Degree
• Typically Minimum 4 years Relevant Mainframe Experience
• Installation, customization, testing and maintenance of database systems within a production environment

Preferred Qualifications:

• Bachelor's Degree in IT related field
• IT related field-mainframe experience

Essential:

• Performs testing of database software, Db2 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 tested/approved 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 and/or other database configurations. Coaches/mentors less experienced Database Administrators (DBAs) as they begin to perform routine/basic database administration tasks
• Schedules database back-up tasks and ensure proper completion of scheduled tasks. Execute database recovery task during a disaster recovery and/or disaster recovery exercise
• Monitors current usage levels of database storage to identify and report growth trends and assist in the forecasting of future storage requirements. Assists with the development of long-term capacity plans
• Performs routine maintenance such as data compression and defragmentation (online reorg)
• Ensures the high availability of the supported database(s) by actively monitoring database performance to identify bottlenecks, such as inefficient queries, inconsistent and/or corrupt indexes, database design, and provides 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 DB2 Disaster Recovery, DB2 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 DBAs regarding company policies and procedures, techniques and current server/database configurations