27 days old

Senior DBA / DB2 for zOS

Lincoln, NE 68508
  • Job Code
At FNBO, our employees are the heart of our story--and we're committed to their success! Please see below the details of this career opportunity and how it fits into our organization's success.

The Senior Engineer for DB2 on z/OS provides technical leadership, software support and database system guidance in support of the mainframe operating system environment. This role maintains and evolves the current and future state business capabilities with the focus on growth, efficiency, and predictability. You will design, migrate, and engineer DB2 and z/OS solutions in line with customer and FNTS strategies and initiatives. You will work collaboratively across FNTS to ensure an agile, cohesive delivery model.

Key Responsibilities:

  • Provide proactive management of all mainframe database systems and infrastructure including DB2 performance monitoring and tuning.
  • Perform mainframe database software upgrades coupled with administration and tuning in support of our customer's DB2 environments.
  • Implement assigned system software to include new releases, corrective fixes, vendor maintenance and customization.
  • Work with vendors and customers to achieve timely implementation and/or resolution of database initiatives.
  • Builds plan to integrate software changes to maintain the highest level of availability coordinating with Operations and the Change Management groups.
  • Perform research into new functions available from latest software identifying opportunities to improve our environment.
  • Responsible for day-to-day database maintenance, creating backups, performing restores, monitoring file extent growth, creating and maintaining DR procedures and overall support of customer needs and requests.
  • Perform various database optimizations including performance and efficiency analysis of the database configuration and periodic review of database performance.
  • Develop standard work and process documentation to enable Network Operations Center to monitor and perform routine tasks.
  • Provide on call and support for reported problems.
  • Must be able to multi-task and work under short deadlines and high-pressure situations.
  • Fulfill customer request for mainframe z/OS customers in a timely manner as they pertain to DB2.
  • Provide key support for customer migration services as they pertain to DB2 and related OEM software products.
  • Assist the project manager in the migration of newly acquired customers.
  • In joint cooperation with the Disaster Recovery Services, successfully execute tasks associated with any given customer's disaster recovery plans.

Required Technical Skills:

  • Bachelor's degree required and/or equivalent work experience.
  • 10+ years of professional experience in DB2 for administration and systems programming support.
  • Documented Systems Programming experience supporting LPAR configurations, buffer pool tuning, applying maintenance through SMP/E, and have successfully migrated DB2 subsystems to a higher Version in a Data Sharing environment.
  • Understand how DB2, CICS, IMS and z/OS interact, and how DB2 supports a WebSphere application environment.
  • Knowledge of z/OS Connect and other Query products
  • DB2 DDF Support for Remote Connections supporting dynamic SQL
  • Knowledge of TLS 1.2 and use of Secured Ports in DB2 is needed.
  • Assist with Database Design and Data Modeling Design
  • Workload Manager Configuration and DB2 Stored Procedures
  • Demonstrate outstanding problem determination and resolution skills working independently from any vendor as needed.
  • CA and IBM tools for DB2 and other third-party vendor products a plus.
  • Extensive experience with the following:
    • Knowledge in best practices of software management, maintenance and documentation.
    • Configure and manage DB2 in a parallel sysplex environment.
    • Develop innovation, strategies, processes and best practices in software management.
    • Establishing policies and procedures pertaining to database management, DR, security, maintenance and utilization.
    • Reviewing new versions of DB2 for functionality, advising how they benefit the client.
    • Evaluating change requests and determine impact to assigned clients.
    • Supporting DB2 security requests.
    • Review DB2 security to find potential risks.
    • Vendor consultation for problems and questions.
    • Space calculations for new objects and environments.
    • Reviewing, tuning of internal DB2 buffer pools and SQL code.
    • DR recovery support.
    • Troubleshooting and solving production database issues.
    • Demonstrated ability to respond quickly and effectively to support requests from multiple clients

Preferred Skills :

  • System programming knowledge of multiple DBMS
  • System programming knowledge of DB2 for z/OS & z/VM
  • Experience integrating DB2 with distributed DBMS
  • Knowledge of Informatica and the Power Exchange listener
  • Supporting multiple customer for after hours on-call.
  • Self-motivated and able to work independently.
  • Excellent communication skills (written, verbal and presentations.)

All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status.

Click here to download 'EEO is The Law' Self-Print Poster

Click here to download 'EEO is The Law' Supplement for Federal Contractors

Click here to download 'EEO is The Law' GINA Supplement

Posted: 2020-10-04 Expires: 2020-11-02
Sponsored by:
ADP Logo
Sponsored by:
Bank of America Logo

Featured Jobs[ View All ]

Featured Employers

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Senior DBA / DB2 for zOS

Lincoln, NE 68508

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast