Database Administrator Job at vTech Solution, Ontario, CA

cVlEYllWUC9uTHYraEpTQTZpaTRYcFdEQlE9PQ==
  • vTech Solution
  • Ontario, CA

Job Description

Job Summary:


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 Tags

Similar Jobs

Cloud Analytics Technologies LLC

Lead C++ Developer (Embedded Developer) Job at Cloud Analytics Technologies LLC

 ...changing deadlines Must work with System Architects to review/approve program and subsystem designs Proficiency in UNIX/Linux and Microsoft Windows distributed computing Basic skills with Excel spreadsheets and Word documents Relational DB principles using... 

UNAVAILABLE

Senior Analyst, Search Marketing Job at UNAVAILABLE

 ...Experiences, Integrated Media, Addressable Relationships, Social Marketing and Total Commerce. Celebrated by AdAge as Data and Insights...  ..., youll manage the tactical components within integrated Search Engine Marketing (SEM) campaigns, more commonly known as Paid Search... 

Heritage Construction Co., LLC

Outside Sales Representative - Paid Training (up to 90 days) + Uncapped Commission ($150K+ 1st year) Job at Heritage Construction Co., LLC

 ...Earn Big. Grow Fast. Get Paid to Succeed! Looking for a career where your hustle determines...  ...freedom, and more opportunity. We'll train you, support you, and give you everything...  ...make $500K+ a year! Paid training. No experience? No problem. We'll teach you how to win.... 

BGSF

Apartment Maintenance Technician Job at BGSF

Apartment Maintenance Technician Contract-to-HireLocation: Oakdale, MNPay: $22/hrSchedule Options:MondayFriday, 8:00 AM 4:00 PMMondayFriday, 9:00 AM 5:00 PMLooking for a stable maintenance role with flexibility? Join BGSF, a nationwide staffing leader... 

MSI Inc.

Entry Level Event Assistant Job at MSI Inc.

 ...marketing, live events, and promotional activations . Driven by creativity, collaboration, and executional excellence, our event...  ...leave lasting impressions. We are currently hiring an Entry-Level Event Assistant to support the planning and execution of live...