Job Details

CapB is looking for an MS SQL Database and Support Specialist to join our IT department. The ideal candidate will be responsible for supporting our MS SQL databases, performing T-SQL programming, triaging technical issues, and handling customer support requests related to a legacy .NET application. This role requires a deep understanding of MS SQL Server, proficiency in T-SQL, and excellent problem-solving skills to ensure high levels of performance and user satisfaction. This is a part time role, with 20 hrs per week and may require a day in office at Denver , each week for around 4 hrs. ( managers discretion, can be 100% remote)

• Issue Triage and Technical Support: Act as the first point of contact for identifying and troubleshooting database-related issues. Prioritize and resolve issues in a timely manner, ensuring minimal impact on operations and customer satisfaction.
• Customer and Internal Support: Respond to customer inquiries and support tickets with technical guidance and solutions. Work closely with the agency to understand requirements and deliver support needed for database and application functionalities.
• T-SQL Development: Develop and optimize T-SQL queries, stored procedures, functions, and triggers for data manipulation and to support application needs.
• Documentation and Reporting: Maintain clear documentation for database setups, configurations, procedures, and troubleshooting guides.

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Proven experience in MS SQL Server database administration and T-SQL programming.
• Strong understanding of database structures, theories, principles, and practices.
• Ability to effectively triage and resolve complex database issues.
• Excellent analytical, problem-solving, and organizational skills.
• Strong communication skills with the ability to provide technical support and guidance to customers and team members.
• Familiarity with .NET framework and its integration with MS SQL Server
• Experience with case management systems