• Maintain and optimize installations of MariaDB across multiple environments, to include architecture, design, installation support, configuration, and maintenance • Configure and maintain database replication within and across multiple sites to ensure performance and high availability • Collaborate with ServiceNow administrators to ensure full alignment and optimal utilization of the database by the ServiceNow application. • Collaborate with stakeholders and Business Analysts to translate business needs into technical specifications and lead technical workshops to review design, architecture, and configuration approaches. • Provide technical leadership and ensure compliance by guiding junior developers or project teams, participating in code reviews, maintaining version control, ensuring security/privacy compliance, and contributing to technical documentation.

Role Description The Department of Administration is seeking a Senior Web Developer to support the development, enhancement, and maintenance of enterprise web applications and websites. The consultant will work across the full Software Development Life Cycle (SDLC), developing both front-end and back-end solutions using Drupal, WordPress, PHP, Linux, and related web technologies. - Design, develop, test, and maintain web-based applications and websites. - Convert user requirements and UI mockups into fully functional websites. - Develop front-end and back-end website functionality. - Work with CMS platforms including Drupal and WordPress. - Maintain and modernize existing PHP applications. - Integrate websites with internal and third-party systems. - Configure and support Apache Web Server environments. - Ensure websites meet accessibility, security, and cross-browser compliance standards. - Deliver training and knowledge transfer to end users and client teams. - Participate in on-call support for system updates and emergency issues. Qualifications - 5+ years of web application development, coding, debugging, and deployment experience. - 5+ years of experience with Linux, PHP, Drupal 8, and WordPress. - 5+ years of experience with HTML, DHTML, CSS, Dreamweaver, and Adobe Flash. - 5+ years of experience with SQL/MySQL databases. - Experience configuring Apache Web Server. - Full CMS deployment experience (installation, configuration, production support). - 5+ years of Public Sector/Government experience. Requirements - Strong hands-on experience with Drupal, WordPress, PHP, Linux, SQL/MySQL, and Public Sector projects. Preferred Skills - Strong Adobe Photoshop experience. - Experience applying Drupal CMS patches and upgrades. - Knowledge of web security remediation and best practices. - Adobe Captivate experience. - Experience creating fillable PDF forms using Adobe Acrobat Pro. - Graphic design experience for professional website deployments. Education - Bachelor’s Degree or equivalent work experience.

• Design, develop, and optimize SQL queries, functions, triggers, and stored procedures in PostgreSQL for high-volume enterprise applications. • Support data modeling activities, ensuring alignment with enterprise architecture, application requirements, and scalability needs. • Collaborate with application and integration teams to support end-to-end delivery of data-driven solutions, including new features, enhancements, and defect remediation. • Participate in code reviews, design sessions, and sprint planning as part of an Agile delivery team. • Analyze complex datasets and data flows to ensure reliability, integrity, and accuracy across systems and interfaces. • Troubleshoot database issues and provide root cause analysis for performance bottlenecks, data inconsistencies, and integration failures. • Lead performance tuning initiatives, including indexing strategies, query refactoring, and database optimization techniques. • Perform execution plan analysis and recommend changes to schema, indexing, or SQL logic to improve performance and scalability. • Ensure all database objects, code, and processes adhere to agency policies, data governance standards, and applicable security/compliance requirements. • Contribute to and maintain database development standards, best practices, and documentation. • Assist in migration, upgrade, and modernization efforts involving PostgreSQL and associated data platforms (e.g., moving from legacy systems, version upgrades, refactoring for cloud). • Support processes for backup, recovery, and environment management in collaboration with infrastructure and operations teams. • Other duties as assigned.

• Lead high-impact, cross-team initiatives such as platform migrations and transformations • Leading efforts like cloud migrations (e.g., AWS → GCP), evolving architecture while ensuring continuity across all product and platform teams • Cross-platform architecture alignment • Defining how services, APIs, and platform capabilities evolve consistently across teams • Partnering with internal platform teams to define requirements for CI/CD, testing, deployment, and developer workflows • Ensuring that platform changes are correctly adopted across services, with clear contracts and minimal friction • Drive cross-cutting architectural initiatives • Lead large-scale efforts that impact multiple teams and systems (e.g., migrations, re-architectures, platform shifts) • Assess impact across the full software ecosystem and define clear execution strategies • Break down complex transitions into actionable plans across teams • Bridge platform, infrastructure, and product teams • Enable execution across teams • Support teams during major transitions by providing guidance, patterns, and hands-on help • Identify and remove blockers that slow down adoption or delivery