Overview
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)
