Job Description
Job DescriptionDescription:
The Database Administrator (DBA) will be responsible for monitoring, tuning, and maintaining our Microsoft SQL Server database. The DBA will provide significant contributions in helping Tria Health improve operational efficiency, reduce risk, and further enable strategic initiatives.
Essential Duties and Responsibilities:
- Monitor the performance and security of Microsoft SQL Server databases.
- Tune databases to ensure efficient operation and response times.
- Optimize existing data queries and stored procedures.
- Assist with building and maintaining Tria’s data warehouse.
- Create, manage, and optimize indexes to improve query performance.
- Develop and implement backup and recovery plans for databases.
- Collaborate with the Software Development team on DBMS selection and establish best practices for usage.
- Provide training and resources for the Development team on SQL Server optimization techniques.
- Perform regular database maintenance tasks including updates and patches.
- Analyze and resolve complex database-related issues.
- Research and integrate new DBA tooling where applicable and cost-effective.
- Collaborates with fellow IT team members to isolate and resolve technical issues, but also skilled enough to identify, research, and resolve technical issues independently – all in a timely manner.
- Looking for continuous improvement opportunities, and promoting innovation.
- Communicates with stakeholders on a regular basis, and upholds the standards of any published IT SLA (service level agreement) documentation.
- Highly committed to constantly learning, and self-improvement, dedicating regular time to formal or self-guided training opportunities.
- On-call support availability may be required periodically in the event of critical system failures.
- Commitment to Tria Health’s mission statement, motto, core values, and employee handbook.
- Other related duties as assigned.
Requirements:
Knowledge and Skills:
- Proven experience as a DBA, with a focus on Microsoft SQL Server.
- Experience with Microsoft Azure cloud-based and on-premises Microsoft SQL database environment required.
- Strong understanding of database structures, theories, principles, and practices.
- Experience in performance tuning and optimization of SQL databases.
- Proficiency in T-SQL and SQL query writing.
- Knowledge of database backup, recovery, and security protocols.
- Excellent problem-solving skills and attention to detail.
- Effective communication skills to teach and collaborate with the software development team.
- Experience with database administration of non-Microsoft SQL databases (e.g., NoSQL, MySQL, PostgreSQL) is a plus.
- Experience in administration of other data-driven infrastructure such as MQ, BPMS, and caching is a plus.
- Experience with Redgate Test Data Manager (TDM) is a plus.
Abilities:
- Highly motivated, self-starter with a strong sense of duty.
- Communicates technical concepts clearly to a diverse range of stakeholders who have varying degrees of technical acumen.
- Superior analytical skills.
- Highly organized and efficient with the ability to multitask, and can prioritize tasks appropriately.
- Goes above and beyond to create outstanding customer experiences.
- Productive without sacrificing quality, maintainability, accessibility, or performance; perform duties at a high degree of accuracy.
- Ability to work with non-technical users in a professional, courteous, and polite manner.
- Ability to communicate effectively using email, Teams chat, SMS text, phone, video conferencing, and remote screen sharing.
- Encourage giving and receiving feedback, while handling such in a positive and graceful fashion.
Education and Experience:
- Bachelor’s degree in Computer Science, Information Technology, or related field or equivalent work experience.
- 1+ years of relevant work experience as a DBA.
- Experience as a software application developer is a plus.
- In addition to either of the education/experience classifications above, Microsoft SQL certification, or similar certification, is a plus.