At a senior level, manages and maintains production and non-production databases. Responsible for standards and design of physical data storage, maintenance, access and security administration. Performs backup and recovery on database management systems, configures database parameters, designs prototypes 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. This position utilizes in-depth knowledge of best practices and experience in own discipline to provide and improve services. Takes a new perspective to solve complex problems. Works independently and receives minimal guidance. Acts as a resource for colleagues with less experience. May direct the work of other staff members.
This general overview only includes essential functions of the job and does not imply that these are the only duties to be performed by the employee occupying this position. Employees will be required to follow any other job-related instruction and to perform any other job-related duties requested by supervisor or management.
Nine or more years of experience in database management system design, testing, implementation, maintenance and administration in a multiple platform environment. A degree(s) in computer science, information technology or relevant field may be substituted per LCRA guidelines for certain years of experience.
5-7 years of DBA experience with Microsoft SQL Server
Strong knowledge and extensive experience with Microsoft SQL server technologies (all core areas: SSMS, SQL Clustering, Data Synchronization, Encryption, Partitioning, Performance, Security, SSAS, SSIS and SSRS configuration) is mandatory
Sound knowledge of all Windows and SQL utilities; strong PowerShell knowledge and experience is a plus
Solid understanding of network, storage, tiered application environments and security
Solid knowledge in database replication technologies including Always-On and strong architectural/engineering skills to design systems that meet various applications High Availability and Disaster Recovery requirements
Have experience in development of automated processes and procedures to support repetitive or frequent tasks in database administration or deployment
Solid understanding and experience in maintain MSSQL technology lifecycle, and automation of MSSQL deployment
Good engineering skills in developing enterprise solutions to support MSSQL in areas like backup, monitoring/alerting, security compliance, patching, etc.
Good interpersonal skills along with effective communication (both written and verbal) skills
Demonstrate ability to solve complex systems and database environment issues
Demonstrate ability to work in a complex organization to determine business and customer needs, providing the best solution to meet those needs
A good team player, leader, flexible, share knowledge, help others, collaborate well within and outside the team