Connect with us

PostgreSQL DBA-Remote in Canada – APPLY NOW

CANADA JOBS

PostgreSQL DBA-Remote in Canada – APPLY NOW

Job title: PostgreSQL DBA-Remote in Canada

Company: Perennial Resources International


Job description: Title Database Administrator – Cloud Location Toronto, Canada-can be remote anywhere in Canada Overview As a cloud focused DBA, your responsibilities include partnering with technology teams to provision, deploy and configure various data-related services to our cloud platform as well as providing best practices and approaches to ensure resiliency and high availability of our cloud solutions. Requirements AWS Cloud Experience Aurora PostgreSQL RDS experience with sound knowledge in SCT, DMS, Elasticsearch, Oracle RDS and DynamoDB. Experience in providing enterprise solutions leveraging AWS services such as S3, EC2, VPC, Glue, Lambda, Athena, Redshift, EMR, Elasticsearch. Experience in Oracle to PostgreSQL migration using EDBMTK or SCT-DMS. Experience with cloud infrastructure, required AWS and good to have AzureGoogle cloud. Experience with development and support of large-scale production systems working within a 24×7 operations environment. Require scripting skillrsquos like shellpython to automate daily activities. Working experience of automation tools such as Ansible, CloudFormation, Terraform, awscli. Good to have AWS certifications – Solutions Architect – Associate or Professional Level PostgreSQL DBA skills Overall 5+ years of experience in PostgreSQL, Oracle database Administration. Good to have experience in Oracle DB administration. Planning and scheduling Backups, Database Recovery, taking Logical Backups Physical Backups. Hands on experience of Recovery scenarios. Experience in table partitioning in PostgreSQL 10 and 11. Cloning of Databases. Upgrading and applying security patches to the databases on VM and also RDSrsquos. Having experience of DR setup through various synch methods. Database Tuning Abilities ndash Tuning Applications, Tuning Memory, and Tuning Disk Usage. Experience in PostgreSQL Performance Tuning using tools such as pgBadger and debugging of code using plprofiler. Experience in Oracle Performance Tuning using various tools Statspack, TKPROF, SQL Trace and Explain Plan. Support to team members for any database related issue Designing strategy towards Capacity Management for DB tracks. Required to work on shifts supporting client, any shift 247

Expected salary:

Location: Toronto, ON

Job date: Wed, 06 Jan 2021 23:07:55 GMT

Apply for the job now!

SEEN THIS? >>
Entry-level Technical Advisors - Work From Home - APPLY NOW

Continue Reading
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

More in CANADA JOBS

To Top