Robotico Digital - Database Administrator - SQL/MySQL

Description :

You will be a member of the Infra Operation & Cyber Security team reporting to the IT Server Ops Team Lead.

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