LFL Group Hiring for Database Administrator at Toronto, ON Full Time

Overview:
Database Administrator

Preferred Experience

Excellent oral and written communications

8+ years of DBA experience with Oracle, Azure Cosmo, MySQL and Microsoft SQL

Proficient in managing databases in various platforms. Support activities ranging from initial database architecture design through implementation, administration, monitoring, tuning, backup and migration. Develop and oversee database policies and procedures.

Understanding of Azure cloud environment

Demonstrated ability to self-motivate and be flexible within a fast-paced environment

Project management and planning skills

Other duties as assigned. Comfortable working weekends and off hours on-call support.

Preferred Knowledge and Qualifications

Enterprise Databases

Working knowledge of Oracle, covering Enterprise and Standard Edition. Oracle Real Application Clusters (RAC) and Data Guard (DG). Familiar with Oracle’s Product line, Database Editions and Options.

Knowledge on MySQL and Microsoft SQL server

Knowledge of Azure Cosmos DB and noSQL is essential

Database Administrator

Participate in database architecture, data modelling, data warehousing, ETL and database/table design. Creates and maintains all databases required for development, testing, education and production usage.

Understand of different ETL tools (e.g. Informatica, PL/SQL, Azure Data factory)

Ensure tight control in database access, standards and quality assurance policies and procedures are followed

Responsible on database schema, development and table structure design

Database software planning, installation, upgrade and patching

Database change control management

Write and Tune SQL and PL/SQL

Database Maintenance

Networking knowledge include TCP/IP and DNS

Contact and work with vendor on all database related issues

Implement security and auditing on databases. Database/Table access and permission

Database server(s) health check, monitoring, database performance capture, trending, tuning and improvement. Project growth and expansion requirements, and plan to ensure that long term requirements are met

Design database maintenance plan and backup/recovery strategies

Prepare and compose technical documentation and support document

Certifications

Oracle Certified Professional DBA (Essential)

ITIL (Preferred)

SQL Server Certifications (Preferred)