[LPS] Database Administrator - MSSQL

We are Lenovo. We do what we say. We own what we do. We WOW our customers.
Lenovo is a US$83 billion revenue global technology powerhouse, ranked #153 in the Fortune Global 500, and serving millions of customers every day in 180 markets. Focused on a bold vision to deliver Smarter Technology for All, Lenovo has built on its success as the world’s largest PC company with a full-stack portfolio of AI-enabled, AI-ready, and AI-optimized devices (PCs, workstations, smartphones, tablets), infrastructure (server, storage, edge, high performance computing and software defined infrastructure), software, solutions, and services. Lenovo’s continued investment in world-changing innovation is building a more equitable, trustworthy, and smarter future for everyone, everywhere. Lenovo is listed on the Hong Kong stock exchange under Lenovo Group Limited (HKSE: 992) (ADR: LNVGY).
This transformation together with Lenovo’s world-changing innovation is building a more inclusive, trustworthy, and smarter future for everyone, everywhere. To find out more visit www.lenovo.com (https://www.lenovo.com), and read about the latest news via our StoryHub (https://news.lenovo.com/).

Key responsibilities

The role covers the full lifecycle of the DB2 and MSSQL estate, plus clear communication around every change and incident.

- Keep DB2 and MSSQL databases highly available and reliable across PROD, DR, and UAT
- Perform daily health checks, routine database maintenance and database security self-assessments
- Create, configure and migrate databases, and apply patches and upgrades to keep them at supported levels
- Design, build and maintain MSSQL Always On Availability Groups, including failover testing
- Define and own the backup, restore and DR strategy, and test it regularly
- Plan database capacity and lead performance tuning, using historical and real-time monitoring
- Implement and maintain database hardening baselines and encryption, including Transparent Data Encryption (TDE) and its key management
- Ensure databases comply with security policies and standards, including periodic account reviews, and close vulnerability and audit findings on schedule
- Act as L3 escalation point: troubleshoot integrity, performance, blocking, deadlock, connectivity and security issues, and lead root-cause analysis with users and vendors
- Plan and lead maintenance windows, including after-office-hours work, with proper change control and stakeholder communication
- Work with the privileged access and virtualisation teams, requesting DB account onboarding and VM resources and following their processes
- Collaborate with the Server, Data Center and Network teams on shared changes and incidents
- Document database policies, architecture and design artefacts, plus runbooks, KBs and topology diagrams
- Provide technical expertise and solutions for database-related projects, and recommend platform roadmap improvements
- Set database standards and best practices, and mentor junior engineers

Requirements:

- Candidates need 6+ years of hands-on DBA experience, strong DB2 and MSSQL skills, and the communication and teamwork to work well across several technical teams.
- Singaporean only.

Technical

- 6+ years of hands-on DBA experience, with strong working knowledge of both DB2 and MSSQL, supporting PROD, DR, and UAT environments
- Proven experience building and supporting Always On Availability Groups in production
- Hands-on experience with Transparent Data Encryption (TDE), including encryption key and certificate management
- Experience developing and applying database hardening standards, security policies and procedures, and remediating vulnerabilities
- Strong experience in backup and recovery, database migration and cloning, and evaluating and installing new releases, patches and upgrades
- Strong troubleshooting skills for integrity, performance, blocking, deadlocking, connectivity and security issues
- Experience producing performance and health reports using native tools and scripts
- Strong knowledge of Windows and Unix/Linux operating systems
- Familiarity with CyberArk (PAM) and VMware vCenter, enough to work with those teams. No administration of either is expected.
- Experience with other RDBMS, NoSQL or cloud platforms is an advantage

Working style

- Strong team player who shares knowledge, supports colleagues and works well across Server, Data Center and Network teams
- Good written and spoken English, able to explain issues, risks and changes clearly to engineers, vendors and non-technical stakeholders
- Strong documentation skills for processes and procedures, including KBs, runbooks and topology diagrams
- Disciplined approach to change control, working with users and vendors to resolve issues promptly within service levels
- Proactive in keeping stakeholders updated during incidents and maintenance windows
- Willing and able to work after-office-hours maintenance windows as scheduled, including nights and weekends where required

Certifications:

Preferred

- IBM Certified Administrator for Db2
- A relevant Microsoft SQL Server certification
- ITIL 4 Foundation

Good to have (cloud)

- Microsoft Certified: Azure Database Administrator Associate (DP-300)
- AWS Certified Database – Specialty, or an equivalent cloud certification
#LPS