SQL DATABASE ARCHITECT

Hi,

Greetings from Iflowsoft Solutions Inc

Position Title: SQL Database Architect

Location: Florham Park, NJ

Position Summary:

·         Candidate must have 10+ years of experience

·         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.

·         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.

·         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.

·         Develop bespoke SQL solutions to address unique business challenges, enhancing operational efficiency and decision-making capabilities.

·         Create comprehensive documentation for SQL database architectures, coding standards, data models, and reporting protocols to ensure consistency and clarity across technical projects.

·         Maintain quality assurance processes for database operations and reports, ensuring data governance and security compliance.

·         Provide expert advice and support on SQL database management, reporting, and ERP system integration.

·         Share SQL knowledge by training and mentoring team members, developing training programs to elevate SQL capabilities.

·         Maintain effective communication with stakeholders, understanding their needs and delivering updates on database and reporting services.

·         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.

·         Support the development of technology strategy and roadmaps acro

·         Also proactive planning to prevent future issues

·         Should have hands on experience with availability group, Distributed availability group and replica.

·         Expedience with handling Huge database and Redesign if needed

·         Manage and design Partition table

·         Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM

·         Builds data transformations with SSIS including importing data from files, moving data from one database platform to another.

·         Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data.

Iflowsoft Solutions inc is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law. We promote and support a diverse workforce at all levels in the company. This is not an unsolicited mail and if it is not intended for you or you are not interested in receiving our e-mails, you may unsubscribe