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
Int. Solutions Architect to support the Wealth Solutions Business Unit for our large Insurance Client.
You will work to define and maintain architecture artifacts for supporting project delivery and application support and lead the technical vision and direction for solutions, ensuring consistency with our overall enterprise architecture strategy. You will also effect change within the organization b...
Administrative Assistant
The Society of Obstetricians and Gynaecologists of Canada (SOGC) is the national voice for women’s health in Canada with a mission to lead the advancement of women’s health through excellence and collaborative professional practice. Reporting to both the Director of Communications and Public Affairs...
REMOTE Senior Data Architect to do FHIR mapping, FHIR implementation for API development for Provider and Service Information Management, Reports Distribution Projects - SOW20240205MB - July 3 - 1
Participates in the selection and implementation of database management systems that meet strategic needs by defining data schemas, optimizing data storage, and establishing data access controls and security measures. Proficiency in the design and implementation of modern data architectures and conc...
SAP PaPM Consultant (Performance & Profitability)
Our ERP projects cover the gamut of typical implementation but we also support bespoke projects and specialty staffing needs covering:. We are also globally partnered with some of some of the Top Accounting, Advisory and Audit firms. An issue that they are currently facing is how to address the requ...
Senior SAP Architect (8+ years) to design and deliver technical solutions supporting Forecast to Produce (F2P) business functions for SAP PP within a manufacturing environment.
Senior SAP Architect (8+ years) to design and deliver technical solutions supporting Forecast to Produce (F2P) business functions for SAP PP within a manufacturing environment. Architecting, designing and implementing SAP solutions in the Forecast to produce area. Providing direction to sustainment ...
Director of Growth & Performance
Strong understanding of attribution tools, Mix Marketing Models and various tools and platforms. Does this sound like you or someone you know in your professional network? Then reach out to our President of Chaos, marcie. MoD is on the lookout for a performance-marketing expert in the role of. We ar...
Remote - Intermediate SAP MM Functional Consultant to provide integration, enhancement, and process improvement support within a S/4 HANA environment
This role is the primary liaison between the SCM Group and the ERP Competency Centre to support and build the relationship and provide solutions and continuous improvement. Utilize expertise in project management, process improvement, metrics, requirements management and understanding of the organiz...
Hiring for Greenhouse Labourers to work in Canada
Working Conditions and Physical Capabilities: Large workload, Repetitive tasks, physically demanding, Combination of sitting, standing, walking, Bending, crouching and kneeling, Standing for extended periods of time, overtime required. Large workload, Repetitive tasks, physically demanding, Combinat...
REMOTE Salesforce Resources for public health authority - Func Analysts, Admins, Trainers, Developers, Leads, Architects - SOW20240611MB - MSA - June 25
Systems BC public health client has selected Salesforce Health Cloud as their CRm to enable integrations between patient and provider portals. They are seeking to build a relationship with a smaller group of vendors (recruiting agencies) to partner with for quicker turnaround of Salesforce resources...
Indigenous Cultural Coordinator
Reporting to the Manager, Indigenous Initiatives & Community Development, The Indigenous Cultural Coordinator is responsible for the management, budget, coordination, planning, and execution of small to large scale events involving Indigenous Initiatives & Community Development. The Indigenous Cultu...