MS SQL Server Database Administrator MindBody Software
This is a MSSQL Server DBA role largely responsible for providing operational database services to the organization. Some of the primary responsibilities of this role would 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 MS SQL Server DBA role requires a service oriented mentality, high sense of ownership of the 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.
During your interview you will be asked to discuss a project or particular piece of technology that excites you, as well as some of your past key technical accomplishments or completed projects. We will ask you questions on that project or piece of technology in order to get a better understanding of the depth of your knowledge.
This role requires good 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.
Essential Qualifications and Requirements:
4 years of MSSQL database administration experience (SQL 2008 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:
Knowledge of MINDBODY products, software, data structures, policies, and procedures.
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 DTS packages.
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.
General 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.
The physical demands are representative of a team member to successfully perform the essential functions of the job. While performing the duties of this job, he/she is regularly required to walk and sit at a desk, read and comprehend reason and analyze, use fine finger movements, and see, talk and hear. Intermittent lifting of heavy computer equipment (20-60 pounds). The noise level in the work environment is usually moderate. The data center environment is typically very loud and hearing protection is recommended.
||San Luis Obispo, CA |