Data Architect

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

Location: Columbia (SC) | Employment Type: Full Time - 40 hours per week | Job Level: T3 | Work Preference: Onsite at work location address | Job Code: 245691

Job Description:

Position Overview

Work on enterprise application systems that leverage Adobe Experience Manager (AEM), Power BI (PBI), and data architecture to support forms, workflows, dashboards, and reporting. This role combines database architecture and development with application support, performance optimization, testing, and deployment across development, QA, and production environments.

Under limited supervision, the Systems Software Programmer will report directly to a functional manager and work with application developers, consultants, database administrators, vendors, and business users to maintain data integrity, improve application performance, and support reliable application and server services. The position includes shared 24/7 on-call responsibilities.

What You'll Do / Key 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 SQL Server Integration Services (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.

Required 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.

Ability to establish and maintain effective working relationships with business users, management, vendors, and peers.

Strong organizational, multitasking, and time-management skills.

Ability to communicate clearly and concisely, both verbally and in writing.

Initiative, attention to detail, customer service skills, and the ability to manage multiple tasks and competing priorities.

Preferred Qualifications

Experience with cloud-based solutions.

PMP or another PMI-issued certification.

What Makes HTC A Great Place To Build Your Future

HTC Global Services wants you to join our team. Come build new things with us and advance your career. At HTC Global, you’ll collaborate with experts, work alongside clients, and be part of high-performing teams driving success together. You’ll have long-term opportunities to grow your career and develop skills in the latest emerging technologies.

At HTC Global Services, our employees have access to a comprehensive benefits package. Benefits can include Group Health (Medical, Dental, and Vision), Paid Time Off, Paid Holidays, 401(k) matching, Group Life and Disability insurance, Professional Development opportunities, Wellness programs, and a variety of other perks.

Our success as a company is built on inclusion and diversity. HTC Global Services is committed to providing a workplace free from discrimination and harassment, where every employee is treated with dignity and respect. We celebrate differences and believe that diverse cultures, perspectives, and skills drive innovation and success. HTC is an Equal Opportunity Employer and a proud National Minority Supplier. We seek to empower each individual, fostering an environment where everyone feels valued, included, and respected.

#SeniorDatabaseArchitect #DatabaseArchitect #AdobeAEM #AEM65 #AdvancedSQL #SQLServer #JavaDeveloper #DatabaseDevelopment #DataArchitecture #DatabaseModeling #SSIS #AgileMethodology #EnterpriseApplications

At HTC Global Services, our culture is an embodiment of who we are – a value-led organizationcommitted to success of our people and customers.

• Hybrid and Workplace flexibility
• Work-Life-Balance
• Well-defined career development plan
• Rewards & Recognition program
• L&D focuses on upskilling
• Hands-on experience on Emerging Technologies and Digital Transformation
• Career Mobility programs