Database Administrator

Job Description:

• The Key Person will perform data refreshes in development, test, and UAT environments, assist in the deprecation of legacy DB2 databases, and troubleshoot and resolve DB2 job and database issues.
• They will plan and implement DB2 upgrades and patches, support the export and load of production data, and provide support for batch jobs on zOS, including job scheduling, monitoring, and troubleshooting.
• The Key Person will also offer DBA support for applications running on AIX, zOS, and Linux platforms, support Java-based applications using JDBC and SQLJ, and create and manage JCL jobs to automate database and system tasks.
• Additionally, the Key Person will design, create, implement, maintain, tune, and support DB2/UDB databases on AIX and z/OS platforms.
• They will manage tables and indexes, promote changes to various subsystems including production, and provide on-call coverage for OLTP
  applications on the zOS platform.
• The Key Person will develop and maintain UNIX shell scripts to monitor table space usage and buffer pool usage, work with ETL tools to extract DB2 data from zOS to staging tables on distributed platforms and develop ETL routines using DB2 load/unload utilities, DB2 Connect, and other data warehousing tools.
• Finally, the Key Person will provide ongoing technical assistance and education to application developers and business analysts for DB2, COBOL, JCL, and SQL.
• They will conduct performance analysis and identify tuning opportunities to enhance database performance, implement and manage recovery strategies using RMAN, and provide schema development and
  system configuration support for application developers.
• The Key Person will also work with developers to diagnose and resolve database-related application issues, supporting schema maintenance and data distribution.

Required:

• Theories, principles and practices of Information Systems Technology.
• Project administration methods, principles, techniques and practices
• Information systems architecture.
• Methods and procedures for designing, developing, monitoring and maintaining databases.
• Tools for constructing database structures.
• Automation products that support a variety of data management environments.
• Business systems and organizational structures.
• Trends, technological changes and developments in IS.
• Operations and business of the organization.
• Administering and managing comprehensive, multi-system projects including directing and motivating internal staff, contractors and other participants.
• Identifying the scope and complexity of a project and assigning segments of that project to others.
• Assigning and reviewing the work of others to determine accuracy and adequacy of identified conditions, criteria, recommendations and supporting materials.
• Developing long and short-range plans to meet established goals.
• Developing policies and procedures.
• Analyzing organizational needs and implementing cost-effective solutions.
• Determining efficient design of data structures and software applications.
• Assessing new technology developments.