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 (e.g. 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
Job Types: Full-time, Permanent Pay: Up to $125,000.00 per year Benefits:
Dental care
Disability insurance
Extended health care
Life insurance
Paid time off
Vision care
Schedule:
8 hour shift
Monday to Friday
Weekends as needed
Supplemental pay types:
Bonus pay
Experience:
AWS RDS: 3 years (required)
Db2LUW: 5 years (required)
Redshift: 2 years (required)
SQL Server, Oracle and other DBMS technologies.: 8 years (required)
Work Location: Hybrid remote in Toronto, ON M6B 2N3
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.