SQL Server DBA

Duties and Responsibilities:

As a member of the managed service team, the SQL Server DBA’s duties and responsibilities include:

  • Proactively monitor supported SQL Server database infrastructure including replication, mirroring, batch process jobs and database backups
  • Maintain the highest levels of system availability
  • Maintain and enhance database maintenance tasks
  • Ensure that databases are monitored using Oracle Enterprise Manager, review and test on a regular basis to ensure that alerting is fully operational, thresholds are meaningful
  • Identify potential issues, raise business awareness and propose solutions before impact to the business
  • Troubleshoot performance issues as and when they occur
  • Respond to reported system performance issues, quickly identifying root cause and responding appropriately
  • Provide guidance and advice during the design phase for HA and DR solution architectures
  • Ensure database backups are up to date, including backup and recovery testing
  • Restore databases to development and UAT environments as required
  • Install new SQL Server instances adhering to company standards and best practices
  • Create new databases in response to business requests
  • Administer instance and database user permissions profiles whilst maintaining security standards
  • Maintain and exercise DR procedures for supported production servers
  • Maintain clear, concise and high quality system documentation for team knowledge sharing
  • Communicate Microsoft SQL Server best practices
  • Participate in application code releases
  • Perform daily approved change code releases
  • Maintain and enhance scripts for DBA tasks including backups, restores and database maintenance including index management
  • Act as a subject matter expert providing advice and input as and when required
  • Keep abreast of relevant technical bulletins, highlight and report any deficiencies, provide solutions to rectify any potential issues

Skills and Experience

  • Solid Microsoft SQL Server Database Administration experience
  • Able to manage multiple RDBMS across versions
  • Proven experience working within a team and 3rd party environment
  • Proven track record providing production support including monitoring and tuning
  • Experience of installing and configuring Microsoft SQL Server RDBMS across versions
  • Experience providing upgrades and patches
  • Good interpersonal skills
  • Familiarity with Windows operating systems to a level below a dedicated Systems Administrator
  • Good spoken English and a positive telephone manner
  • Good written English for formal and informal information exchange with clients and the team
  • Provide support to senior members of the managed service team

Knowledge

  • SQL Server 2005, 2008, 2008 R2 (awareness of 2012)
  • Windows Operating Systems
  • Windows Performance Monitor
  • Microsoft Clustering
  • Patching
  • Migrations
  • Upgrades
  • SQL Server Security Controls
  • Database Maintenance
  • Database Performance Tuning
  • SQL Profiler
  • Server Side Tracing
  • Database Backup and Recovery
  • Database Mirroring
  • Replication
  • Log Shipping
  • T-SQL
  • Stored Procedures
  • User Defined Functions
  • Triggers
  • SSIS/DTS
  • Troubleshooting
  • Knowledge or experience of SQL Server tools
  • Knowledge of Red-Gate SQL Server Backup Application desirable

Qualifications

  •  Relevant Microsoft accreditations are desirable but not essential

Personable Attributes

  • Numerical, resourceful, adaptable, flexible, enthusiastic
  • Willing to learn and take on new tasks
  • Tactful, helpful, proactive, honest, considerate
  • Has a ‘can-do’ attitude and holds a customer service approach
  • Communicate with members of the team when issues arise
  • Willingness to work outside normal business hours on occasion when required
  • Professional manner and approach
  • Enthusiasm and willingness to address unfamiliar tasks
  • Take on new technologies as the company requires

Add your CV:

Jay PatelSQL Server DBA