The Database Administrator is responsible for developing, testing and implementing various SQL applications and projects. The firm is looking for an administrator who has at least 5 years of SQL database experience, who has strong ETL background and is comfortable with database scaling and performance tuning. The administrator will be required to build a strong working knowledge of in line business applications and their interaction with SQL. Candidates will be expected to develop new and optimize existing T-SQL, stored procedures, triggers and other core SQL components. Ongoing requirements will involve developing reports and designing/supporting integrations to all existing firm systems.
This person will be expected to understand and manage MS SQL servers in regards to performance, security, redundancy/high availability, backups/restores and integrations
Experience with SQL Server 2012 / 2014 / 2016
3+ Years MS SQL Server administration
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Experience with backups, restores and recovery models
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Experience in implementing operational automation using scripts.
Knowledge of indexes, index management, and statistics.
Experience working with Windows server and proper disk configurations.
Integration Services (SSIS) and ETL
Good communication and documentation skills
Reporting Services (SSRS) and Analysis Services (SSAS)
Master Data Services
LINQ or Entity Framework
Team Foundation Server
Additional Job Functions
Business application support and collaboration with the firm’s technology team is critical to the success of this position
Education (formal, while at work, and on one’s own time) is highly encouraged to take advantage of any new features, and opportunities related to SQL server
Position requires a high degree of active, participatory interaction with the Technology department’s staff – specifically: user services (Help Desk, and Trainers), Infrastructure, and Management
Adhere to and advocate industry (Microsoft) best practice(s) when it comes to SQL specifically and data systems methodology in general
Bracewell is a leading law and government relations firm primarily serving the energy, finance and technology industries throughout the world.
Our industry focus results in comprehensive state-of-the-art knowledge of the commercial, legal and governmental challenges faced by our clients and enables us to provide innovative solutions to facilitate transactions and resolve disputes.