Database Administrator (Layer 2)

Job Description

Tasks and Responsibilities :

• Maintain, manage, and optimize databases using SQL Server
• Perform database tuning, including analyzing execution plans, optimizing slow queries, and ensuring efficient use of resources.
• Continuously monitor database health, performance metrics, and system logs using relevant tools.
• Identify and troubleshoot performance issues
• Set up and maintain alerts for potential issues such as slow queries, locking, or resource bottlenecks.
• Conduct SQL query optimization, indexing strategies, and partitioning for performance improvement.
• Configure Data Guard and Clustering
• Monitor major data movement processes
• Back up information for data recovery
• Provide database support to employees as needed

Requirements :

• Bachelor’s degree in computer engineering or computer science.
• Minimum 3 years experience as a Database Administrator
• Expert in SQL-based databases, especially SQL Server
• Experience in Ms SQL Server and PostgreSQL will be advantage
• Expert in creating Queries, Stored Procedures and Triggers Knowledge of database backup procedures and recovery systems
• Complete SQL and other shell scripting
• Excellent communication and problem-solving skills
• Experienced with Replication, Clustering, Tuning, Query Optimization, Database Link, Monitoring, Database Security
• Experience with Linux/Unix and Windows operating systems
• Analytical skills
• Technical communication skills