Principal SQL Server Database Administrator

Join the Market Leader in Electric Power Data and Analytics Solutions

The electrical grid is the largest and most complicated machine ever built. Yes Energy’s industry-leading electric power trading analytics software provides real-time visibility into the data generated by the North American electrical grid daily. Our view informs real-time trading decisions and mid-to-long-term investment decisions that help keep utility prices reasonable, support the energy transition, and keep the grid running.

Be a part of our successful, growing business during international transformation.

Position Summary

The Principal SQL Server Database Architect will be a strategic and technical leader within the Product Technology Services organization, responsible for architecting, optimizing, and future-proofing Yes Energy’s database ecosystem. This role focuses on advanced performance tuning, query optimization, indexing strategies, and data partitioning across SQL Server environments. The Principal DBA will combine deep SQL Server expertise with a strategic mindset, collaborating with senior technology leadership to define the long-term roadmap for database technologies across products, environments, and global regions. The ideal candidate will work on improving system performance through interactive changes to queries and scheduled processes, supporting complex analytical workloads, and collaborating with application and data engineering teams to continuously enhance database reliability and efficiency. This role drives enterprise-wide data platform strategy, database modernization initiatives, and cross-team data architecture alignment to ensure reliability, scalability, and innovation.

Yes Energy uses several database technologies, including Oracle, SQL Server, and MySQL; this position will lead the SQL Server expertise and join a senior group of database professionals at the heart of the Yes Energy product engine. SQL Server and Azure SQL are used extensively for OLTP and OLAP, and the goal is to bring uniformity, consistency, and world-class techniques across product lines.

• Salary range : $170,000 - $190,000; depending on experience and location
• Location : Boston / Dedham, MA; Chicago, IL; Richmond, VA
• Full-time
• Hybrid; required to work in the office 2–3 days per week
• Reporting to : Vice President, Technology
• Applicants must be authorized to work in the United States without the need for visa sponsorship

Primary Responsibilities

Technology Leadership

Collaboration and Mentoring

Minimum Qualifications

Preferred Qualifications

Keywords

Database Administration, SQL Server, Columnstore, Indexing, Partitioning, Query Tuning, Always On, High Availability, T-SQL, Azure SQL, Synapse, Data Warehousing, Performance Optimization, CDC, Replication, Data Quality

At Yes Energy, we value connecting directly with candidates. We kindly ask that third-party recruiters and agencies not submit resumes, as we are not open to external recruiting partnerships.

About Yes Energy

Overview

Yes Energy delivers real-time market data and electric power trading decision solutions. Over 1,000 market participants use Yes Energy solutions daily. The business is a leader in information content collection and management, developing and delivering data and market analytics solutions. Since its inception in 2008, Yes Energy has become a trusted and respected supplier focused on power market analysts, traders, and trade managers. Yes Energy has a team of over 350 professionals in Boulder, CO (HQ); Boston, MA; Chicago, IL; Glendora, CA; Richmond, VA; London, UK; Auckland, NZ; Tokyo, JP; Bucharest, RO.

Culture

Yes Energy has been named one of the Best Places to Work in Colorado. The culture emphasizes listening to customers, teamwork, and professional development.

Values include innovation, high standards, teamwork in flat hierarchies, and continuous growth.

Equal Opportunity

Yes Energy provides equal employment opportunities (EEO) to all employees and applicants without regard to race, color, religion, sex, national origin, age, disability, or genetics. We comply with applicable state and local laws. This policy covers all terms and conditions of employment.

#J-18808-Ljbffr