Data Information Architect - Contract - Columbia, SC Onsite

SUNSHINE ENTERPRISE USA LLC•Irmo, SC

6d•Onsite

About The Position

The Data Information Architect supports the development, maintenance, and optimization of enterprise applications, data architecture, database systems, and reporting solutions. The role requires experience in database modeling, relational database design, advanced SQL development, Adobe Experience Manager (AEM) 6.5, Java development, and Agile methodologies. Working under limited supervision and reporting to a functional manager, the contractor collaborates with application developers, business users, technical teams, and vendors to maintain data integrity, improve application performance, support system deployments, and ensure reliable server and database services. The role also includes developing technical documentation, supporting application testing and migrations, following secure programming practices, and participating in shared 24/7 on-call support.

Requirements

10+ years of experience in database modeling, architecture, and development.
9+ years of state government experience.
10+ years of advanced SQL experience.
5+ years of experience with Adobe Experience Manager (AEM) 6.5.
4+ years of Java development, design, and coding experience.
5+ years of experience working with Agile methodologies.
Strong knowledge of relational database design, data modeling, stored procedures, and database performance optimization.
Experience supporting application development, testing, deployment, and migration across multiple environments.
Strong troubleshooting, analytical, and problem-solving skills.
Excellent communication, organizational, and time-management skills.
Bachelor’s or Master’s degree in Information Technology, Computer Science, or a related field.
Must be a current South Carolina resident; relocation is not allowed.

Nice To Haves

Experience with cloud-based solutions and infrastructure.
Experience supporting enterprise application environments and data architecture modernization.
Familiarity with secure web programming, continuous integration, and automated testing practices.
Project Management Professional (PMP) certification.
Other certifications issued by the Project Management Institute (PMI).

Responsibilities

Design and maintain logical data models and data architecture for assigned applications in collaboration with consultants, application developers, and end users.
Design relational databases within established architectural frameworks to meet application requirements and serve as lead database designer for assigned application systems.
Develop, implement, and maintain database design standards and best practices, including standards for stored procedures, object-relational mapping, database access, and application-level database error handling.
Write and maintain stored procedures, database scripts, and other database access components; develop database utilities and SSIS packages as required.
Analyze anticipated data volumes, usage patterns, and business requirements to improve database performance and efficiency.
Collaborate with database administrators to troubleshoot and resolve database performance issues.
Support application developers in resolving database-related issues in development and production environments.
Configure system settings and options to meet technical and business requirements.
Plan and execute unit, integration, and user acceptance testing activities as applicable.
Prepare system specifications, programming documentation, and technical documentation for review and approval.
Assist with application deployment across Development, QA, and Production environments, and support application migrations and upgrades.
Follow secure web programming practices, coding standards, unit test coverage requirements, automation practices, and continuous integration procedures.
Collaborate with internal teams and vendors to maintain effective site architecture, system performance, reliability, and content delivery.
Support Adobe Experience Manager (AEM) and Power BI solutions used for forms, workflows, dashboards, and reporting.
Monitor, maintain, support, and optimize server infrastructure, data services, and related systems.
Troubleshoot technical issues and recommend solutions for customer and application support requests.
Troubleshoot backup configuration and recovery issues and develop workarounds when necessary.
Perform software and equipment upgrades as required and maintain familiarity with current computer, server, and networking technologies.
Follow information security guidelines and promote secure practices across the team.
Manage support tickets, document issue resolution, provide timely stakeholder updates, and prioritize incidents and service requests according to severity and established service levels.
Participate in shared 24/7 on-call support responsibilities.
Communicate effectively with technical peers, business users, management, vendors, and stakeholders at all organizational levels.
Provide feedback on product issues, enhancements, and new features; proactively identify and implement process improvements.
Manage multiple assignments simultaneously, provide regular status updates, maintain strong customer service and responsiveness, and build effective working relationships across technical and business teams.
Perform other duties and special projects as assigned.