SQL Server DBA
7nSoft Systems (Pvt) Limited , Pakistan

• The candidate will be a member of a team within Database Managed Services.
• The primary role on the team will be as a SQL Server Production Database Administrator.
• All team members must have the ability to provide 24x7 rotational on-call duties, after hour change support and support disaster recovery test weekends.
• The eligible candidate will be required to carry a cell phone, laptop and on occasion will need to do work outside of regular work hours.

Check the below skills set (minimum five) , before applying for this job.

Skill Set:

• Capacity Management
  • Physical and Logical
• Security Management
  • AD Group
  • Windows / SQL Server Authentication
• High Availability Management (minimum two)
  • Replication
  • Cluster
  • Mirroring
  • Log shipping
• Backup and Recovery Management
  • Full
  • Point in time
  • Transactional
  • Differential
• Performance Tuning
  • OS (good to know)
  • DB level
  • Code level
• Process Improvements
  • Query Optimization
  • Stored Procedure
  • Trigger
  • Function
• Daily, Weekly and Monthly maintenance
  • Fragmentation
  • Index re-org / re-build
  • Update stat
  • DB / TR log shrink
• Installations / Upgrades / Patching
• Health Checks / Report Analysis
• ETL
  • Data Load
• Support SQL Server versions 2005, 2008, 2012 and 2014 including: Database Engine, Integration Services, Reporting Services and Analysis Services.
• SQL Server Monitoring
  • Proactive monitoring of database environment for stability, performance, availability and recoverability.
• Knowledge of tools ( optional )
  • Confluence
  • Jira
  • Remedy Force
  • COMM vault
  • Red Gate
  • Sentry One
  • Solar wind Ignite

Job Rewards and Benefits