Mainframe Database Administrator - DB2 - PART TIME

Job#: 1371440

Job Description:

POSITION SUMMARY:

The Senior Software Engineer / Database Administrator - DB2: is the principal IBM and 3rd party software product architect and an expert technical resource for those software systems. This position incorporates some functions and responsibilities of a Software Architect and Software Specialist. Under general direction, the Senior Software Engineer / Database Administrator will evaluate, design, implement, and maintain IBM software, third party software, management systems, computer applications, operating systems, and direct software services.
**This is a REMOTE, part time postiion working around 25 hours per week**

DUTIES/RESPONSIBILITIES:

• Primary responsibility for maintaining the DB2 in a z/OS 2.4, CICS and JES2 software environment.
• Install and/or participate with software management and installation. This would include installation and maintenance utilizing the IBM SMP/E product. It also includes migration with testing and integration.
• Implement and verifies backup and recovery procedures. This would include Business Recovery concerns and associated testing.
• Reviews new features and other changes related to system software and advises Technical/Development/Operations groups of issues relevant to reporting, programming, and performance, identifying the need for software upgrades and patches, as appropriate.
• Creates, maintains, and upgrades software systems for development and production environments.
• Monitors system software access, performance, and resource utilization.
• Provides technical leadership to developers on the use of software management system, development and integration tools, and deployment strategies, to include application tuning and guidance in effective use of software features.
• Act as a liaison between application programmers and vendors to report and resolve software problems.
• Work with application programmers to ensure that application problems do not adversely affect production operations.
• Assists with the analysis, design, programming, and implementation of applications that will interface with system software.
• Analyzes requirements and recommends policies, procedures, and standards for software systems.
• Develops and modifies technical documentation to support operations and training.
• Performs other duties as assigned including special projects.
• Develop/maintain/monitor proper software use and security authorization policies.
• Ability to provide 24/7/365 software support, including on-call support during off-hours.
• Perform DB2 object maintenance including, database, tablespaces and tables/index creation and maintenance.
• Allocate disk space / dataset proactively.
• Maintain and verify DB2 database related jobs like backups and runstat etc.
• Knowledge in the use of DB2 utilities like REORG RUNSTAT LOAD/UNLOAD etc.
• Knowledge of SMS tablespaces.
• Knowledge of tuning and optimizing of SQLs.
• Knowledge of Database and related objects recovery, in case of a DR.
• Knowledge of resolving different tablespace status including check pending. copy pending and how DB2 object grants work.

MINIMUM QUALIFICATIONS:

• 20+ years of experience with mainframe software management specific to DB2 sub-system and associated software products.
• Experience supporting/leading/training of software management use with little or no direction. This would include all aspects such as logical/physical design, defining, implementing, monitoring, reporting and utilities.
• Actively mentor and guide staff in development of mainframe implementation, testing, and maintaining of DB2 software and related system software skills.
• Monitor DB2 and its components to make recommendations to better utilize resources for optimal performance and cost-effectiveness.
• Ability to install and customize IBM and third-party software using SMP/E & IEBCOPY
• Ability to perform multiple activities simultaneously with minimal supervision.
• Possible travel and variable hours may be required.
• Ability to write/read/debug programs in a batch and online environment.
• Ability to write software exit program(s) and use software utilities as required.
• Solid knowledge of mainframe JCL and utilities.
• Advanced Knowledge of VSAM file structures, SQL & DB2 Tables.
• Experience using PTX, TSO, ISPF & SDSF
• Working knowledge of TMON for DB2, Vision Results & Platinum Tool
• Experience writing in Assembler, REXX and CLISTs.
• Experience and understanding of z/OS UNIX environment.
• Strong analytical skills.
• Excellent oral and written communication skills.
• Excellent problem-solving skills.
• Ability to think strategically and act tactically.
• Ability to work in a team environment, share ideas and take direction.

ADDITIONAL QUALIFICATIONS:

• Working knowledge of z/OS, JES2 & RACF
• Experience with Communications Server, CICS & DR
• Performs regular maintenance and checkups to keep DB2 environment in high performance.
• Have a good working knowledge of DB2 utilities.
• Ability to design and implement DB2 objects in an optimal manner so that they can work with best performance.
• To be able to keep an eye on database object growths and act proactively.
• Ability to optimize and tune SQL queries to assist DB2 developers.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.