Apptad - Database Administrator - Senior
نُشرت في :
15-06-2024
صاحب العمل نشط
حالة تأهب وظيفة
سيتم تحديثك بأحدث تنبيهات الوظائف عبر البريد الإلكترونيValid email field required
أرسل الوظائف
شارك هذه الوظيفة
أرسل لي وظائف مشابهة
حالة تأهب وظيفة
سيتم تحديثك بأحدث تنبيهات الوظائف عبر البريد الإلكترونيValid email field required
أرسل الوظائف
الراتب الشهري
لم يكشف
لم يتم الكشف عن الراتب
نُشرت في :
15-06-2024
الوصف الوظيفي
Job Title: Apptad Database Administrator Senior
Job Location: 21 College Street Toronto Ontario (This position is currently listed as Onsite; however the Assignment under this request will provisionally be Hybrid)
Job Duration: LongTerm
Job Location: 21 College Street Toronto Ontario (This position is currently listed as Onsite; however the Assignment under this request will provisionally be Hybrid)
Job Duration: LongTerm
Job Description
NOTE:
- This position is currently listed as Onsite; however the Assignment under this request will provisionally be Hybrid working 7.25 hours per calendar day sometime between 8:00
- 5:00 PM (excluding lunch breaks) Monday to Friday inclusive unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation.
- During the duration of the assignment you will be under the discretion of the Hiring Managers requirements for the Project you are assigned to.
- 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.
Skills
Experience and Skill Set Requirements
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
Skills and Knowledge:
- 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
- Mandatory Requirements:
- At least 10 years of experience
- Experience in database replication / RealTime data delivery with either MSSQL or Oracle products (5 years)
Criteria Ratings MUST TOTAL 100
Criteria 1: Technical Skills 55 Points
- 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.
- Criteria 2: Analysis and Problem Solving 30 Points
- 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.
- Criteria 3: Communication and Interpersonal Skills 15 Points
- Demonstrated writing and negotiation
- Oral and written communication skills Interpersonal and consultative skills
- Experience preparing operational documentation (build guides procedures etc)
Knowledge Transfer
- Knowledge to be Transferred:
- All documentation relating to functional and technical specifications for systems development. Codes Scripts.
- Knowledge to be Transferred to:
- Project Manager team members
Details of Transfer:
- Knowledge Transfer to occur throughout the project life cycle.
- 1:1 meetings / team meetings / documentation on SharePoint site
Must haves:
- At least 10 years of experience
- Experience in database replication / RealTime data delivery with either MSSQL or Oracle products (5 years)
- Previous experience in OPS will be an asset
نوع التوظيف
دوام كامل
المهارات المطلوبة
الإبلاغ عن هذه الوظيفة
إخلاء المسؤولية: د.جوب هو مجرد منصة تربط بين الباحثين عن عمل وأصحاب العمل. ننصح المتقدمين بإجراء بحث مستقل خاص بهم في أوراق اعتماد صاحب العمل المحتمل.
نحن نحرص على ألا يتم طلب أي مدفوعات مالية من قبل عملائنا، وبالتالي فإننا ننصح بعدم مشاركة أي معلومات شخصية أو متعلقة بالحسابات المصرفية مع أي طرف ثالث. إذا كنت تشك في وقوع أي احتيال أو سوء تصرف، فيرجى التواصل معنا من خلال تعبئة النموذج الموجود على الصفحة اتصل بنا
