Soho Square Solutions · 5 hours ago
DB2 Database Administrator
Soho Square Solutions is seeking an experienced DB2 Database Administrator to manage enterprise-scale DB2 databases. The role involves database administration, performance tuning, security management, and providing 24x7 on-call support for mission-critical systems.
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
Qualification
Required
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)
AWS Database Services – Advanced
DB2 Database Administration – Advanced
Linux (Red Hat) – Advanced
Snowflake Architecture – Advanced
Unix Shell Scripting – Advanced
Data Replication (Global) – Intermediate
Security & Risk Management / Disaster Recovery – Intermediate
Splunk – Intermediate
Company
Soho Square Solutions
Soho Square Solutions expertise in financial services, enterprise risk, information security, project management, big data and blockchain.
H1B Sponsorship
Soho Square Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (1)
2022 (5)
2021 (2)
2020 (3)
Funding
Current Stage
Growth StageRecent News
Company data provided by crunchbase