Innosoft Corporation - Senior Adobe AEM Developer or SQL Data Architect

Database Developer is needed in Columbia, United States.

Client: Innosoft Corporation

Location: Columbia, SC, us

Contract: Contract

Job Description

South Carolina Department of Revenue (SCDOR) is seeking a Senior Adobe AEM Developer / SQL Data Architect to support its enterprise technology environment. The role will focus on Adobe Experience Manager (AEM), Power BI, database architecture, forms development, workflow automation, dashboards, and reporting solutions.

Working under limited supervision, the contractor will support the stability, availability, performance, and security of data and server services within a complex, secure state-government environment. The position requires participation in a shared 24/7 on-call rotation.

Key responsibilities include:

• Design logical data models, relational databases, and data architectures for assigned applications.
• Lead database design activities, ensuring performance, scalability, reliability, and alignment with business requirements.
• Develop and optimize stored procedures, SQL scripts, database objects, SSIS packages, and database utilities.
• Establish database design, ORM, database access, error-handling, coding, testing, and deployment standards.
• Analyze data volumes and usage patterns to improve database access, processing, and performance.
• Provide database-related support to application developers and collaborate with database administrators to resolve performance issues.
• Configure system settings and support application deployments, releases, migrations, and upgrades across Development, QA, and Production environments.
• Plan and execute unit, integration, and user acceptance testing.
• Support AEM, Power BI, site architecture, system performance, workflow automation, content delivery, dashboards, and reporting solutions.
• Troubleshoot application, backup, recovery, infrastructure, and operational issues, implementing temporary workarounds and permanent solutions.
• Prepare and maintain system design specifications, technical documentation, programming documentation, and Helpdesk records.
• Follow secure development, deployment, information security, continuous integration, automation, and industry best practices.
• Collaborate with internal teams, vendors, management, technical stakeholders, and end users to resolve issues and implement improvements.
• Manage multiple priorities, provide status updates, meet service-level agreements, and deliver responsive customer support.
• Identify process improvements and provide recommendations for system enhancements, new features, and technology upgrades.
• Perform other assigned duties and special projects as required.

Requirements

Education and Certifications:

• Bachelor’s or master’s degree in Information Technology or a related field.

Required Experience and Technical Skills:

• 10+ years of experience in database modeling, architecture, and development.
• 9+ years of experience working with state government agencies.
• 10+ years of advanced SQL experience.
• 5+ years of hands-on experience with Adobe Experience Manager (AEM) 6.5.
• 4+ years of experience in Java development, application design, and coding.
• 5+ years of experience working with Agile methodologies.
• Experience with relational database design, stored procedures, database scripting, SSIS, performance optimization, testing, and production support.
• Knowledge of secure web programming, application deployment, system operations, backup and recovery, and information security practices.

Preferred Skills:

• Experience with cloud-based solutions.
• PMP or other PMI-issued certification.

Professional and Communication Skills:

• Ability to build and maintain effective relationships with business users, management, vendors, and technical teams.
• Strong organizational, multitasking, prioritization, and time-management skills.
• Understanding of business processes, workflows, and operational requirements.
• Excellent verbal and written communication skills.
• Strong problem-solving, analytical, customer-service, and independent-working abilities.
• Ability to manage competing assignments, meet deadlines, and communicate status effectively.

Project and Engagement Details

• Client: South Carolina Department of Revenue (SCDOR)
• Agency: State of South Carolina
• Project Identifier: SC
• Contract Duration: 12 months
• Work Arrangement: Onsite
• Work Location: 300 A Outlet Point Blvd, Columbia, South Carolina 29201, USA
• Interview Type: Online
• Tentative Start Date: November 17, 2026
• Application Deadline: October 19, 2026

Candidate and Work Authorization Requirements

• Candidate must be a current South Carolina resident.
• No relocation is permitted.
• Candidate must work on an Innosoft W-2.
• At least six months of valid work authorization is required.
• Accepted work authorization includes U.S. citizenship, Green Card, EAD, OPT-EAD, or H4-EAD.
• The position requires participation in a shared 24/7 on-call rotation.

Benefits

Standard employee benefits include 50% health insurance paid by Innosoft, paid vacation, 401(k) matching, and short-term disability, long-term disability, and AD&D coverage paid by Innosoft.