Oracle Database Administrator

Position Title- Oracle Database Administrator

Location- Canada, Remote

Job Summary –

The Database Specialist must have an in-depth understanding of the technology and of the applications and business processes. A Database Specialist (DBA) acts as a mentor and establishes policies and procedures with the application and development teams to improve availability and protect the operations. The Database Specialist (DBA) role provides solution engineering, support and administration for database systems and infrastructure.

Database Specialist specializes in Oracle database, Oracle RAC & Data guard, Oracle Spatial and Oracle Exadata. Considered as an asset experience with Versant, CockroachDB, GCP, Terraform, Ansible, Python, Prometheus and Grafana.

Main responsibilities

Operational Support

• Define, document, communicate, and enforce monitoring, observability and automation guidelines, standards and best practices.
• Participate in all initiatives related to monitoring, automation, optimization, efficiency, capacity planning, emergency response, change management and process improvements.
• Ensure all components of a DBMS including storage, archiving, capacity management, high availability, backup and recovery procedures are built, configured and monitored correctly.
• Maintain data integrity and security (manage roles and permissions of database users).
• Manage Production, UAT and Development database environments.
• Manage back-ups, restorations and replications.
• Review and approve change controls.
• Optimize support tasks.
• Perform preventive maintenance tasks.
• Quality review of infrastructure changes and implementations.
• Work with other team members to develop and implement process improvement.
• Takes ownership in defining key performance indicators (KPIs) related to:

Capacity and performance

Services

• Ensure database access is provided in a responsive and reliable manner.
• Respond to production incidents.
• Participate in various projects intended to continuously improve/upgrade infrastructure.
• Handle escalation issues.
• Prepare and document root cause analysis of production-related database issues.
• Support the team and the business in resolving complex issues.
• Performance monitoring and tuning.
• Expertise with configuring, implementing and supporting large high availability clustered environments.
• Test, validate and implement performance and resource optimization improvements.
• Monitor and maintain database security.
• Execute system admin tasks such as daily routine and operational reports analysis.
• Handle capacity planning.
• Maintain data and the database server and application tools.
• 24 x 7 on call Support on rotation (TBC).
• Create detailed documentation including diagrams of database infrastructure.
• Able to prepare and present job-related topics to upper management.
• Monitor and maintain database security.
• Monitoring, maintenance and administration of production, QA and development database environments and familiar with change request process.

Delivery

• Participate in Business projects to design, install and configure new database installations.
• The DBA must understand the particular security model that the database product uses and how to use it effectively to control access to the data.
• Minimize database downtime and manage parameters to provide fast query responses.
• Perform tests and evaluations regularly to ensure data security, privacy and integrity.
• The Database Specialist (DBA) will also coach and mentor more junior DBAs.
• Monitor database performance, implement changes and apply new patches and versions when required.
• Adhere to all documented standards, guidelines and procedures.
• Modify the database structure, as necessary, from information given by application developers.
• Plan how much disk storage will be required and monitor available disk space.
• Learn relevant business processes and understand the data flow, criticality and dependencies.
• Will act as a SME and go to the person to handle most complex problems.

Practice Evolution

• Provide mentoring and technical guidance to other members of the team.
• Will act as a SME and go to the person to handle most complex problems.
• Engage with team to define, design and implement suitable automated processes solutions to optimize the day-to-day support activities.
• Work with other team members to develop and implement process improvement.

Education/Certification/Designation

• Bachelor’s in computer science and 5+ years in a similar role or College degree in Computer Science and 10 years in a similar role.
• A database certification is an asset.
• GCP certification is an asset.
• At least 2 years of experience in the field of cloud computing and monitoring operation with hands-on experience with Infrastructure as code technology such as Terraform and Ansible.

Technical Skills:

• Excellent knowledge of Oracle RDBMS, RAC, Dataguard and Exadata.
• Excellent knowledge of Oracle Spatial.
• Knowledge of more than one RDBMS is an asset.
• Excellent knowledge of the high-availability technologies and best practices.
• In-depth knowledge of the PL SQL, function and procedure with ability to write or optimize very complex queries.
• Data modeling knowledge is an asset.
• Strong Programming language skill.
• Familiar with Linux environments and knowledge of programming languages such as Korn, Perl or Python.
• Ability to work independently with minimal supervision.
• Ability to collaborate with other team members.
• Strong infrastructure knowledge (such as Storage, Network, OS and Hypervisors).

Experience

• 7-10+ years of experience in database management.
• Proficiency in MS Office Suite.
• Strong analytical and problem-solving skills.
• Excellent written and oral communication skills.
• Ability to troubleshoot software and hardware issues.

About Mphasis

Mphasis applies next-generation technology to help enterprises transform businesses globally. Customer centricity is foundational to Mphasis and is reflected in the Mphasis’ Front2Back Transformation approach. Front2Back uses the exponential power of cloud and cognitive to provide hyper-personalized (C=X2C2TM=1) digital experience to clients and their end customers. Mphasis’ Service Transformation approach helps ‘shrink the core’ through the application of digital technologies across legacy environments within an enterprise, enabling businesses to stay ahead in a changing world. Mphasis’ core reference architectures and tools, speed and innovation with domain expertise and specialization are key to building strong relationships with marquee clients.

Other details

Deputation Location : CA~Quebec~Montreal