Solaire Resort Entertainment City | Full time
The Sr. Database Engineer is responsible for providing day to day management, capacity planning, performance optimization, incident resolution and overall support for database systems including systems running on the platform.
This position is an escalation point for critical core gaming systems and related outages. Provides assistance and monitoring across all IT projects using or interfacing with MSSQL, MySQL, Oracle, PostgreSQL, DB2 and MongoDB and ensuring that the outcomes of work are delivering the most effective and robust to run business applications.
ESSENTIAL DUTIES AND RESPONSIBILITIES
- Setups, maintains and monitor of high availability of database servers
- Closely work with production support team in setting up testing environments, review of test plans and test cases, investigation of technical issues raised
- Provide capacity planning of database server hardware resources
- Ensure all server issues are addressed within a service level agreement (SLA)
- Suggests and implements process and systems improvement
- Work closely with the network team on company security policy
- Creates and monitors backup strategy
- Daily monitors system logs and provide root cause analysis of errors
Requirements
QUALIFICATION AND REQUIREMENTS:
- Bachelor’s degree in Computer Engineering, Information management or equivalent
- At least 5 years total career experience handling hundreds of servers and databases on a 24/7 environment
- Successful implementation of Infrastructure rollout, upgrades, administration and decommission with relation to databases
- Demonstrated migrations of databases to newer versions
- Successfully implemented different high-availability solutions, business continuity and disaster recovery
- Strong and proven competencies on Microsoft SQL, MySQL (InnoDB Cluster, Master-Slave replication), Oracle (RAC, Dataguard) and PostgreSQL (PostgreHA)
- Strong experience in performance monitoring, database optimization and index tuning
- Experience in other databases such as DB2 and MongoDB is a plus
- Experience and exposure in different Cloud Database technologies (GCP, AWS and Azure)
- Experience in BCP/DR configuration and monitoring including backup and recovery scenarios
- Adequate exposure in Data Warehousing, Stored Procedure optimization, SQL Server optimization, and Disk space optimization for performance (RAID and SAN)
- Experience with Virtualization Technologies is preferred
#J-18808-Ljbffr