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
Sr. Mainframe Developer to work with Cobol to develop and implement solutions for a large insurance client - 5019
The candidate will be expected to manage/coordinate offshore resources and be able to pivot / adjust dev resourcing once the solution road map is well established. Mainframe Developer to work with Cobol to develop and implement solutions for a large insurance client -. Continuously strives to improv...
$200/hour Paid Market Research Study for Marketing Strategists in the Pharmaceutical Sector
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...
Do you want to be apart of the Indigenous Continuum of care?
For appointment processes where the area of selection was limited to Indigenous peoples or to members of designated employment equity groups that included Indigenous peoples, the Indigenous candidates proposed for appointment or appointed must complete and sign the Affirmation of Indigenous Identity...
$200/hour Paid Market Research Study for Marketing Strategists in the Computer Hardware Sector
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...
Senior Sitecore Developer to provide design, develop, deploy, and test sitecore CMS
System's client is looking for a. Senior Sitecore Developer to provide design, develop, deploy, and test Sitecore CMS. ...
$200/hour Paid Market Research Study for Social Media Marketing Managers in the Healthcare Sector
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...
Manager, Partner Relations | Gestionnaire, Relations partenaires
The Manager will often be the front-facing and primary point of contact for these prospective and current organizations. Reporting to the Manager, Business Development, the Manager, Partner Relations is responsible for driving sustainable financial growth for CCDI through sales activities as well as...
Assistant Director of Finance
Working as part of the finance team, the Assistance Director of Finance assists the Director of Finance with day to day accounting tasks, the development, preparation, and submission of financial reports for the organization and staff supervision. Assist in overseeing the approval and processing of ...
Resume Inventory for Persons Living with Disabilities
The PPSC’s mission is to serve the public interest and help make Canada a safe and just society by conducting prosecutions in a manner that is equitable, objective and independent, while protecting the rights of every individual; and contributing to the change necessary to support a criminal justice...
Director of Employment Services
This includes assistance with career exploration, referrals to education and training opportunities, job search strategies, referrals to employment, and customized service and employment referrals to recent post-secondary graduates and clients seeking professional employment. As a key leader, you wi...