Lead Consultant, dba SQL - Montréal, Canada - Genpact

Genpact

Verified Company

Montréal, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

With a startup spirit and 115,000 + curious and courageous minds, we have the expertise to go deep with the world's biggest brands—and we have fun doing it We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line.

We're harnessing the power of technology and humanity to create meaningful transformation that moves us forward in our pursuit of a world that works better for people.

Now, we're calling upon the thinkers and doers, those with a natural curiosity and a hunger to keep learning, keep growing. People who thrive on fearlessly experimenting, seizing opportunities, and pushing boundaries to turn our vision into reality. And as you help us create a better world, we will help you build your own intellectual firepower._
Welcome to the relentless pursuit of better._

_ _

The purpose of this job is to provide all aspects of database administration provide technical guidance and support to junior (L1) database administrators (when applicable) and vulnerability remediation would be the primary task._
This position will also handle escalated incidents and perform root cause analysis of any problems that may arise out of IRs and/or proactive needs for business._
Responsibilities_

- _The main responsibilities include vulnerability remediation which would be the primary task._
- _Should work on configuration, implementation, support of SQL Database Production servers and technical guidance of junior team members._
- _Understand business requirements and design solutions accordingly._
- _Ensure quality standards in release implementation especially in DML/DCL/DDL & Data Fixes of any form._
- _Resolve incidents, escalate to Client management and SQL Vendor as necessary._
- _Create SOPs_
- _Perform root cause analysis for P1/P2/P3 and P4 incidents and/or proactively based on business needs._
- _Work with the Genpact, CACIB or 3rd party teams for the implementation of changes_
- _Follow the required policies and procedures for the incident, problem and change management._
- _Ensure service performance expectations are met with service levels and quality._
- _Raise/escalate any service-related issues and risks to track lead and/or ITS lead._
- _Technical guidance of junior team members (when applicable)_

Qualifications we seek in you_
Minimum Qualifications_

- _Graduate or postgraduate in Technology with Computers or IT stream_

- _Graduate or postgraduate in any stream with course in Computers or IT stream_

Preferred Qualifications/ Skills_

- _Knowledgeable about the Oracle; Sybase and SQL Database architecture_
- _Hands-on experience with installation, configuration, and disaster recovery procedures_
- _Worked on multiple Databases releases._
- _Perform DB refreshes._
- _Perform DB installs and refreshes._
- _Knowledge of shell scripts_
- _UNIX

Solaris/Linux all current releases_

- _Database user creation_
- _Hands on with backup recovery_
- _Adding of datafiles and space management_
- _Well versed with Index and Reorganization of database objects_
- _Well versed with audit concepts_
- _Analysis and implementation of CPU patching on production system independently_
- _Understanding of database concept as a SME and ability to provide solutions._
- _Good Understanding of Patch concepts_
- _Well versed with performance & tuning of databases_
- _Exposure of database recovery scenarios_
- _Experience of database upgrades_
- _Good understanding of reports_
- _Sound experience of Database export/import functions_
- _Experience of database character set conversion_
- _Knowledge of Database monitoring tools_
- _Must have very good trouble shooting and analytical skills._
- _Excellent communication skills (verbal and written)_
- _High energy, results driven person with strong interpersonal skills._
- _Ability to work under mínimal supervision._
- _Capital Markets Domain knowledge is preferred._
- _Knowledge of Information Technology Infrastructure Library (ITIL), integration across Incident, Problem & Change (IPC) Management. Experience._

_ _
**_
Job_**_Lead Consultant_

_ Primary Location__CA-Montreal_

_ Schedule__Full-time_

_ Education Level__Bachelor's / Graduation / Equivalent_

_ Job Posting__Mar 22, 2024, 7:06:08 AM_

_ Unposting Date__Ongoing_