SQL Server Database Architect

Florham Park, New Jersey

 MDMS Recruiting
Apply for this Job
Job Description
W2 or Self Incorporated Only No C2C / No Corp to Corp

This is a hybrid role (onsite 3 days per week)

SQL Server Database Architect
  • Architect scalable and robust database schemas to support business data requirements, utilizing extensive SQL experience for efficient database structures.
  • Apply expertise in SQL performance tuning to optimize database operations and enhance data retrieval and manipulation speed.
  • Implement SQL database security measures, including robust access controls, encryption, and auditing policies, to protect sensitive data.
  • Design and manage complex SQL queries, stored procedures, views, and functions to support data analysis, reporting, and business intelligence, optimizing query performance and ensuring data integrity.
  • Lead data migration and integration projects, ensuring seamless data transfers and accurate data consolidation with extensive SQL expertise.
  • Develop strategies utilizing SQL expertise to ensure business continuity, including robust backup procedures and data replication.
  • Manage SQL databases across various platforms, ensuring consistent performance and data integrity.
  • Create comprehensive documentation for SQL database architectures, coding standards, data models, and reporting protocols to ensure consistency and clarity across technical projects.
  • Provide expert advice and support on SQL database management, reporting, and Performance or Database designs.
  • Design, develop and promote data strategy, architecture, methodologies, and standards for modern platforms.
  • Provide vision and thought leadership on High-Level Architecture and Design, to establish data architecture frameworks.
  • Interpret and deliver impactful strategic plans improving data integration, data quality, and data delivery in support of business initiatives and roadmaps.
  • Should have hands on experience with availability group, Distributed availability group and replica.
  • Experience with handling huge database and Redesign, Partition table if needed
  • Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM
  • Experience with logging, Monitoring, and alerting
Date Posted: 14 May 2025
Apply for this Job
Show me similar jobs
Send me jobs by email