Job Description:
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 server less 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.

Must Have:

• 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 Cloud Formation, 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 Cloud Trail, AWS Cloud Watch, 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).

Experience and Skill Set Requirements:
Public Sector Experience - 5 points:

• 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 50 points:

• 10+ years of experience in IT field with experience.
• 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.
• 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 30 points:

• 10+ years of experience.
• 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.

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.