RQ10358 Database Administrator Senior

Toronto - Canada

Monthly Salary: Not Disclosed

Experience Required: 7-10years

Posted on: 2 hours ago

Vacancies: 1 Vacancy

Job Summary

Responsibilities:

Creation of functional and technical specifications for database development analyze requirements and help project team in solution technical design implementation and support.
Work with the project team in completing all relevant and required documentation in alignment with OPS standards.
Creation of technical specifications for Azure SQL and Oracle database systems development
Design implement and work with the project team in completing all relevant and required documentation in alignment with OPS standards
Undertake special assignments/sub-projects as assigned
Conduct assess evaluate and document stakeholder interests and business needs
Create and validate business scenarios and use cases
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
Create review provide input and support of Enterprise Architecture artifacts for all checkpoints as required
Create system and user interface design and modifications (data & screen) as required
Review all test scenarios to ensure the requirements are met; establish traceability matrix to monitor output
Ensure alignment and adherence to Ministry of Government Services processes and standards
Support the testing team during system and UAT testing
Participate in Knowledge transfer
Experience administering database management systems (i.e. ORACLE Exadata Microsoft SQL Server Azure etc.) for business intelligence and analytics applications
Create test and implement safeguards to maintain data integrity and protect against unauthorized access
Assist with SQL optimization and code reviews to ensure queries are efficient
At least 10 years of experience
Experience in database replication / Real-Time data delivery with either MSSQL or Oracle products (5 years)

Requirements

Experience and Skill Set Requirements:

Must Haves:

Oracle SQL Managed Instance & Elastic Pools:

Performance tuning using AWR ASH and execution plans
Storage optimization partitioning and indexing strategies

Oracle GoldenGate:

Designing deploying and monitoring GoldenGate replication topologies
Tuning extract/replicat processes log retention and checkpointing

Azure Data Replication:

SQLMI transactional replication
Elastic pool implementations and tenantlevel balancing

Operational Excellence:

Incident response performance baselines and proactive monitoring
Root cause analysis and postincident optimization

Skill Set Requirements:

Technical Skills:

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

Analysis and Problem Solving:

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

Communication and Interpersonal Skills:

Demonstrated writing and negotiation
Oral and written communication skills Interpersonal and consultative skills
Experience preparing operational documentation (build guides procedures etc)

Required Skills:

Experience and Skill Set Requirements: Must Haves: Oracle SQL Managed Instance & Elastic Pools: Performance tuning using AWR ASH and execution plans Storage optimization partitioning and indexing strategies Oracle GoldenGate: Designing deploying and monitoring GoldenGate replication topologies Tuning extract/replicat processes log retention and checkpointing Azure Data Replication: SQLMI transactional replication Elastic pool implementations and tenantlevel balancing Operational Excellence: Incident response performance baselines and proactive monitoring Root cause analysis and postincident optimization Skill Set Requirements: Technical Skills: Oracle Exadata Golden Gate MSSQL Azure SQL technical knowledge and experience. Demonstrated experience in modifying database structures using information provided by application developers Demonstrated experience with monitoring optimizing and performance tuning using either manual or automated tools Able to develop and interpret highly complex SQL to support queries and provide feedback for developers. Analysis and Problem Solving: Research and evaluation of complex design options. Superior ability to identify root cause of complex environmental or underlying database specific issues. Determining areas of risk and recommending innovative alternatives and options for resolution to meet program needs. Demonstrated experience working within a team environment to troubleshoot and resolve technical problems. Communication and Interpersonal Skills: Demonstrated writing and negotiation Oral and written communication skills Interpersonal and consultative skills Experience preparing operational documentation (build guides procedures etc)

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