About the role
Working with one of the top financial clients, this role calls for a SQL Server Database Administrator who will be responsible for coordinating changes to computer databases, testing and implementing the database, and applying knowledge of database management systems. The successful candidate will be 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, and other DBMS technologies.
- Design and develop optimal solutions to migrate or upgrade existing databases to a new platform or DBMS versions
- Build and leverage automation and DB DevSecOps pipelines to provision, upgrade, patch and maintain DB systems.
- Support DB change requests 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 are run when appropriate.
- Test upgrades/new releases of database software and related products. Assess impacts on the application and the database environment.
- Responds immediately to critical issues. On call and/or shift duty may be required.
Desired Skill Set:
- 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, preferably with 1+ year hands-on experience
- 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’s degree in computer science, engineering or related field or equivalent work experience
BeachHead is an equal opportunity agency and employer. We advocate for you and welcome anyone regardless of race, color, religion, national origin, sex, physical or mental disability, or age.
Privacy Policy
About BeachHead
BeachHead is a premier and specialized consultancy and staffing firm focused on the Canadian Finance marketplace. We specialize in providing the highest quality of service for both our clients and professional Financial Candidates. Our unique business model supports a direct relationship with senior hiring business executives and stakeholders.
The BeachHead system is designed to capture intimate knowledge of both the client opportunity and qualified candidates, ensuring that each client/candidate is properly and competitively positioned in the marketplace.
About the role
Working with one of the top financial clients, this role calls for a SQL Server Database Administrator who will be responsible for coordinating changes to computer databases, testing and implementing the database, and applying knowledge of database management systems. The successful candidate will be 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, and other DBMS technologies.
- Design and develop optimal solutions to migrate or upgrade existing databases to a new platform or DBMS versions
- Build and leverage automation and DB DevSecOps pipelines to provision, upgrade, patch and maintain DB systems.
- Support DB change requests 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 are run when appropriate.
- Test upgrades/new releases of database software and related products. Assess impacts on the application and the database environment.
- Responds immediately to critical issues. On call and/or shift duty may be required.
Desired Skill Set:
- 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, preferably with 1+ year hands-on experience
- 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’s degree in computer science, engineering or related field or equivalent work experience
BeachHead is an equal opportunity agency and employer. We advocate for you and welcome anyone regardless of race, color, religion, national origin, sex, physical or mental disability, or age.
Privacy Policy
About BeachHead
BeachHead is a premier and specialized consultancy and staffing firm focused on the Canadian Finance marketplace. We specialize in providing the highest quality of service for both our clients and professional Financial Candidates. Our unique business model supports a direct relationship with senior hiring business executives and stakeholders.
The BeachHead system is designed to capture intimate knowledge of both the client opportunity and qualified candidates, ensuring that each client/candidate is properly and competitively positioned in the marketplace.