About the role
Database Management (SQL Server & Oracle)
... - Manage the full lifecycle (installation, configuration, patching, and upgrades) of MS SQL Server (2016+) and Oracle (12c/19c) instances across hybrid cloud environments.
- Implement and maintain robust High Availability/Disaster Recovery (HA/DR) solutions, including SQL Always On Availability Groups, Oracle Data Guard, Log Shipping, and Replication.
- Execute secure database migration strategies to AWS RDS and EC2 using best practices.
- Conduct proactive performance tuning, query optimization, and indexing strategies for all core database platforms.
- Enforce stringent database security measures, including access control, data encryption, and auditing.
Cloud and Automation
- Expertly provision, configure, and maintain AWS RDS instances for SQL Server and Oracle 19c.
- Provide operational support for NoSQL databases, such as DynamoDB and MongoDB.
- Automate routine and complex administrative tasks using advanced T-SQL, PL/SQL, and PowerShell scripting.
- Monitor database health, performance, and alerting using cloud-native tools like AWS CloudWatch and Azure Monitor.
- Manage parameter groups, backup retention, snapshots, and complex restoration operations within RDS.
Skills and Experience required
- Minimum 5 years of total DBA experience, with a strong focus on MS SQL Server and 2+ years of hands-on Oracle 12c/19c administration.
- Proven expertise in Cloud DBA responsibilities, specifically managing AWS RDS (SQL Server and Oracle) and providing support for NoSQL databases.
- Strong proficiency in T-SQL, PL/SQL, and PowerShell for automation and administration.
To apply online please use the apply function, alternatively you may contact Chloe Chen at chloe.chen(@)randstad.com.sg. (EA: 94C3609 /R1768253)
show more
About the role
Database Management (SQL Server & Oracle)
- Manage the full lifecycle (installation, configuration, patching, and upgrades) of MS SQL Server (2016+) and Oracle (12c/19c) instances across hybrid cloud environments.
- Implement and maintain robust High Availability/Disaster Recovery (HA/DR) solutions, including SQL Always On Availability Groups, Oracle Data Guard, Log Shipping, and Replication.
- Execute secure database migration strategies to AWS RDS and EC2 using best practices.
- Conduct proactive performance tuning, query optimization, and indexing strategies for all core database platforms.
- Enforce stringent database security measures, including access control, data encryption, and auditing.
Cloud and Automation
- Expertly provision, configure, and maintain AWS RDS instances for SQL Server and Oracle 19c.
- Provide operational support for NoSQL databases, such as DynamoDB and MongoDB.
- Automate routine and complex administrative tasks using advanced T-SQL, PL/SQL, and PowerShell scripting.
- Monitor database health, performance, and alerting using cloud-native tools like AWS CloudWatch and Azure Monitor.
- Manage parameter groups, backup retention, snapshots, and complex restoration operations within RDS.
Skills and Experience required
- Minimum 5 years of total DBA experience, with a strong focus on MS SQL Server and 2+ years of hands-on Oracle 12c/19c administration.
- Proven expertise in Cloud DBA responsibilities, specifically managing AWS RDS (SQL Server and Oracle) and providing support for NoSQL databases.
- Strong proficiency in T-SQL, PL/SQL, and PowerShell for automation and administration.
...
To apply online please use the apply function, alternatively you may contact Chloe Chen at chloe.chen(@)randstad.com.sg. (EA: 94C3609 /R1768253)
show more