Int Database Admin to be responsible for the implementation, configuration, maintenance, and performance of critical SQL/MP and SQL/MX database systems for our large telco client -19003

S.i. Systems
Winnipeg
$40 an hour (estimated)
Full-time

Int Database Admin to be responsible for the implementation, configuration, maintenance, and performance of critical SQL / MP and SQL / MX database systems for our large telco client -

Duration- 8 Months

Location - WF (1 Day a month in office)

Description :

The Int Database Administrator (DBA) will be responsible for the implementation, configuration, maintenance, and performance of critical SQL / MP and SQL / MX database systems to ensure the availability and consistent performance of HNS applications.

This is a hands-on position requiring solid technical skills, as well as excellent interpersonal and communication skills.

The successful candidate will be responsible for developing and sustaining the SQL / MP AND SQL / MX database systems, ensuring its operational readiness (security and performance), executing data loads, and performing data modelling in support of multiple development teams.

The DBA supports an enterprise application suite of software and tools.

Responsibilities

  • Plan, consult, design, implement and manage SQL / MP and SQL / MX objects
  • Configure and support NonStop ODBC / MP and ODBC / MX (Open Database Connectivity) components - define and enforce thresholds governing rules and tracing of ODBC processes.
  • Participate in quarterly capacity analysis & reporting.
  • Perform large data extracts and data encryption.
  • Participate in hardware migration planning and NonStop O / S Upgrades.
  • Maintain SQL statistics (Metadata).
  • Perform technical testing of new version releases for SQL / MP and SQL / MX and ODBC / MP and ODBC / MX.
  • Configure, test and provide on-going support for ODBC / MX data sources
  • Install and manage SQL / MX database
  • Participate in data verification process (code, execute SQL scripts).
  • Open and manage problem tickets with HP Global Support.
  • Participate in proof of concepts, benchmarks and measurements and performance analysis and Dry Runs.
  • Participate in Tier 2 support
  • Ensure implementation policies, procedures and quality standards are followed.
  • Work with the Development team and client to prepare test data and consult on test scenarios.
  • Consult with production control to recommend CPU & priority assignment, job partitioning (instances of processes) and scheduling new processes.
  • Forecast future storage requirements to provide input to the hardware acquisition process.
  • Consult with and provide feedback to application designers concerning data access, data integrity and data access concurrency / locking.
  • Promote enforcement of referential data integrity by providing accurate and timely feedback to application architects.
  • Extracts and masks production data for testing environments.

Must-have skills :

  • 8+ yrs of hands-on DBA experience at a large company (+ employees
  • Hands-on DBA support and maintenance including on-call incident management
  • Expert level SQL, ODBC

Nice to have skills :

  • HPE Nonstop SQL MP / MX experience
  • Unix and Shell scripting

Consultant will require security clearance for the Government of Ontario.

History of the role (new role or replacement?) : Net new

Project details / team environment / additional comments : Ministry of Health Ontario Drug Benefits Program

13 days ago
Related jobs
S.i. Systems
Winnipeg, Manitoba

Planning will determine what needs to be done in the execution phase by demonstrating the gap between today's solution and the S/4 HANA environment, and detailing the enhancements and field changes that are possible and/or required. Perform detailed demonstrations and explore the SAP S/4HANA functio...

Promoted
Ivy Exec
Remote/Online Interview, Canada
Remote

Legal, Information Technologies, Financial Services, Pharmaceutical, Healthcare, Internet, Computer Software, Consumer Products, Architecture, Civil Engineering, Management Consulting, Marketing, Manufacturing, Media, Energy, Insurance, Computer Hardware, Non-Profit, Accounting, Banking, Hospitality...

S.i. Systems
Winnipeg, Manitoba

Build and lead team of functional analysts and architects responsible for designing and implementing SAP solutions to support Procure-to-Pay business function. Work with senior business leaders to understand how the technology will support their business strategies and processes . SAP Functional Tea...

Promoted
Ivy Exec
Remote/Online Interview, Canada
Remote

Legal, Information Technologies, Financial Services, Pharmaceutical, Healthcare, Internet, Computer Software, Consumer Products, Architecture, Civil Engineering, Management Consulting, Marketing, Manufacturing, Media, Energy, Insurance, Computer Hardware, Non-Profit, Accounting, Banking, Hospitality...

S.i. Systems
Winnipeg, Manitoba

Experience implementing secure authentication and authorization mechanisms using JSON Web Tokens (JWT) through platforms such as AWS Cognito, AWS Amplify, Auth0, or equivalent services. This role is % Remote and candidate must be willing to work standard MST business hours. Senior Front End Develope...

Promoted
Ivy Exec
Remote/Online Interview, Canada
Remote

Legal, Information Technologies, Financial Services, Pharmaceutical, Healthcare, Internet, Computer Software, Consumer Products, Architecture, Civil Engineering, Management Consulting, Marketing, Manufacturing, Media, Energy, Insurance, Computer Hardware, Non-Profit, Accounting, Banking, Hospitality...

Promoted
Ivy Exec
Canada, CA
Remote

Participation requirements: Job titles: Marketing Manager, Marketing Specialist, Marketing Strategist, Social Media Marketing Manager Industries : Legal, Information Technologies, Financial Services, Pharmaceutical, Healthcare, Internet, Computer Software, Consumer Products, Architecture, Civil Engi...

S.i. Systems
Winnipeg, Manitoba
Remote

Provide training and support to end-users and stakeholders on the use and administration of Power Apps and Power Automate solutions. Senior Microsoft Power Platform Developer/Analyst to design, develop and deploy custom applications and automate workflows within an enterprise environment – % remote....

Promoted
Ivy Exec
Canada, CA
Remote

Participation requirements: Job titles: Marketing Manager, Marketing Specialist, Marketing Strategist, Social Media Marketing Manager Industries : Legal, Information Technologies, Financial Services, Pharmaceutical, Healthcare, Internet, Computer Software, Consumer Products, Architecture, Civil Engi...

Remotivate LLC
CA
Remote

You'll be responsible for implementing and optimizing paid advertising campaigns across Google Ads, Meta Ads, Bing Ads, and other paid media platforms for our clients, leveraging your expertise to generate insights and recommendations that fuel business growth. You leverage data-driven insights and ...