Senior Adobe AEM Developer or SQL Data Architect

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 agencys 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 agencys 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 agencys mission organizational values and client service standards.
  
• Perform other assigned duties and special projects as required.
  

Education and Certifications:

• Bachelors or Masters 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.