Database Administrator 8264-0512

Dheya; Old Toronto; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

An innovative firm is seeking a skilled Database Administrator for a hybrid role, focusing on SQL Server and Oracle database management. This position involves creating technical specifications, collaborating with project teams, and ensuring data integrity. You will play a key role in performance tuning, backup solutions, and compliance with security best practices. If you thrive in a dynamic environment and are passionate about database technologies, this opportunity offers a chance to make a significant impact while working with a talented team. Join us to drive excellence in database solutions and elevate your career!

Qualifications

• Experience with Oracle Exadata, Golden Gate, and Azure SQL is crucial.
• Strong skills in performance tuning and data migration techniques.

Responsibilities

• Create functional and technical specifications for database development.
• Work with project teams to ensure documentation aligns with OPS standards.

Skills

SQL Server Management

Oracle Exadata

Golden Gate

Azure SQL Database Design and Architecture

Performance Tuning and Optimization

Backup and Recovery Solutions

Data Migration Techniques

Scripting Languages (e.g. Python, PowerShell)

Cloud Database Management (e.g. AWS, Azure)

Team Collaboration Tools (e.g. Jira, Confluence)

Compliance and Security Best Practices

Job description

Skills Required:

1. SQL Server Management
2. Oracle Exadata
3. Golden Gate
4. Azure SQL Database Design and Architecture
5. Performance Tuning and Optimization
6. Backup and Recovery Solutions
7. Data Migration Techniques
8. Scripting Languages (e.g. Python, PowerShell)
9. Cloud Database Management (e.g. AWS, Azure)
10. Team Collaboration Tools (e.g. Jira, Confluence)
11. Compliance and Security Best Practices

HM Note: This contract hybrid role is three (3) days in office.

Scope:

1. Creation of functional and technical specifications for database development, analyze requirements and help project team in solution, technical design, implementation, and support.
2. Work with the project team in completing all relevant and required documentation in alignment with OPS standards.

Experience and Skill Set Requirements:

1. Creation of technical specifications for Azure, SQL, and Oracle database systems development.
2. Design, implement and work with the project team in completing all relevant and required documentation in alignment with OPS standards.
3. Undertake special assignments/sub-projects as assigned.
4. Conduct, assess, evaluate and document stakeholder interests and business needs.
5. Create and validate business scenarios and use cases.
6. Produce visual depiction of use cases and process flows; ensure alignment with the program area and associated business architecture, as well as traceability to solution logical and physical architectures.
7. Create, review, provide input and support of Enterprise Architecture artifacts for all checkpoints as required.
8. Create system and user interface design and modifications (data & screen) as required.
9. Review all test scenarios to ensure the requirements are met; establish traceability matrix to monitor output.
10. Ensure alignment and adherence to Ministry of Government Services’ processes and standards.
11. Support the testing team during system and UAT testing.
12. Participate in Knowledge transfer.

Skills and Knowledge:

1. Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL Server, Azure etc.) for business intelligence and analytics applications.
2. Create, test and implement safeguards to maintain data integrity and protect against unauthorized access.
3. Assist with SQL optimization and code reviews to ensure queries are efficient.

Criteria 1: Technical Skills - 50 points

1. Oracle Exadata, Golden Gate, MSSQL, Azure SQL technical knowledge and experience.
2. Demonstrated experience in modifying database structures using information provided by application developers.
3. Demonstrated experience with monitoring, optimizing and performance tuning using either manual or automated tools.
4. Able to develop and interpret highly complex SQL to support queries and provide feedback for developers.

Criteria 2: Analytical and Problem-Solving Skills - 30 points

1. Research and evaluation of complex design options.
2. Superior ability to identify root cause of complex environmental or underlying database specific issues.
3. Determining areas of risk, and recommending innovative alternatives and options for resolution to meet program needs.
4. Demonstrated experience working within a team environment to troubleshoot and resolve technical problems.

Criteria 3: Communication Skills - 20 points

1. Oral and written communication skills, interpersonal and consultative skills.

Knowledge Transfer:

1. Knowledge to be Transferred: Project Manager / Team members
2. Details of Transfer: (how transfer will occur) 1:1 meetings / team meetings / documentation on SharePoint site, throughout the duration of the project life cycle etc.