SQL Server Developer/DBA(Locals Only)

  • Jersey City, NJ
  • Posted 15 hours ago | Updated 15 hours ago

Overview

On Site
$40 - $50
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

SQL Server
TSQL

Job Details

An in-person interview is a Must

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, vies, stored
procedures, functions, triggers, cursors and dynamic TSQL queries.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.