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:
...states, is currently seeking applicants to deliver mail on a CDS mail route solicited by the USPS in the Preble, NY area. Applicants must be at least... ...Generally, one day per week to be set with the lead carrier.~8:45am - 12:25pm*~ Rate of Pay: $27.50*/hour...
...About the Role Are you passionate about solving complex problems and shaping the future of analytics? Join our high-impact Business Intelligence (BI) team as we transform how data drives decisions in a dynamic manufacturing and distribution organization. This isnt a ...
...Decorates and finishes cakes and pies.All Whole Foods Market Retail jobs require ensuring a... ...service to customers and Team Members at all times. All positions must be performed in... ...communication skills and willingness to work as part of a team. Ability to deliver...
...Accenture Flex offers you the flexibility of local fixed-duration project-based work powered by Accenture, a leading global professional services company. Accenture is consistently recognized on FORTUNE's 100 Best Companies to Work For and Diversity Inc's Top 50 Companies...
FMNE Insurance (Formerly Farmers Mutual of Nebraska) is seeking a Claims Adjuster in our Fargo , ND District Office - an exceptional individual who is intuitive, motivated, and skilled. Were experiencing incredible growth and are on the search for individuals who would...