Sr. Database Engineer/Administrator

About Stem
Stem (NYSE: STEM) is a global leader in AI-enabled software and services that enable its customers to plan, deploy, and operate clean energy assets. The company offers a complete set of solutions that transform how solar and energy storage projects are developed, built, and operated, including an integrated suite of software and edge products, and full lifecycle services from a team of leading experts. More than 16,000 global customers rely on Stem to maximize the value of their clean energy projects and portfolios. Learn more at http://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.
 

Stem is Looking for a SQL Server Database Administrator in India with great SQL Server experience. This is an exciting opportunity to be a part of a growing office and a collaborative team. Review the job requirements below and please apply if you feel you are a good fit

Database Development

• Design and develop database schemas, objects (tables, views, stored procedures, and triggers), and ETL pipelines to support On Premise and Cloud based applications.
• Develop and maintain integration processes between on-premises databases, and AWS cloud platforms.
• Create and optimize SQL queries, scripts, and code for data manipulation and reporting.
• Leverage Data Loader, APIs, or similar tools for data imports, exports, and migrations.
• Develop data models that support development, business intelligence (BI) and analytics initiatives.
• Analyze database issues and troubleshoot or configure the database accordingly
• Drive automation of code
• Monitor database performance to ensure high levels of security and speed

Database Administration

• Manage and maintain Cloud-based databases (e.g. SQL Server Database, MySQL, Aurora DB, Redshift) and hybrid environments.
• Monitor and optimize database performance, ensuring high availability and security.
• Implement backup, recovery, and disaster recovery solutions for Cloud-hosted and on-premises databases.
• Administer and optimize databases and data integrations.
• Apply updates, patches, and manage database upgrades in cloud and on-prem environments.
• Assist in the design and implementation of cloud-based data warehousing solutions.

Performance Optimization

• Analyze and optimize database performance using indexing strategies, query tuning, and partitioning techniques.
• Troubleshoot and resolve complex database issues, ensuring minimal downtime.
• Monitor system performance and usage patterns to plan for future scalability.

Data Governance and Compliance

• Enforce data security, privacy, and compliance with relevant regulations (e.g., PCI, NIST, GDPR).
• Implement and maintain role-based access controls in On Premise and Cloud environments.
• Establish and document database development and administration standards.

Collaboration and Support

• Partner with Stem Engineers, architects, and key stakeholders to deliver robust solutions.
• Provide technical support to end-users and resolve database-related issues.
• Train team members on database tools, processes, and best practices.

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

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.