SQL Database Administrator
Stem
Stem provides clean energy solutions and services designed to maximize the economic, environmental, and resiliency value of energy assets and portfolios. Stem’s leading AI-driven enterprise software platform, Athena®, enables organizations to deploy and unlock value from clean energy assets at scale. Powerful applications, including AlsoEnergy’s PowerTrack, simplify and optimize asset management and connect an ecosystem of owners, developers, assets, and markets. Stem also offers integrated partner solutions to help improve returns across energy projects, including storage, solar, and EV fleet charging. For more information, visit www.stem.com.
Stem’s culture embodies diversity & inclusion beyond the traditional facets of gender, ethnicity, age, disabilities, and sexual orientation to include experience, personality, communication, workstyles, and more. At our core, Stem is at the momentous intersection of clean energy and software technology where diverse ideas, experiences, and professional skills converge to make the inclusive culture we have today. Together, we are turning old school thoughts about software and energy into progressive, collaborative, and innovative solutions. By joining our team, you will be collaborating with data scientists, energy experts, skilled salespeople, thought-leading executives and more from a range of backgrounds. This intersection of ideas, beliefs, and skills is what makes us unique enough to lead the world’s largest network of digitally connected energy storage systems.
Responsibilities: •
- Work with business partners and stakeholders to understand data requirements.
- Knowledge of Database fundamentals, SQL, and distributed computing.
- Proficiency in more than one of the following scripting languages: SQL, Python, Csharp/C++/C, Java, Golang, and other modern languages.
- Perform code versioning and code deployments for data pipelines.
- Knowledge of IaC technologies like Terraform, and CI/CD technologies like Ansible, Chef, Puppet, etc. to partner with DevOps to build CI/CD pipelines associated with RDBMS-related elements of the overall IaC platform.
- Knowledge of container build process and container orchestration tools, such as with Docker or Kubernetes, within CI/CD environments to realize IaC.
- Demonstratable experience writing complex, highly optimized SQL queries across large data sets.
- Develop and implement data quality checks, database monitoring/optimizing routines, and assist with data quality checks and metrics, as part of performance monitoring of data infrastructure.
- Design, develop, and implement large-scale, high-volume, high-performance data models. Familiarity with pipelines for time series databases a plus. • Proficiency working with multiple vendor DBMS platforms, with experience in one or more of PostgreSQL, MySQL, SQL Server, and data warehouses (i.e., Snowflake, Redshift, Vertica, Oracle, etc)
- Experience with cloud providers such as AWS, and familiarity with one or more hosted technologies such as S3, DynamoDB, RDS, Redshift, Aurora, and DMS Desired experience with ETL tools, database migration from on-premises to Cloud, and cloud-hosted technologies for database service management.
Qualifications:
- Bachelor’s degree in computer science or a related field.
- 8-11 years of experience in database administration, information technology, database architecture, or a related field.
- Experience with MySQL/Postgres/Aurora/MsSQL server tuning, query optimization, replication strategies, storage engines, monitoring, capacity planning, backups, recovery, HA, Clustering, etc.
- Ability to develop procedures, processes, and conventions to standardize database operations.
- Proficient in one of the scripting languages (shell, Perl, PHP, Python etc) for monitoring and custom automation.
- Good understanding of relational and dimensional data modeling
Salary and benefits: As per market standard
Employment type: Full-time
Work arrangement: In-office
Location: Gurgaon, India
Stem, Inc. is an equal opportunity employer committed to diversity in the workplace and does not discriminate against any employee or applicant for employment because of race, color, sex, pregnancy, religion, national origin, ethnicity, citizenship, sexual orientation, gender identity, age, marital status, disability, genetic information, military status, protected veteran status or any other factor protected by applicable federal, state or local laws.