Cedar Gate Services Pvt. Ltd, Nepal, provides software research & development, data analytics, IT infrastructure management and various support services for Cedar Gate Technologies, USA. We employ 600+ professionals in our Sanepa office. For more information, visit company website at https://cedargate.com/ and follow our FB page at https://www.facebook.com/CGTNepal

Database Administrator

Views: 1247 | Apply Before: 1 week, 5 days from now

Basic Job Information

Job Category	:	IT & Telecommunication
Job Level	:	Mid Level
No. of Vacancy/s	:	[ 1 ]
Employment Type	:	Full Time
Job Location	:	Lalitpur, Nepal
Offered Salary	:	Negotiable
Apply Before(Deadline)	:	Dec. 10, 2023 23:55 (1 week, 5 days from now)

Job Specification

Education Level	:	Under Graduate (Bachelor)
Experience Required	:	More than or equal to 2 years

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.