Soho Square Solutions
We are
looking for a DB2 Database Administrator – Lake Mary, FL .
Location:
Lake Mary, FL
Duration:
12+ Months
Note:
Looking for candidate local to Lake Mary, FL.
We are seeking an experienced DB2 Database Administrator with strong expertise in database management, performance tuning, security, and automation. The ideal candidate will have hands‑on experience managing enterprise‑scale DB2 databases across on‑prem and cloud environments, supporting mission‑critical systems with high availability, security, and performance requirements. This role requires strong analytical skills, excellent communication abilities, and willingness to provide 24x7 on‑call support.
Key Responsibilities
Administer, maintain, and support DB2 databases across development, test, and production environments.
Perform database performance tuning, including SQL optimization, indexing strategies, and capacity planning.
Manage database security, access controls, auditing, and compliance with enterprise security standards.
Implement and maintain backup, recovery, and disaster recovery strategies to ensure data availability and integrity.
Troubleshoot and resolve complex database issues, including performance bottlenecks, data corruption, and system failures.
Manage and maintain database objects such as tables, indexes, views, stored procedures, and triggers.
Utilize DB2 utilities including LOAD, REORG, RUNSTATS, and related tools for database maintenance and optimization.
Work with Job Control Language (JCL) in mainframe environments to support batch processing and database jobs.
Develop and maintain scripts and automation using Unix Shell scripting to improve operational efficiency.
Support data replication and global data distribution strategies across environments.
Monitor database environments using tools such as Splunk and proactively address issues.
Document database architecture, technical designs, operational procedures, and troubleshooting guides.
Collaborate with application teams, infrastructure teams, and business stakeholders to support database design, data modeling, and data integrity requirements.
Provide 24x7 production support and participate in on‑call rotations as required.
Required Skills & Qualifications & Core Skills
Advanced experience in DB2 Database Administration
Strong understanding of database design, data modeling, and data integrity concepts
Expertise in SQL tuning and database performance optimization
Hands‑on experience with backup, recovery, and disaster recovery planning
Strong analytical, problem‑solving, and troubleshooting skills
Excellent documentation and communication skills (technical and non‑technical)
Technical Skills
Snowflake Architecture – Advanced
Unix Shell Scripting – Advanced
Security & Risk Management / Disaster Recovery – Intermediate
Seniority Level Mid‑Senior level
Employment Type Contract
Job Function Administrative, Analyst, and Information Technology
Industries IT Services and IT Consulting, Software Development, and Business Consulting and Services
#J-18808-Ljbffr
looking for a DB2 Database Administrator – Lake Mary, FL .
Location:
Lake Mary, FL
Duration:
12+ Months
Note:
Looking for candidate local to Lake Mary, FL.
We are seeking an experienced DB2 Database Administrator with strong expertise in database management, performance tuning, security, and automation. The ideal candidate will have hands‑on experience managing enterprise‑scale DB2 databases across on‑prem and cloud environments, supporting mission‑critical systems with high availability, security, and performance requirements. This role requires strong analytical skills, excellent communication abilities, and willingness to provide 24x7 on‑call support.
Key Responsibilities
Administer, maintain, and support DB2 databases across development, test, and production environments.
Perform database performance tuning, including SQL optimization, indexing strategies, and capacity planning.
Manage database security, access controls, auditing, and compliance with enterprise security standards.
Implement and maintain backup, recovery, and disaster recovery strategies to ensure data availability and integrity.
Troubleshoot and resolve complex database issues, including performance bottlenecks, data corruption, and system failures.
Manage and maintain database objects such as tables, indexes, views, stored procedures, and triggers.
Utilize DB2 utilities including LOAD, REORG, RUNSTATS, and related tools for database maintenance and optimization.
Work with Job Control Language (JCL) in mainframe environments to support batch processing and database jobs.
Develop and maintain scripts and automation using Unix Shell scripting to improve operational efficiency.
Support data replication and global data distribution strategies across environments.
Monitor database environments using tools such as Splunk and proactively address issues.
Document database architecture, technical designs, operational procedures, and troubleshooting guides.
Collaborate with application teams, infrastructure teams, and business stakeholders to support database design, data modeling, and data integrity requirements.
Provide 24x7 production support and participate in on‑call rotations as required.
Required Skills & Qualifications & Core Skills
Advanced experience in DB2 Database Administration
Strong understanding of database design, data modeling, and data integrity concepts
Expertise in SQL tuning and database performance optimization
Hands‑on experience with backup, recovery, and disaster recovery planning
Strong analytical, problem‑solving, and troubleshooting skills
Excellent documentation and communication skills (technical and non‑technical)
Technical Skills
Snowflake Architecture – Advanced
Unix Shell Scripting – Advanced
Security & Risk Management / Disaster Recovery – Intermediate
Seniority Level Mid‑Senior level
Employment Type Contract
Job Function Administrative, Analyst, and Information Technology
Industries IT Services and IT Consulting, Software Development, and Business Consulting and Services
#J-18808-Ljbffr