Senior Database Administrator
Allied Universal · United States · Yesterday
RemoteRemoteInformation Technology$110k–$120k/yrFull-time
Responsibilities
- Administer Microsoft SQL Server and related database technologies
- Ensure availability, reliability, performance, and recoverability of production, development, test, and disaster recovery environments
- Optimize database performance through indexing, query tuning, execution plan analysis, and system configuration improvements
- Identify and resolve application and database performance bottlenecks
- Establish database development, performance, and optimization standards; review application code and database structures
- Support database architecture, technology planning, schema design, data modeling, and integration initiatives
- Evaluate emerging technologies and recommend improvements
- Implement and maintain security controls, access management, and privileged account governance in accordance with corporate, regulatory, audit, cybersecurity, and compliance requirements
- Support vulnerability remediation, security assessments, and protection of sensitive and regulated data
- Develop, maintain, test, and validate disaster recovery procedures, backup recovery processes, recovery objectives, and business continuity plans
- Develop automation solutions using T-SQL, PowerShell, SQL Agent, and related technologies to improve efficiency through scripting, monitoring, alerting, and self-healing processes
- Maintain operational documentation, standard operating procedures, and database administration standards
- Support application deployments, production releases, reporting, integration, and analytics solutions
- Partner with development teams on database design, coding best practices, and troubleshooting database-related application issues
- Serve as a senior technical advisor and mentor for database technologies
- Participate in project planning, estimation, and technical reviews while effectively communicating with technical and business stakeholders
- Provide after-hours support and participate in on-call rotations as required
Qualifications
- Must possess one of the following:
- Bachelor’s degree in Computer Science, Information Systems, Information Technology, or related field of study
- Associate’s degree in Computer Science, Information Systems, Information Technology, or related field of study with a minimum of seven (7) years of progressively responsible database administration experience
- High school diploma or equivalent with a minimum of ten (10) years of progressively responsible database administration experience
- Minimum of five (5) years of progressively responsible database administration experience
- Minimum of three (3) years of experience supporting mission-critical Microsoft SQL Server environments
- Experience supporting high-availability enterprise systems, database performance tuning, backup and recovery strategies, disaster recovery solutions, and on-premises and cloud-hosted database environments
- Experience with SQL Server Agent, SSIS, SSRS, Always On Availability Groups, Replication, Database Mirroring, and backup/recovery methodologies
- Experience with PowerShell scripting, automation, database monitoring, performance analysis, data modeling, database design, troubleshooting, and root-cause analysis
- Advanced Microsoft SQL Server administration and T-SQL programming skills
- Strong project leadership, oral and written communication skills
- Ability to manage multiple priorities in a dynamic enterprise environment