RQ11860 - Database Administrator - Senior
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
Responsibilities:
- 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
Must Have Experience:
- Experience with major database management systems (DBMS) such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2
- Experience managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS, Google Cloud SQL) alongside legacy on-premises mainframes and enterprise servers
- Experience Cloud (Azure or AWS), Cyber Security, Enterprise and Solution Architecture, Java, Microsoft .Net,
- Experience with SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQL MI, Azure Blob, Cosmos DB etc.)
Technical Skills (40%)
- Experience with major database management systems (DBMS) such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2
- Experience managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS, Google Cloud SQL) alongside legacy on-premises mainframes and enterprise servers
- Experience with Agile methodologies
- Experience with conceptual, logical, and physical data modeling, schema design, and enterprise data architecture to support large-scale public applications
- Experience with onPrem and Cloud connections using Mulesoft or similar tools
- Experience Cloud (Azure or AWS), Cyber Security, Enterprise and Solution Architecture, Java, Microsoft .Net,
- Experience with SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQL MI, Azure Blob, Cosmos DB etc.)
- Experience with Rest APIs & Integrations, Web/Lite Apps
Experience (40%)
- Experience with cloud platforms such as Azure, Dynamics 365, Power Platform
- Experience Implementing strict role-based access control (RBAC), data masking, row-level security, and transparent data encryption (TDE) at rest and in transit
- Ensuring adherence to provincial data privacy and security mandates
- Designing, testing, and executing enterprise backup strategies, point-in-time recovery, geo-replication, and business continuity failover drills
- Experience with Agile methodologies including using kanban/task boards
- Hands-on experience leading major database version upgrades, cross-platform migrations, and consolidation projects without disrupting agency services
- Experience with SQL, PL/SQL, T-SQL, and shell scripting (Bash, PowerShell, Python) for automation, stored procedures, and triggers
- Experience with large government applications
Communication Skills (20%)
- Strong communication skills to prepare documentation, including but not limited to; reports, reviews, assessments
- Ability to present ideas and suggestions clearly and effectively and in a user friendly manner; maintain a high level of customer service to both internal and external clients
- Ability to communicate designs and development in clear and understandable manner
More about this job
Responsibilities
Design, administer, optimize, and maintain enterprise databases, including capacity planning, installation, migration, performance tuning, and backup and recovery. Lead database upgrades, migrations, security controls, and continuity planning while supporting large-scale public applications and communicating technical designs and documentation to stakeholders.
Requirements
Requires experience with major relational database systems, cloud-hosted and hybrid databases, data modeling, integrations, and large government applications. Candidates should also have experience with database security and recovery, scripting and SQL programming, Agile methods, and clear technical communication.
Skills
- Database Administration
- Oracle
- Microsoft SQL Server
- PostgreSQL
- MySQL
- IBM DB2
- Cloud Databases
- Azure
- AWS
- Data Modeling
- SQL
- PL/SQL
- T-SQL
- Database Security
- Backup and Recovery
- Agile Methodologies
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Government & Public Sector
- Consulting
Keywords
- Database Administration
- Database Management Systems
- Oracle
- Microsoft SQL Server
- PostgreSQL
- MySQL
- IBM DB2
- Azure
- AWS
- Azure SQL
- Amazon RDS
- Google Cloud SQL
- SQL MI
- Azure Blob
- Cosmos DB
- Data Modeling
- Enterprise Data Architecture
- MuleSoft
- REST APIs
- Java
- Microsoft .NET
- RBAC
- Data Masking
- Row-Level Security
- Transparent Data Encryption
- Backup and Recovery
- Geo-Replication
- SQL
- PL/SQL
- T-SQL