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