Database Administrator
2 weeks ago
Position Overview:
The position is responsible for managing, maintaining, and optimizing Microsoft SQL Server and Azure SQL databases within an organization. They play a critical role in ensuring the performance, availability, security, reliability and automation of the database systems. Their duties include database design, installation, configuration, troubleshooting, backup and recovery, performance tuning, security management, and ensuring data integrity.
** In order to be considered for this position you MUST have strong, in-depth experience with Azure SQL as a Database Administrator, Automation and specifically have worked with Cloud Native solutions. - While I thank you for interest in this position, if this experience is not present you will not be considered for this role.
Essential Responsibilities:
• Collaborate with application developers and system architects to design and implement efficient and scalable database structures.
• Create and maintain database schemas, tables, indexes, views, and stored procedures.
• Deploy, manage, automate and secure Azure SQL databases
• Install, configure, and upgrade on prem Microsoft SQL Server instances, including applying patches and service packs.
• Configure database settings and options to optimize performance and ensure security.
• Monitor database performance using built-in tools and third-party monitoring solutions.
• Identify and resolve performance bottlenecks through query optimization, indexing strategies, and server configuration adjustments.
• Participate in rotating On-Call coverage or emergency response, as needed.
• Develop and implement backup and recovery strategies to safeguard critical data.
• Perform regular backups, test restores, and maintain backup integrity.
• Develop disaster recovery plans and participate in recovery drills.
• Implement and enforce security policies and access controls to protect sensitive data.
• Manage user permissions, roles, and privileges.
• Monitor for security vulnerabilities and apply security patches and updates.
• Diagnose and resolve database-related issues, including connectivity problems, performance degradation, and data corruption.
• Conduct root cause analysis and implement preventive measures to mitigate future incidents.
• Estimate future database growth and plan for scalability requirements.
• Optimize resource utilization to accommodate increasing workloads.
• Maintain accurate documentation of database configurations, procedures, and processes.
• Generate reports on database performance, availability, and security compliance.
Required Qualifications & Skills:
• Bachelor's degree in computer science, Information Technology, or a related field; a combination of training and experience may be considered in lieu of degree.
• A minimum of 3 years of experience in design, implementation and support of Azure SQL and proficiency in Azure services. Intermediate to advanced level knowledge of Microsoft Azure
• A minimum of seven (7) years of experience in design, implementation and support of Microsoft SQL Server in Windows Server environments
• Strong understanding of relational database concepts and SQL query language.
• Experience with performance tuning, indexing, and query optimization.
• Familiarity with backup and recovery procedures, disaster recovery planning, and high availability solutions (e.g., clustering, replication, AlwaysOn).
• Experience supporting production and pre-production environments across multiple locations and the technologies to support them.
• Ability to troubleshoot database-related issues and perform root cause analysis.
• Advanced knowledge of PowerShell working with database environments
• Excellent communication and collaboration skills for working with cross-functional teams.
• Understanding of ITIL and SDLC
Preferred Qualifications & Skills:
• Certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Data Management and Analytics (SQL Server).
• Azure DevOps experience
• Azure Data Factory (ADF) and Azure Synapse
• PostgreSQL, and MySQL are a plus.
-
Database Administrator Lead
1 week ago
Greater Toronto Area, Canada War Child Canada Full timeJob OverviewThe Senior Officer, Database Administrator plays a pivotal role in ensuring the efficient operation of our database systems. As a key member of our team, you will be responsible for advising on database configurations, maintaining data integrity, and driving improvements in system performance.Key ResponsibilitiesProvide strategic advice on...
-
Senior Officer, Database Administrator
3 weeks ago
Greater Toronto Area, Canada War Child Canada Full timePosition SummaryThe Senior Officer, Database Administrator plays a critical role in advising, configuring, and maintaining database systems for the Development and Finance teams. Key responsibilities include executing database updates, ensuring compliance with industry standards, and driving improvements in system performance and processes. The role also...
-
Senior Officer, Database Administrator
3 weeks ago
Greater Toronto Area, Canada War Child Canada Full timePosition SummaryThe Senior Officer, Database Administrator plays a critical role in advising, configuring, and maintaining database systems for the Development and Finance teams. Key responsibilities include executing database updates, ensuring compliance with industry standards, and driving improvements in system performance and processes. The role also...
-
Database Administrator
4 days ago
Greater Toronto Area, Canada Bright Technologies Full timeReporting to the Manager of Data Operations, the Database Administrator will be part of a dynamic operations team that is excited to promote and adopt a DevOps mindset. In this role, you will work closely with engineering/architecture, data management and support to ensure our production systems are deployed, managed and monitored to the best of our ability....
-
SQL Database Administrator
5 days ago
Greater Toronto Area, Canada Deeta IT solutions INC Full time**Role: Sr. SQL DBA** **Full time Job** **Exp: 10-15 years** **After covid onsite at Halifax or GTA area and work remotely for now.** Roles/Responsibilities: - Maintaining health and performance of servers - Troubleshooting database connectivity & network related issues, database performance issues and query tuning - Managing high availability features...
-
Database Administrator
3 days ago
Toronto, Canada Red Label Vacations Full time**Reports to**:Director, IT **Department**:IT **Location**:Hybrid**: - **Head Office, Toronto, ON/ Canada & work from home **Summary**: As DBA you'll be the first respondent to database problems that arise and carry out periodic maintenance and troubleshooting. To ensure success as a database administrator, you should be an excellent problem-solver and...
-
Database Administrator
3 weeks ago
Toronto, Canada Rang Healthcare Full timeJob Title: Database Administrator Duration: 04 Month Contract Location: 125 Sir William Hearst, Toronto, ON M3M 0B5 (Position is 3 days onsite in a week) Must haves: Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database Experience with database development, e.g., stored procedure, PL/SQL,...
-
Database Administrator
2 weeks ago
Toronto, Canada Financial Services Regulatory Authority of Ontario (FSRA) Full timeJob Description: PURPOSE OF POSITION Accountable for providing highly specialized senior level technical expertise, oversight and support in the project implementation and administration of FSRA database systems to ensure all business operations are fully supported in the areas of design, setup, configuration, performance, capacity, monitoring, backup and...
-
Database Administrator
3 days ago
Toronto, Ontario, Canada CloudVital Full timeJob Title: Database Administrator Job Location: Toronto Job Type: Hybrid Responsibilties: · Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.; · Prepare and implement database changes according to design; · Promote database changes through Development, Integration Testing, QA,...
-
Database Administrator
4 weeks ago
Toronto, Canada Infotek Consulting Services Full timeSupport on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade: - Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.; - Prepare and implement database changes according to design; - Promote database changes through Development,...
-
Database Administrator
3 weeks ago
Toronto, Canada Intelex Technologies Full time**Position Overview** Database is one of the most critical core components in any service infrastructure! If you wish to work with several database technologies and drive infrastructure efficiency through innovative designs, then you should consider a position as a SQL Server DBA / System Admin here at Intelex. In this role you take ownership of defining...
-
Database Administrator
2 weeks ago
Toronto, Canada iPartner Staffing Full timeMust haves: - Expert level knowledge of migrating Oracle technologies from Unix (Solaris) to Oracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x; UNIX OS (Operating System) and Linux OS, utilities, shell scripting - **Expert level knowledge of Oracle 12c/19c database administration**, maintenance, security implementation include:, upgrade and...
-
Database Administrator
3 weeks ago
Toronto, Ontario, Canada 2iResourcing Full timeRQ03871- Database Administrator SeniorClient: Ministry of TransportationPeriod: 5 MonthsStart Date: 10/27/2022End Date: 03/31/2023Location: TorontoWorking Hrs.: 7.25 Hrs. / dayAssignment Type: HybridCandidate is required to come to office 3 days a week.Must Haves:Expert Oracle and Microsoft SQL Database administration and upgrade experienceExperience with...
-
Database Administrator
3 days ago
Toronto, Canada iPartner Staffing Full timeRole: Database Administrator - Senior Location: Toronto, ON Contract **Must-haves**: - More than 10 yrs Oracle DBA experience - Approved experience of Oracle 12c AND 19c using multi-tenant architecture - Oracle 12c and 19c RAC - Grid infrastructure/ASM - RMAN backup and Restore - Data Encryption using ASO/TDE - Oracle Dataguard Physical/Logical...
-
Database Administrator
4 days ago
Toronto, Canada KPMG Full timeOverview: At KPMG, you’ll join a team of diverse and dedicated problem solvers, connected by a common cause: turning insight into opportunity for clients and communities around the world. **The Opportunity** What you will do: - Provide database administration, maintenance, monitoring, and support for both on premise databases and Azure PaaS database...
-
Database and Administrative Coordinator
4 days ago
Greater Sudbury, Canada Health Sciences North Full time_A dynamic and growing health care environment awaits you in Sudbury Ontario: Canada’s happiest city!_ - Surrounded by provincial parks and over 200 lakes, Greater Sudbury has over 160,000 residents and is a_ - rich mix of urban, suburban, rural and wilderness environments. Just a one hour flight or four-hour drive of_ - Toronto; here, you will experience...
-
Database Administrator
3 weeks ago
Toronto, Ontario, Canada Article Student Living Part timeThursday, July 11, 2024About Spirit of Math:With over 30 years of success, Spirit of Math is an innovative leader in after-school mathematics education for high-performing students. Located at more than 40 campuses across Canada. From our after-school classes and campuses to our expanding series of math workbooks and training for educators, Spirit of Math is...
-
Database Administrator
7 days ago
Toronto, Canada Cloudvital Technologies Full timeWe are hiring Mainframe DB2 for one of the fast growing dynamic company Job Title: Database Administrator Job Location: Montreal **Job Type**: Hybrid - **This is a Hybrid role with 3 days in office and 2 days remote **_ **Required skills**: - Extensive hands-on experience in the use of z/OS and related software packages and tools - Extensive experience...
-
Database Administrator
3 weeks ago
Toronto, Canada Teckhorizon Inc Full timeEstablished in 2013, Teckhorizon has expertise in providing Staffing Solutions, IT managed services, security solutions, cloud solutions, and Software Development services to meet your growing business needs. Technology is our craft and passion. We bring together technologists, creators, and trailblazers who are always on the lookout for solutions to...
-
Database Administrator
1 week ago
Toronto, Ontario, Canada Teckhorizon Inc Full timeThe Client is seeking an experienced Database Administrator (DBA) – Intermediate to manage and optimize database systems, particularly SQL Server and Microsoft Dynamics GP. The role involves database design, performance tuning, backup and recovery, as well as collaboration with the finance team to support financial systems.Key ResponsibilitiesDatabase...