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:
Sephora is seeking an Asset Protection Partner at Mountain View Village in Riverton, United States. This full-time role involves safeguarding Sephora's assets, promoting safety, and supporting a secure environment for clients and employees. The position requires 1-2 years...
..., intellectually, emotionally, socially, and physically in the Catholic tradition.Key ResponsibilitiesCatholic Mission & CultureJoyfully... ...Professional CollaborationWork as a committed member of the school's PLC structure.Collaborate with the Assistant Principal to...
...find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these... ...Implementation Professional works on problems of diverse scope and complexity... ...business need within the US Work-At-Home Requirements At minimum, a download...
...We are: Accenture Song accelerates growth and value for our clients through sustained customer relevance. Our capabilities span ideation to execution: growth, product and experience design; technology and experience platforms; creative, media and marketing strategy;...
...Family Medicine opportunity in Goodyear, AZ We are seeking a Family Medicine Physician to join our growing team of Physicians providing comprehensive primary health care services through the identification, management and/or referral of the health problems and maintenance...