Development Database Administrator

Overview

Trimark Associates is a leading innovator in utility-scale solutions to help electric power resources optimize control, connect to the grid, maximize revenue, and meter energy transactions.  We specialize in state-of-the-art SCADA (Supervisory Control and Data Acquisition) systems and software platforms. Our cutting-edge technologies empower the renewable industry to monitor, control, and optimize complex processes with precision and efficiency. As we continue to expand our offerings, we are seeking a talented Development Database Administrator (DDBA) to join our dynamic team and contribute to the development of an exceptional software platform. As the DDBA, you will be responsible for managing and maintaining the databases of Trimark and our customers.

This position may be performed remotely or based onsite or hybrid at our headquarters in Folsom, California, at management’s discretion.

Responsibilities

Designing, building and optimizing queries in MS SQL and PostgreSQL

Reading and interpreting execution plans in SQL Server and PostgreSQL to troubleshoot query performance issues

Designing, building and optimizing indexes in MS SQL and PostgreSQL

Creating and managing database partitions

Monitoring database performance and tuning them for optimal performance

Monitoring index performance and tuning them for optimal performance

Ensuring data security and integrity.

Developing and maintaining database documentation, including data standards, procedures, and definitions for the data dictionary

Collaborating with developers to design, develop, and implement new database applications

Troubleshooting database issues

Knowledge, Skill, and Ability Requirements

Proficient in the usage of PostgreSQL, Timescale and Microsoft SQL Server databases

Strong knowledge of ETL solutions (Azure Data Factory preferred)

Strong knowledge of Azure cloud database technologies.

Strong knowledge of SQL and experience with relational databases

Experience with PostgreSQL and SQL Server administration

Knowledge of database partitioning procedures

Knowledge of database security best practices

Proven history of using excellent problem-solving skills to address technical issues

Strong communication skills to work effectively with developers, management, and other stakeholders

Must be legally authorized to work in the United States of America. This position is not eligible for Visa sponsorship.

Benefits

Trimark Associates offers a comprehensive benefits package, including the following:

Paid Vacation

Paid Sick Leave

Paid Holidays

Medical Insurance

Dental Insurance

Vision Insurance

Health Savings Plan

Flexible Spending Account

401K Match

Student Loan Assistance

529 Savings Plan

Referral Bonus

Company Paid Life Insurance

Voluntary Life Insurance

Long Term Disability Insurance

Accident Insurance

Critical Illness Insurance

Identity Theft Protection

Legal Insurance

Pet Discounts

Employee Assistance Program

Onsite Gym Access (Folsom office)

Equal Opportunity Statement

Trimark is committed to compliance with all applicable laws providing equal employment opportunities. This commitment applies to all people involved in Company operations and prohibits unlawful discrimination by any employee of the Company, including supervisors and coworkers.

E-Verify Statement

Trimark will provide the Social Security Administration, and if necessary, the Department of Homeland Security, with information from each new employee’s Form I-9 to confirm work authorization. Please note that we do not use this information to pre-screen job applicants.

Work Authorization

This role is not eligible for sponsorship by Trimark, including future sponsorship.  Candidates must reside and be legally authorized to work in the United States.

Pay Transparency

Compensation is based on market rate, job level, job related knowledge, skills, experience, education, and certifications.   

Candidate Safety

Trimark engages in a structured hiring process during which you will meet with multiple team members.  We do not issue offers based on email contact and will not ask for your personal or sensitive information prior to an accepted offer.  Communications from our talent team will come from the trimarkassoc.com domains.  

Unsolicited Candidate Referrals

Trimark values our strategic partnerships with our agency partners who may supplement our internal recruitment team’s efforts from time to time.  To submit candidates for consideration, agency partners must have an executed agreement signed by Trimark’s president and a job specific requisition.  Without such agreements in place, Trimark will not pay a fee to any agency.  Unsolicited referrals from any source other than directly from a candidate will be considered Trimark property and will be considered to have been referred by the agency free of any charge or fee.  This includes resumes, partial resumes, candidate profiles, and candidate details or information.