Responsibilities:

• Provide expertise in AWS cloud platform.
  
• Provide design, build and support for cloud environments to create solutions for Public Health domain.
  
• Provide expertise on Linux operating system like Red-Hat including installation, troubleshooting, hardening and scripting to automate.
  
• The role will monitor and assess the performance of applications in a cloud environment to ensure solutions are available
  
• Participate to create, test and implement safeguards to maintain data integrity and protect against unauthorized access
  
• Regularly review production logs, providing analysis & suggestions to implement measures in a proactive manner
  
• Hands-on experience with microservices and distributed application architecture, such as containers, Kubernetes, and/or serverless technology
  
• Provide detailed documentation for system design, integration, configuration, development and implementation of related activities
  
• Develop and maintain system design models, technical documentation and specifications
  
• Produce integration plans, inputs into configuration and development project
  

Experience and Skill Set Requirements

Public sector experience

• 5+ years of experience working with federal/provincial/broader public-sector healthcare providers
  
• Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices
  
• In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies.
  
• Knowledge and experience with Public Sector Health related projects
  
• Knowledge and understanding of Ministry policy and IT project approval processes and requirements
  
• Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies
  
• Experience with large complex IT Health-related projects.
  

Technical Skills

10+ years of experience in IT field with experience in the following areas:

• Provisioning Resources by Automating the provisioning of AWS resources (including Amazon RDS for Oracle and Aurora instances) using Infrastructure as Code (IaC) tools such as AWS CloudFormation, Terraform, or AWS CDK.
  
• Automating Database Management namely automate the creation, backup, restoration, and scaling of RDS instances and Aurora clusters using scripts, AWS CLI, or SDKs.
  
• Provisioning Amazon RDS/Aurora Databases, set up, scale, and optimize Amazon RDS (e.g., MySQL, PostgreSQL, Oracle) and Aurora (MySQL compatible, PostgreSQL compatible) databases for production workloads.
  
• Database Scaling and utilize RDS Read Replicas, Aurora Auto Scaling, and Aurora Global Databases to manage read heavy workloads, ensure high availability, and handle global distribution.
  
• Performance Tuning by Continuously monitoring database performance using Amazon RDS Performance Insights, CloudWatch, and Enhanced Monitoring to identify and resolve bottlenecks (e.g., slow queries, I/O limitations).
  
• Database Backup and Recovery by Configuring automated backups for RDS and Aurora and manage point in time recovery for both, ensuring data durability and disaster recovery.
  
• Deployment and automation of packages for cloud-based systems like Pipeline Setup as well as design and implement CI/CD pipelines for applications running on AWS, including databases like RDS and Aurora, using AWS Code Pipeline, Jenkins, GitLab CI, or similar tools.
  
• Automated Deployment such as Integrating database changes (schema updates, migrations) into the deployment pipeline to ensure smooth and automated updates to databases running in RDS or Aurora. Leverage version control and automation, use Git for version control and CI/CD tools to ensure consistent deployment of application code, database scripts, and infrastructure changes.
  
• Ensuring availability, performance, security, and scalability of AWS & related production systems.
  
• Excellent knowledge in managing AWS resources and configuring Amazon VPC, Amazon Elastic Load Balancing, auto-scaling, AWS IAM, Amazon EC2, Amazon S3, Amazon, AWS Lambda, Amazon RDS/Aurora DB, Amazon Redshift, Active MQ, AWS CloudTrail, AWS CloudWatch, KMS, RDS Performance Insights, DMS, S3 and other services in the AWS family including Databases: RDS for Oracle, MySQL, PostgreSQL, MariaDB, SQL Server, Aurora (MySQL & PostgreSQL compatible)
  
• 5+ years working experience of Unix/Linux operating systems like Solaris and Red-Hat including installation, troubleshooting, hardening and scripting to automate.
  
• Proven implementation of cloud security models, particularly identity, network, and encryption.
  

Core Skills and Experience

10+ years of experience with:

• Production environment troubleshooting and tuning to improve application performance.
  
• Developing and maintaining system design models, technical documentation, and specifications
  
• Experience setting up development environments and mechanism using tools such as JIRA, Confluence, Maven and Jenkins or similar tools.
  
• Experience in scripting languages like Python, Bash, PHP, Java, JavaScript, Node, etc.
  
• Experience in build tools like Git, Ansible, Chef, Puppet etc. for continuous integration
  
• Experience in mobile device management for various versions of cellular and tablets
  
• Providing recommendations for architecture and process improvements.
  
• Definition and deployment of systems for metrics, logging, and monitoring on AWS and related platform.
  
• Designing, maintenance and management of tools for automation of different operational processes.
  
• Evaluation of new technology alternatives and vendor products.
  

Specific RDS (Relational Database Service) Core Skills and Experience:

• Manage various types of RDS databases, including Oracle, MariaDB, SQL Server.
  
• Set up Read Replicas for scaling read heavy applications.
  
• Regularly update RDS instances to the latest patches and security updates.
  
• Data Migration: Use AWS Database Migration Service (DMS) to migrate databases to RDS instances.
  

RDS Aurora core skills:

• Configure Aurora clusters (MySQL compatible or PostgreSQL compatible) for highly available, scalable, and performant databases.
  
• Aurora Serverless: Utilize Aurora Serverless for OnDemand, autoscaling databases based on traffic and usage patterns.
  
• Cross Region Replication: Implement Aurora Global Databases for multi region disaster recovery and low latency read operations across geographies.
  
• Aurora Performance: Leverage Aurora's read scaling and performance insights to optimize database performance and minimize latency.
  

General Skills

• Proven technical leadership skills with ability to identify areas for improvement and recommend solutions.
  
• Exceptional analytical, problem solving and decision-making skills.
  
• Demonstrated strong interpersonal, verbal, and written communication, and presentation skills as well as working with development teams to integrate database management, migrations, and versioning processes into the overall architecture.
  
• Experience applying industry web, architectural and security standards, and best practices through maintaining detailed documentation for the setup, deployment, and optimization as well as best practices for managing cloud databases.
  
• Proven troubleshooting and critical thinking experience
  
• Demonstrated ability to apply strong listening skills to facilitate issue resolution.
  
• Effective consulting skills to engage with all stakeholders with proven track record for building strong working relationships.
  
• Strong interpersonal, facilitation and negotiation skills with ability to build rapport with stakeholders and drive negotiations to a successful outcome.
  
• Excellent customer service skills, including tact and diplomacy to ensure client needs are managed effectively.
  
• A motivated, flexible, detail-oriented, and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.
  

MUST HAVES:

• Provisioning Resources by Automating the provisioning of AWS resources (including Amazon RDS for Oracle and Aurora instances) using Infrastructure as Code (IaC) tools such as AWS CloudFormation, Terraform, or AWS CDK.
  
• Automating Database Management namely automate the creation, backup, restoration, and scaling of RDS instances and Aurora clusters using scripts, AWS CLI, or SDKs.
  
• Ensuring availability, performance, security, and scalability of AWS & related production systems.
  
• Excellent knowledge in managing AWS resources and configuring Amazon VPC, Amazon Elastic Load Balancing, auto-scaling, AWS IAM, Amazon EC2, Amazon S3, Amazon, AWS Lambda, Amazon RDS/Aurora DB, Amazon Redshift, Active MQ, AWS CloudTrail, AWS CloudWatch, KMS, RDS Performance Insights, DMS, S3 and other services in the AWS family including Databases: RDS for Oracle, MySQL, PostgreSQL, MariaDB, SQL Server, Aurora (MySQL & PostgreSQL compatible)