Senior Database Administrator

Overview

Job Purpose: Provides support to and maintains multiple production and/or non-production databases of significant and/or strategic impact across the enterprise. Responsible for standards and design of physical data storage, maintenance, access and security administration.

Responsibilities

Provide strategic engineering leadership to drive technology improvements

Take ownership of projects to ensure successful implementation including Tech-Stack upgrade efforts

Foster relationship and act as a technical liaison between the DBA Team and the Lines of Business

Performs backup and recovery on Database Management Systems, configures database parameters and prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements

Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost

Tune the stored procedures of simple to complex, assist the development team to optimize the application

Experience in writing or assisting the T-SQL and PowerShell scripts

Ensures service level agreements are met for internal and external clients

Automate the mundane process using T-SQL or PowerShell scripts

Provides status reports that detail issues for escalation to management

Performs configuration, scripting, analysis, installation, monitoring, administration and tuning for database management systems

Performs data analysis to provide management with timely and accurate information and predict future requirements

Develops, implements and tests database backup and recovery policies and procedures

Creates and maintains documentation for database policies, procedures, and processes

Performs/schedules routine maintenance on databases to keep them running at peak performance

Monitors database performance, availability, and capacity

Review database storage utilization to ensure proper whitespace allocations

Review and develop trend analysis for incident remediation and prevention

Participates in continuous business process redesign to improve internal operations

Interfaces with user departments remotely and on-site to assist in the implementation of work requests and provide operational support

Troubleshoots issues and recommends solutions

Research and evaluate new RDBMS for possible implementation

Experience in setting up, managing Distributed Availability groups (DAG) across multiple domains

Performs other duties as required

Knowledge And Experience

Bachelors Degree in Computer Science, Information Systems or the equivalent combination of education, training, or work experience

Requires nine (9) or more years of experience working with various database management systems in database design, testing, implementation, maintenance and administration in a multiple platform environment

Required to participate in a 24x7 on-call rotation

Expert level knowledge of SQL Server database management systems (2012, 2014, 2017, & 2019 [SQL 2022 is a plus])

Expert level knowledge SQL performance and tuning

Expert level knowledge of Microsoft Geo-Clustering, Always-On Availability Groups in local & geographically dispersed data centers, Distributed Availability groups (DAG) across multiple domains

Extensive knowledge of task automation

Strong database design and analysis skills

Knowledge of backup and recovery operations for database management systems

Knowledge of database encryption such as Always Encrypted, Protegrity, TDE, and TLS

Knowledge of OS, storage, and network layers for troubleshooting purposes

Knowledge of relational database concepts and terminology

Ability to monitor and tune databases and instances

Ability to maintain and monitor availability, security, and integrity of databases

Ability to focus on production and customer needs and deliverables

Ability to adapt to the use of new software tools as they are acquired or adopted within IT

Strong written and verbal communication skills

Must be self-motivated, a team player, and have a strong track record in customer satisfaction

Demonstrated experience with successful system and project implementations

Preferred Knowledge And Experience

Knowledge of T-SQL, PowerShell Scripting and Automation

Knowledge of AWS - RDS SQL

Knowledge of Microsoft Azure RDBMS

Knowledge of Cloud SaaS RDBMS

Knowledge of OLA Hallengren maintenance plans

Experience with scripting languages

Strong problem-solving skills

Ability to work independently and in a team environment with minimal supervision

Ability to learn and apply new skills in a constantly changing technical environment

Seniority level

Not Applicable

Employment type

Full-time

Job function

Information Technology

#J-18808-Ljbffr