Systems Limited Karachi is looking for a Senior SQL Server DBA

. Core Job Description • Has 5+ years of experience in database development and support in MS SQL Server environments. • Strong experience in Database Administration in SQL Server ( 2005 and 2008 ) • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. • Experience in 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. • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication. • Expert experience in implementing operational automation. • Strong 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. • Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, systems procedure) • 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. • Documentation skills for processes and procedures (creating KBs, runbooks, topology etc. ) • Production SQL Database support to tech users in 24/7 • He should be capable enough to train the Development resources to write efficient SQLs by providing them the training Skills & Experience • Essential skills:  More than 5 Years of experience required.  In-depth knowledge of SQL Server with production support experience in a multi project environment.  In-depth knowledge of SQL and T-SQL including tuning.  Performance and tuning skills including server configuration and tracing facilities.  Good working knowledge of job scheduling and monitoring tools.  Experience of working with multiple projects/tasks and the ability to prioritize on the fly.  Experience of supporting multiple teams within a business. • Other skills of interest:  Advanced Replication and cluster administration.  An interest in data warehousing.  Hard working but easygoing manner.  SQL Server Certification  Familiarity with SQL Server specific tools and utilities.  Good documenting skills (Windows Office/Visio/Cvs etc.) • Personal Characteristics:  Excellent communicator  Self-motivated  Ability to learn quickly  Ability to problem solve high pressure issues  Enjoys a challenging yet rewarding environment.

If interested please send your updated resume to maheen.baber@systemsltd.com and mention the position in the subject of the email.

www. myjobs.tk