Senior Data Architect - AEM, SQL, Java, Enterprise

HTC Global; Columbia (SC); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Hybrid and Workplace flexibility

Well-defined career development plan

Rewards & Recognition program

L&D focuses on upskilling

Hands-on experience on Emerging Tech

Job summary

HTC Global Services is seeking a Senior Database Architect to work onsite in Columbia, SC. You will design data models, build relational databases, and optimize performance across development, QA, and production environments.

The role requires extensive SQL and Java development, experience with Adobe AEM 6.5, and Agile practices. You will collaborate with consultants, vendors, and business users to maintain data integrity and enable reliable analytics and reporting.

Qualifications

• 10+ years of database modeling, architecture, and development experience.
• 9+ years of State Government experience.
• 10+ years of advanced SQL experience.
• 5+ years of experience with Adobe AEM 6.5.
• 4+ years of Java development, design, and coding experience.
• 5+ years of experience with Agile methodology.
• Bachelor's or Master's degree in Information Technology or a related field.

Responsibilities

• Develop logical data models and data architecture for assigned applications in collaboration with consultants, application developers, and end users.
• Design relational databases within the established architectural framework and serve as the lead database designer for assigned application systems.
• Develop and implement database design standards.
• Write and maintain stored procedures and establish standards for stored procedures, object-relational mappers, database access, and application-level database error handling.
• Build database utilities as needed, including SSIS packages and database scripts.
• Analyze anticipated data volumes and usage patterns to improve database access and data manipulation efficiency.
• Support application developers in resolving database-related issues in development and production environments.
• Work with Database Administration to troubleshoot and resolve database performance problems.
• Prepare system and programming documentation and obtain the required approvals.
• Configure system settings and options; plan and execute unit, integration, and acceptance testing; and create system specifications to meet business requirements.
• Assist with application deployments and migrations across development, QA, and production environments.
• Follow secure web programming and deployment practices, coding standards, unit test coverage expectations, automation practices, and continuous integration processes.
• Collaborate with the team and vendors to maintain sound site architecture, performance, reliability, and content delivery practices.
• Troubleshoot customer issues related to backup configuration and recovery, recommend technical solutions, and develop workarounds when appropriate.
• Perform equipment and software upgrades and maintain familiarity with current computer and network products.
• Follow information security guidelines and promote security awareness among coworkers.
• Communicate effectively with peers, management, vendors, and stakeholders; provide status updates; prioritize multiple issues; and respond to customer tickets within accepted service levels.
• Identify process improvements, provide product feedback, maintain accurate Helpdesk issue updates, and perform other duties and special projects as assigned.

Skills

Adobe AEM

SQL

Java

Data modeling

Agile methodology

Power BI

SSIS

Education

Bachelor’s or Master’s degree in IT or related field

Tools

Adobe AEM 6.5

SQL Server

SSIS

Power BI

Job description

HTC Global Services is seeking a Senior Database Architect to work onsite in Columbia, SC. You will design data models, build relational databases, and optimize performance across development, QA, and production environments.

The role requires extensive SQL and Java development, experience with Adobe AEM 6.5, and Agile practices. You will collaborate with consultants, vendors, and business users to maintain data integrity and enable reliable analytics and reporting.