Senior Database Administrator(Oracle & SQL)

Responsibilities

Database Administration

. Install, configure, and upgrade Oracle (12c/19c/21c) on Windows and Linux servers.

. Install, configure, and maintain Microsoft SQL Server (2016/2019/2022) on Windows platforms.

. Manage database storage structures, users, roles, and access privileges.

. Perform routine database maintenance, patching, and performance tuning.

. Implement and maintain backup and recovery strategies using RMAN (Oracle) and SQL Server native tools.

High Availability & Replication

. Configure, administer, and monitor Oracle Data Guard for disaster recovery and standby database management.

. Implement and support Oracle GoldenGate for real-time data replication and synchronization across heterogeneous environments.

. Configure and maintain SQL Server AlwaysOn Availability Groups for high availability and read-scale solutions.

. Manage SQL Server Failover Cluster Instances (FCI), including cluster setup, node management, and failover testing.

Performance & Optimization

. Analyze and tune SQL queries, indexes, and database performance parameters.

. Troubleshoot slow-running queries and application performance issues.

. Use AWR, ADDM (Oracle) and Query Store, Extended Events (MSSQL) for performance diagnostics.

Security & Compliance

. Enforce database security policies, encryption, and audit mechanisms.

. Ensure compliance with data governance and industry standards (e.g., MAS TRM, ISO 27001).

. Apply regular patches and perform vulnerability remediation activities.

Monitoring & Automation

. Set up proactive database monitoring and alerting using tools such as Oracle Enterprise Manager, SQL Server Management Studio, and third-party monitoring platforms.

. Develop scripts for automation of maintenance, monitoring, and reporting tasks (using Shell, PowerShell, or Python).

Disaster Recovery & Documentation

. Conduct periodic DR drills and validate failover/failback processes.

. Maintain comprehensive documentation for database architecture, configurations, and operational procedures.

. Participate in 24x7 on-call rotation and incident response.

Required skills and qualifications

. Degree/Diploma in Computer Science, Computing, Electrical Engineering, IT or equivalent.

. Good knowledge in one or more of the following platforms and technologies:

a. Database (e.g. MS SQL and Oracle)

b. Big Data (e.g. Hadoop, NoSQL, Hive, Sqoop, Cloudera)

c. Database Activity Monitoring (e.g. Imperva, Guardium, Data Sunrise)

. Good knowledge of Windows platform and Linux platform such as Red Hat and Oracle Linux.

. At least one (1) year experience in installing, configuring or administrating Relational databases, Big data platforms or Database Activity Monitoring tools.

. Strong experience with Oracle Data Guard and Oracle GoldenGate.

. Hands-on experience with SQL Server AlwaysOn Availability Groups and Failover Cluster Instances.

. Proven experience in both Windows and Linux environments.

Technical Skills:

. Oracle Database 12c/19c/21c (RAC, ASM, RMAN, OEM).

. MS SQL Server 2016/2019/2022 (SSMS, SSIS, SSRS, AlwaysOn, FCI).

. Scripting: Shell, PowerShell, Python (for automation).

. Backup tools (NetBackup, CommVault, or equivalent).

. Strong understanding of networking, storage, and OS fundamentals for database performance optimization.

Preferred skills and qualifications

. Oracle and/or MS SQL certifications

. Windows and/or Linux certifications

. ITIL Foundation

Soft Skills

. Strong analytical and troubleshooting skills.

. Excellent communication and documentation ability.

. Team-oriented, with experience working in multi-vendor and cross-platform environments.

. Ability to prioritize and manage multiple tasks under pressure.