DB2 Database Administrator

SENIOR DB2 DBA - REMOTE ARC Group has an immediate opportunity for a Senior DB2 DBA!

This is starting out as a 12 month contract position with strong potential to extend longer or potentially convert to FTE.

This position is 100% remote working Eastern Time Zone business hours.

This is a fantastic opportunity to join a dynamic and well-respected organization.   At ARC Group, we are committed to fostering a diverse and inclusive workplace where everyone feels valued and respected.

We believe that diverse perspectives lead to better innovation and problem-solving.

As an organization, we embrace diversity in all its forms and encourage individuals from underrepresented groups to apply.   100% REMOTE!

Reference # 19269-1 Required (must have) :

• 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.
• Experience with DB2 LUW is a plus.
• 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) Required Education :

Preferred :