Data Architect

Job Title : Senior Database Architect – Adobe AEM 6.5 & SQL 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