Pause
Lecture
Moteur de recherche d'offres d'emploi Crédit Agricole CIB

DBA Expert


Vacancy details

General information

Entity

About Crédit Agricole Corporate and Investment Bank (Crédit Agricole CIB)

Crédit Agricole CIB is the corporate and investment banking arm of Credit Agricole Group, the 12th largest banking group worldwide in terms of tier 1 capital (The Banker, July 2021). Nearly 8,600 employees across Europe, the Americas, Asia-Pacific, the Middle East and Africa support the Bank's clients, meeting their financial needs throughout the world. Crédit Agricole CIB offers its large corporate and institutional clients a range of products and services in capital markets activities, investment banking, structured finance, commercial banking and international trade. The Bank is a pioneer in the area of climate finance, and is currently a market leader in this segment with a complete offer for all its clients.


For more information, please visit www.ca-cib.com

Twitter: https://twitter.com/ca_cib
LinkedIn: https://www.linkedin.com/company/credit-agricole-cib/
  

Reference

2021-55265  

Update date

19/03/2021

Job description

Business type

Types of Jobs - Information systems / IT Project management

Job title

DBA Expert

Contract type

Permanent Contract

Job summary

Job summary

·         Expert in Sybase/PostgreSQL/SQL Server Database Technologies as DBA

·         Database monitoring, troubleshooting, performance tuning, high-availability strategies with Sybase/PostgreSQL/SQL Server technologies.

·         Administering, maintaining, developing and recommending policies and procedures for ensuring the performance, availability, security and integrity of the company’s databases and systems.

·         Proactively monitoring production databases for optimum performance.

·         Troubleshoot recurring problems and fix them permanently.

·         Resolve locking conflicts/blocking and resource utilization Identifying and resolving database performance issues, database capacity issues and other database issues.

·         Constantly seek out methods to better handle data and increase system efficiency which also includes, but not limited to, assisting developers with query tuning and schema refinement

·         Performing regular deployments, scheduled maintenance and house-keeping.

·         Refine and automate regular processes, track issues, document changes and provide reports.

·         Anticipating hardware requirements and storage capacity planning for production, physical database implementation architecture and design, test and development environments and implementing replication, archiving and backup and recovery strategies.

·         Ensuring availability and integrity all database environments

·         Point of escalation in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues,

·         Writing technical and RCA (Root Cause Analysis) documentation

·         Strong Experience in writing database documentation, including data standards, procedures and definitions for the data dictionary(metadata)

·         Owning and Managing the projects and be final escalation point for these projects on technical and functional grounds

·         Hold knowledge transfer in the team to ensure all DBA have same level of knowledge on the subjects

·         Incident management and propose and implement stability of databases with short and long term goals

·         Conduct DB DR Drill activity, ensure to bring the DR site online if any outage at Primary site

·         Manage the Projects and be point of Contact for Support and Developers/Architects

·         Propose and develop improved methodologies to increase efficiency and institute best practices around database security and access.

An Expert has a wide spectrum of responsibilities and actions.

As an expert of his/her team, he/she:

·         assigns technical tasks and manages delegation for technical issues,

·         animates the team to encourage collaboration and sharing of best practices,

·          has a role in supporting technical skills development and provides training when required.

Position location

Geographical area

Asia, Singapore

City

Singapour

Candidate criteria

Minimal education level

Bachelor Degree / BSc Degree or equivalent

Academic qualification / Speciality

• Must be a bachelors/engineering graduate

Level of minimal experience

6-10 years

Experience

-8+ years of experience in Sybase/SQL/PostgreSQL Database Administration.
-5+ years in performance tuning of Sybase/MSSQL.
-Supported multiple RDBMS technologies/Servers and databases on 24 X 7 environments.
-5+ years of Transact-SQL experience in high volume transaction processing environment.



Required skills

-Flexible to work in 24/7 support model.
-Flexible to be on-call on a rotation basis.

Technical skills required

-Strong experience on performance tuning on Sybase/SQL/PostgreSQL; experience with data integrity, data retention.
-Strong experience in database performance optimization.
-Strong Knowledge in PostgreSQL Architecture.
-Strong Knowledge in PowerShell.
-Hands on experience on PostgreSQL/Sybase High Availability Failover Replication setup.
-Advanced knowledge of SQL Profiler, extended events and server side traces.
-Strong Sybase ASE and Good experience in Sybase IQ & MS SQL Server.

Languages

English, French