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.
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.
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.
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
Strong Project Management and communication skills
Cloud experience, particularly with alternate data stores
Infrastructure/system design and engineering experience
Up to 5% travel
Knowledge of nodal power markets
Kafka experience. or similar messaging systems
Oracle Goldengate or other major CDC replication tools
AWS, Google cloud
Microsoft SQL Server (basic administration)
Oracle Active Data Guard
Enterprise backup technologies
Oracle Database 12C (basic administration)
Oracle Enterprise Manager (13C)
How to Apply
Please email a resume and cover letter to:
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.