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