DB2 DBA Analyst

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Manage and provide support for the IBM DB2 environment along with its high-availability infrastructure.

• Strategically plan and carry out preventive and corrective maintenance tasks.

• Implement best practices for DB2 administration.

• Oversee instances in Development, QA/UAT, and Production environments.

• Track the usage and performance of DB2 environments.

• Examine performance issues, locks, resource usage, and query performance degradation.

• Discover opportunities for query enhancements.

• Evaluate execution plans and index usage.

• Investigate intricate incidents and issues.

• Conduct root cause analysis and outline preventive and corrective measures.

• Manage high-availability and replication systems.

• Engage in contingency planning and disaster recovery initiatives.

• Confirm the effectiveness of backup and restore processes.

• Assess availability risks and eliminate single points of failure.

• Oversee DB2 users, groups, roles, and privileges.

• Grant, change, and revoke access in line with institutional policies.

• Assist with audit and compliance efforts and address vulnerabilities.

• Plan and implement changes in QA/UAT and Production environments.

• Evaluate business impacts and associated risks.

• Organize implementation and rollback strategies.

• Upgrade versions, apply fix packs, and implement security patches.

• Take part in database creation, modification, and migration initiatives.

• Provide DB2-related solutions to Development and Architecture teams.

• Collaborate with Development, Architecture, Middleware, Security, NOC, Governance, vendors, and partners.

⛳️ Requirements

• Investigate intricate problems.

• Conduct root cause analysis.

• Evaluate impact and risk.

• Suggest structural solutions.

• Automate repetitive tasks.

• Establish technical standards.

• Document solutions effectively.

• Support architectural design efforts.

• Guide fellow professionals.

• Act as a technical reference within the team.

• Experience in critical, 24x7 operational settings.

• Experience managing high data volumes in clustered environments.

• Familiarity with regulated environments.

• Ability to respond to critical incidents proficiently.

• Experience analyzing recurring issues and implementing structural corrective measures.

🏝️ Benefits

• Meal voucher or food allowance.

• Discounts on courses, universities, and language schools.

• Stefanini Academy — a platform that offers free, current online courses with certification.

• Mentoring opportunities.

• Benefits club providing discounts on consultations and medical tests.

• Health insurance coverage.

• Dental insurance coverage.

• Benefits and discounts at premier establishments.

• Travel club membership.

• Pet benefits program.