323 Senior Dba jobs in Singapore

Mandatory Skill: MS SQL DBA, Always-on, Performance Tuning

Core Database Administration

• Manage and maintain SQL Server instances across development, QA, and production environments.

• Configure and support Always-On Availability Groups, failover clusters, and other HA/DR solutions

• Perform database installations, upgrades, patching, and migrations across SQL Server versions (2008–2019)

• Conduct performance tuning using indexing strategies, query optimization, and monitoring tools like SQL Profiler and Extended Events

Mandatory Skill : MS SQL DBA, Always-on, Performance Tuning

Core Database Administration

• Manage and maintain SQL Server instances across development, QA, and production environments.

• onfigure and support Always-On Availability Groups, failover clusters, and other HA/DR solutions

• P rform database installations, upgrades, patching, and migrations across SQL Server versions (2008–2019)

• Con uct performance tuning using indexing strategies, query optimization, and monitoring tools like SQL Profiler and Extended Events

Mandatory Skill: MS SQL DBA, Always-on, Performance Tuning

Core Database Administration

• Manage and maintain SQL Server instances across development, QA, and production environments.

• Configure and support Always-On Availability Groups, failover clusters, and other HA/DR solutions

• Perform database installations, upgrades, patching, and migrations across SQL Server versions (2008–2019)

• Conduct performance tuning using indexing strategies, query optimization, and monitoring tools like SQL Profiler and Extended Events

Requirement

• Diploma/Degree in Information Technology or equivalent
• At least 4 years of relevant experience
• Skills on SQL Administration, Microsoft SQL Server

Responsibilities

• Service database changes through change request process & provide status reports to the relevant parties.
• Performance Tuning
• Respond promptly to incident, investigate & provide temporary &/or permanent resolution of incidents escalated and provide timely status updates to relevant parties.
• Monitor & measure the performance & availability of databases proactively; implement corrective actions identified to improve performance & availability.
• Monitor the agreed service level, document & maintain the configuration of the databases; provide regular reporting to relevant parties.

Interested applicants, please send your updated resume MS Word to

Please Indicate Job Code 109 "SQL DBA" on the email subject

We regret that only shortlisted candidates will be notified.

Garcia Diana Rosario (Reg. No. R )

IT Consultancy & Services Pte Ltd

EA No: 92C5311

Please visit to learn more information about ITC

Key responsibilities:

• Manage, maintain, and optimise Oracle database environments

• Implement and manage Oracle RAC environments

• Perform database installations, upgrades, and patches

• Implement and manage backup and recovery strategies

• Monitor database performance and tune for optimal efficiency

• Ensure high availability and disaster recovery readiness

• Automate common database maintenance tasks

• Collaborate with development teams to ensure efficient database design

• Implement and maintain database security measures

• Ensure compliance with data protection regulations

• Conduct regular security audits and implement best practices

Qualifications:

• Bachelor’s degree in computer science, Information Technology, or related field

• Minimum 5 years of experience as an Oracle DBA

• Oracle Certified Professional (OCP) certification

• Proven experience implementing and managing Oracle RAC

• Proficiency in scripting languages (e.g., Shell, Python, Perl) for automation

Preferred Skills:

o Oracle Certified Master (OCM) certification

o Knowledge of DevOps practices and tools

o Familiarity with database compliance standards (e.g., PCI DSS, HIPAA)

o Experience with other database technologies (e.g., MySQL, PostgreSQL)

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

Select how often (in days) to receive an alert:

• Develop and update all necessary DB documentation (including checklist, operations manual and relevant changes to configuration settings) and DR setup
• Report monthly on database size and DB Uptime and Performance
• Generate ad-hoc non-standard reports for incident/problem investigations, DB capacity planning or audit purposes
• Create new DB creations, database network configuration, determine/adhere to guidelines for database structures and file layout, review and enhance scripts and procedures, proper management of transaction and redo/archive logs
• Assist in database purging and collaborate with Solutions Team to define the purging policy for each individual system, database re-indexing and database tuning, if required
• Review daily on log irregularities and follow-up actions
• Monitor the performance to discover and detect from on-start, the possible system anomalies which may impact business operations. This shall include system resource usage, Basic CPU utilization, Disk I/O, Basic network I/O, memory utilization of database buffers, shared pool, memory cache, inefficient SQL, long running queries, in-doubt transactions, temporary table space usage, job query analysis, lock and latch analysis, alert log errors, availability of required start-up services/components for low disk space/archive logs, blocking locks, core dump, interfaces and batch-jobs
• Monitor backups, recovery and replication for successful completion
• Data Management
• Monitor object fragmentation, invalid objects and extent of failure detection
• Perform Disaster Recovery (DR) for all the critical systems and ensure successful rebuilt of Production or DR servers, if necessary
• Incident detection and confirmation of production database systems shall include timely escalation to the Managed Helpdesk, and performing the DBA onsite services on physical database facilities, to rectify the incidents with root cause analysis in order to ensure permanent resolution
• Verify and validate databases backup, recovery and replication status
• Review, improve and document the database administration and operational guide on new or revised processes and procedures regularly
• Work with customers/clients, service desk and third-party solutions vendor to resolve on the disrupted service and rectify the database integrity for the users promptly, to minimize business impact. This shall include applications that are undergoing upgrades.
• Assist the Operations and Project Lead on the issues related to database in daily operations or new projects implementation
• Any other ad-hoc duties as required or assigned

Job Requirements:

• Diploma / Degree in Information Technology, Computer Science or equivalent
• 7 - 10 years of experience in Oracle DBA or Microsoft SQL server
• Possess hands-on technical exprience for L1 - L3 support

Select how often (in days) to receive an alert:

• Develop and update all necessary DB documentation (including checklist, operations manual, and relevant changes to configuration settings) and DR setup.
• Report monthly on database size and DB uptime and performance.
• Generate ad-hoc non-standard reports for incident/problem investigations, DB capacity planning, or audit purposes.
• Create new DB creations, database network configuration, determine/adhere to guidelines for database structures and file layout, review and enhance scripts and procedures, and manage transaction and redo/archive logs properly.
• Assist in database purging and collaborate with Solutions Team to define the purging policy for each individual system, database re-indexing, and database tuning, if required.
• Review daily log irregularities and follow-up actions.
• Monitor performance to discover and detect possible system anomalies that may impact business operations, including system resource usage, basic CPU utilization, Disk I/O, basic network I/O, memory utilization of database buffers, shared pool, memory cache, inefficient SQL, long-running queries, in-doubt transactions, temporary table space usage, job query analysis, lock and latch analysis, alert log errors, availability of required start-up services/components for low disk space/archive logs, blocking locks, core dump, interfaces, and batch-jobs.
• Monitor backups, recovery, and replication for successful completion.
• Data management.
• Monitor object fragmentation, invalid objects, and extent of failure detection.
• Perform Disaster Recovery (DR) for all critical systems and ensure successful rebuild of Production or DR servers if necessary.
• Incident detection and confirmation of production database systems, including timely escalation to the Managed Helpdesk and performing onsite DBA services to rectify incidents with root cause analysis for permanent resolution.
• Verify and validate databases backup, recovery, and replication status.
• Review, improve, and document the database administration and operational guide on new or revised processes and procedures regularly.
• Work with customers/clients, service desk, and third-party solutions vendors to resolve disrupted services and rectify database integrity for users promptly to minimize business impact, including applications undergoing upgrades.
• Assist the Operations and Project Lead on issues related to the database in daily operations or new project implementation.
• Any other ad-hoc duties as required or assigned.

• Diploma/Degree in Information Technology, Computer Science, or equivalent.
• 7 - 10 years of experience in Oracle DBA or Microsoft SQL Server.
• Possess hands-on technical experience for L1 - L3 support.

• Install, configure, and upgrade Oracle database software (single instance and RAC environments).
• Plan and execute patch management, including security and version upgrades.
• Design and implement high-availability and disaster recovery strategies (e.g., Oracle Data Guard, RMAN).
• Manage Oracle ASM, storage configurations, and interaction with SAN/NAS teams.

• Monitor database health and performance using Oracle Enterprise Manager (OEM) and infrastructure tools (e.g., Nagios, Dynatrace).
• Perform proactive capacity planning and tuning of database servers (memory, CPU, I/O).
• Manage tablespaces, redo logs, undo segments, indexes, partitions, and backups.

• Implement and manage database backup strategies using RMAN and third-party backup tools (e.g., NetBackup, Commvault).
• Conduct regular DR drills and support recovery activities during outages or planned exercises.

• Implement database security policies (user roles, auditing, encryption, patch compliance).
• Collaborate with InfoSec teams for vulnerability scans and remediation.
• Ensure compliance with data protection, GDPR, and regulatory standards.

• Develop shell/Perl/Python scripts for database monitoring, maintenance, and reporting.
• Automate routine tasks and improve operational efficiency.

• Work with infrastructure, storage, network, and application teams for cross-functional support.
• Maintain database documentation, runbooks, change logs, and compliance audit records.

• 5+ years as an Oracle DBA in enterprise-scale infrastructure.
• Expertise in Oracle versions 12c, 19c
• Strong knowledge of Oracle RAC, ASM, Data Guard, and Grid Infrastructure.
• Experience in Linux/Unix environments and shell scripting.
• Familiarity with ITIL processes for incident, problem, and change management.
• Exposure to cloud-based Oracle environments (OCI, AWS RDS, or Azure DB).
• Strong troubleshooting skills and ability to resolve performance and outage issues.

• Oracle Certified Professional (OCP)
• Oracle Certified Expert (OCE) in RAC or Data Guard
• ITIL Foundation

• Excellent communication and documentation skills.
• Ability to work independently and under pressure.
• Strong problem-solving and root cause analysis abilities.

• Create and Administer an Oracle Database, Pluggable Databases
• Configure and Administer Oracle Net Services
• Create and Manage Database Storage
• Handle Database migration
• Manage Automated Maintenance Tasks
• Monitor and Tune Database Performance
• Manage Oracle Database instances, including initialization parameters, and learn to start and stop databases as per operational requirements
• Enforce database security by managing users, roles, privileges, and audit policies to protect data integrity and comply with security standards.
• Configure Oracle Net Services to facilitate communication with Oracle instances

• Bachelor's degree in Computer Science/Information Technology/Engineering
• 2-4 years of experience in Oracle Cloud and Oracle Database administration.
• Understanding of Oracle database architecture and administration.
• Familiarity with Oracle RAC and multitenant architecture.
• Oracle backup and recovery concepts using RMAN, datapump, and export/import.
• Knowledge of Oracle Cloud (OCI), Exadata, and Exadata (ExaCC).
• Good problem-solving skills and ability to work in a team environment.
• Good communication skills and a proactive learning attitude.
• Good in troubleshooting, diagnostics, and analytical tasks.
• Communication and coordination abilities are required, along with initiative and a sense of ownership.

• Exposire to various Unix operating systems and shell scripting.
• Exposure to scripting languages such as Ansible and Python