Senior Database Administrator at Ensono in Bengaluru, India; Chennai, India; Hyderabad, India; Pune, India

Job description

• 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.
• 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 24×7 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.

Requirements

• 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
• 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
• 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

Required

• Db2 LUW database administration
• Database performance tuning
• UNIX/Linux and Windows platforms
• Db2 HADR and TSA/Pacemaker
• Db2 Connect and Db2 client connectivity
• Technical leadership
• Client centric approach

Preferred

• Knowledge of ITIL framework