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 RedHat 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
- Handson 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.
SkillsExperience and Skill Set Requirements
Public Sector Experience
5 years of experience working with federal/provincial/broader publicsector 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
- Indepth 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 Healthrelated projects.
5 points
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 cloudbased 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 autoscaling 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 RedHat including installation troubleshooting hardening and scripting to automate.
Proven implementation of cloud security models particularly identity network and encryption.
50 points
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 Auroras read scaling and performance insights to optimize database performance and minimize latency.
30 points
General Skills
Proven technical leadership skills with ability to identify areas for improvement and recommend solutions.
- Exceptional analytical problem solving and decisionmaking 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 detailoriented and creative team player with perseverance excellent organization and multitasking abilities and a proven track record for meeting strict deadlines.
15 points
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 autoscaling 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)