Job Description
Job Description
Join the Market Leader in Electric Power Trading 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 massive amount of data generated by the North American electrical grid daily. Our unique and innovative view of the data informs real-time trading decisions and mid-to-long-term investment decisions that keep utility prices low, support the energy transition, and keep the grid running. It's both challenging work and work with a purpose.
Be a part of our successful, growing business during international transformation.
Position Summary
The Senior Database Administrator/Team Lead will serve as the team lead and key contributor for a dedicated team of Senior Database Administrators with many years of experience in various database systems. This team is part of a larger team, Product Technology Services, which responsible for ensuring that Yes Energy's technology products and solutions are relevant, cutting-edge, and cost-effective.
This position is a mission-critical team player and a leader who can see the big picture, including the full relationship between the systems, operational deliverables, and the customer experience. Key performance indicators include uptime, system performance, data quality, service level, and customer and employee satisfaction. The team lead requires the candidate to move seamlessly between strategic systems and operations planning, hands-on DBA implementation, and management as business needs dictate. This position will be primarily responsible for developing a deep and functional DBA team that monitors, enhances and operates our business-critical data systems.
Position Details
- Salary range: USD $150,000 - 170,000; depending on experience and location
- Location: Boston/Dedham, MA; Richmond, VA; or Bucharest, Romania
- Full-time
- Hybrid; Will be required to work in the office 2-3 days a week
- Reporting to: Vice President, Technology
Primary Responsibilities
Lead, direct, and support the DBA team.Ensure best practices are documented and followed to anticipate, mitigate, and resolve problems affecting database performance, efficiency, and availability.Manage, coordinate, and optimize development and support efforts in various database environments with hands-on responsibilities, especially on Oracle and MS SQL Server.
- Ensure our on-premise and cloud databases are functioning as one seamless system
Perform installations, configurations, backups, recovery, and tunes database performance for Oracle and MS SQL Server.Support code reviews and provide solutions/guidance to issues faced by DB and application developers during SDLC.Administer and maintain end user accounts, permissions, and access rights.Assist compliance team in managing updates, patches, and upgrades for system availability and complianceIdentify opportunities for improvement, makes proposals, and participates in planning maintenance plus new, or enhanced technologies and services.Communicate problems and resolution processes to IT and Business partners.Evaluate performance and costs through regular reporting and summaries of the systems, including availability, usage, and capacity.Ensure 24x7x365 availability for critical data services.Provide On-Call and after-business hours support as needed.Perform other duties as assigned.
Minimum Qualifications
- Bachelor's degree in Computer Science, Data Science, Mathematics, or a related field
Must have strong hands-on leadership, direction, and support to the DBA team
- 10 years of experience in Information Technology, including at least 4 years of strong hands-on experience with database modeling, extraction tools, and replication technologies (solutions, designing, installing, configuring, and administrating)
- Minimum of 3 years of hands-on experience with High Availability methodologies such as Oracle ExaData, RAC, MS SQL Always On Availability Groups, Active Data Guard
- Proficient in SQL and experience with relational and non-relational databases
- Experience with data warehousing solutions (e.g., Snowflake, Synapse, Autonomous Data Warehouse, MySQL)
- Familiar with database replication tools or techniques
- Experience working in agile team is a plus
Keywords
Database Administration, Oracle, ExaData, RAC, Snowflake, SQL Server, ETL, SQL, Data Warehousing, RDBMS Analytics, CDC, Replication, Reporting, Data Quality
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 all aspects of 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 of innovative and reliable solutions focused on the needs of power market analysts, traders, and trade managers. Yes Energy has a team of 300 amazing professionals in Boulder, CO (HQ); Boston, MA; Chicago, IL; Glendora, CA; Richmond, VA; London, United Kingdom; Auckland, New Zealand; and Bucharest, Romania.
Culture
Yes Energy has been named one of the Best Places to Work in Colorado, and we have the culture to prove it. At Yes Energy, we care about saying "Yes" to customers. We like to listen, learn, and develop our solutions in line with their needs. We think about customers as business partners, and when we help them be more successful … we are more successful, too.
Around the office, our culture is driven by some pretty fundamental values that we're proud of:
- We love innovation and solving tough challenges;
- We are "high standards people" who combine passion and pride with hard work and rewards of all kinds-- in an ethic that is consistent across the company;
- We're team-focused with a flat hierarchy-- we work in small teams on well-defined projects that directly impact the success of the business;
- We play to the strengths and experience of each person while each of us also works along a continuum of roles adjacent to our focus area. This presents the challenge of maintaining a broad set of skills as well as an opportunity to learn and contribute in many ways;
- We are constantly growing. Professional development happens every day and every year.
Compensation and Benefits
We offer highly competitive salaries and real bonuses that are achievable and that you can impact. Our benefits package is also very competitive, including medical insurance, a 401 (k) Plan with matching, flexible vacation, and flexible work schedules. Yes Energy encourages and funds investment in both formal and informal professional development.
At Yes Energy, we are dedicated to building a diverse, inclusive, and authentic workplace. If you're excited about this role but your experience doesn't perfectly align with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.
In accordance with Colorado law, the range provided is Yes Energy's reasonable estimate of the base compensation for this role. The actual amount may be higher or lower based on non-discriminatory factors such as location, experience, knowledge, skills, and abilities.
Yes Energy provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, Yes Energy complies with applicable state and local laws governing nondiscrimination in employment in every location where the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.