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:
...Job Location: Boulder, Colorado (Onsite role from day one) Job Duration: Long Term Job Description: Primary Tool: Microsoft Power BI (Desktop, Service, Premium) Data Sources: Databricks, Oracle ADW, Oracle Fusion ERP Languages: SQL, DAX, Power Query...
1. English native speaker (South African, American, Canadian, Australian preferred)2. Over one or two years of English teaching experiences preferred3. Be able to do onfline teaching with decent... ...Class amount: 1 or 2 students onlineIf you are interested in the job...
...Terms and conditions: Wolfgang Puck Catering is committed to recruiting individuals who express an interest in and passion for hospitality-driven experiences; who come from diverse backgrounds, are open-minded and curious about our clients and guests; and, most of all...
...United States (US) Hourly/Salaried: Hourly (Non-Exempt) Full Time/Part Time: Full Time Position Type: Regular Your Role at Sephora Asset Protection is constantly evolving to ensure we have products available to delight our clients. Our action-oriented leaders...
# Design, develop, and maintain responsive WordPress websites. # Customize themes, templates, and plugins as per project requirements. # Create custom plugins or modify existing ones to extend functionality. # Integrate third-party tools, APIs, and payment gateways...