Install, configure, and upgrade DB2 database software and associated tools on mainframe systems, ensuring compatibility, performance, and security.
Create and manage DB2 databases, tablespaces, tables, indexes, and other database objects according to organizational standards and best practices.
Perform ongoing database maintenance activities such as backup and recovery, reorganization, space management, and health checks to ensure data integrity and availability.
Monitor database performance and resource utilization, proactively identifying and resolving performance issues, tuning SQL queries, and optimizing database parameters.
Implement and maintain database security policies, including roles and permissions, ensuring compliance with regulatory and data privacy standards.
Plan and execute database migrations, upgrades, and patch installations in alignment with change management processes and business needs.
Collaborate with application developers, system administrators, and other stakeholders to support database-related activities including development, testing, and production deployments.
Develop and maintain documentation, procedures, and standards for database administration tasks, including disaster recovery plans and high availability configurations.
Provide technical support and assistance to internal teams and users by troubleshooting and resolving DB2-related issues.
Stay current with emerging technologies, tools, and best practices in Mainframe DB2 administration, and contribute to knowledge sharing within the team.
Required Experience:
Minimum of 5+ years of experience as a Mainframe DB2 DBA.
Mainframe, DB2 DBA, Backup Recovery, Performance and SQL Tuning, HA, DR
Keyskills: mainframes database maintenance backup sql queries upgrade indexing configuration database security database migration sql tuning dbms data integrity recovery database administration sql high availability mainframe db2 sql dba db dba troubleshooting db sql database
Sterling Outsourcing from Poland is a professional outsourcing services provider specializing in delivering cost-effective, high-quality business support solutions. Based in Poland, Sterling offers a strategic advantage through a highly skilled workforce, competitive pricing, and EU-aligned busin...