Senior Database Administrator

MINDBODY

Responsibilities
Experience
Workhours

This is a Senior MSSQL Server Database Administrator role largely responsible for providing operational database services to the organization. Some of the primary responsibilities of this role include: owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with other colleagues in Engineering to come up with strategic solutions to recurring problems. This Senior MS SQL Server DBA role requires a service oriented mentality, high sense of ownership of problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication within the entire Engineering team and with internal and external customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes. This role requires strong communication skills. If you have a blog then please pass along the URL so we can review your work. If you do not actively blog that is fine, but you should be prepared to show us an example of something you have written previously if we should happen to ask. Minimum Qualifications and Requirements: 4+ years of MSSQL database administration experience; MS SQL 2008 required, 2012 or 2014 preferred. BS in Computer Science or equivalent education / professional experience. Ability to create and follow written procedures. Experience in troubleshooting and resolving database problems. Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. Experience with backups, restores and database recovery models. Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server. Ability to independently learn new technologies through research and vendor provided documentation. Ability to work independently and proactively with a minimum of supervision. Desired Skills or Qualities: Experience in implementing operational automation (PowerShell 2.0 and/or C# are preferred). Knowledge of indexes, index management, and statistics. Experience working with Windows server, including Active Directory and proper disk configurations. Experience with virtualization technologies (e.g. VMWare), particularly virtualization of MSSQL. Experience with designing and troubleshooting SSIS. A basic understanding of Storage Area Network concepts and technologies. Good communication and documentation skills. Involvement with the MSSQL Server Community; membership in PASS, active in forums or newsgroups. Certification is a plus: MCTS, MCITP, MVP Previous experience in either a teaching or volunteer role. Essential Duties and Responsibilities: Assists in planning, implementing and maintaining a production MSSQL database server environment. Supports a robust security program by following best practices related to the database server environment. Participates in rotating schedule for designated second-level responder duties that require on-call availability 24x7 during scheduled period. Responds to database-oriented Engineering helpdesk requests. Maintains automation scripts written in Powershell 2. Update as needed for new processes. Researches new database-related technologies and can provide a spoken presentation or training session to Engineering and IT Operations team. Maintains system performance by performing system monitoring and analysis, and performance tuning; troubleshooting system hardware, software, networks and operating and system management systems; designing and running system load/stress testing; escalating application problems to vendors Performs system upgrades in collaboration with operation staff and external service providers as needed. Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations. Other duties may be assigned, as required.

Read Full Description
Confirmed 30+ days ago. Posted 30+ days ago.

Discover Similar Jobs

Suggested Articles