Senior Mainframe Server Administrator (Database Administrator) in San Jose, CA (Remote)

  • San Jose, CA
  • Posted 60+ days ago | Updated 13 days ago


On Site
Full Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 1 year


IT management
Software deployment
Systems analysis/design
Software development
Technical writing
Software Support
Backup administration
Software management
Physical data model
IBM mainframe utility programs
Platinum DB2 for z/OS
Assembly language
Analytical skill
Problem solving
Job Entry Subsystem 2/3

Job Details

Position: Senior Mainframe Server Administrator (Database Administrator)
Location: San Jose, CA (Remote)
Its a part-time role with 20 hrs/week
Job Description:

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.
Required Skills & Abilities:
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 Tools
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.