Overview
On Site
USD 43,040.00 per year
Contract - W2
Skills
Database Design
Data Storage
Data Integrity
Backup Administration
Replication
Optimization
Performance Metrics
Access Control
Data Security
Capacity Management
Storage
Workflow
DevOps
Backup
Recovery
Disaster Recovery
SQL
Regulatory Compliance
Data Governance
Auditing
Scripting
Python
Perl
Collaboration
Development Testing
Incident Management
Migration
Database Administration
IBM DB2
High Availability
Amazon Web Services
IaaS
PaaS
Cloud Computing
Amazon RDS
Remote Desktop Services
PostgreSQL
Amazon DynamoDB
MongoDB
Neo4j
Database
Performance Tuning
Query Optimization
Linux
Unix
Operating Systems
Shell Scripting
Problem Solving
Conflict Resolution
Project Management
Communication
Presentations
Management
Job Details
CALL US NOW for immediate consideration! Click Apply on Web or Apply Now to view our recruiter s contact info and reach out today, we d love to speak with you!
===
** We will NOT accept 3rd Party (C2C) Contractors **
===
JOB DETAILS:
Position:DB2 Database Administrator/Developer
Job Ref #:43997 - JIH5JP00003964
Duration:12+ Years (On-Going Contract)
Location:ONSITE - Marysville, OH 43040
Pay Rate:$71.00 per hour (W2 ONLY)
This role is 100% ONSITE, no remote work offered (Must be LOCAL or willing to RELOCATE at your own expense)
RESPONSIBILITIES INCLUDE:
Database Design and Implementation: Design, develop, and implement database solutions in collaboration with development teams. Create database schemas, tables, and indexes to support efficient data storage and retrieval.
Database Administration: Manage, monitor, and optimize database instances to ensure high availability, performance, and data integrity. Configure and maintain database backups, replication, and disaster recovery strategies.
Performance Tuning and Optimization: Identify and resolve database performance issues, including query optimization, index tuning, and resource utilization. Monitor database performance metrics and implement improvements to optimize
performance.
Data Security and Compliance: Implement and maintain appropriate security measures and access controls to protect sensitive data stored in the cloud database. Ensure compliance with data protection regulations and industry best practices.
Database Monitoring and Troubleshooting: Monitor database activity and performance using database monitoring tools. Diagnose and resolve database-related issues and incidents, working closely with cross-functional teams to ensure timely
resolution.
Database Capacity Planning: Estimate future database storage and performance requirements based on data growth projections. Plan and implement database capacity upgrades or scaling activities to accommodate evolving business needs.
Database Automation and Scripting: Develop and maintain database automation scripts, workflows, and configurations using scripting languages and infrastructure-as-code tools. Implement DevOps practices for database deployment and
management.
Collaboration and Communication: Collaborate with application teams, infrastructure teams, and stakeholders to understand database requirements, provide technical guidance, and ensure effective integration with other systems. Communicate
database-related updates, issues, and recommendations to relevant stakeholders.
DAILY TASKS:
Database Administration: Install, Configure, and Upgrade database software for DB2 LUW and Cloud Database Platforms. Monitor and maintain database health, performance, and security. Implement and manage database backup and recovery
strategies. Ensure high availability and disaster recovery readiness.
Performance Tuning: Analyze and optimize SQL queries and database performance. Identify and resolve bottlenecks in database systems. Implement indexing and tuning strategies and partitioning for performance gains.
Security & Compliance: Manage user access and roles. Ensure compliance with data governance and security policies. Perform audits and vulnerability assessments.
Automation & Scripting: Develop scripts for monitoring, maintenance, and automation tasks. Use tools like shell scripting, Python, or Perl for automation.
Collaboration: Work closely with application developers, system administrators, and business analysts to understand new requirements and recommend high level direction and approach. Provide support for development, testing, and production
environments.
Support: Resolve platform related issues. Participate in Incident Response. Coordinate with Vendors for Product related issues, Patches and Bug Fixes.
Future Technologies: Assist in migrating On-Prem Databases to the cloud and integrating data from various sources into Cloud-based systems.
REQUIRED EXPERIENCE/SKILLS:
10+ years experience as a DB2 LUW DBA in enterprise environments.
Strong knowledge of DB2 LUW architecture, utilities, and tools. Experience with HADR, TSA, QREP and other high availability solutions.
5+ years experience with Cloud Concepts, AWS and other Cloud Technologies, IaaS and PaaS, Cloud Database Platforms (RDS PostgreSQL, AWS DynamoDB, DocumentDB, MongoDB, Neo4j, Neptune etc.)
5+ years experience working with large database / large scale projects.
Proficiency with performance tuning and query optimization.
Familiarity with Linux/Unix operating systems and shell scripting.
Experience with monitoring tools
Excellent problem-solving and communication skills.
Use technology, design and/or architecture processes with business sense to make appropriate decisions.
Good knowledge of Project Management principles.
Excellent verbal communication skills, Strong visual presentation skills.
Flexibility to communicate effectively with various levels of management.
Ability to analyze critical information, assess upstream/downstream impact, and formulate broad recommendations.
==
==
Calance Consultant Benefits Offerings:
- EPO/PPO Medical Plans
- HMO/PPO Dental programs
- Vision - VSP (Vision Plan Summary)
- 401K Retirement vesting program (VOYA)
- Paid Bi-Weekly/Direct Deposit
- Flex Spending Plan
- Voluntary Life, AD&D, STD or LTD plans
===
** We will NOT accept 3rd Party (C2C) Contractors **
===
JOB DETAILS:
Position:DB2 Database Administrator/Developer
Job Ref #:43997 - JIH5JP00003964
Duration:12+ Years (On-Going Contract)
Location:ONSITE - Marysville, OH 43040
Pay Rate:$71.00 per hour (W2 ONLY)
This role is 100% ONSITE, no remote work offered (Must be LOCAL or willing to RELOCATE at your own expense)
RESPONSIBILITIES INCLUDE:
Database Design and Implementation: Design, develop, and implement database solutions in collaboration with development teams. Create database schemas, tables, and indexes to support efficient data storage and retrieval.
Database Administration: Manage, monitor, and optimize database instances to ensure high availability, performance, and data integrity. Configure and maintain database backups, replication, and disaster recovery strategies.
Performance Tuning and Optimization: Identify and resolve database performance issues, including query optimization, index tuning, and resource utilization. Monitor database performance metrics and implement improvements to optimize
performance.
Data Security and Compliance: Implement and maintain appropriate security measures and access controls to protect sensitive data stored in the cloud database. Ensure compliance with data protection regulations and industry best practices.
Database Monitoring and Troubleshooting: Monitor database activity and performance using database monitoring tools. Diagnose and resolve database-related issues and incidents, working closely with cross-functional teams to ensure timely
resolution.
Database Capacity Planning: Estimate future database storage and performance requirements based on data growth projections. Plan and implement database capacity upgrades or scaling activities to accommodate evolving business needs.
Database Automation and Scripting: Develop and maintain database automation scripts, workflows, and configurations using scripting languages and infrastructure-as-code tools. Implement DevOps practices for database deployment and
management.
Collaboration and Communication: Collaborate with application teams, infrastructure teams, and stakeholders to understand database requirements, provide technical guidance, and ensure effective integration with other systems. Communicate
database-related updates, issues, and recommendations to relevant stakeholders.
DAILY TASKS:
Database Administration: Install, Configure, and Upgrade database software for DB2 LUW and Cloud Database Platforms. Monitor and maintain database health, performance, and security. Implement and manage database backup and recovery
strategies. Ensure high availability and disaster recovery readiness.
Performance Tuning: Analyze and optimize SQL queries and database performance. Identify and resolve bottlenecks in database systems. Implement indexing and tuning strategies and partitioning for performance gains.
Security & Compliance: Manage user access and roles. Ensure compliance with data governance and security policies. Perform audits and vulnerability assessments.
Automation & Scripting: Develop scripts for monitoring, maintenance, and automation tasks. Use tools like shell scripting, Python, or Perl for automation.
Collaboration: Work closely with application developers, system administrators, and business analysts to understand new requirements and recommend high level direction and approach. Provide support for development, testing, and production
environments.
Support: Resolve platform related issues. Participate in Incident Response. Coordinate with Vendors for Product related issues, Patches and Bug Fixes.
Future Technologies: Assist in migrating On-Prem Databases to the cloud and integrating data from various sources into Cloud-based systems.
REQUIRED EXPERIENCE/SKILLS:
10+ years experience as a DB2 LUW DBA in enterprise environments.
Strong knowledge of DB2 LUW architecture, utilities, and tools. Experience with HADR, TSA, QREP and other high availability solutions.
5+ years experience with Cloud Concepts, AWS and other Cloud Technologies, IaaS and PaaS, Cloud Database Platforms (RDS PostgreSQL, AWS DynamoDB, DocumentDB, MongoDB, Neo4j, Neptune etc.)
5+ years experience working with large database / large scale projects.
Proficiency with performance tuning and query optimization.
Familiarity with Linux/Unix operating systems and shell scripting.
Experience with monitoring tools
Excellent problem-solving and communication skills.
Use technology, design and/or architecture processes with business sense to make appropriate decisions.
Good knowledge of Project Management principles.
Excellent verbal communication skills, Strong visual presentation skills.
Flexibility to communicate effectively with various levels of management.
Ability to analyze critical information, assess upstream/downstream impact, and formulate broad recommendations.
==
==
Calance Consultant Benefits Offerings:
- EPO/PPO Medical Plans
- HMO/PPO Dental programs
- Vision - VSP (Vision Plan Summary)
- 401K Retirement vesting program (VOYA)
- Paid Bi-Weekly/Direct Deposit
- Flex Spending Plan
- Voluntary Life, AD&D, STD or LTD plans
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.