Mainframe Database Administrator – DB2 – PART TIME

Job Description


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**


tPrimary responsibility for maintaining the DB2 in a z/OS 2.4, CICS and JES2 software environment.
tInstall 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.
tImplement and verifies backup and recovery procedures. This would include Business Recovery concerns and associated testing.
tReviews 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.
tCreates, maintains, and upgrades software systems for development and production environments.
tMonitors system software access, performance, and resource utilization.
tProvides 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.
tAct as a liaison between application programmers and vendors to report and resolve software problems.
tWork with application programmers to ensure that application problems do not adversely affect production operations.
tAssists with the analysis, design, programming, and implementation of applications that will interface with system software.
tAnalyzes requirements and recommends policies, procedures, and standards for software systems.
tDevelops and modifies technical documentation to support operations and training.
tPerforms other duties as assigned including special projects.
tDevelop/maintain/monitor proper software use and security authorization policies.
tAbility to provide 24/7/365 software support, including on-call support during off-hours.
tPerform DB2 object maintenance including, database, tablespaces and tables/index creation and maintenance.
tAllocate disk space / dataset proactively.
tMaintain and verify DB2 database related jobs like backups and runstat etc.
tKnowledge in the use of DB2 utilities like REORG RUNSTAT LOAD/UNLOAD etc.
tKnowledge of SMS tablespaces.
tKnowledge of tuning and optimizing of SQLs.
tKnowledge of Database and related objects recovery, in case of a DR.
tKnowledge of resolving different tablespace status including check pending. copy pending and how DB2 object grants work.


t20+ years of experience with mainframe software management specific to DB2 sub-system and associated software products.
tExperience 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.
tActively mentor and guide staff in development of mainframe implementation, testing, and maintaining of DB2 software and related system software skills.
tMonitor DB2 and its components to make recommendations to better utilize resources for optimal performance and cost-effectiveness.
tAbility to install and customize IBM and third-party software using SMP/E & IEBCOPY
tAbility to perform multiple activities simultaneously with minimal supervision.
tPossible travel and variable hours may be required.
tAbility to write/read/debug programs in a batch and online environment.
tAbility to write software exit program(s) and use software utilities as required.
tSolid knowledge of mainframe JCL and utilities.
tAdvanced Knowledge of VSAM file structures, SQL & DB2 Tables.
tExperience using PTX, TSO, ISPF & SDSF
tWorking knowledge of TMON for DB2, Vision Results & Platinum Tool
tExperience writing in Assembler, REXX and CLISTs.
tExperience and understanding of z/OS UNIX environment.
tStrong analytical skills.
tExcellent oral and written communication skills.
tExcellent problem-solving skills.
tAbility to think strategically and act tactically.
tAbility to work in a team environment, share ideas and take direction.


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

EEO EmployerApex 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 [email protected] or 844-463-6178Show full descriptionCollapse