Senior Adobe AEM Developer or SQL Data Architect

Innosoft Corporation • Columbia, SC

1d • Onsite

About The Position

The South Carolina Department of Revenue (SCDOR) is seeking a skilled Systems Software Programmer with expertise in Adobe Experience Manager (AEM), Power BI, and data architecture to support its enterprise technology environment. The contractor will support SCDOR’s implementation and ongoing use of AEM and Power BI for forms development, workflow automation, dashboards, and reporting solutions. The environment is complex, multi-layered, and secure, with work performed according to established methodologies, procedures, and industry best practices.

Working under limited supervision and reporting directly to a functional manager, the contractor will collaborate with the technology team to maintain the stability, integrity, availability, and performance of data and server services. Work includes monitoring, maintaining, supporting, troubleshooting, and optimizing server infrastructure. The role also involves database architecture and development, application support, testing, deployments, documentation, security practices, customer support, and process improvement. Participation in a shared 24/7 on-call rotation is required. The position is onsite at 300 A Outlet Point Blvd, Columbia, South Carolina. Candidates must be current South Carolina residents; relocation is not allowed. The contractor must work on an Innosoft W-2 and have at least six months of valid work authorization from the listed categories. The contract duration is 12 months, with a tentative start date of November 17, 2026.

Requirements

• Bachelor’s or master’s degree in Information Technology or a related field.
• 10 or more years of experience in database modeling, architecture, and development.
• 9 or more years of experience working with state government agencies.
• 10 or more years of advanced SQL experience.
• 5 or more years of hands-on experience with Adobe Experience Manager (AEM) 6.5.
• 4 or more years of experience in Java development, application design, and coding.
• 5 or more years of experience working with Agile methodologies.
• Ability to establish and maintain strong professional relationships with business users, management, vendors, and team members.
• Strong organizational, multitasking, and time-management skills, including the ability to prioritize tasks and meet deadlines.
• 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.
• Must be a current South Carolina resident; relocation is not allowed.
• Must work on an Innosoft W-2 and have at least six months of valid work authorization; listed categories are Citizen, GC, EAD, OPT-EAD, and H4-EAD.

Nice To Haves

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

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 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 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, integration, 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 coding standards, unit test coverage requirements, automation practices, and continuous integration processes.
• Work 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 computer systems, network products, software technologies, and industry best practices.
• Follow organizational information security policies and guidelines and promote 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 and independent problem-solving; ask relevant questions to clarify technical and business requirements.
• Identify, recommend, communicate, and implement process improvements to enhance operational efficiency.
• Manage multiple assignments and priorities 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 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.
• Participate in a shared 24/7 on-call rotation supporting critical systems and infrastructure.

Benefits

• Standard employee benefits.
• 50% of health insurance paid by Innosoft.
• Paid vacation.
• 401(k) match.
• Short-term disability (STD), long-term disability (LTD), and AD&D paid by Innosoft.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior