Job Description

[LPS] DB2 Database AdministratorGeneral InformationReq #WD00068927Career area:ServicesCountry/Region:SingaporeState:Central SingaporeCity:SINGAPOREDate:Wednesday, August 14, 2024Working time:Full-timeAdditional Locations:

• Singapore - Central Singapore - Singapore

Why Work at LenovoWe are Lenovo. We do what we say. We own what we do. We WOW our customers.Lenovo is a US$62 billion revenue global technology powerhouse, ranked #217 in the Fortune Global 500, employing 77,000 people around the world, 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 by further expanding into growth areas that fuel the advancement of \'New IT\' technologies (client, edge, cloud, network, and intelligence) including server, storage, mobile, software, solutions, and services.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 , and read about the latest news via our .Description and RequirementsDatabase Administrator- In this role, you will be provided DBA services to application development teams, including database design, database generation, coding, and database production support. Provide DBA support with a high degree of customer service, technical expertise, and timeliness. Provide accurate and creative solutions to user problems of moderate nature to ensure user productivity.You Will:Database Management:

• Design, install, configure, and maintain database systems to ensure the availability, reliability, and performance of the databases.
• Monitor database performance and tune the database as necessary to ensure efficient performance.
• Plan and implement backup and recovery of the database.
• Manage database users and maintain data integrity and security.

Development and Implementation:

• Collaborate with developers and other IT team members to design and implement database solutions that meet business requirements.
• Develop database documentation, including data standards, procedures, and definitions for the data dictionary.
• Perform data modeling and database design.

Maintenance and Support:

• Troubleshoot and resolve database issues, including performing root cause analysis and recommending solutions.
• Apply patches and upgrades to the database software as needed.
• Ensure databases are compliant with organizational standards and best practices.

Security and Compliance:

• Implement and maintain database security measures to protect data from unauthorized access.
• Ensure compliance with data protection regulations and corporate policies.

Performance Monitoring and Optimization:

• Conduct regular performance tuning and capacity planning to ensure optimal performance.
• Analyze and implement techniques to optimize database performance.

You Bring:

• Experience in supporting Database environments PROD/DR/DEV/QA/UAT
• Strong experience in Database Administration in DB2/Oracle/MySQL
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues
• Strong Knowledge in Operating systems like windows and Unix
• Generating reports in Oracle database using tools like AWR, ASH, ADDM and manual scripts.
• Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the Oracle.
• Strong Experience of RMAN, expdp/impdp, Backup/Recovery
• Experience in evaluating and Installing new software releases, patches, upgrade and Database cloning
• Experience in developing and executing database security policies, procedures
• Daily health monitoring of database system and data integrity checks
• Collect and analyse database performance information, identify and implement solutions for performance problems
• Experience with other RDBMS, NO SQL, cloud platforms will be added advantage
• Good communication skills English (written, spoken) and Documentation skills for processes and procedures (creating KBs, runbooks, topology)
• Work with users, vendors to take timely and appropriate steps to resolve and troubleshoot issues impacting service levels and conduct root cause analysis

Additional Locations:

• Singapore - Central Singapore - Singapore

• Singapore

• Singapore - Central Singapore

• Singapore - Central Singapore - Singapore

Lenovo