Architecting, administering and optimizing all enterprise SQL Server databases
Ensuring security, reliability, and scalability of databases
Collaborating with application owners and IT teams to support business operations
Providing technical guidance to users accessing enterprise data
Maintaining all enterprise SQL database operations including SQL server updates and patches
Maintaining database security and compliance with company, industry and government standards (GDPR, HIPAA, etc.)
Reviewing current architecture and updating and optimizing all enterprise database systems
Architects and implements new database systems
Proactively monitoring database performance and performing database tuning for optimal performance
Troubleshooting enterprise database servers and related systems
Supporting system audits and providing documentation as required
Planning testing and implementation of DR and backup processes to ensure continuous operation
Creating custom queries, data-driven SSRS subscriptions, migration scripts, and executing other tasks as needed

Bachelor's degree or equivalent work experience
Minimum 8 to 10 years’ experience in design, development, administration, and maintenance of enterprise-level MS SQL Server database systems
Sound understanding of SQL Server technology features and limitations
In-depth, advanced knowledge of SQL Server database structures, security, storage solutions, virtualization, replication, and clustering
Ability to create performance projections based upon hardware, OS, databases design, query structures and interactions between external systems with the database servers
Ability to evaluate and recommend technological changes in the database environment to support business objectives
Proficiency in automation and scripting (e.g., PowerShell)
Demonstrable experience configuring, operating and maintaining Microsoft SQL Server, both on-prem and cloud environments
Demonstrable experience in database design, creating standards and processes, capacity planning, disaster recovery planning, accessibility, scalability and documentation for SQL Server
Demonstrable experience in development of complex queries, SSIS Packages and SSRS reports

Senior Database Administrator

Key skills