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.
Typical Deliverables:
" 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.