Job Summary:
Energy Transfer is recognized by Forbes as one of America's best large employers, dedicated to responsibly delivering America’s energy. The Lead Specialist - SQL Server Database Administration is responsible for managing and maintaining SQL Server databases, ensuring high availability, performance tuning, and implementing backup strategies.
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
Qualifications:
Required:
• 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
Preferred:
• Microsoft SQL Server 2014 and greater
• Powershell
• ServiceNow
• Foglight / Litespeed
• Encryption / SQL TDE
• Vormetric/Ciphertrust
Company:
Energy Transfer LP (NYSE: ET) owns and operates one of the largest and most diversified portfolios of energy assets in the United States, with more than 125,000 miles of pipeline and associated energy infrastructure. Founded in 1995, the company is headquartered in Dallas, USA, with a team of 10001+ employees. The company is currently Late Stage.