What are the responsibilities and job description for the SQL Server Database Architect position at MDMS Recruiting LLC?
Job Description
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
