Roles & Responsibilities
Oracle:
Oracle RAC (Real Application Clusters)/ASM (Automatic Storage Management)/OGG (Oracle Golden Gate)/Exadata/ODA
- Has minimally 2+ years’ experience in Oracle Database Management (12c/19c)
- Experience in Backup/Recovery
- Proven expertise in supporting Grid Infrastructure (Clusterware, ASM, Disk Groups
- Installation, Configuration, administration and operations support of Oracle Golden Gate
- Knowledge in supporting Exadata and ODA
- Troubleshooting of Performance and tuning problems in Oracle database using tools like AWR, ADDM
- Install, configure and manage oracle on Unix will be an added advantage
- Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the oracle
- Strong experience of RMAN, 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, SQL and physical storage
- Establish and maintain documentation and standards
- Knowledge of Oracle PL/SQL, Linux shell scripting/PowerShell.
MSQL:
- 2+ years of experience in database management support in MS SQL Server environments
- Strong experience in Database Administration in SQL Server (2014, 2016, 2017)
- 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
- Experience in performance tuning, query optimization, using performance monitor, SQL profiler and other related monitoring
- Ability to detect and troubleshoot SQL server related CPU, memory, I/O, disk space and other resource contention
- Strong knowledge of backups, restore, recovery models, database shrink operations, DBCC commands
- Expert experience in implementing operational automation
- Knowledge of SQL server tools (profiler, SSMS, DAC)
- Strong knowledge of indexes, index management, integrity checks, configuration, patching, statistics, created and managed effectively
- SQL database operational support
- Solid acquaintance with windows server, security delegation, SPNs, storage components
- Configure and maintain dataset server and processes including monitoring of system health and performance
- Experienced in CIS hardening is an added advantage
Education Qualification
- Bachelor’s Degree in Computer Science, Computing, Engineering, IT or equivalent.
Primary Purpose
- Responsible for the day-to-day operational aspects of database administration to meet the business needs and service level
Traits
- Good knowledge of Windows Platform and Linux Platforms such as RedHat and Oracle Linux.
- Good planning and coordination skills.
- Good writing and verbal communication skills.
- Good team player, responsible and conscientious.
- Resourceful, independent, responsive and pro-active
- Assume ownership of database related problems; pursue problem resolution and root cause analysis
- Previous experience with government sector is preferred
