Job Description

Oracle Database Administrator:

• 4+ years of 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

Microsoft SQL Server Database Administrator:

• 4+ years of experience in supporting Microsoft SQL Server environments PROD/DR/DEV/QA/UAT

• Strong experience in Database Administration in Microsoft SQL Server versions ( 2005,2008,2008 R2, 2012, 2014 , 2016 ,2017 & 2019)

• Experience on Failover Clustering Instances, Database Mirroring, Replication ,Log shipping, AlwaysOn Availability Group -configuration and troubleshoot issues

• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues

• Experience in Performance Tuning, Query Optimization, optimize databases ,using Performance Monitor, SQL Profiler, capacity planning, Installation, migration and other related monitoring and troubleshooting.

• Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.

• Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands and recovery on database failure

• Strong knowledge of indexes, index management, integrity checks, configuration, patching, upgrade management.

• Knowledge of SQL Server tools ( Profiler, DTA, SSMS, DAC)

• Solid acquaintance with windows server, security delegation, SPNs, storage components and enforcing security standards for databases

• Daily health monitoring of database system and data integrity checks

• Collect and analyze 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

Ref ID: 38251

Location:

Singapore, 01, SG, 0

Business Unit: Lenovo PCCW Solutions

Full Time/ Part Time: Full Time

Job Function: Technical

Featured Job Category::