Reporting& Segmentation team
PrincipalData Engineer & DBA Job Description
AboutOracle Utilities (Opower)
At OracleUtilities (Opower), we’re applying cutting-edge computer science to one ofhumanity’s greatest challenges: Energy.
The DataPlatform group powers most all of Opower’s products, owns the organization’s mostcritical data sets, and provides both real-time services and batch analyticsprocesses. We own everything from processing and validating inbound data tomachine learning projects that drive energy savings and increase customersatisfaction.
One of ourkey missions this year is to simplify integrations across our product suite andsupport cross-product analytics and business intelligence needs. As a principalDBA on our team, you will help with a migration to Oracle Cloud and OracleDatabase adoption. You will be leading efforts to innovate our solutions andmeet the goals of the business intelligence and segmentation roadmap.
Our utilitycustomers in the United States and abroad give us energy usage data for tens ofmillions of their customers, which we then analyze and aggregate usingstate-of-the-art tools such as Java, Hadoop, Spark, Oracle Analytics Cloud andOracle DB.
You'll bepart of a friendly and technically skilled engineering team. The Reporting& Segmentation team runs the back-end processes and user interfaces thatallow our clients to target the right messages to their customers around theworld. We also provide the business intelligence and analytics tools that tellour clients how successful their energy efficiency and engagement programs are.
●Work on the design andimplementation of complex solutions using Oracle Database for BI, reporting andanalytics need.
●Provision and maintain OracleDB inOracle’s cloud.
●Design and implement new processesfor analyzing large volumes of data for millions of utility customers.
●Support and improve existinganalytics and segmentation data pipelines
●Tune database and optimize DBperformance.
●Work in integration of new data setsfrom internal and external sources
●Work along with your team to deliverhigh quality software, lead code reviews, adhere to best practices and codestandards, and thoroughly test your deliverables.
●Strong DBA skills and relevantworking experience with Oracle Database
●5+ years of experience working in asa DBA & Data Engineer
●2+ years of experience in ETL(Extract, Transform, Load) from various data sources
●Experience in tuning and optimizingDB performance
●Knowledge of DB security bestpractices, and backup and recovery processes
●Experience in developing dataarchitectures
●Strong expertise in data storagedesign principles. Understanding of pros and cons of SQL/NoSQL solutions, theirtypes and configurations (standalone/cluster, column/row oriented,key-value/document stores)
●Working knowledge of data analysis /data science
●Excellent verbal and writtencommunication skills in English
Will be aplus:
●Eperience in Oracle Business Intelligencesoftwares (OAC, OBIEE,) etc.
●Expertise in Java
●Experience in *nix environments
●Experience in Hadoop-relatedtechnologies (e.g., Map/Reduce, Spark, Hive, or HBase)
●Geospatial data expirience
What we offer:
●MacBooks Pro instead of workstations
●Companylunches and snacks
●Full-time employment (regularemployee hire)
●Cozy office in Odessa city center
●Access to Oracle University programs(Education/Certification)