Database Administrator (Pathum Thani/Chonburi)
About this position
This position will be a part of a team responsible for providing the planning, coordination, utilization and administration of Database. The job includes implementation, backup, recovery, monitoring and troubleshooting and resolving Database server problem.
Responsibilities
• Installing or upgrading SQL Servers (both OS and Database level).
• Patching up the database Servers after installing to make sure that the Oracle, SQL and another Database Server is properly patched with the correct Service Pack.
• Ensure all database servers are backed up in a way that meets the Recovery Point Objectives (RPO).
• Test backups/Restores to ensure we can meet the Recovery Time Objectives (RTO) the database server.
• Ensures the integrity of database files through the daily monitoring of database backups, logs, and transaction statistics.
• To proactively monitor the database systems to ensure that the Oracle, SQL Servers, and Another Database Server have minimum downtime with no / minimum impact on business.
• When performance issues arise, determine the most effective way to increase performance including server configuration changes, index/query changes, or hardware purchases.
• Troubleshoot MSSQL Server service outages as they occur, including after-hours and weekends.
Requirements
• Education: B.Sc., B.Eng. (Computer) or related field.
• Experience: 3+ years.
• Experience with Database Administration for MSSQL Server, Oracle Database Server.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
• Experience in troubleshooting and resolving database problems.
• Knowledge of SQL Transactional, and stored procedures, indexes, index management, and statistics.
• Experience with Performance Tuning, and Query Optimization.
• Ability to detect and troubleshoot SQL Server related CPU, Memory, I/O, Disk space and other resource contention.
• Experience in implementing operational automation using scripts.
• Knowledge with backups, restores and recovery models.
• Proficient in Backup/Recovery, troubleshooting and monitoring of databases for a 7X24 hour operation.
• Experience working with Windows Server, Linux Server and also Open-source Database such as PostgreSQL.
• Documentation skills for processes and procedures.
• Fluent in both written and spoken English.
• Communication, since the DBA has to interact with different teams, so has to be very good and effective in communication.
• Like supporting, capable of understanding system monitor & maintenance and flexible to work both individual or in a small team of professional to contribute ideas.