Overview
Remote
On Site
Full Time
Skills
Mainframe
Netezza
IBM
Tier 1
Operating Systems
Capacity Management
Analytics
Data Warehouse
Data Marts
Database Security
Encryption
SQL Tuning
Dynatrace
Event Management
Performance Monitoring
Licensing
Optimization
Shell
Python
Perl
BMC Control-M
Project Management
Application Development
Application Support
JCL
IBM OMEGAMON
z/OS
IBM DB2
Health Care
Data-flow Analysis
Data Flow
Data Storage
Backup
System Requirements
Database Architecture
Computer Hardware
Issue Resolution
Regulatory Compliance
Auditing
Scripting
Disaster Recovery
Testing
IT Management
Change Management
Migration
Documentation
Database Design
PMM
Database Administration
Database
Production Support
Recovery
Systems Design
Management
Managed Services
Partnership
Collaboration
Value Engineering
Effective Communication
Law
Job Details
Senior DB2 DBA
12 month+ Contract
100% Remote
Job Summary
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.
Preferred:
DB2 zOS Database Administration Certification.
Added advantage of knowledge of administration of db2 LUW and Sailfish
Health care industry related experience.
GENERIC JOB DESCRIPTION:
The Senior IT Database Administrator (Senior DBA) provides consultation related to database management and administration. The Senior DBA's perform detailed data flow analysis ensuring the highest levels of efficiency in database and query design in distributed data flows. Senior DBA's administer database systems to protect the confidentiality, integrity and availability of data. The Senior DBA is responsible for maintenance, control and testing of complex databases which provide orderly methods of data storage and controlled access to data. Senior DBA's also maintain complex query language for established database systems, design and execute backup and recovery schemes and implement disaster recovery procedures. The Senior DBA serves as a subject matter expert providing consultation to end-users and project team members on database management, query development, system requirements and database change management initiatives and providing technical guidance to other DBAs.
Consults on database, architecture and related infrastructure technologies to all areas and levels within IT.
Consults on exploiting opportunities involving multiple hardware and software systems, issue resolution, providing innovative business solutions, etc. to both internal and external customers and partners.
Provides technical leadership on the implementation of leading-edge database technologies and the design and implementation of large-scale technical solutions based on business requirements.
Develops and ensures compliance with all system, disaster recovery and security audit policies.
Writes complex programming/scripts.
Participate in disaster recovery design, testing and execution
Monitor and evaluate database performance and adjust database configuration as appropriate
Provide technical leadership to other DBAs
Design process for database change management issues related to environment migration
Make highly complex physical changes to current databases, often this requires working after hours
Maintain operational documentation (e.g., procedures, task lists, architecture blueprints)
Provide subject matter expertise to corporate projects and initiatives
Work with users and IT partners to understand requirements for a physical database design
Provide database consulting expertise to corporate projects and initiatives applying PMM and development life cycle concepts
Address customer concerns and issues related to database management
Evaluate database performance and adjust configuration appropriately
Provide production support for outages, restore/recovery events
Optimize implementation of system design in order to optimize performance and effectiveness while realizing the optimum technical issues.
Other duties as assigned
Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore.
Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results.
Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold.
Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at .
We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.
12 month+ Contract
100% Remote
Job Summary
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.
Preferred:
DB2 zOS Database Administration Certification.
Added advantage of knowledge of administration of db2 LUW and Sailfish
Health care industry related experience.
GENERIC JOB DESCRIPTION:
The Senior IT Database Administrator (Senior DBA) provides consultation related to database management and administration. The Senior DBA's perform detailed data flow analysis ensuring the highest levels of efficiency in database and query design in distributed data flows. Senior DBA's administer database systems to protect the confidentiality, integrity and availability of data. The Senior DBA is responsible for maintenance, control and testing of complex databases which provide orderly methods of data storage and controlled access to data. Senior DBA's also maintain complex query language for established database systems, design and execute backup and recovery schemes and implement disaster recovery procedures. The Senior DBA serves as a subject matter expert providing consultation to end-users and project team members on database management, query development, system requirements and database change management initiatives and providing technical guidance to other DBAs.
Consults on database, architecture and related infrastructure technologies to all areas and levels within IT.
Consults on exploiting opportunities involving multiple hardware and software systems, issue resolution, providing innovative business solutions, etc. to both internal and external customers and partners.
Provides technical leadership on the implementation of leading-edge database technologies and the design and implementation of large-scale technical solutions based on business requirements.
Develops and ensures compliance with all system, disaster recovery and security audit policies.
Writes complex programming/scripts.
Participate in disaster recovery design, testing and execution
Monitor and evaluate database performance and adjust database configuration as appropriate
Provide technical leadership to other DBAs
Design process for database change management issues related to environment migration
Make highly complex physical changes to current databases, often this requires working after hours
Maintain operational documentation (e.g., procedures, task lists, architecture blueprints)
Provide subject matter expertise to corporate projects and initiatives
Work with users and IT partners to understand requirements for a physical database design
Provide database consulting expertise to corporate projects and initiatives applying PMM and development life cycle concepts
Address customer concerns and issues related to database management
Evaluate database performance and adjust configuration appropriately
Provide production support for outages, restore/recovery events
Optimize implementation of system design in order to optimize performance and effectiveness while realizing the optimum technical issues.
Other duties as assigned
Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore.
Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results.
Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold.
Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at .
We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.
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.