Database Administrator

Duties and Responsibilities: • Manage and perform administrative tasks on databases (Microsoft SQL, Oracle, MySQL) running on Windows & Linux platforms. • Monitoring the health of the databases, and perform trouble-shooting to identify and resolve any reported issues. • Install, configure and setup databases for application use. • Perform upgrade of databases and/or migration of databases from one product to another. • Perform database refresh across different environments. • Perform tuning and optimization activities to improve database performance and utilization of storage space. • Involve in the hardening of cloud databases like Azure SQL. • Monitor and manage data replication, including execution of database switchover for Disaster Recovery (DR) exercises. • Perform database maintenance, including applying and validating of security & critical patches. • Manage database security, and engage in process improvement such as automation of tasks and procedures. • Execute and provide technical support for the deployment of application fixes and/or changes in relation to the database. • Participate in system audits, adhere to the internal security standards. • Manage and co-ordinate with 3rd party vendors to troubleshoot and resolve problems. • Ensure availability and continuity of database services. • Involve in incident, problem, change and service request management. Requirements: • Diploma / Degree in Information Technology or equivalent with at least 5 years of experience in infrastructure support. • Minimum 5 years’ experience of MS SQL/MYSQL and Oracle DB Server. • Experience and understand with Azure Cloud, AAD, IAAS, PAAS, SAAS and etc. • Proficient in Database installation, configuration on Linux / Windows/Azure platforms. • Experience in Database High Availability setup using Oracle Dataguard, SQL Server Failover Replication/Mirroring Availability Groups, MySQL Cluster • Good database performance tuning, troubleshooting skills and locating bottlenecks at both server and database level. • Familiar with database partitioning design, Data warehouse, TDE encryption and implementing security standards to secure critical environments. • Disaster Recovery implementations based on Oracle Dataguard. /SQL server /MYSQL Work with infrastructure team on upgrades, patching and resolution of cross functional issues. • Knowledge on SAP, CCNB, CRM, Oracle JDBC, ODP.Net, UCP, TAF, FCF, and MySQL Connectors. • Provide deployment support for database objects in production and UAT environments. • Provide 24x7 production database support and willing to work after office hours / weekends. Experienced with standard database monitoring tools. • Experience in Linux and Windows Shell scripting and PL/SQL Programming Required Skills: • Strong troubleshooting skills • Strong documentation and organizational skills • Independent worker with minimum supervision • Good team player and process driven • Good verbal and written communication skills