Database Administrator I

United States Steel Corporation Pittsburgh , PA 15201

Posted 4 months ago

Job Description:

U. S. Steel is seeking at Senior DB2 DBA at our Business Service Center located in the Southside, Pittsburgh, PA. This position will perform daily database administration against DB2 databases, including software installations and patching, backup and recovery, database refreshes, database maintenance tasks and problem resolution.

The position will require occasional on call (telephone/web) 24X7 production support. This position also allows for flexible scheduling and/or some remote work.

Major Responsibilities:

  • Database Administration support for DB2 for z/OS, v11 or later.

  • Overall maintenance, administration, monitoring, problem resolution for DB2 databases

  • Database data refreshes

  • Backup & Recovery

  • Support of high availability databases

  • Database performance and tuning

  • SQL query optimization and tuning

  • Documentation development and maintenance

  • Database and data security / RACF

  • Production support 24x7, with an on-call rotation

Minimum Requirements:

  • 5+ experience as a DB2 Database Administrator

  • Strong understanding of IBM z/OS Mainframe Technologies

  • Experience with at least 1 programming language

  • Strong SQL skills

  • Experience with JCL and ISPF

Desired Qualifications:

  • Mainframe software upgrade / migration experience, using SMP/E

  • Experience using IBM DB2 Tools, Omegamon monitoring

  • Experience with other database technologies

Education:

  • Bachelors Degree in Information Systems, Computer Science, Math, Engineering or equivalent work experience.
upload resume icon
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Database Administrator Sr

University Of Pittsburgh Medical Center

Posted 2 weeks ago

VIEW JOBS 1/4/2019 12:00:00 AM 2019-04-04T00:00 Description Purpose: Under the general direction of the team lead and management, this senior level position is responsible for day to support of database systems. This individual works independently with minimal supervision to maintain systems to supported levels, identifies and resolves complex issues that may arise with the database software and aids junior staff as needed. This position will assume On-Call support responsibilities on a rotational basis. This position will sit within the Health Plan Core Systems department. Responsibilities: * Auditing - Respond to requests from Internal Audit, external auditors as directed and SOX requirements. * Customer Service - Maintains professional relationship with application owner/teams, provide support as needed. Facilitate a productive dialogue relative to the success of the services provided. * Database Management - Support multiple implementations at various support levels. Install, configure and provide day to day support after implementation, including off hours as needed. Strong understanding of database design and query strategy to provide suggestions for optimal performance. Quickly learns the new features of RDBMS and becomes proficient at implementing those options or features as they become available with minimal direction. Involved with review, analysis and implementation of additional 3rd party software solutions and database add-on solutions when required. * Expertise - Go To resource or resident expert on at least one component of the database platform or infrastructure the RDBMS is hosted on. * Infrastructure - strong understanding of the operating system, networking and other underlying components of the infrastructure as it relates to the RDBMS supported. * Maintenance - Works closely with application team to maintain systems with routine maintenance and patching as outlined by the RDBMS vendor through major and minor upgrades in a timely fashion as they are released. * Mentoring - Mentors junior members of the team. * Performance Tuning - Performs performance/Health Checks on systems as needed or as requested by Management. Strong understanding of database design and query strategy to advise customers on optimal database performance. * Project Management - Complete DBA related tasks as they are associated with the application team and initiatives of the project. * Recovery - strong understanding of advanced business continuity and disaster recovery options for supported RDBMS. Clearly communicates available options to application teams with minimal supervision. * Scripting - strong understanding of OS based scripting, writes, enhances & debugs scripts that automate and orchestrate DBA related tasks. * Self-Development - Continual self-learning to master most all administrative tasks. Strong understanding of the architecture of the RDBMS platform and how various components can impact the system from availability to performance. * Troubleshooting - Respond to tickets and other notifications of issues. Resolves the more complex issues that arise, determining the cause of the database problem, determine a solution and implement the appropriate actions to correct. Qualifications * Typically has strong IT background with several years of practical experience. * Proven track record with database supported with at least 5 years of practical experience within the DBA role for the platform. * Strong understanding of security principles and implements roles appropriately. * Supports the mission critical systems effectively & efficiently. * Strong knowledge of query language. * Takes initiative frequently. * Driven to continually self-learn, learning new features of the RDBM software and understand DBA role and expectations of position. * Works independently with application teams, understands application requirements in turn uses sound judgment and provides direction to the application team in support of those requirements, contributes to team efforts regularly. Preferred Skills: * iBMi and SQL University Of Pittsburgh Medical Center Pittsburgh PA

Database Administrator I

United States Steel Corporation