Data Architect

This is an onsite role; only local candidates will be considered.

Responsibilities

• Design and develop logical data models and relational database architectures, serving as lead database designer for assigned application systems.
  
• Develop and implement database design standards, including standards for stored procedures, database access, and error handling.
  
• Write, maintain, and optimize advanced SQL queries, stored procedures, SSIS packages, database scripts, and supporting utilities.
  
• Analyze data volumes, application usage patterns, and database performance, and partner with database administrators to resolve performance issues.
  
• Support Adobe AEM 6.5 applications and related workflows, and perform Java application development, design, and coding activities.
  
• Support Power BI reporting and dashboard technology, and configure system settings and application options as needed.
  
• Develop technical specifications and system documentation, and plan and execute unit, integration, and acceptance testing.
  
• Assist with deployments and application migrations across Development, QA, and Production environments while following secure development and deployment practices.
  
• Investigate and resolve application and production issues, troubleshoot backup and recovery problems, perform software upgrades, and develop technical workarounds when appropriate.
  
• Maintain accurate Helpdesk documentation and ticket updates, provide timely status updates, and communicate effectively with technical peers, business users, IT leadership, and outside vendors.
  

Minimum Qualifications

• 10 years of experience in database modeling, architecture, and development.
  
• Experience designing logical and relational data models.
  
• Experience designing databases for enterprise applications.
  
• Experience implementing database architecture and design standards.
  
• 9 years of state government experience.
  
• Direct experience supporting state government technology environments.
  
• Understanding of state agency operations and enterprise application requirements.
  
• 10 years of advanced SQL experience.
  
• Hands-on experience writing complex SQL queries.
  
• Experience developing stored procedures.
  
• Experience with database optimization and troubleshooting.
  
• Experience with relational database development.
  
• 5 years of Adobe Experience Manager (AEM) 6.5 experience.
  
• Hands-on experience supporting, developing, or maintaining applications using AEM.
  
• Understanding of AEM-based enterprise application environments.
  
• 4 years of Java development, design, and coding experience.
  
• Experience developing and maintaining enterprise applications.
  
• Experience troubleshooting and supporting Java-based systems.
  
• 5 years of experience working in Agile development environments.
  
• Experience collaborating with application developers and technical teams.
  
• Experience supporting iterative development, testing, and deployment processes.
  
• Bachelor’s or master’s degree in Information Technology or a related field.
  

Preferred Qualifications

• Experience with cloud-based solutions, cloud application architecture, and cloud data platforms.
  
• Experience with enterprise cloud integration.
  
• Experience with Power BI development and reporting.
  
• Advanced SQL Server Integration Services (SSIS) development experience.
  
• Experience with SQL Server performance optimization.
  
• Experience with database access-layer design.
  
• Experience with enterprise application integration.
  
• Experience with automated testing and continuous integration.
  
• Experience with secure web application development.
  
• Experience with government technology modernization.
  
• Experience working in large-scale enterprise environments.
  
• Experience with Adobe AEM Forms and AEM Workflows.
  
• Experience with T-SQL and CI/CD practices.
  
• South Carolina state government or South Carolina Department of Revenue experience.
  
• Project Management Professional (PMP) or other PMI-issued certification.
  

Additional Requirements

• Candidates must currently reside in South Carolina.
  
• Candidates must be able to work 100% onsite in Columbia, South Carolina.
  
• Candidates must be available for an onsite interview in Columbia, South Carolina.
  
• Candidates must complete a criminal background check, credit check, E-Verify, and South Carolina tax compliance review.
  
• Candidates must participate in shared 24/7 on-call support.
  

Work Location and Schedule