Sr DB2 DBA (Need Only on W2)

Overview

Remote
Depends on Experience
Contract - W2
Contract - 6 Month(s)

Skills

z/OS DB2 DBA
Netezza

Job Details

This is a 100% Remote Opportunity and Need Candidates ONLY on W2

10 or more year s professional experience as an application z/OS DB2 DBA on V11+.
8 or more years LUW DB2 including installing, supporting, configuring, and upgrading DB2 LUW subsystems.

In depth knowledge of the DB2 zOS architecture.
Experience with Netezza Performance Server database administration
Experience with DB2 Purescale environment
Experience working with IBM on opening cases and working with them
Experience in configuring and supporting Tier-1 mission critical databases as an application z/os DBA and LUW systems/infrastructure DBA.
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, data Lakehouse and data lakes.
Perform routine maintenance on several database environments including application of updates, patches, and hotfixes for LUW servers
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.
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) and Query monitor for z/os DB2

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.