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