Provides leadership for the team by ensuring standards are adhered to as well assign work to team membersDesigns, implements and supports current company data
Evaluates current database environments, conducts research, recommends, and implements innovate systems technology that can enhance the reliability, security, productivity, and efficiency of the database infrastructure
Adheres to company security policies and effectively controls access to dataInsures that data for top tier applications maintains a state of high availability
Develops and maintains documentation of design and workflow of data structures
Contributes to and maintains technical database standardsWorks with multiple teams on efficient ETL of data for availability to different business units within AscendAssists other IT functional teams to troubleshoot critical business systems Solves complex problems with many variables
Required Skills & Experience:
A minimum of 5 years of configuration and/or development experience with MS SQL Server, SQL Server Integration Services (SSIS), SQL Server Always On Availability, and SQL Server Transaction Replication
A minimum of 3 years of experience as a DBA lead in a high paced organization and the ability to provide technical leadership to the team
Must be familiar with advanced concepts of relational and dimensional database designMust possess the ability to effectively gather, document, and translate business requirements into business rules and supporting data models.
Must have excellent oral and written communication skills to effectively interact with internal and external customers and department staff, as described above.
Must possess the ability to perform work in a Dev/Ops environment, direct and act as a resource for less experienced analysts and relay necessary information as appropriate.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting toolsEvaluates current database environments, conducts research, recommends, and implements innovate systems technology that can enhance the reliability, security, productivity, and efficiency of the database infrastructure
Assists other IT functional teams to troubleshoot critical business systems
Experience in troubleshooting and resolving database integrity, performance issues, blocking and deadlocking, replication, connectivity, security issues etc
Ability to identify and resolve bottlenecks in SQL server and business processesMust be disciplined, dynamic and flexible to manage multiple projects and tasks, work effectively in a rapidly changing environment and meet ongoing and overlapping deadlines
