The Database Administrator (DBA) is responsible for ensuring database performance, integrity, and security. Key tasks include SQL query optimization, database migrations, backup and recovery procedures, monitoring performance, and creating documentation. This role will collaborate with development and operations teams to maintain optimal database operations.
We are seeking a skilled and experienced Database Administrator (DBA) to join our growing team. This DBA role is a ninja role; We need a detailed oriented person who can dig into a variety of system backends and help find areas of performance and reliability risks in our database infrastructure.
The ideal candidate will be responsible for ensuring the integrity, security, and performance of our databases. This role involves monitoring and optimizing SQL queries, verifying database configurations, and performing database migrations and upgrades. The DBA will collaborate closely with our development and operations teams to maintain smooth database operations and support ongoing projects.
If you want to contribute to exciting projects and make an impact in a dynamic and collaborative environment, we want to hear from you.
KEY RESPONSIBILITIES
- DATABASE OPERATIONS
- SQL Query Optimization: Review and optimize SQL queries to enhance database performance and efficiency. Identify and address bottlenecks to improve query execution times.
- Database Configuration Verification: Validate database configurations to ensure compliance with best practices and security standards. Implement necessary adjustments to optimize database settings for performance and security.
- Database Migrations and Upgrades: Plan and execute database migrations and upgrades in coordination with development and operations teams. Ensure seamless transition with minimal downtime and data loss.
- Backup and Recovery: Establish and maintain robust backup and recovery procedures to safeguard critical data. Regularly test backup integrity and implement disaster recovery strategies.
- Performance Monitoring and Tuning: Monitor database performance metrics and proactively identify areas for improvement. Implement tuning strategies to optimize database performance and resource utilization.
- Documentation: Assist in the upgrade and creation of system documentation of database configurations, procedures, and standards. Work directly with Operations Services team to draft runbooks and technical documentation of all database environments.
EXPERIENCE REQUIREMENTS
- Proven experience as a Database Administrator, with expertise in SQL query optimization, database configuration management, and database migrations.
- A strong working knowledge of how databases optimize and execute queries, with the ability to assist developers in building optimal high performing database queries, transactions, and stored procedures.
- Strong working background with MS SQL Server, and proficiency in other database technologies such as MySQL, PostgreSQL, or Oracle.
- Strong understanding of database architecture, including indexing, storage, and caching mechanisms.
- Experience with database migration tools and techniques, such as dump and restore, replication, or schema migration scripts.
- Familiarity with version control systems and automated deployment pipelines.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills, with the ability to work effectively in a team environment.
PREFERRED QUALIFICATIONS
- Certification in database administration (e.g., Oracle Certified Professional, Microsoft Certified Database Administrator).
- Experience with cloud-based database platforms (e.g., Amazon RDS, Microsoft Azure SQL Database).
- Knowledge of containerization technologies (e.g., Docker, Kubernetes) and their impact on database deployments.
Top Skills
Ms Sql Server
MySQL
Oracle
Postgres
Similar Jobs at Bounteous
The Platform Reliability Analyst ensures the health of cloud infrastructure by monitoring performance, managing incident responses, and collaborating with teams to resolve issues. Responsibilities include proactive system monitoring, coordinating outages, and conducting root cause analyses. The ideal candidate has strong communication skills and an understanding of cloud technologies to support system optimization.
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
