DB2 zOS DBA

100% Remote

Issued Equipment: Yes

Remote/Hybrid/Onsite: Remote

Interview Comments: Panel interview- Video required

Candidates MUST have z/OS as well as experience with LUW and Netezza

Required (must have):

• 10 or more year's professional experience as a systems DB2 zOS databases on V11+ Database Administrator should be very strong working knowledge of Operational/Systems DBA to setup and support IBM DB2 zOS databases on Mainframe systems. Experience of 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:

• Bachelor's degree in an IT related field or equivalent work experience.

Required:

• DB2 zOS Database Administration Certification.

• Added advantage of knowledge of administration of db2 LUW and Sailfish

• Health care industry related experience.

EEO:

"Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."