- Role: Database Administrator
- Location: Toronto, ON•Hybrid work
- Company: LCBO
- Salary: $64,745.00 – $113,090.00 /Year
- Qualifications: Bachelor’s degree
- Experience: 5 Years
- Employment Type: Full Time
Company Overview:
The Liquor Control Board of Ontario (LCBO) is a crown company responsible for the sale of alcoholic beverages in Ontario, Canada. Known for its big form of merchandise and dedication to customer support, the LCBO is looking for a professional Database Administrator to enroll in their group. With a focal point on operational excellence, this role gives a unique possibility to contribute to the corporation’s fulfillment at the same time as going for walks in collaborative and supportive surroundings.
Database Administrator Job Description:
The Database Administrator (DBA) may be responsible for the management, preservation, and resources of the enterprise’s relational and non-relational databases. This role requires overseeing a couple of production and non-production environments, ensuring databases are up to date via recurring patching, improvements, and function/repair packs. The DBA will collaborate with internal organizations and external agencies to provide operational resources, display and track database normal performance, and manage database backup, repair, and restoration strategies.
Key Responsibilities:
1. Database Maintenance and Administration:
- Maintain and manipulate a couple of production and non-manufacturing databases.
- Perform ordinary patching, and improvements, and observe function/recuperation packs.
- Ensure databases are steady and compliant with licensing requirements.
2. Performance Monitoring and Optimization:
- Monitor database universal performance and locate into effect tuning strategies to optimize performance.
- Provide tips and strategic input for database implementations.
3. Documentation and Compliance:
- Create and maintain documentation for preferred running techniques, and logical, and physical diagrams.
- Implement and locate into impact necessities and techniques related to database garage and usage.
4. Operational Support:
- Collaborate with inner and external businesses, which encompass providers, to offer database guides.
- Participate in rotational 24×7 on-name assist for important problems.
5. Backup and Recovery:
- Oversee database backup, restore, and restoration processes to ensure statistics integrity and availability.
6. Emerging Technologies:
- Stay up to date with growing technologies, developments, and systems.
- Provide entry on corporation deployment strategies, collectively with load balancing and immoderate availability implementations.
Education and Experience:
- Bachelor’s degree in Computer Science or an associated field, or equivalent business organization.
- At least 5 years of experience in a Database Administrator function or an associated feature.
Technical Skills:
- Advanced know-how in Structured Query Language (SQL).
- Experience with the database era which consists of SQL Server, Oracle, Postgres, MySQL, and NoSQL databases e.g.., MongoDB, Redis, Cassandra).
- Familiarity with UNIX, Linux, AIX, and Windows going for walks systems.
- Experience with cloud technologies and deploying databases on cloud structures.
- Service Management and Communication:
- Strong Service Management talents in Incident, Change, and Problem Management.
- Effective useful resources manipulate talents for a couple of concurrent tasks.
- Excellent verbal and written verbal exchange competencies, with the capacity to provide a motive of technical thoughts to senior leaders and enterprise partners.
Additional Skills (Preferred):
- Experience with DB2 and Teradata databases.
- Knowledge of the Software Development Lifecycle (SDLC) and Quality Assurance (QA) necessities.
Company Culture and Values:
The LCBO promotes a lifestyle of inclusion and belonging, ensuring that each employees feel valued, actual, and heard. The agency is devoted to fostering a numerous and inclusive place of work in which each group member can thrive. As an equal opportunity organization, the LCBO gives lodging according to the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act.
Benefits:
- Health and Dental Insurance: Comprehensive fitness coverage, which includes scientific, dental, imaginative, and prescient care.
- Pension Plan: Participation in a described gain pension plan, which offers economic safety in retirement.
- Paid Time Off: Generous holiday time, paid vacations, and private departures to preserve existence stability.
- Professional Development: Opportunities for schooling, certifications, and career development to decorate your abilities and profession boom.
- Employee Assistance Program (EAP): Access to exclusive counseling and assistance services for personal and painting-related issues.
- Wellness Programs: Wellness initiatives that could include gymnasium memberships, mental health sources, and other programs to help standard well-being.
Other Jobs:
Walmart Hiring Senior, Data Scientist Job
FedEx Hiring Sales Account Executive Senior
Abode Recruiting For Associate Account Manager
TD Bank Hiring Candidates For Sr. IT Data Analyst
