Data/Information Architect - Consultant (Onsite)
About The Position
The consultant will work under limited supervision as a systems software programmer, reporting directly to a functional manager. The role supports the stability and integrity of data and server services through monitoring, maintenance, support, and optimization of server infrastructure. The contractor will share 24/7 on-call responsibilities with the group. The position focuses on data architecture and database design for assigned applications, while also supporting application development and deployment. The client uses Adobe Experience Manager (AEM) and Power BI for forms, workflow, dashboards, and reports. The consultant will collaborate with consultants, developers, end users, database administration, vendors, and other stakeholders to meet application and business requirements, maintain secure and reliable systems, and resolve client issues.
Requirements
- At least 10 years of database modeling, architecture, and development experience.
- At least 9 years of state government experience.
- At least 10 years of advanced SQL experience.
- At least 5 years of experience with Adobe AEM 6.5.
- At least 4 years of Java development, design, and coding experience.
- At least 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 good working relationships with business users, management, vendors, and peers.
- Strong organizational, multitasking, and time-management skills.
- Hands-on knowledge of business processes.
- Clear and concise oral and written communication skills.
- Initiative, attention to detail, customer responsiveness, and the ability to manage multiple tasks and prioritize issues.
- Shared 24/7 on-call availability.
Nice To Haves
- Experience with cloud-based solutions.
- PMP or another PMI-issued certification.
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 lead database designer for assigned application systems.
- Develop and implement database design standards, including standards for stored procedures, object relational mappers, database access, and application error handling.
- Write and maintain stored procedures as needed; build database utilities such as SSIS packages and database scripts.
- Analyze data volumes and usage patterns and apply knowledge of agency data usage to improve database access and manipulation efficiency.
- Support application developers and help resolve database-related application problems in development and production.
- Work with Database Administration to resolve database performance problems.
- Prepare system and programming documentation and obtain 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 deployment to Dev, QA, and Production environments and with migrations.
- Follow secure web programming and deployment practices, and adhere to coding, unit-test coverage, automation, and continuous-integration standards.
- Work with the team or vendors to ensure sound site architecture, performance, reliability, and content delivery practices.
- Communicate and collaborate with IT peers and leaders, provide feedback on product issues and enhancements, and proactively identify and implement process improvements.
- Manage concurrent tasks, provide periodic stakeholder status updates, prioritize issues by severity, and resolve them within accepted service levels.
- Own Helpdesk issue records and provide timely status updates to clients and relevant employees; respond attentively to customer tickets.
- Troubleshoot customer issues related to backup configuration and recovery, recommend technical solutions, and develop workarounds as appropriate.
- Perform equipment and software upgrades and maintain familiarity with current computer and network products.
- Follow corporate information-security guidelines and promote information security among coworkers.
- Perform other assigned duties and special projects.
- Perform duties in a manner consistent with the organization’s mission, values, and client service standards.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
