Database Administrator (MySQL,PostgreSQL)

Job Description MegaNexus (An NEC Company) – Database Administrator INTRODUCTION Meganexus (An NEC Company) has lead rehabilitation ICT for over a decade, and our aim is to support and develop software that continues to help vulnerable people build better lives. Our software platform places each individual service user at the heart of every solution and operates in over 120 prisons and NHS trusts. Our platform enables supporting staff on the front line to focus on delivery of services and face-to-face time to deliver personalised interventions. Coupled with a library of your organisations curated digital content, the platform is an empowering, co-designed digital asset for services users, front line staff and organisations. You will be responsible for:- • Monitor and maintain Microsoft SQL Server, MySQL, and PostgreSQL database environments. • Ensure database availability, performance, reliability, and security. • Perform database performance tuning and optimize SQL queries, indexes, stored procedures, and database objects to improve application performance. • Troubleshoot database-related incidents and ensure timely resolution. • Support application teams in resolving database performance and connectivity issues. • Manage database users, roles, permissions, and access requests. • Implement and maintain database security standards and compliance requirements. • Investigate and resolve blocking, long-running queries, and locking issues. • Participate in Incident, Problem, and Change Management processes. • Support application and development teams in resolving database-related issues and performance concerns. Required Technical Skills:- • B.Tech/MCA or equivalent qualification. • 3-5 years of hands-on Database Administration experience. • Strong experience with: • Microsoft SQL Server • MySQL • PostgreSQL • Strong knowledge of: • SQL, T-SQL, MySQL, and PostgreSQL • Query Performance Tuning • Stored Procedures, Functions, Views, and Triggers • Index Management • Database Security and User Management • Database Monitoring and Troubleshooting • Familiarity with Azure database environments and monitoring tools. • Familiarity with programming languages like Java • Strong problem-solving skills and ability to think analytically. Required Soft Skill:- • Have the ability to work in teams and take instruction from a variety of people. • Polite and approachable manner when liaising with people both internally and externally. • Show a willingness to listen and learn. • Take initiative in self-development and career progression. • Good communication skills. • Be punctual and reliable. • Take ownership of assigned tasks, and take seriously the responsibility for delivering these tasks on time and to a high quality. • Demonstrate an ability to alleviate pressure and stress through prioritizing work, time management, and sound organizational skills.