About the role
Database Administrator - SQL Server DBA - Expert
Physical Work Location: Toronto, ON
Duration: 12 Months
Physical Working Location (required):Hybrid Hours of Operation: 9-5 core business
Description:
Summary: Responsible for coordinating changes to computer databases, test and implement the database applying knowledge of database management systems. Responsible for planning, coordinating and implementing security measures to safeguard the computer database.
Responsibilities:
• Design, engineer, and deploy on a breadth of RDBMS and NoSQL database technologies and platforms such as Db2 LUW, Netezza, Oracle, SQL Server, Postgres, MongoDB, AWS RDS, Redshift, other DBMS technologies.
• Design and develop optimal solutions to migrate or upgrade existing databases to new platform or DBMS versions
• Build and leverage automation and DB DevSecOps pipelines to provision, upgrade, patch and maintain DB systems
• 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 Db2LUW, Netezza, Oracle, SQL server. Postgres, MongoDB. Proficient DBA skills for at least 2 DBMS.
• Sound knowledge of AWS RDS, Redshift, DynamoDB, preferable with 1+ year hands-on experiences
• Solid understanding of the Software Development Life Cycle (SDLC)
• Sound knowledge and 1+year experience with Database automation and DB DevSecOps (e.g. Ansible, AWS CDK, Github Action, Liquibase, shell scripting, python, SQL)
• Excellent oral and written communication skills
• In depth team and collaboration skills
• In depth Analytical and problem-solving skills
• Bachelor degree in computer science, engineering or related field or equivalent work experience
Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.
Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit https://dexian.com/ to learn more.
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.
Dexian will on request provide accommodation for disabilities to support your participation in all aspects of Recruitment, Assessment and selection process.
About Dexian
Dexian is a leading provider of staffing, IT, and workforce solutions with nearly 12,000 employees and 70 locations worldwide. As one of the largest IT and professional staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was launched in 2023 and created from the combination of DISYS, Signature Consultants, and other strategic acquisitions.
Dexian fuses the best elements of its legacy companies to create a platform that connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.
Dexian’s brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit www.dexian.com to learn more.
About the role
Database Administrator - SQL Server DBA - Expert
Physical Work Location: Toronto, ON
Duration: 12 Months
Physical Working Location (required):Hybrid Hours of Operation: 9-5 core business
Description:
Summary: Responsible for coordinating changes to computer databases, test and implement the database applying knowledge of database management systems. Responsible for planning, coordinating and implementing security measures to safeguard the computer database.
Responsibilities:
• Design, engineer, and deploy on a breadth of RDBMS and NoSQL database technologies and platforms such as Db2 LUW, Netezza, Oracle, SQL Server, Postgres, MongoDB, AWS RDS, Redshift, other DBMS technologies.
• Design and develop optimal solutions to migrate or upgrade existing databases to new platform or DBMS versions
• Build and leverage automation and DB DevSecOps pipelines to provision, upgrade, patch and maintain DB systems
• 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 Db2LUW, Netezza, Oracle, SQL server. Postgres, MongoDB. Proficient DBA skills for at least 2 DBMS.
• Sound knowledge of AWS RDS, Redshift, DynamoDB, preferable with 1+ year hands-on experiences
• Solid understanding of the Software Development Life Cycle (SDLC)
• Sound knowledge and 1+year experience with Database automation and DB DevSecOps (e.g. Ansible, AWS CDK, Github Action, Liquibase, shell scripting, python, SQL)
• Excellent oral and written communication skills
• In depth team and collaboration skills
• In depth Analytical and problem-solving skills
• Bachelor degree in computer science, engineering or related field or equivalent work experience
Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.
Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit https://dexian.com/ to learn more.
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.
Dexian will on request provide accommodation for disabilities to support your participation in all aspects of Recruitment, Assessment and selection process.
About Dexian
Dexian is a leading provider of staffing, IT, and workforce solutions with nearly 12,000 employees and 70 locations worldwide. As one of the largest IT and professional staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was launched in 2023 and created from the combination of DISYS, Signature Consultants, and other strategic acquisitions.
Dexian fuses the best elements of its legacy companies to create a platform that connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.
Dexian’s brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit www.dexian.com to learn more.