Sr DB2 DBA at The Computer Merchant, LTD.
Jacksonville, FL 32246
About the Job
JOB TITLE: Sr. DB2/ DBA
JOB LOCATION: Remote
WAGE RANGE*: $58 - 64/ hour W2 only
JOB NUMBER: 16351
Required Experience:
• 10 or more year's professional experience as a systems DB2 zOS databases on version 12+. Database Administrator should be very strong working knowledge of application DBA to setup and support IBM DB2 zOS databases on Mainframe systems. Experience of db2 LUW is a plus.
• Bachelor's degree in an IT related field or equivalent work experience.
• In depth knowledge of the DB2 zOS architecture.
• 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
• 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.
• Creating databases, migrating database objects from non-production to production environment.
• Designing and building data models, schemas, views, and tables to support application requirements
• 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 IBM Monitoring tools (Omegamon & query monitor) and other event management and performance monitoring tools.
• Good understanding of licensing options and optimization.
• 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 (DB2 admin, DB2 automation tool, Toad. JCL, performance monitoring tool (Omegamon)
Preferred:
• DB2 zOS Database Administration Certification.
• Added advantage of knowledge of administration of db2 LUW, Netezza and Sailfish
• Health care industry related experience.
Comments for Suppliers: Core Business Hours: 8:30am-5pm Eastern (this will be an on call position as well for support production)
FLSA Classification: Exempt Computer Professional
Sponsorship/Visa Eligibility: N
GuideWell Issued Equipment: Y
Remote/Hybrid/Onsite: Remote (Local candidates preferred)
Background Requirement: Advanced
Interview Comments: Teams interview
Musts:
• Need at least 10+ years z/OS DB2 experience.
• The position is looking specifically for an expert level DB2 mainframe DBA.
Preferred:
• DB2 zOS Database Administration Certification.
• Added advantage of knowledge of administration of db2 LUW, Netezza and Sailfish
• Health care industry related experience.
• Unix
• Jacksonville area preferred (manager hopes this contract to roll perm so would like local candidate if possible)
Job Description:
• 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.
• Design, implement, and maintain DB2 database architectures that meet business requirements on the z/OS platform.
• Keep up-to-date with the latest trends, technologies, and best practices in DB2 database administration on the z/OS platform.
• Provide technical support and guidance to development teams, system administrators, and other stakeholders on database-related issues, including SQL coding, database design, and performance tuning.
• Develop and implement database maintenance tasks, such as backups, patching, and upgrades, using tools like IEFBR14, IDCAMS, and DFSORT.
• Monitor and optimize database performance, capacity, and availability using various tools and techniques, such as DB2 Utilities, z/OS Unix, and SQL.
• 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
Equal Opportunity Employer Veterans/Disabled
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions.
JOB LOCATION: Remote
WAGE RANGE*: $58 - 64/ hour W2 only
JOB NUMBER: 16351
Required Experience:
• 10 or more year's professional experience as a systems DB2 zOS databases on version 12+. Database Administrator should be very strong working knowledge of application DBA to setup and support IBM DB2 zOS databases on Mainframe systems. Experience of db2 LUW is a plus.
• Bachelor's degree in an IT related field or equivalent work experience.
• In depth knowledge of the DB2 zOS architecture.
• 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
• 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.
• Creating databases, migrating database objects from non-production to production environment.
• Designing and building data models, schemas, views, and tables to support application requirements
• 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 IBM Monitoring tools (Omegamon & query monitor) and other event management and performance monitoring tools.
• Good understanding of licensing options and optimization.
• 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 (DB2 admin, DB2 automation tool, Toad. JCL, performance monitoring tool (Omegamon)
Preferred:
• DB2 zOS Database Administration Certification.
• Added advantage of knowledge of administration of db2 LUW, Netezza and Sailfish
• Health care industry related experience.
Comments for Suppliers: Core Business Hours: 8:30am-5pm Eastern (this will be an on call position as well for support production)
FLSA Classification: Exempt Computer Professional
Sponsorship/Visa Eligibility: N
GuideWell Issued Equipment: Y
Remote/Hybrid/Onsite: Remote (Local candidates preferred)
Background Requirement: Advanced
Interview Comments: Teams interview
Musts:
• Need at least 10+ years z/OS DB2 experience.
• The position is looking specifically for an expert level DB2 mainframe DBA.
Preferred:
• DB2 zOS Database Administration Certification.
• Added advantage of knowledge of administration of db2 LUW, Netezza and Sailfish
• Health care industry related experience.
• Unix
• Jacksonville area preferred (manager hopes this contract to roll perm so would like local candidate if possible)
Job Description:
• 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.
• Design, implement, and maintain DB2 database architectures that meet business requirements on the z/OS platform.
• Keep up-to-date with the latest trends, technologies, and best practices in DB2 database administration on the z/OS platform.
• Provide technical support and guidance to development teams, system administrators, and other stakeholders on database-related issues, including SQL coding, database design, and performance tuning.
• Develop and implement database maintenance tasks, such as backups, patching, and upgrades, using tools like IEFBR14, IDCAMS, and DFSORT.
• Monitor and optimize database performance, capacity, and availability using various tools and techniques, such as DB2 Utilities, z/OS Unix, and SQL.
• 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
Equal Opportunity Employer Veterans/Disabled
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions.
Salary
58 - 64 /hour