Job summary:
The Database Administrator will be responsible for the overall installation, configuration, troubleshooting, support and maintenance of SQL server 2008/2012 for primary site and disaster recovery site in Kabul. The administrator will spend their time performing day-to-day management of Microsoft SQL Server database environments, including backup and recovery, database optimization, database replication and log shipping User management, and performance tuning.
The SQL Server DBA will be reporting to General / Deputy General Manager –Database.
Job Description:
- Responsible for the overall Microsoft SQL server 2003/2008 and 2012 database installation, administration, maintenance and support in MS SQL Server environments. And work as backup of Oracle DBA after in-house knowledge sharing and training in Oracle.
- Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
- Responsible for all functions associated with the design, implementation and maintenance of SQL Server databases including security, back-up, logging, reporting and recovery procedures
- Perform Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
- Ability to backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
- Ability and knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
- Working experience of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, and PerfMon).
- SQL Development – ability to write and troubleshoot SQL Code and design ( stored procedures, functions, tables, views, triggers, indexes, constraints )
- Solid acquaintance with windows server, security delegation, SPNs, storage components.
- Knowledge sharing with fellow team members.
- Any other task assigned by direct supervisor, CIO or DCIO.
- Develop, implement and timely review Application/Website related policies and suggest changes to IT management according to current technological challenges and threats.
- Ensure checkup of all the Applications and on call availability 24/7 and ensures 100% uptime and work as a team
