Database Administrator

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.

  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