Database Engineer
EnerNOC - Boston, MA

This job posting is no longer available on EnerNOC. Find similar jobs: Database Engineer jobs - EnerNOC jobs

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
• Support test environment databases

Required Qualifications:

• Bachelor's degree in Computer Science or related field
• Minimum 2 or more years of experience in commercial software development with proven problem solving skills demonstrated through professional experience
• Excellent English language written and verbal communication skills
• Solid understanding of Data Architecture and Logical/Physical Data Modeling
• Excellent understanding of the Oracle Server databases, related utilities and tools, with experience on Oracle 11gR2
• Solid understanding of Oracle PL/SQL, Triggers, etc
• Knowledge of architectural platform constraints on database performance
• Ability to perform both query, database and operating system performance tuning and monitoring
• Experience with different types of Oracle 11g Partitioning, Materialized Views and AQ
• Strong software engineering habits: unit testing, continuous integration, code reviews, etc.
• Ability to concurrently manage multiple projects and priorities
• Excellent English language written and verbal communication skills

Desired Qualifications:

• Experience in Database Design, including designing and developing procedural code for Oracle Databases specifically
• Experience troubleshooting production SaaS online database solutions
• Experience with Oracle 11gR2, RAC, ASM, Exadata
• Experience with Oracle GoldenGate
• Experience tuning and performance testing table structures with billions of rows or more.
• Experience interfacing with web based applications (Java, VB, IE) and BI applications (Cognos, MicroStrategy)
• A proven track record of successfully delivering complex, commercial products on time
• Prior experience within and/or passion for the clean tech industry

EnerNOC - 2 years ago - save job
About this company
15 reviews
Working Toward a Clean Energy Future! Charting the future of energy takes a different kind of corporation. EnerNOC is one of the leading...