Database Architect

Summary

Join Catchpoint, a best-in-class company, as a Database Architect with in-depth SQL Server experience. You will manage and optimize database performance, ensure data integrity and security, and collaborate with developers. Success involves delivering high-quality solutions, optimizing SQL Server performance, and contributing to system scalability and reliability. You will be a key team player, designing robust architectures and improving processes. Your adaptability and proactive problem-solving will be crucial. This role offers the opportunity to make a lasting impact on the team and organization.

Requirements

• 6+ years of software development experience
• Excellent command of the SQL language with the ability to write and optimize complex queries
• Solid knowledge of relational database architecture and concepts
• Knowledge and experience in Kibana for application monitoring
• Knowledge of caching strategies and implementations for both distributed (like Redis) and in-memory approaches

Responsibilities

• Manage and optimize the performance of the databases for our critical systems
• Ensure security and data integrity of all database environments
• Develop and implement all database indexing, maintenance, and transformations
• Collaborate with application developers to support database-related application development
• Participate in the refinement and development of user stories, assessing the impact of new development on current database implementation, etc
• Write and optimize complex SQL queries and stored procedures for various applications
• Troubleshoot and resolve database-related issues
• Keep SQL servers up to date with necessary patches
• Developing a robust DB monitoring and reporting
• Suggest different caching approaches such as In-Memory or Redis etc opt for the business requirement

Preferred Qualifications

• Experience with or willing to learn ClickHouse, Hydrolix DB or other time series databases
• Experience developing reports using SQL Server Reporting Services or similar ones
• Startup or small cross-functional group experience

Benefits

#LI-REMOTE