Database Specialist and ETL administrator

Yes Energy –  Boston, Ma or Boulder, CO

Yes Energy’s industry leading electric power trading analytics software provides real time visibility into the massive amount of data that is generated by the US electrical grid every day.  This in turn facilitates the optimal use of financial and physical capital in the energy industry - an industry that is a critical backbone of the entire economy. We take great pride in our technology, our data management and our suite of visualization and analysis tools that serve this industry.  

Our business was founded on the principle of saying say “yes” to our customers - and we excel at this.  The combination of our industry-leading tools and industry-leading customer care is powerful. As a result, our data products are growing in an exciting way.  To support that growth, we are hiring a Database Specialist and ETL Administrator.

Position Summary

The Database Specialist and ETL Administrator is a mission critical Team Player and technical lead that has the ability to see the big picture including the full relationship between the systems and operational deliverables, and the customer experience.  Key Performance Indicators for this position include: performance of systems, quality of data, level of service, and customer and employee satisfaction. This position in the Database Group requires that the candidate have the ability to move seamlessly between strategic systems and operations planning as dictated by business needs. This position will have a large responsibility for ensuring the Yes Energy data is delivered to our clients in a timely fashion using the most current tools available.

This position includes production support of database systems and will collaborate closely with system administrators and senior DBAs.

GET STARTED TODAY

Please fill out this application and attach it with your cover letter and resume in an email to jobs@yesenergy.com

 

Primary Responsibilities

  • Owns all aspects of data replication to internal and external systems, with particular focus on the support, maintenance, and development of our client database product (DataSignals Private). 

  • Develops and operates ETL/data integration solutions for propagation of key data assets to disparate storage technologies and infrastructure, including MSSQL Server, Hadoop, cloud databases including RedShift, in support of cloud and bare-metal analytic solutions and new products.

  • Translates customer requirements into quantifiable and actionable items and uses corporate project management tools to ensure a timely delivery.

  • Researches, evaluates and integrates new software, software versions, drivers, and hardware.

  • Assists in the monitoring of all installed database systems and technologies.

  • Participates as a key member of cross-functional data security team.

  • Responds to and resolves incident and problem tickets.

  • Works closely with customer support team to communicate the root cause of outages, duration and recommendations or steps to resolve issues.

Minimum Qualifications

  • 2-4 years CDC based replication experience, preferably Oracle Goldengate

  • Familiarity with other RDBMS technologies for the purposes of end point replication

  • 5 years Linux (preferably Red Hat) 

  • 2-4 years Oracle Database experience

  • Familiarity with Oracle ASM

  • Shell scripting

  • SQL tuning 

  • Strong Project Management and communication skills

  • Cloud experience, particularly with alternate data stores

Additional Qualifications

  • Infrastructure/system design and engineering experience

  • Up to 5% travel

  • Knowledge of nodal power markets

  • Kafka experience. or similar messaging systems

Technology

  • Oracle Goldengate or other major CDC replication tools

  • Quest Shareplex

  • AWS, Google cloud

  • Microsoft SQL Server (basic administration)

  • Oracle Active Data Guard

  • Oracle RMAN

  • Linux (RHEL)

  • VmWare, vCenter

  • Hyper-Converged architecture

  • Enterprise backup technologies

  • Oracle Database 12C (basic administration)

  • Oracle Enterprise Manager (13C)

How to Apply

Please email a resume and cover letter to:

jobs@yesenergy.com

Only applicants who include a cover letter, resume and completed application will be considered.

Yes Energy does not provide any Visa sponsorship.

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 in which 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.