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
