CalTek Staffing is a Software and IT recruitment firm in search of a Database Developer for a San Francisco Bay Area client of ours. Our client is a leading electric utility company at the forefront of innovation in the energy and utilities sector, driving the future of clean energy, smart grids, energy storage, and digital transformation. With a focus on operational efficiency and customer engagement, the company is investing heavily in advanced data analytics, real-time monitoring systems, and intelligent digital platforms that support the transition to a more sustainable, resilient, and reliable energy grid.
As a Database Developer, you will play a critical role in designing, developing, and optimizing enterprise-scale databases that power smart grid applications, renewable energy integration, customer analytics, and mission-critical utility operations.
Typical Duties and Responsibilities
As a Database Developer (Energy & Smart Grid Systems), your responsibilities will include:
- Designing, developing, and maintaining relational and non-relational databases to support utility operations, grid monitoring, energy storage, and analytics platforms.
- Developing and optimizing ETL pipelines for ingesting and transforming large datasets from smart meters, IoT sensors, SCADA systems, and renewable energy assets.
- Ensuring high availability, scalability, and performance tuning of enterprise databases for mission-critical utility applications.
- Implementing SQL queries, stored procedures, triggers, and indexing strategies to improve system efficiency and support real-time decision-making.
- Integrating databases with cloud platforms (AWS, Azure, GCP) and utility-grade applications for predictive analytics, forecasting, and grid stability management.
- Supporting compliance with industry standards such as NERC CIP (Critical Infrastructure Protection), FERC regulations, ISO/IEC 27001, GDPR, and data governance frameworks.
- Collaborating with data scientists and software engineers to deploy machine learning models and AI-driven energy analytics into production databases.
- Developing APIs and services to connect databases with digital customer engagement platforms, billing systems, and mobile apps.
- Supporting cybersecurity and implementing role-based access control (RBAC), encryption, and backup/recovery strategies to ensure secure and resilient energy operations.
Education
- Bachelor’s degree in Computer Science, Information Systems, Software Engineering, or a related technical field required.
- Master’s degree in Data Science, Database Management, or Energy Informatics preferred.
Required Skills and Experience
- 5+ years of experience as a Database Developer, Database Engineer, or Data Platform Engineer, preferably within the energy, utilities, or critical infrastructure industries.
- Proficiency in SQL and database management systems such as:
- Oracle, Microsoft SQL Server, MySQL, PostgreSQL
- NoSQL databases: MongoDB, Cassandra, DynamoDB, Redis
- Strong experience with ETL tools (Informatica, Talend, Apache NiFi, SSIS) and data integration pipelines.
- Experience working with big data frameworks such as Hadoop, Spark, Kafka, Hive for large-scale analytics.
- Hands-on expertise in data warehousing platforms (Snowflake, Redshift, BigQuery, Azure Synapse).
- Familiarity with SCADA, AMI (Advanced Metering Infrastructure), IoT energy sensors, and grid telemetry systems.
- Experience in cloud-based database services (AWS RDS, DynamoDB, Aurora, Azure SQL Database, Google Cloud Spanner).
- Knowledge of data governance frameworks and compliance (NERC CIP, FERC, ISO/IEC 27001, SOC 2).
- Expertise in database performance tuning, query optimization, partitioning, and clustering.
- Strong experience with API integration, RESTful services, and JSON/XML data exchange.
Preferred Qualifications
- Experience in the energy and utilities sector, particularly with smart grid, energy storage, and renewable energy integration projects.
- Familiarity with time-series databases (InfluxDB, TimescaleDB, OpenTSDB) for IoT and grid monitoring data.
- Exposure to machine learning pipelines for energy forecasting, demand response, and predictive maintenance.
- Knowledge of data visualization tools (Tableau, Power BI, Grafana, Kibana) for energy analytics dashboards.
- Certifications such as:
- Oracle Certified Professional (OCP)
- Microsoft Certified: Azure Database Administrator Associate
- AWS Certified Database – Specialty
- Google Cloud Professional Data Engineer
- Strong background in cybersecurity practices for critical infrastructure, including encryption, multi-factor authentication, and secure data transmission.
