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.
