Lead Specialist - SQL Server Database Administration

Energy Transfer•Houston, TX

1d•Onsite

About The Position

Energy Transfer Partners is seeking a Microsoft SQL Server Administrator with extensive experience in managing and maintaining large, complex environments. This individual is responsible for designing, installing, monitoring, maintaining, and performance tuning production databases while ensuring high levels of data availability. He/she is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Initial focus will be on database administration, particularly in making sure all production databases are up and running 24x7, and making sure all databases are backed up properly.

Requirements

Bachelor’s degree in Computer Science or Information Systems or equivalent
7+ years of experience in Information Technology working in a MS SQL DBA capacity.
Strong understanding of database structures, theories, principles, and practices.
Hands-on database development, tuning, and troubleshooting experience
Migrating, Upgrading SQL Server to later SQL versions
Must be a Team player
The ability and desire to rapidly learn complex technologies and software products in a self-starting mode without the benefit of formal training
Good written and oral communication skills
Good interpersonal skills
Ability to conduct research into database/software issues, standards, and products as required
Highly self-motivated and directed
Keen attention to detail
Proven analytical and problem-solving abilities
Ability to effectively prioritize and execute tasks in a high-pressure environment
Ability to lead in projects and work efforts
Strong customer service
The Lead IT Specialist level requires a Bachelor’s degree or equivalent experience and 8+ years of relevant job related experience

Nice To Haves

Microsoft SQL Server 2014 and greater
Powershell
ServiceNow
Foglight / Litespeed
Encryption / SQL TDE
Vormetric/Ciphertrust

Responsibilities

Responsible for implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems
Ensure all production databases are up and running 24x7
Ensure all data assets are protected by designing and implementing the appropriate backup and restore strategy
Monitoring database performance, including stored procedures and query execution times, and implement efficiency improvements
Respond to and resolve database access and performance issues
Monitor and optimize the physical data storage for database systems
Perform scheduled maintenance and support release deployment activities after hours
Plan, coordinate and implement database migrations and upgrades
Perform database security audits
Establish appropriate database access control levels
Configure SQL to achieve high levels of performance, scalability, and availability
Experience with SQL HADR technologies; including failover clustering and always-on availability groups
Design and implement disaster recovery strategy
Participate in the On Call rotation
SQL Encryption technology including TDE and Network traffic encryption