Development Database Administrator

Development Database Administrator Trimark Associates - 3.4 Folsom, CA Job Details Full-time $100,000 - $130,000 a year 1 day ago Benefits Paid holidays Disability insurance Health insurance On-site gym Dental insurance Flexible spending account Employee assistance program Vision insurance 401(k) matching Gym membership Loan assistance Life insurance Referral program Paid sick time Qualifications Database security management SQL ETL Full Job Description 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.