Senior Database Administrator
0 viewsEnsonoBengaluruHybrid
6+ years
Posted 13 days ago
- AWS
- GCP
- Python
- Terraform
About Ensono
Ensono is a hybrid IT services provider that optimizes and modernizes IT infrastructure by combining the power of mainframes and mid-range servers with the agility of cloud. With nearly 50 years of experience, Ensono works with some of the most innovative and forward-thinking companies in the world.
Role: Senior Database Administrator (Db2 LUW)
The Senior Db2 LUW Database Administrator reports to the Db2 LUW Manager and is part of the Global Implementation and Operational team. The role supports operational and migration activities for mission-critical infrastructure of Ensono's clients, delivering responsive and exceptional support for client events and requests. The role supports Db2 LUW for multiple clients in a shared support model.
Responsibilities
- Design, build, 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.
- Ensure integrity and recoverability of Db2 LUW databases using industry-standard technologies and methods.
- Analyze and tune instance and database configuration parameters, indexes, physical database design and SQL statements to optimize performance.
- Serve as a technical resource to business analysts, solution development and other groups on Db2 LUW application standards, system design and integration.
- Keep Db2 LUW systems at operational excellence during infrastructure improvements (hardware and software upgrades, server migrations and consolidations, application deployment).
- Create and maintain documentation, runbooks, knowledge articles and diagrams.
- Handle major issues and complex troubleshooting, serving as an escalation point.
- Facilitate communication and collaboration between the ops DBA team and clients.
- Automate DBA best practices and apply AI in secure ways to improve efficiency.
- Mentor and train junior and mid-level database administrators.
- Participate in a 24x7 on-call rotation for incidents and outages, and work rotating shifts aligned to client needs.
Requirements
- More than six years of Db2 LUW database administration experience.
- Excellent understanding of Db2 LUW technology, including builds, upgrades, patching, migrations and troubleshooting across multiple versions.
- Extensive database performance tuning experience.
- Deep knowledge of enterprise-class best practices for large database environments.
- 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.
- Willingness to participate in a 24x7 on-call rotation and rotating shift schedule.
- Excellent written and verbal English communication skills.
- Technical leadership skills and ability to work independently.
Nice to have
- Automation skills in Shell Scripting, Python, Ansible or Terraform (cloud) for routine maintenance.
- Experience using AI to increase efficiency in database environments.
- Knowledge of advanced Db2 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 (GCP, AWS, etc.).
Application questions (from the posting)
- Do you have 6+ years of hands-on experience in Db2 LUW database administration?
- Are you proficient in Db2 HADR and TSA/Pacemaker at an Advanced or Expert level?
- Do you have extensive experience in database performance tuning?
- Have you implemented and supported database security and backup/recovery strategies in production?
- Can you join with a notice period of 30 to 60 days or less?
- Are you open to hybrid work from Pune, Bangalore, Hyderabad or Chennai with 24x7 rotating shifts?
- Do you hold a B.Tech, M.Tech, MCA or equivalent degree in Computer Science or a related field?