SQLData Architect (Secret Clearance and US Citizenship Required)

Our Government Services Prime Client is seeking an experienced SQL/Data Architect with an active Secret security clearance to support our client and their government customer in Huntsville AL. This is an on-site position.

Must be a highly skilled SQL/Data Architect to design implement and manage enterprise-level data solutions. This role combines expertise in database administration data architecture and modern data technologies to support business intelligence data migration and cybersecurity initiatives.

The ideal candidate will work closely with or under the guidance of a Lead Architect to ensure alignment with organizational goals and best practices. This role requires a background in SQL development data modeling data architecture and cloud-based platforms along with a proven ability to optimize database performance and ensure data security.

Key Responsibilities:

Work with the Lead Architect to design and implement enterprise data architecture including conceptual logical and physical data models.

Guide and mentor Database Administrators and Developers in areas such as database optimization security protocols and troubleshooting.

Assist in leading data migration projects from on-premises systems (SQL Server) to modern platforms such as Azure Vantage and Dataverse.

Develop and maintain complex SQL functions stored procedures and queries for applications and business intelligence reporting.

Optimize database performance including indexing querying and normalization.

Architect and manage ETL processes using tools like Azure Data Factory and equivalent Microsoft stack technologies.

Architect data models and data flows optimized for business intelligence reporting and dashboarding.

Ensure database integrity security and compliance with industry standards (e.g. DISA DoW).

Collaborate with stakeholders to gather requirements and deliver solutions that align with business objectives.

Maintain documentation including schematics configurations performance metrics user manuals SOPs and change management requests.

Implement and maintain security provisions to guard against unauthorized updates copying or destruction of databases. Support risk management processes including security technical implementation guides and plans of action and milestones.

Act as a final escalation point for complex database incidents providing expert analysis and resolution strategies

Assign metadata tags develop search strategies and maintain a metadata library for data analytics.

Qualifications :

Required Skills and Qualifications:

BS in Computer Science and/or Computer Engineering or equivalent.

At least 7 years of experience in database architecture design and development.

Expertise in SQL development including troubleshooting debugging and performance optimization.

Strong knowledge of relational database management systems indexing querying and normalization.

Familiarity with integration patterns SOA REST SOAP and Enterprise Service Bus.

Knowledge of database schemas such as star schemas snowflake schemas and other data modeling techniques.

Have or be capable of obtaining within 1 month Security CE and a government-approved computing education certification consistent with primary skills.

Excellent communication leadership and project management skills.

Ability to collaborate effectively with the Lead Architect stakeholders and cross--

functional teams.

Preferred Qualifications and Certifications:

Experience with cybersecurity data analysis and reporting.

Knowledge of Agile methodologies and CI/CD pipelines.

Familiarity with Vantage (Army) Advana (DOW) or similar analytical engines.

Completion of Oracle Database SQL Exam (1Z0-071) is a plus.

Preferred Certifications such as:

o Google Professional Data Engineer

o Certified Analytics Professional (CAP)

o Certified Data Management Professional (CDMP)

o The Open Group Architecture Framework (TOGAF)

Additional Information :

LARC Staffing LLC is an Equal Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity and expression national origin disability or protected veteran status.

Our Equal Employment Opportunity Policy

Please note this job posting is not designed to cover or contain a comprehensive listing of activities duties or responsibilities that are required of the employee for this job. Duties responsibilities and activities may change at any time with or without notice. Client provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race color religion age sex national origin disability status genetics protected veteran status sexual orientation gender identity or expression or any other characteristic protected by federal state or local laws. This policy applies to all terms and conditions of employment including recruiting hiring placement promotion termination layoff recall transfer leaves of absence compensation and training. U.S. Export Controls Requirements: This job may require access to technology materials software or hardware that is controlled by the export laws of the United States. Candidates are required to provide proof of either US citizenship Permanent US residency or classification as a protected individual as defined in 8 USC 1324b (a) (3). This position is not eligible for immigration sponsorship.

Equal Opportunity Employer/Veterans/Disabled. Shareholder Preference in accordance with Public Law 88-352

Remote Work :

No

Employment Type :

Full-time