Senior Database Administrator (DB2 LUW)

Job Description: Senior Database Administrator (Db2 LUW)

At Ensono, our Purpose is to be a relentless ally, disrupting the status quo and unleashing our clients to Do Great Things! We enable our clients to achieve key business outcomes that reshape how our world runs. As an expert technology adviser and managed service provider with cross-platform certifications, Ensono empowers our clients to keep up with continuous change and embrace innovation.

We can Do Great Things because we have great Associates. The Ensono Core Values unify our diverse talents and are woven into how we do business. These five traits are the key to achieving our purpose.

About the role and what you'll be doing:

The Senior Db2 LUW Database Administrator reports to the Db2 LUW Manager. Youll be part of Global Implementation & Operational team, supporting the operational & migration activities of mission critical infrastructure of Ensonos 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 clients 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
• Ability to multi-task, prioritize and work well under pressure
• Excellent team collaboration skills are essential
• Strong organizational and analytical skills
• Ability to document processes and procedures in a clear, concise, and logical manner
• Self-starter with the capability to work independently and produce positive results that will keep timelines on schedule