Database Administrator

Job Description

To administer and maintain databases, ensuring their availability, security, and optimal performance, while supporting other teams with data management and recovery needs.

Job Requirements

• Bachelor's degree in Computer Science, or closely related field.
• 4+ years of IT experience in MS SQL Server Database Administration.

Responsibilities

• Installation, Configuration and upgrade of MS SQL Server.
• Designing, implementation and configuration of SQL Server Replication.
• Applying SQL patching.
• Plan, execute and support implementations so the applications are deployed with minimal disruption to the production environment and meet established standards.
• Perform and review health checks, identify and escalate trends. Act on all DBs level alerts and assist with service restoration.
• Troubleshooting & investigating. Assisting with root cause analysis and remediation via review of logs & code logic.
• Designing the architecture of the database and can forecast the future requirements and demands.
• Prepare detailed documentation including diagrams of database infrastructure.
• Monitor all DBs execution and sustain full proof processes in line with business needs.

Skills

• Knowledge about Linux OS and Windows OS.
• Experience with backups, restores and recovery models.
• Experience in troubleshooting and resolving performance issues, blocking and deadlocking etc.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Ability to write and troubleshoot SQL queries and codes (stored procedures, functions, tables, views, triggers, indexes, constraints).
• Knowledge of implementing DR and SQL failover solutions.
• Knowledge about SSIS packages.
• Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.
• Knowledge about OpenSources PostgreSQL, MySQL – Preferred.