RQ10358 - Database Administrator - Senior

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 tenant‑level balancing
  

Operational Excellence:

• Incident response, performance baselines, and proactive monitoring
  


• Root cause analysis and post‑incident 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)