Senior Adobe AEM Developer or SQL Data Architect

Senior Adobe AEM Developer / SQL Data Architect

Project Identifier

SC

Client

South Carolina

Agency

State of South Carolina

Location

Onsite

Location:
300 A Outlet Point Blvd, Columbia, South Carolina, USA, 29201.

Candidate
location: Candidate must be a CURRENT SC resident. No relocation
allowed.

Contract Duration

12 Months

Interview Type

Online

Visa Requirements

The candidate will have to be on an Innosoft
W2.

At least 6 months of valid work
authorization

(Citizen, GC, EAD, OPT-EAD, H4-EAD)

Tentative Start Date

11/17/2026

Deadline

10/19/2026

#
Project Overview
The South Carolina Department of Revenue (SCDOR) is
seeking a skilled and experienced Systems Software Programmer with expertise in
Adobe Experience Manager (AEM), Power Business Intelligence (Power BI), and
Data Architecture to support the agency's enterprise technology environment.
SCDOR operates in a complex, multi-layered secure environment and focuses on
delivering high-quality technology solutions through established methodologies,
procedures, and industry best practices. The selected contractor will support
the agency's implementation and ongoing use of AEM and Power BI for forms
development, workflow automation, dashboards, and reporting solutions.

Working under limited supervision and reporting
directly to a functional manager, the contractor will collaborate with the
technology team to ensure the stability, integrity, availability, and
performance of data and server services. Responsibilities include monitoring,
maintaining, supporting, troubleshooting, and optimizing server infrastructure
to ensure reliable and efficient operations. The ideal candidate should
demonstrate strong technical expertise, professionalism, problem-solving
abilities, and the ability to deliver quality work within established deadlines
while contributing innovative solutions and industry best practices. The
position requires participation in a shared 24/7 on-call rotation to support
critical systems and infrastructure.
Duties/Responsibilities:
- Collaborate
with consultants, application developers, and end users to develop logical
data models and data architecture for assigned applications.
- Design
and develop relational databases within established architectural
frameworks to meet application and business requirements.
- Serve as
the lead database designer for assigned application systems, ensuring
database performance, scalability, and reliability.
- Develop,
implement, and maintain database design standards, best practices, and
procedures.
- Write,
maintain, and optimize stored procedures, database scripts, and other
database objects.
- Establish
standards for stored procedures, Object-Relational Mappers (ORM), database
access methods, and application-level database error handling.
- Develop
database utilities, including SQL Server Integration Services (SSIS)
packages and database scripts, to support application functionality.
- Analyze
anticipated data volumes, usage patterns, and agency data requirements to
improve database access, processing, and performance.
- Provide
technical support to application developers in resolving database-related
issues in development and production environments.
- Collaborate
with Database Administration teams to identify, troubleshoot, and resolve
database performance issues.
- Prepare,
maintain, and obtain approval for system design specifications, technical
documentation, and programming documentation.
- Configure
system settings and options to meet application functionality,
performance, and business requirements.
- Plan,
develop, and execute unit testing, integration testing, and user
acceptance testing (UAT) to validate system functionality.
- Assist
with application deployments, releases, and migrations across Development,
Quality Assurance (QA), and Production environments.
- Follow
secure web programming, application development, and deployment best
practices.
- Adhere
to established coding standards, unit test coverage requirements,
automation practices, and continuous integration processes.
- Work
closely with internal teams and external vendors to ensure effective site
architecture, system performance, reliability, and content delivery.
- Troubleshoot
technical issues related to backup configuration, data recovery, system
operations, and application performance.
- Develop
and implement temporary workarounds and permanent technical solutions to
resolve customer and system issues.
- Perform
hardware, equipment, and software upgrades to maintain system
functionality and operational efficiency.
- Maintain
knowledge of current computer systems, network products, software
technologies, and industry best practices.
- Follow
organizational information security policies and guidelines while
promoting secure practices among team members.
- Communicate
effectively with IT professionals, technical teams, management, and
director-level stakeholders.
- Provide
feedback and recommendations regarding product issues, system
enhancements, new features, and technology improvements.
- Demonstrate
initiative, independent problem-solving skills, and the ability to ask
relevant questions to clarify technical and business requirements.
- Proactively
identify, recommend, communicate, and implement process improvements to
enhance operational efficiency.
- Manage
multiple assignments and priorities simultaneously while providing regular
status updates to stakeholders.
- Collaborate
with peers, management, and vendors to resolve client issues and
contribute to shared technical knowledge and documentation.
- Prioritize
and resolve technical issues based on severity, business impact, and
established service-level agreements (SLAs).
- Maintain
accurate Helpdesk records, take ownership of assigned tickets, and provide
timely updates to clients and internal teams.
- Deliver
responsive customer support with strong attention to detail,
professionalism, and commitment to service quality.
- Perform
responsibilities in accordance with the agency's mission, organizational
values, and client service standards.
- Perform
other assigned duties and special projects as required.

Requirements

Education and Certifications:

- Bachelor's
or Master’s in Information Technology or related field

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

Preferred Skills:

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

Additional Skills:

- Ability
to establish and maintain strong professional relationships with business
users, management, vendors, and team members.
- Strong
organizational, multitasking, and time-management skills, with the ability
to prioritize tasks and meet deadlines effectively.
- Hands-on
understanding of business processes, workflows, and operational
requirements.
- Excellent
verbal and written communication skills, with the ability to convey
information clearly, concisely, and professionally.

### Benefits
Standard Employee Benefits.
50% Health Insurance Paid by Innosoft, Paid Vacation, 401K Match, STD LTD and AD&D paid by Innosoft.