MHK TECH INC
Join to apply for the
SQL Server Developer/Admin
role at
MHK TECH INC . 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. Perform Bulk Insert, import, export from different data sources. Develop scripts to create constraints, defaults, rules, tables, indexes, views, stored procedures, functions, triggers, cursors and dynamic TSQL queries.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Other
Industries
IT Services and IT Consulting
#J-18808-Ljbffr
SQL Server Developer/Admin
role at
MHK TECH INC . 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. Perform Bulk Insert, import, export from different data sources. Develop scripts to create constraints, defaults, rules, tables, indexes, views, stored procedures, functions, triggers, cursors and dynamic TSQL queries.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Other
Industries
IT Services and IT Consulting
#J-18808-Ljbffr