Development Database Administrator
About The Position
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.
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.
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
Benefits
- 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)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
