SQL Server Developer / Admin

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.
• Perform Bulk Insert, import, export from different data sources.
• Develop scripts to create constraints, defaults, rules, tables, indexes, vies, stored

procedures, functions, triggers, cursors and dynamic TSQL queries.