Database Administrator - Senior

If you are interested kindly send the following documents to [email removed] by Monday, Jun 22, 10:00 AM EST if that interests you and matches your profile.

• Updated Resume in word format (Mandatory)

• References (Mandatory)

• Expected hourly rate (Mandatory)

• Visa Status (Mandatory)

• LinkedIn ID (Mandatory)

Client: Ministry of Public and Business Service Delivery and Procurement

Work Location: 222 Jarvis St., Kingston, Toronto, Ontario, Onsite

Estimated Start Date: [phone removed]

Estimated End Date: [phone removed]

#Business Days: 447.00

Extension: Probable after the initial mandate

Hours per day or Week: 7.25 hours per day

Security Level: CRJMC

Must Have

• 7–10+ years of experience in Database Administration, including design, implementation, operations, and optimization of enterprise‑scale database systems.

• Proven expertise administering cloud database platforms, with a strong focus on Azure PaaS and IaaS database services.

• Experience managing cloud data services for project delivery, including storage, repositories, virtual machines, disks, key vaults, Data Lake, Data Warehouse, and Data Lakehouse platforms

• Expertise in Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.

• Advanced performance tuning and troubleshooting, including:

• Query optimization and indexing strategies

• Azure SQL Query Store analysis

• Intelligent Performance & automatic tuning features

• Review of wait statistics and IO analysis

• Temp DB optimization

• Understanding and mitigating Azure throttling limits

RoleOverview

Responsibilities:

• Designing and developing data pipelines from source to end user

• Optimizing data pipelines

• Creates physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery

General Skills

• Experience with one or more operating systems Experience with one or more database technologies

• Experience in one or more programming languages Experience in the use of information retrieval packages and proficiency with query languages Experience in monitoring and enforcing database rules

• Experience in Incident, Change and Configuration Management procedures

• Experience with one or more communications protocols Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills

• A team player with a track record for meeting deadlines

Desirable Skills

• Experience with distributed data systems

• Experience with middleware and gateways

• Experience with researching and implementing cyber security vulnerability remediations

• Awareness of emerging IT trends and directions

• Experience with Computer Aided Software Engineering (CASE) tools

• Knowledge and understanding of Information Management principles, concepts, policies and practices

• Experience in Database Administration, Maintenance Optimization

Additional Skills For Case Management And ERP

• Experience in designing/developing an automated data distribution mechanism

• Knowledge and understanding of object-oriented analysis and design techniques.

• Experience in developing enterprise architecture deliverables (e.g. models) based

• Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice

• Knowledge and understanding of Information Management principles, concepts,

• policies and practices

• Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases

• Experience in technical design, planning and implementation of specific technology or suite

• Experience with database administration and vendor support services

• Additional Skills for Cloud Database Administrator:

Expertise and experience in Cloud DB Administration, Data Development (DevOps/Data Ops) & Operations, Data Integration, Automation tools and technologies. Further research suggested on a potential need for a role of a Senior DevOps/Cloud DBA at a rate similar to a Senior DevOps/Could Engineer

Additional Skills For Oracle Database Administrator

• Experience in e-Business Suite Applications R12.2 and Oracle Data Guard application (installation, configuration, maintenance, patching, upgrade, and cloning)

• Knowledge and experience in configuring the latest version of WebLogic, OEM Grid Control

• Expert level knowledge of migrating Oracle technologies from Unix (Solaris) to Oracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x

• Expert level knowledge of Advanced Compression, Data partitioning processes

• High level knowledge of data masking using Oracle patches and database scripts

• Performance tuning of e-Business Suite R12.2/19c in multi-node RAC

• Developing database backup and