Cloud Database Administrator - Singapore - Rapsys Technologies

Rapsys Technologies

Verified Company

Singapore

2 weeks ago

Posted by:

Wei Jie

beBee Recruiter

Has 5+ years' experience in Oracle Database Management ( 9i/10g/11g/12c )

Experience in Backup / Recovery
Hands on experience in Installation of high availability Oracle RAC environment (2/3/4 node clusters)
Proven expertise in supporting Grid Infrastructure (Clusterware, ASM, Disk Groups), Private Network for Interconnect and Public Network (VIP, SCAN),
OCR and Voting Disk, Cluster verify utility (cluvfy)
Installation, Configuration, administration and operations support of Oracle Golden Gate
Knowledge in supporting Exadata Database Machine
Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, OEM Grid Control and manual scripts.
Install, configure and manage Oracle on Unix & MicroSoft Windows.
Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the Oracle in 24 X 7 environment
Database administration for a critical Oracle Exadata
Strong Experience of RMAN, Data Guard, Grid Control
Experience evaluating and installing new software releases, patches and system upgrades
Knowledge and understanding of all aspects of database tuning: software configuration, memory usage, data access, data manipulation, SQL, and physical storage
Experience developing and executing database security policies, procedures and auditingexperience with database authentication methods, authorization methods, and data encryption techniques
Establish and maintain documentation and standards
Work as part of a team and provide 24x7 support when required

MSSQL:

2+ years of experience in database management and support in MS SQL Server environments.
Strong experience in Database Administration in SQL Server ( 2005, 2008, 2012 & 2014 )
Experience on Clustering, Database mirroring, Replication and log shipping configuring and troubleshoot issues.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues,
Replication issues, log shipping issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
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
Expert experience in implementing operational automation.
Strong knowledge of indexes, index management, integrity checks, configuration, patching, statistics, created and managed effectively.
Knowledge of SQL Server tools ( Profiler, DTA, SSMS, DAC)
SQL Development ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
Solid acquaintance with windows server, security delegation, SPNs, storage components.
Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
SQL Database Operational support to tech users"