Sybase Oracle Database Administrator - Quebec City, Canada - AppTad Technologies Pvt Ltd

AppTad Technologies Pvt Ltd

Verified Company

Quebec City, Canada

3 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Job Title:
Lead Consultant-Sybase DBA

Job Location:
Quebec, Canada(Onsite)

Job Duration:
Long-Term

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 Sybase 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 Sybase 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 servicerelated issues and risks to track lead and/or ITS lead.
Technical guidance of junior team members (when applicable)

Minimum Qualifications

Preferred Qualifications/ Skills

Knowledgeable about the Oracle; Sybase and SQL Database architecture
Handson 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