Job Summary:

The Senior Database Administrator is responsible for designing, operating, and optimizing complex database management systems across on-premises and cloud environments. This role ensures database performance, security, backup, recovery, and capacity planning to support large-scale public sector applications, while leading upgrades, migrations, and enforcing compliance with data privacy mandates.

Responsibilities:

- Create and maintain physical database designs and schemas.
- Administer and optimize database management systems including Oracle, SQL Server, PostgreSQL, MySQL, and IBM DB2.
- Plan and execute database installation, migration, upgrades, patching, and capacity planning.
- Implement and monitor backup, recovery, and disaster recovery strategies.
- Ensure database security through role-based access control, data masking, encryption, and compliance with provincial data privacy requirements.
- Lead cloud and hybrid database management including Azure, AWS, and Google Cloud platforms.
- Develop automation scripts and tools using SQL, PL/SQL, T-SQL, Bash, PowerShell, and Python.
- Collaborate with cross-functional teams on enterprise architecture, data integration, and middleware solutions.
- Provide technical leadership on database design for data warehouses, data marts, and ERP/case management systems.
- Maintain documentation and communicate technical information effectively to stakeholders.

Required Skills:
- Expertise in major DBMS platforms: Oracle, Microsoft SQL Server, PostgreSQL, MySQL, IBM DB2.
- Experience managing cloud-hosted and hybrid database environments (Azure SQL, Amazon RDS, Google Cloud SQL).
- Strong knowledge of database backup, recovery, and disaster recovery techniques.
- Proficiency in database performance tuning and capacity planning.
- Experience with security implementations including RBAC, data masking, TDE, and row-level security.
- Familiarity with scripting languages for automation: SQL, PL/SQL, T-SQL, Bash, PowerShell, Python.




- Understanding of Agile methodologies and enterprise data architecture.
- Excellent communication and documentation skills.
- Ability to work onsite 5 days a week.

Desired Skills:
- Experience with distributed data systems, middleware, and gateways.
- Knowledge of cyber security vulnerability remediation and emerging IT trends.
- Experience with Oracle E-Business Suite R12.2, Oracle Data Guard, WebLogic, and OEM Grid Control.
- Familiarity with cloud DevOps/DataOps, automation tools, and data integration technologies.
- Understanding of object-oriented analysis, enterprise architecture modeling, and Ontario Government Enterprise Architecture.
- Experience with data warehouse technologies including Oracle OBIEE.
- Knowledge of containerized and cloud-native database deployments.

Rated Criteria:
- Database Management Expertise (Oracle, SQL Server, PostgreSQL, MySQL, IBM DB2) - 30 Points
- Cloud and Hybrid Database Administration (Azure, AWS, Google Cloud) - 25 Points
- Database Security and Compliance (RBAC, Data Masking, Encryption) - 15 Points
- Performance Tuning, Backup and Recovery Strategies - 15 Points
- Automation and Scripting Skills (SQL, PL/SQL, Bash, PowerShell, Python) - 10 Points
- Communication and Documentation Skills - 5 Points

Total: 100 Points Deliverables:
- Optimized and secure database environments supporting mission-critical applications.
- Comprehensive database design documentation and architecture models.
- Backup and recovery plans with tested disaster recovery procedures.
- Automated scripts and tools for database maintenance and monitoring.
- Reports on database performance, security compliance, and upgrade/migration activities.

Must Haves:
- Proven experience with major DBMS platforms and cloud database services.
- Strong knowledge of database security practices and compliance requirements.
- Hands-on expertise in database backup, recovery, and disaster recovery planning.
- Ability to automate database administration tasks through scripting.
- Excellent communication skills and ability to work onsite full time.

Public Sector Experience:

Preferred

📌 Senior Database Administrator (Ontario)
🏢 vTech Solution
📍 Ontario