Database Engineer

Thursday June 07, 2012

EnerNOC, a leading provider of demand response and energy efficiency solutions, has an immediate need for a Database Engineer to join our world-class Engineering organization.  The Database Engineer will participate in procedural development and design for sustaining engineering and production issue resolution for a wide variety of business requirements and technologies, including high speed/high volume real time streaming systems (fast transactional OLTP), to Large Volume Data Mining Databases, e.g. Big Data.   The Database Engineer will mentor and guide non-database personnel (Java and BI), making sure solutions are aligned with our enterprise data architecture.   This individual must be able to wear many different hats, including helping to refine business requirements, investigating production issues, designing/architecting innovative database solutions (document said solutions), maintaining/supporting production and QA/dev databases, and developing in PL/SQL themselves.  The Database Engineer must possess the ability to work on tight schedules and firm deadlines with a variety of individuals across the organization, as well as be a strong team player, have strong communication skills (both spoken and written), as well as be able to adapt to a dynamic environment.

Key Responsibilities:

• PL/SQL & SQL Development - Stored Procedures, SQL Optimization, Prepares units and system test scripts, etc.
• Investigating production issues to determine root causes
• Database Architecture -Database Modeling and Optimal Database Table Structure/Design, Prepares system requirements and detailed design documents
• Physical Modeling and Load/Performance Testing different scenarios to validate technical approach to problems
• Performance tuning and monitoring - Database, Application and Operating System parameters 
• Work as part of a team and provide 7x24 support when required

Required Qualifications:

• Bachelor's degree in Computer Science or related field
• Minimum 6-10+ years of experience in commercial software development with proven problem solving skills demonstrated through professional experience
• Minimum 3-8+ years of experience in Database Design, including 3-5+ years in designing and developing procedural code for Oracle Databases specifically
• Minimum 3-5+ years troubleshooting production SaaS online database solutions
• Excellent English language written and verbal communication skills
• Ability to concurrently manage multiple projects and priorities
• Solid understanding of Data Architecture and Logical/Physical Data Modeling
• Solid understanding of PL/SQL, Triggers, etc
• Experience tuning and performance testing table structures with billions of rows or more.
• Excellent understanding of the Oracle Server databases, related utilities and tools
• Experience interfacing with web based applications (Java, VB, IE) and  BI applications (Cognos, MicroStrategy)
• Knowledge of architectural platform constraints on database performance
• Solid understanding of Oracle internals and Concepts
• Ability to perform both query, database and operating system performance tuning and monitoring
• Experience with Oracle 11gR2, RAC, ASM, Exadata
• Experience with different types of Oracle 11g Partitioning, Materialized Views and AQ
• Experience with Oracle GoldenGate
• Strong software engineering habits: unit testing, continuous integration, code reviews, etc.
• A proven track record of successfully delivering complex, commercial products on time

Desired Qualifications:

• Prior experience within and/or passion for the clean tech industry

About EnerNOC:

EnerNOC unlocks the full value of energy management for our utility and commercial, institutional, and industrial (C&I) customers by reducing real-time demand for electricity, increasing energy efficiency, improving energy supply transparency in competitive markets, and mitigating emissions. We accomplish this by delivering world-class energy management applications including DemandSMART™, comprehensive demand response; EfficiencySMART™, data-driven energy efficiency; SupplySMART™, energy price and risk management; and CarbonSMART™, enterprise carbon management. Our Energy Network Operations Center (EnerNOC) supports these applications across thousands of C&I customer sites throughout the world. Using our C&I customers’ energy usage flexibility, we make capacity, energy, ancillary services, and carbon products available to grid operators and our more than 100 utility customers on demand as a cost-effective alternative to traditional power generation, transmission, and distribution.  For more information, visit www.enernoc.com.  EnerNOC is an Equal Opportunity Employer.