> Markdown version of [/jobs/ext/4364023-sql-data-architect](https://www.wearedevelopers.com/jobs/ext/4364023-sql-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # SQL Data Architect - **Company:** AreteTechnologies Inc - **Location:** Columbia, SC, United States - **Experience:** Experienced - **Salary:** $166,400.0 - **Contract:** Permanent contract - **Skills:** Java (Programming Language), Adobe Experience Manager, Agile Methodology, Data Analysis, Applications Architecture, Application Performance Management, Cloud Computing, Code Coverage, Software Documentation, Cyber Security, Computer Programming, Databases, Continuous Integration, Data Architecture, Data Integrity, Data Security, Relational Databases, Database Design, Database Models, Logical Data Models, Object-Relational Mapping, Web Application Security, Software Engineering, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Enterprise Software Applications, Sql Optimization, Database Optimization, Database Performance, Information Technology, Software Coding - **Published:** October 12, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=2ee2912655b8e36a ## About the Role The ideal candidate will design and maintain database architectures, support enterprise application development, optimize data access and performance, and contribute to the development of secure, reliable applications. Experience working with state government organizations and Agile methodologies is essential. This role requires a highly motivated professional who can collaborate effectively with technical teams, business stakeholders, and vendors while maintaining high standards for data integrity, security, and application performance., * 10+ years of experience in database modeling, architecture, and development. * 9+ years of experience working with state government organizations. * 10+ years of advanced SQL experience. * 5+ years of experience with Adobe Experience Manager (AEM) 6.5. * 4+ years of Java development, design, and coding experience. * 5+ years of experience working with Agile methodologies. * Strong understanding of relational database design, stored procedures, and database optimization. * Experience supporting application development, testing, deployment, and production troubleshooting. * Knowledge of secure application development and information security best practices. Preferred Qualifications * Experience working with cloud-based solutions. * Project Management Professional (PMP) certification or another certification issued by the Project Management Institute (PMI). Education Requirements * Bachelor's or Master's degree in Information Technology or a related field., * Excellent verbal and written communication skills. * Strong analytical, troubleshooting, and problem-solving abilities. * Excellent organizational, multitasking, and time-management skills. * Ability to work effectively with business users, management, vendors, and technical teams. * Strong understanding of business processes and application requirements. * Ability to take initiative, work independently, and identify process improvements. * Strong customer service skills and attention to detail. * Ability to manage competing priorities and resolve issues within established service levels. ## Description We are seeking an experienced Data/Information Architect Consultant with strong expertise in database modeling, data architecture, advanced SQL, Adobe Experience Manager (AEM 6.5), and Java development., * Design and develop logical data models and data architectures for assigned applications. * Design relational databases that meet application and business requirements. * Serve as the lead database designer for assigned application systems. * Develop, implement, and maintain database design standards. * Write and maintain stored procedures, database scripts, and SQL Server Integration Services (SSIS) packages. * Establish standards for database access, object-relational mapping, and application-level error handling. * Analyze data volumes and usage patterns to improve database performance and efficiency. * Collaborate with application developers to troubleshoot and resolve database-related issues in development and production environments. * Work with database administration teams to identify and resolve performance issues. * Prepare and maintain system documentation, programming specifications, and technical documentation. * Configure system settings and develop specifications based on business requirements. * Plan and execute unit, integration, and acceptance testing. * Support application deployments and migrations across Development, QA, and Production environments. * Follow secure web development practices, coding standards, test coverage requirements, automation, and continuous integration processes. * Collaborate with technical teams and vendors to ensure application architecture, reliability, performance, and content delivery meet established standards. * Troubleshoot backup and recovery issues and recommend appropriate technical solutions. * Support equipment and software upgrades while adhering to information security guidelines. * Manage multiple priorities, provide timely status updates, and respond effectively to support requests. * Participate in a shared 24/7 on-call rotation., * Nationwide criminal background check covering federal, state, and county records for the previous seven years. * Credit history check. * Employment eligibility verification through E-Verify. * South Carolina tax history verification; candidates must be current on applicable tax filings and payments. Application Requirements Interested candidates should submit the following documents: * Updated resume. * Valid Right to Represent (RTR). * Required cover letter. * Completed South Carolina cover sheet. * Confirmation that the candidate meets the onsite work location and South Carolina residency requirements. Please ensure all required documents are submitted with the candidate's full legal first and last name.