Mainframe DB2 Lead
Job Description:
- Control access to tables, plans, and packages
- Tune SQL queries
- Monitor state of the DBMS
- Prepare for upgrades and migration
- Proficiency with logical and physical data modeling design concepts
- Solid performance tuning experience in assisting developers with SQL queries, indexing, stored procedures, triggers and resolving concurrency issues
- Experience with table partitioning and maintaining very large databases
- Creation and maintenance of database objects (tables, columns, indexes, etc)
- Setup and support of database utilities including REORG, RUNSTATS, LOAD, UNLOAD, BIND, and EXPLAIN
- Demonstrated knowledge of third party tools (FileAid, CA, RLX/REXX, etc.)
- Experience with IBM’s Q Replication and WebSphere MQ products (Must)
Minimum Requirements:
- 6+ years DB2 z/OS DBA experience
- Experience handling very large database environment
- Emphasis on DB2 performance tuning techniques
- Troubleshooting techniques and attentive, thoughtful problem diagnosis
- Auditing, Security and SOX compliance and reporting
- Ability to analyze and resolve data issues
- Experience in deploying database changes for new releases with minimal downtime
- Knowledge of z/OS Operating system administration
- Superb and social communication skills to be able to interact with application developers and end-users to understand their requirements
- Experience with DB2 on LUW is a plus
- Demonstrated ability to take on complex systems and database environment issues
- Work experience in a financial institution is preferred
Job Features
Job Category | Mainframe DB2 Lead |
Experience | Entry Level |