The Database Administrator is responsible for the creation of functional and technical specifications for database development, analyzing requirements, and assisting the project team in solution design, technical design, implementation, and support. This role involves working with Azure, SQL, and Oracle database systems, ensuring data integrity, optimizing performance, and providing knowledge transfer to team members.
Location:Ontario, Canada
Responsibilities:
- Creating functional and technical specifications for database development.
- Analyzing requirements and assisting the project team in solution, technical design, implementation, and support.
- Designing, implementing, and completing relevant documentation in alignment with standards.
- Undertaking special assignments/sub-projects as assigned.
- Conducting, assessing, evaluating, and documenting stakeholder interests and business needs.
- Creating and validating business scenarios and use cases.
- Producing visual depictions of use cases and process flows.
- Creating, reviewing, and supporting Enterprise Architecture artifacts.
- Creating system and user interface design and modifications.
- Reviewing test scenarios to ensure requirements are met.
- Supporting the testing team during system and UAT testing.
- Participating in Knowledge transfer.
- Administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL Server, Azure etc.) for business intelligence and analytics applications.
- Creating, testing, and implementing safeguards to maintain data integrity and protect against unauthorized access.
- Assisting with SQL optimization and code reviews.
- Developing and interpreting complex SQL queries.
- Monitoring, optimizing, and performance tuning using manual or automated tools.
- Troubleshooting and resolving technical problems within a team environment.
- Preparing operational documentation (build guides, procedures, etc).
Required Skills & Certifications:
Preferred Skills & Certifications:
Special Considerations:
Scheduling:
...staffing with your collaborating therapists, at least monthly, to discuss patient cases or clinical topics. Clinical work is performed from home, days and hours are per the clinician's choosing (this includes mornings, afternoons, evenings, weekends, holidays, etc.)...
...FlightSafety International FlightSafety International is the worlds premier professional aviation training company and supplier of flight simulators, visual systems and displays to commercial, government and military organizations. The company provides training for...
...Oracle Payroll Functional Consultant - Entry Level (Career Transition Opportunity) Role: Oracle Payroll Functional Consultant Location: Canada (Remote) Visa Status: Canada, Work permit/Citizen/PR Pay Rate: $60/hr- $70/hr Travel: Not Required...
NOW HIRING: General Manager DoubleTree by Hilton Fort Worth South Hotel & Conference Center Managed by GF Hotels & ResortsWe are seeking a top-performing, highly motivated General Manager to lead the newly renovated DoubleTree by Hilton Fort Worth South, a full-service...
...Salary: $50,000 - 60,000 per year Requirements: Proficiency in WordPress, PHP, HTML, CSS, and JavaScript Sound understanding of web... ...Capacity to work collaboratively with a diverse team of developers and designers Experience with AWS is a significant advantage...