TierPoint, LLC Database Administrator III in Remote, United States
This Database Administrator III role is largely responsible for providing operational database services to a variety of organizations in a managed services capacity. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents on a daily basis to ensure service related issues are identified and resolved, responding to database related alerts and escalations and working with clients and developers to come up with strategic solutions to recurring problems. This role requires a client first mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues. Effective client interaction and technical project management are integral to the position. Clients view this role as an essential resource for their current issues and future plans.
Expert skill in managing and executing complex projects including migrations and upgrades.
Great client management skills including written and verbal communication. The ability to communicate complex issues and ideas in understandable terms.
Excellent attention to detail and ability to own issues/projects and see them through to their resolution
Expert knowledge in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Strong knowledge 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 Pressure, I/O, disk space and other resource contention.
Mastery of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication and Availability Groups.
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, system stored procedures)
Advanced SQL Development skills – 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, run books, topology etc.)
Ability to own on-call and off hours responsibilities
Driven to reduce potential issues and outages by taking a proactive approach to client's environments
Expert skill in training other DBAs and the support staff on SQL server theory and troubleshooting.
Team oriented. Driven to communicate and work with all the teams. Willing to assist with issues and projects. Willing to play a leadership role if needed.
Bachelor of Science Degree or equivalent experience.
5 plus years of experience in Database Administration in SQL Server
5 plus years of experience in Database Administration in MySQL
Solid acquaintance in a scripting language like PowerShell
Experience with VMWare VCloud Director
Department: 240 - Service Delivery: Managed Ser
External Company Name: Tierpoint
External Company URL: https://www.tierpoint.com/