Requirements
Requires 8+ years of hands-on experience in database administration, performance tuning, backup/recovery, high availability, disaster recovery, and production support for both Oracle Database and Microsoft SQL Server environments. Must have strong expertise in Oracle RMAN, Data Pump, RAC, Data Guard, and performance tuning, as well as SQL Server Always On Availability Groups, T-SQL, and performance monitoring. Responsibilities include installation, configuration, monitoring, troubleshooting, security implementation, and documentation.
Description
Avensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation and managed services. Given our decade of success we have evolved to become one of the top trusted providers in Singapore and service a client base across banking and financial services, insurance, information technology, healthcare, retail and supply chain.We are seeking an experienced DBA Admin (Oracle & MSSQL) with 8+ years of hands-on experience in database administration, performance tuning, backup/recovery, high availability, disaster recovery, and production support. The ideal candidate should have strong expertise in both Oracle Database and Microsoft SQL Server environments and be comfortable supporting mission-critical production databases.Key ResponsibilitiesInstall, configure, upgrade, patch, and maintain Oracle Database and Microsoft SQL Server environments.Perform database administration activities including users, roles, privileges, tablespaces, datafiles, schemas, indexes, and database objects.Monitor and troubleshoot database performance, identify bottlenecks, and perform SQL/query and database performance tuning.Manage Oracle RMAN backup/recovery, Data Pump (expdp/impdp), and SQL Server backup and restore operations.Implement and support Oracle Data Guard, RAC, and disaster recovery solutions.Manage SQL Server Always On Availability Groups, Failover Clustering, Replication, Log Shipping, and Database Mirroring.Perform database upgrades, migrations, patching, refreshes, cloning, and environment synchronization.Monitor database health, capacity, storage, sessions, locks, jobs, and alerts; proactively resolve issues.Handle production incidents, root-cause analysis, problem management, and change activities in accordance with defined SLAs.Implement database security, access controls, auditing, and compliance standards.Develop and maintain database monitoring, maintenance, backup, and recovery procedures.Collaborate with application, infrastructure, development, and cloud teams to resolve database-related issues.Maintain technical documentation, operational procedures, and disaster recovery runbooks.Required Technical SkillsOracle:Oracle 11g/12c/18c/19c or higherRMAN, Data Pump, SQL*LoaderRAC and Data GuardPerformance tuning, AWR/ASHTablespace, datafile, user and privilege managementDatabase upgrades, patching, backup and recoveryMicrosoft SQL Server:SQL Server 2012/2014/2016/2017/2019/2022T-SQL and query optimizationAlways On Availability GroupsFailover ClusteringReplication and Log ShippingBackup, restore and recoverySQL Server performance monitoring and troubleshootingThe candidate should have 8+ years of DBA experience, with strong hands-on expertise in both Oracle and MSSQL, particularly in production support, performance tuning, backup/recovery, high availability, disaster recovery, upgrades, and database security. The responsibilities above align with standard Oracle DBA administration areas and commonly required Oracle/MSSQL production skills.WHAT'S ON OFFER:You will be remunerated with an excellent base salary and entitled to attractive company benefits. Additionally, you will get the opportunity to enjoy a fun and collaborative work environment, alongside a strong career progression.To submit your application, please apply online or email your UPDATED CV in Microsoft Word format to [HIDDEN TEXT] Your interest will be treated with strict confidentiality.CONSULTANT DETAILS:Consultant Name : Neelu SharmaAvensysConsultingPteLtdPrivacy Statement: Data collected will be used for recruitment purposes only. Personal data provided will be used strictly in accordance with the relevant data protection law and Avensys privacy policy.