Senior Software Engineer (DB2 DBA)

About the position

The Senior Software Engineer (DB2 DBA) is a key technical role responsible for the managing, maintaining, optimizing and securing the DB2 databases of new and existing applications within Citibank's technology ecosystem. This position requires a highly proficient and experienced individual with a deep understanding of the database administration, software development lifecycle (SDLC) principles, modern development practices, and a proven ability to deliver high-quality solutions in a fast-paced financial environment. This role demands strong technical expertise, problem-solving skills, collaboration within and across teams, and the ability to mentor junior team members.

Responsibilities

• Perform core DBA tasks, including database creation, patching (specifically VTM patching), DB2 upgrades, backup and restore procedures, and ongoing maintenance.
• Download the DB2 database software from the IBM vendor site and create the packages for installation in the Citi environment.
• Interface with the IBM vendor for remediation of any security vulnerabilities and any other issues identified as database related.
• Investigate and resolve database performance bottlenecks.
• Utilize tools like DB2explain and DB2advise to analyze query performance and recommend optimization strategies.
• Monitor space usage and proactively recommend adjustments for optimal performance.
• Develop and maintain contingency plans for database recovery and business continuity.
• Participate in annual disaster recovery testing to validate and refine recovery procedures.
• Implement and maintain database security measures, including FID/Policy access management.
• Support audit and compliance requirements related to data security and access control.
• Manage OS upgrades and minimize their impact on database systems.
• Maintain expertise in relevant operating systems and platforms supporting our database infrastructure.

Requirements

• 5+ years of experience in the DB2 Database Administration role.
• Proven experience in Performance Tuning and Optimization using tools like DB2explain and DB2advise.
• Experience with automation scripting (e.g., Java, Shell, Python).
• Experience with distributed Database Platforms (DB2, Oracle, SQL, NoSQL).
• Familiarity with Cloud Database Technologies (e.g., Amazon RDS, Azure SQL Database, Google Cloud SQL, AWS DynamoDB, MongoDB Atlas).
• Practical experience with CI/CD principles and Implementation, including familiarity with tools like Jenkins, GitLab CI, or Azure DevOps.
• Familiarity with monitoring tools such as Autosys.
• Experience with hardware upgrades, sizing, and high-availability configurations.
• Strong understanding of contingency planning and disaster recovery procedures.
• Knowledge of database security management, FID/Policy access management, and audit/compliance requirements.
• Experience managing OS upgrades and their impact on database systems.
• Excellent communication and problem-solving skills.
• Ability to work independently and as part of a team.
• Ability to manage multiple tasks and prioritize effectively.
• Excellent written and verbal communication skills.

Benefits

• medical, dental & vision coverage
• 401(k)
• life, accident, and disability insurance
• wellness programs
• paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays