Software Architect

Key Responsibilities: • Assess the current SQL Server database architecture and identify areas for improvement in scalability, performance, and maintainability. • Design and implement a new high-performance, future-ready database architecture to support a 5M daily transaction load and integration with microservices and AI-driven systems. • Develop and implement a comprehensive archival strategy for cold, warm, and hot data storage to efficiently manage a large-scale system of 100TB. • Work closely with application developers to ensure database design aligns with the microservices architecture. • Optimize database performance by identifying and resolving bottlenecks, indexing strategies, and query tuning. • Develop and implement best practices for database design, partitioning, indexing, and data archiving. • Ensure high availability and disaster recovery strategies with near-zero RPO and RTO, considering the multi-agency information handled by the system. • Collaborate with DevOps teams to automate deployment, backup, and monitoring processes. • Implement data security measures and ensure compliance with industry standards. • Provide technical guidance and mentorship to the development and operations teams. • Stay up-to-date with the latest SQL Server technologies and industry trends. Required Qualifications: • Bachelor's or Master's degree in Computer Science, Information Technology, or a related field. • 8+ years of experience in SQL Server database design, development, and administration. • Proven experience in redesigning and implementing large-scale, high-performance SQL Server databases, with the ability to contribute from day one. • Strong understanding of database scalability techniques such as sharding, partitioning, and indexing. • Experience in handling large-volume databases (100TB+) and implementing efficient archival strategies. • Proficiency in performance tuning, query optimization, and troubleshooting database issues. • Experience with self-hosted SQL Server databases on virtual machines (VMs). • Hands-on experience with database migration, backup, and recovery processes. • Familiarity with data modeling techniques and tools such as ERwin or PowerDesigner. • Strong knowledge of T-SQL, stored procedures, and triggers. • Experience with microservices architecture and integrating databases within distributed systems. • Excellent problem-solving skills and the ability to work in a fast-paced environment. • Strong communication and collaboration skills.

Preferred Qualifications: • Tolling Experience is strong plus • Any relevant SQL Server certification is preferred. • Experience with NoSQL databases and hybrid database solutions. • Knowledge of AI-driven database optimization and predictive analytics. • Knowledge of ETL processes and data warehousing concepts.