Senior Database Administrator

About the role and what you'll be doing:

The Senior Db2 LUW Database Administrator reports to the Db2 LUW Manager. You’ll be part of Global Implementation & Operational team, supporting the operational & migration activities of mission critical infrastructure of Ensono’s clients, delivering a responsive and exceptional support service for client events and requests. We are looking for a Senior Db2 LUW DBA to join our team to support multiple clients. Key responsibilities include:

• Primary role will be to support Db2 LUW for multiple clients in our shared support model.
• Coordinate with a team of global DBAs and with key client contacts to align efforts with the client’s needs.
• Work with clients on issues and requests related to Projects.
• Work proactively and review high level project requirements and deliverables.
• Be willing to participate in an on-call rotation for 24x7 support for incidents and outages.
• Be willing to work on a rotating shift schedule to align with client needs.
• Automate DBA best practices.
• Apply AI in secure ways to improve efficiency.

Responsibilities

• Design, build, and enhance, upgrade, and build new client Db2 LUW environments.
• Work closely with clients daily on projects, troubleshooting, or consultations.
• Perform software installations, upgrades, and patches to Db2 LUW instances and servers.
• Define and maintain Db2 LUW standards and governance.
• Utilize industry standard technologies & methods to ensure the integrity & recoverability of Db2 LUW databases.
• Analyze and tune instance/database configuration parameters, indexes, physical database design, and SQL statements to optimize performance.
• Serve as technical resource to business analysts, solutions development, and other groups responsible for Db2 LUW application development standards, system design and integration.
• Ensure Db2 LUW systems remain at operational excellence during infrastructure improvements (hardware/software upgrades server migrations/consolidations, application deployment, etc.).
• Assist in creating new or maintaining documentation, runbooks, knowledge articles and diagrams.
• Assist with major issues, technical challenges, and troubleshooting, serving as an escalation point for complex problems.
• Facilitate open communication and collaboration between our ops DBA team and the client, ensuring alignment and effective problem-solving.
• Mentor and train junior and mid-level database administrators.

Required Qualifications

• More than six years of experience in Db2 LUW database administration
• Excellent understanding of Db2 LUW technology (builds, upgrades, patching, migrations, troubleshooting multiple versions of Db2 LUW)
• Extensive database performance tuning experience
• Deep knowledge of industry-standard, enterprise-class best practices for a large database environment
• Good understanding of UNIX/Linux and Windows platforms
• Deep understanding of Db2 HADR and TSA/Pacemaker
• Experience implementing, supporting and auditing database security
• Experience with transaction log management, backup strategies and security configuration using LDAP
• Knowledge of Db2 Connect and Db2 client connectivity

Preferred Qualifications

• Automation skills in Shell Scripting/Python/Ansible/Terraform (cloud) to automate routine maintenance activities.
• Experience using AI to increase efficiency in database environments.
• Knowledge of administering advanced Db2 database functions including federation, database encryption, Q-Replication and SQL replication.
• Knowledge of the ITIL framework.
• Database administration experience in a public or private cloud environment – Google Cloud Platform (GCP), Amazon Web Services (AWS), etc.

Skills

• Technical leadership skills
• Ability to work independently, analyze the requirement, and provide solutions
• A ‘client centric’ approach
• Excellent demonstrable English written and verbal communication skills
• Able to communicate in groups with confidence and conviction