[LPS] Oracle Database Engineer
Why Work at Lenovo
Description and Requirements
Lenovo PCCW Solutions (LPS) is a leading IT and technology solutions provider in the Asia Pacific region. We partner with governments and enterprises to achieve digital transformation excellence, driving business growth through our market-leading solutions and industry best practices. As a proud member of Lenovo Group, we have unlocked new synergies with Lenovo’s global reach and technological capabilities, focusing on AI, data practice and cloud. With our 4,000+ team of domain experts and a strong network of ecosystem partners, LPS is committed to providing cutting-edge AI-powered solutions and data practice to enable organizations excel in their digital journey.
Oracle Database Administrator- In this new 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:
• Maintain high availability and reliability of databases
• Perform daily Health Check, database maintenance and database security self-assessment.
• Perform database creation, configuration and migration, apply patches and technology upgrade to keep the databases at supported level
• Database Capacity Planning
• Ensure that the database assets and systems are managed in accordance with the security policies and standards [This includes Account Reviews]
• Responsible for documenting database related policy, architecture and design artefact.
• Provide technical expertise and solutions based on user requirements for database-related project.
You Bring:
• Experience in supporting Oracle Database environments PROD/DR/DEV/QA/UAT
• Strong experience in Database Administration in Oracle version (11g/12c/18C/19C)
• Experience in supporting high availability Oracle RAC environment (2/3/4 node clusters), Oracle Golden Gate, Oracle Data Guard
• 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
