Note: The job is a remote job and is open to candidates in USA. Softthink Solutions is an IT services and software consulting company focused on delivering secure and reliable technology solutions. The IBM DB2 Database Administrator will administer, secure, optimize, and support enterprise DB2 environments while ensuring availability, performance, backup and recovery, and operational stability across development, test, QA, and production environments.
Responsibilities
- Install, configure, administer, patch, upgrade, and maintain IBM DB2 databases
- Monitor database health, availability, performance, capacity, and resource utilization
- Perform database and SQL performance tuning
- Analyze SQL execution plans and identify performance bottlenecks
- Optimize tables, indexes, queries, memory, storage, and database configurations
- Implement and manage database backup and recovery procedures
- Perform database restoration and recovery when required
- Design and maintain high-availability and disaster-recovery configurations
- Perform database capacity planning and storage management
- Manage database users, roles, privileges, and access controls
- Implement database security, encryption, and auditing requirements
- Monitor database logs, jobs, utilities, and scheduled processes
- Troubleshoot database failures, locking, deadlocks, connectivity, and performance issues
- Perform root-cause analysis of production database incidents
- Support database migrations, upgrades, refreshes, and environment cloning
- Develop scripts and utilities to automate routine DBA activities
- Support application releases and production deployments from a database perspective
- Maintain database configuration documentation, SOPs, recovery procedures, and operational runbooks
- Participate in production incident, change, and problem-management processes
Skills
- · 10+ years of hands-on **IBM DB2 DBA** experience
- · Strong experience with DB2 LUW administration
- · Strong SQL skills
- · Strong experience with database performance tuning
- · Experience with DB2 backup and recovery
- · Experience with high availability and disaster recovery
- · Experience with database security, access control, and auditing
- · Strong Linux/Unix skills
- · Experience supporting large enterprise production databases
- · Strong troubleshooting and root-cause-analysis capabilities
- · Experience with database monitoring and performance-management tools
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related technical discipline, or equivalent professional experience
- **Work Authorization: US Citizen**
- **Location:** **Remote**
- · IBM DB2 certification
Benefits
- Fully remote work arrangement
- Cutting-edge technology, training, and career guidance to expand and grow skill sets
- Opportunities to work with leading multinational clients
- Established methodologies, processes, and mentoring to maximize efficacy and efficiency
- Opportunities to engage with specialized services and advanced IT solutions
- A growing R&D division continually exploring and pioneering the latest technological developments
Company Overview