We are seeking a Senior Database Architect with extensive experience in database architecture, advanced SQL, Java development, and Adobe Experience Manager (AEM) 6.5. The role involves designing data models, optimizing database performance, supporting enterprise applications, and managing application deployments across development, QA, and production environments. Experience in State Government environments is required. This position also includes application support, security compliance, documentation, and shared 24/7 on-call responsibilities. Key Responsibilities Design logical data models, database architecture, and relational database solutions for enterprise applications. Establish and maintain database design standards, stored procedures, and database access practices. Develop and maintain advanced SQL scripts, stored procedures, SSIS packages, and database utilities. Analyze data volumes and usage patterns to optimize database performance and query efficiency. Collaborate with application developers and database administrators to troubleshoot database issues and improve system reliability. Support Adobe AEM 6.5 applications, workflows, forms, content delivery, and related integrations. Configure application settings and develop system specifications based on business requirements. Plan and execute unit, integration, and user acceptance testing. Support application deployments, upgrades, and migrations across development, QA, and production environments. Apply secure coding practices, coding standards, automated testing, and continuous integration processes. Prepare and maintain technical documentation, system specifications, and implementation plans. Troubleshoot application, server, backup, and recovery issues and recommend effective solutions. Coordinate with vendors, business users, technical teams, and management to resolve issues and deliver enhancements. Follow information security policies and support compliance requirements. Manage support tickets, prioritize competing issues, meet service-level agreements, and provide timely status updates. Participate in shared 24/7 on-call support and identify opportunities for process improvement. Required Skills and Qualifications 10+ years of experience in database modeling, architecture, and development. 9+ years of experience working with State Government organizations. 10+ years of advanced SQL experience. 5+ years of experience with Adobe Experience Manager (AEM) 6.5. 4+ years of Java development, design, and coding experience. 5+ years of experience working with Agile methodologies. Strong knowledge of relational database design, data modeling, stored procedures, and database performance tuning. Experience supporting enterprise applications, testing, deployment, and production troubleshooting. Bachelor's or Master's degree in Information Technology or a related field. Strong analytical, organizational, multitasking, and time-management skills. Excellent written and verbal communication skills. Ability to work effectively with business users, vendors, technical teams, and management. Strong customer-service orientation, attention to detail, and ability to manage multiple priorities. Preferred Qualifications Experience with cloud-based solutions and application environments. PMP certification or another certification issued by the Project Management Institute (PMI). Refer
