DB2 DBA Remote Location
Posted 1 week ago by Sierra Business Solution LLC
Negotiable
Undetermined
Remote
Remote
Summary: The DB2AS400 Administrator is tasked with the installation, configuration, and ongoing support of IBM i (AS400) systems and DB2 databases, ensuring high availability and optimal performance in production environments. Key responsibilities include database performance tuning, backup management, and compliance with IT regulations. The role also involves troubleshooting and coordinating with various teams to support system upgrades and migrations. This position requires strong expertise in IBM i administration and DB2 database management.
Key Responsibilities:
- Perform database installation, upgrades, patches, and fixes
- Monitor and tune database performance, queries, and system resources
- Manage backup, recovery, and disaster recovery (DR) procedures
- Implement and maintain security controls, user access, and authorities
- Handle capacity planning and environment stability reviews
- Troubleshoot database and system issues, perform root cause analysis
- Support migration, upgrade, and modernization initiatives
- Coordinate with application, infrastructure, and operations teams
- Ensure compliance with IT audit, and regulatory requirements
- Maintain technical documentation and standard operating procedures
- Manage capacity planning, performance tuning, forecasting, and trending
Key Skills:
- Strong experience with IBM i (AS400) administration
- Hands-on with DB2 for i database management
- Expertise in backup recovery, journaling, and high availability concepts
- Knowledge of performance tuning and workload management
- Familiarity with security, auditing, and compliance controls
- Experience supporting 24x7 production environments
- Exposure to cloud or hybrid migration projects is a plus
Salary (Rate): £50 hourly
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
DB2AS400 Administrator
The DB2AS400 Administrator is responsible for the installation, configuration, administration, performance tuning, and ongoing support of IBM i (AS400) systems and DB2 databases. The role ensures high availability, data integrity, security, and optimal system performance in a production environment.
Perform database installation, upgrades, patches, and fixes
Monitor and tune database performance, queries, and system resources
Manage backup, recovery, and disaster recovery (DR) procedures
Implement and maintain security controls, user access, and authorities
Handle capacity planning and environment stability reviews
Troubleshoot database and system issues, perform root cause analysis
Support migration, upgrade, and modernization initiatives
Coordinate with application, infrastructure, and operations teams
Ensure compliance with IT audit, and regulatory requirements
Maintain technical documentation and standard operating procedures
Manage capacity planning, performance tuning, forecasting, and trending.
Roles & Responsibilities
Perform database installation, upgrades, patches, and fixes
Monitor and tune database performance, queries, and system resources
Manage backup, recovery, and disaster recovery (DR) procedures
Implement and maintain security controls, user access, and authorities
Handle capacity planning and environment stability reviews
Troubleshoot database and system issues, perform root cause analysis
Support migration, upgrade, and modernization initiatives
Coordinate with application, infrastructure, and operations teams
Ensure compliance with IT audit, and regulatory requirements
Maintain technical documentation and standard operating procedures
Manage capacity planning, performance tuning, forecasting, and trending.
Strong experience with IBM i (AS400) administration
Hands-on with DB2 for i database management
Expertise in backuprecovery, journaling, and high availability concepts
Knowledge of performance tuning and workload management
Familiarity with security, auditing, and compliance controls
Experience supporting 24x7 production environments
Exposure to cloud or hybrid migration projects is a plus