Other Specification:

• Bachelor's degree or equivalent in Computer Science, Information Technology, or a related field 
• 2+ years of relevant experience  
• Expertise in Amazon Redshift/MySQL/MariaDB/MSSQL  
• Strong knowledge of database design, administration, and architecture 
• Experience with replication and cluster configuration in MySQL/MariaDB, MSSQL 
• Experience with MSSQL high availability configuration and monitoring 
• Experience with backups, restores, and recovery models 
• Strong knowledge of stored procedures and query optimization 
• Knowledge and understanding of all aspects of database tuning: software configuration, memory usage, data access, data manipulation, SQL, and physical storage 
• Ability to develop procedure documents and maintain detailed database-related documents 
• Good analytical, time management, troubleshooting, and decision-making skills 
• Excellent written and verbal communication skills.

Job Description:

Cedar Gate Technologies is looking for a Database Administrator in the infrastructure department to maintain, monitor, and administer the company’s databases. 

Job Responsibilities:

• Provision MySQL/MariaDB, MSSQL instances, both in clustered and non-clustered configurations, HA groups. 
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. 
• Manage Production, QA, and development database environments. 
• Learn relevant business processes and understand the data flow, criticality, and dependencies. 
• Minimize database downtime and manage parameters to provide fast query responses. 
• Enroll users, maintain system security, and monitor user access to databases. 
• Database version upgrades and security patching to comply with security. 
• Allocate system storage and plan storage requirements for database systems. 
• Refine and automate regular processes, track issues, and document changes. 
• Perform periodic health checks and reports on database systems. 
• Develop innovation, strategies, processes, and best practices. 
• Configure and maintain Amazon Redshift clusters. 
• Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, and security issues.

Source: Merojob

Job Detail Expired

Contact Detail