Apply on Employer Site

American Recruiting & Consulting Group · 5 days ago

Mainframe DB2 DBA

United States

Contract

Remote

Senior Level, Lead/Staff

10+ years exp

ARC Group is a well-respected organization seeking a Senior DB2 DBA for a remote position. The role involves managing and supporting IBM DB2 zOS databases, ensuring optimal performance, and providing 24/7 support to critical production systems.

Professional ServicesRecruitingStaffing Agency

Growth Opportunities

Hiring Manager

Suresh Gaddala

Responsibilities

10 or more years professional experience as a systems DB2 zOS databases on V11+; Database Administrator should have very strong working knowledge of Operational/Systems DBA to setup and support IBM DB2 zOS databases on Mainframe systems

In depth knowledge of the DB2 zOS architecture

Experienced in installing, configuring, and upgrading DB2 zOS subsystems

Experience with Netezza Performance Server database administration

Experience working with IBM on opening cases and working with them

Experience in configuring and supporting Tier-1 mission critical databases as a systems/infrastructure DBA

In-depth knowledge of operating system zOS and hands on working experiences on zOS

Good knowledge of capacity planning and architecture design for database server deployment

Proven experience in working in a mission critical environment in a multi-terabyte database platform, including analytics workloads

Good understanding of data warehouse concepts including data marts and data lakes

Perform routine maintenance on several database environments including application of updates, patches, and hotfixes

Creating databases, migrating database objects from non-production to production environment

Designing and building data models, schemas, views, and tables to support application requirements

Working knowledge of Database Security mechanism, data encryption, obfuscation, auditing using tools such as Guardium

Extensive experience designing and executing backup and recovery concepts and procedures

Measure database performance and troubleshoot complex database issues, I/O bottlenecks, SQL Tuning/

Experience in using Nimsoft, Dynatrace or Datadog or other event management and performance monitoring tools

Good understanding of licensing options and optimization

Experience in scripting languages (shell or python or Perl) for automating DBA administrative tasks

Experience with automation tools such as Control-M

In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies

Provide 24 x 7 Support to Critical production systems

Knowledge of Project Management Methodologies

Experience in working closely with the application development teams to resolve any performance related issues and provide application support

DB2 tools, JCL, Perf monitoring (Omegamon)

Qualification

DB2 zOS databasesDB2 zOS architectureDatabase administrationNetezza Performance ServerCapacity planningData warehouse conceptsDatabase Security mechanismsBackupRecoveryPerformance monitoring toolsScripting languagesAutomation toolsApplication supportDB2 toolsHealth care experienceProject Management Methodologies

Required