RQ08027 - Database Administrator - Senior
RQ08027 - Database Administrator - Senior
Posted on :
12-10-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Scope:
- 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.
Deliverables:
- 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/subprojects 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
Requirements
Experience and Skill Set Requirements:
Must Haves:
- At least 10 years of relevant experience as a Database Administrator
- Experience in database replication / RealTime data delivery with either MSSQL or Oracle products (5 years)
- Experience administering Oracle 12C MSSQL Azure SQL Elastic Pools SQLMI.
Skill Set Requirements:
- 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
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.
Analytical and Problem Solving Skills:
- 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 Skills:
- Oral and written communication skills Interpersonal and consultative skills
- Experience preparing operational documentation (build guides procedures etc)
Experience and Skill Set Requirements: Must Haves: At least 10 years of relevant experience as a Database Administrator Experience in database replication / Real-Time data delivery with either MSSQL or Oracle products (5+ years) Experience administering Oracle 12C+, MSSQL, Azure SQL, Elastic Pools, SQLMI. Skill Set Requirements: 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 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. Analytical and Problem Solving Skills: 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 Skills: Oral and written communication skills, Interpersonal and consultative skills, Experience preparing operational documentation (build guides, procedures, etc)
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
