Senior Adobe AEM Developer / SQL Data Architect

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.

• 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