Mainframe DB2 Lead

Full Time
Posted 2 years ago

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 CategoryMainframe DB2 Lead
ExperienceEntry Level

Apply Online

A valid email address is required.