Senior Data Architect for Adobe AEM & SQL

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

Job summary

HTC Global Services is seeking a Senior Database Architect to lead data modeling and database design for enterprise applications leveraging Adobe AEM 6.5, SQL Server, and SSIS. You will architect data solutions, ensure data integrity, and support performance across development, QA, and production.

The role involves collaboration with developers, vendors, and business users while maintaining 24/7 on-call responsibilities.

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.
• 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.
• Design relational databases and lead database design for assigned systems.
• Develop and implement database design standards.
• Write and maintain stored procedures and establish standards for database access and error handling.
• Build database utilities including SSIS packages and scripts.
• Analyze data volumes and usage patterns to optimize performance.
• Support developers in resolving database issues in development and production environments.
• Troubleshoot database performance problems with DBA.
• Prepare system documentation and obtain approvals.
• Configure system settings, plan testing, and create system specifications.
• Assist with deployments and migrations across environments.
• Follow secure coding and deployment practices and CI processes.
• Collaborate to maintain sound site architecture, performance, and reliability.
• Troubleshoot backup configuration and recoverability, propose solutions.
• Perform equipment/software upgrades and stay current with tech.
• Follow information security guidelines and promote security awareness.
• Communicate status updates and manage multiple priorities.

Skills

SQL

AEM 6.5

Java

Data modeling

Agile

Stored procedures

Education

Bachelor's or Master's degree in IT

Tools

SSIS

Job description

HTC Global Services is seeking a Senior Database Architect to lead data modeling and database design for enterprise applications leveraging Adobe AEM 6.5, SQL Server, and SSIS. You will architect data solutions, ensure data integrity, and support performance across development, QA, and production.

The role involves collaboration with developers, vendors, and business users while maintaining 24/7 on-call responsibilities.