Job Details

100% Remote

Issued Equipment: Yes
Remote/Hybrid/Onsite: Remote
Interview Comments: Panel interview- Video required

Position Details:
Required (must have):
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

Required Education:
Bachelor's degree in related field or additional equivalent work experience.

Required Education:
Related Bachelor's degree in an IT related field or relevant work 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."