JOBSEARCHER

SQL Database Architect

ARCHIVED

We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.

Job Summary: (SQL Database Architect) 10+ years of experience required in SQL Database Architecture and Management. Design and manage complex SQL queries, stored procedures, views, and functions to support data analysis and business intelligence. Architect scalable and robust database schemas for business data requirements. Optimize SQL database performance through advanced performance tuning. Implement and manage SQL database security measures (access controls, encryption, auditing). Lead data migration and integration projects, ensuring data accuracy and seamless transfer. Develop and maintain robust backup procedures and data replication strategies for business continuity. Manage SQL databases across multiple platforms, ensuring performance and data integrity. Develop custom SQL solutions for unique business challenges. Create comprehensive documentation for database architectures, coding standards, and reporting protocols. Maintain quality assurance processes for database operations and reports to ensure data governance and security compliance. Provide expert support on SQL database management, reporting, and ERP integration. Train and mentor team members, sharing SQL knowledge and developing training programs. Maintain effective communication with stakeholders, gathering requirements and delivering updates. Design and promote data strategy, architecture, methodologies, and standards for modern data platforms. Provide vision and leadership on high-level architecture and design, establishing frameworks and strategic plans. Improve data integration, quality, and delivery processes to support business initiatives. Proactively plan to prevent future issues in database systems. Hands-on experience with Availability Groups, Distributed Availability Groups, and replicas. Experience handling large-scale databases and redesigning as needed. Manage and design partitioned tables for large datasets. Design and develop SSIS/SQL ETL solutions, acquiring and preparing data from multiple sources. Build and debug SSIS data transformations, ensuring efficient and accurate data movement. Tune and troubleshoot SSIS or other ETL processes for optimal performance.