AWS RDS DBA

Emonics LLC; Ontario; On-site; CAD 80,000 - 120,000; Full time

Job summary

A leading technology company, Emonics LLC, is seeking an experienced Database Administrator to manage and optimize database systems across multiple platforms. The ideal candidate will have extensive hands-on experience with both SQL and NoSQL databases, along with a strong background in database automation and performance tuning. If you're a detail-oriented individual with excellent problem-solving skills and a commitment to maintaining high database availability, we encourage you to apply.

Qualifications

• 5+ years of DBA experience with Postgres, MongoDB, SQL Server, and/or Oracle.
• 1+ year DBA experience with AWS RDS, Redshift, DynamoDB.
• Solid understanding of SDLC and database security measures.

Responsibilities

• Design, engineer, and deploy various database technologies.
• Monitor and ensure high availability and performance of databases.
• Respond to critical issues and provide database maintenance.

Skills

Database Performance Tuning

Database Automation

SQL

Analytical Skills

Problem-solving Skills

Communication Skills

Collaboration Skills

Education

Bachelor of Science in Computer Science

Tools

AWS CDK

GitHub Action

Ansible

Python

Shell Scripting

Job description

• Design, engineer, and deploy on a breadth of RDBMS and NoSQL database technologies and platforms like AWS RDS, Redshift, DynamoDB, DocumentDB, Neptune, PostgreSQL, MongoDB, Db2 LUW, SQL Server, Oracle and other DBMS technologies.
• Design and develop optimal solutions to migrate or upgrade existing databases to new platform or DBMS versions
• Support DB change request and problem investigation and resolution of both production and non-production environments.
• Monitor capacity, high-availability and performance for non-production and production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality.
• Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate.
• Develops and maintains database backup and recovery strategy and procedures. Ensures that databases are properly backed up and recovered when necessary
• Ensures databases are properly maintained, meeting security, audit, and compliance requirements. Databases are reorganized / groomed when necessary and other DBA utilities run when appropriate.
• Tests upgrades / new releases of database software and related products. Assesses impacts to application and the database environment.
• Responds immediately to critical issues. On call and / or shift duty may be required.

Requirements :

• 5+ years of hands-on DBA experience with Postgres, MongoDB, Db2LUW, SQL server and / or Oracle.
• 1+ year hands on DBA experience with AWS RDS, Redshift, DynamoDB, Neptune, DocumentDB
• Solid understanding of the Software Development Life Cycle (SDLC)
• Sound knowledge of DevSecOps and database automation and scripting (., AWS CDK, GitHub Action, Ansible, shell scripting, python, SQL)
• Excellent oral and written communication skills
• In depth team and collaboration skills
• In depth Analytical and problem-solving skills

Bachelor of Science degree in a computer science or related field or equivalent work experience"