Support Analyst

About BNP Paribas Group:

BNP Paribas is a top-ranking bank in Europe with an international profile. It operates in 71 countries and has almost 199 000 employees. The Group ranks highly in its three core areas of activity: Domestic Markets and International Financial Services (whose retail banking networks and financial services are grouped together under Retail Banking & Services) and Corporate & Institutional Banking, centred on corporate and institutional clients. The Group helps all of its clients (retail, associations, businesses, SMEs, large corporates and institutional) to implement their projects by providing them with services in financing, investment, savings and protection. In its Corporate & Institutional Banking and International Financial Services activities, BNP Paribas enjoys leading positions in Europe, a strong presence in the Americas and has a solid and fast-growing network in the Asia/Pacific region.

About BNP Paribas India Solutions:

Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas SA, a leading bank in Europe with an international reach. With delivery centers located in Bengaluru, Chennai and Mumbai, we are a 24x7 global delivery center. India Solutions services three business lines: Corporate and Institutional Banking, Investment Solutions and Retail Banking for BNP Paribas across the Group. Driving innovation and growth, we are harnessing the potential of over 6000 employees, to provide support and develop best-in-class solutions.

About Business line/Function :

Bank of the West is a regional financial services company, headquartered in San Francisco, California.[1] It is a subsidiary of BNP Paribas. It has more than 600 branches and offices in the Midwest and Western United States. Bank of the West is seeking a Senior Database Administrator with Minimum 6 year’s previous related experience with MS SQL server. This role will involve/provide expert level hands on exposure on SQL Server Database Servers hosting OLTP/DW applications involving L3/SME activities. PowerShell Automation and Linux/MySQL experience is desirable.

Job Title:

Support Analyst

MS- SQL Server DBA

Date:

07/22/2021

Department:

BOW IT

Location:

Mumbai

Business Line / Function:

IRB - Bank of the West IT

Reports to:

(Direct)

Manager

Grade:

(if applicable)

(Functional)

Number of Direct Reports:

Directorship / Registration:

NA

Position Purpose

Provide a brief description of the overall purpose of the position, why this position exists and how it will contribute in achieving the team’s goal.

Under the supervision of the Database Manager/Lead, the DBA will be working on database administration duties. This role will provide expert level hands on exposure on SQL Server Database Servers hosting OLTP/DW applications involving L2/L3 activities.

Responsibilities

• Direct Responsibilities

• Design, architect, and build databases based application systems from business requirements to planning and deploying test and production systems that are completely available and highly scalable
• Automate and perfect operational DBA duties which will include installation, database upgrades, patching, environment cloning, implementing backup/recovery and monitoring procedures, capacity planning and site failover/switchover.
• Interface with clients, network, and hardware and system operations teams to resolve problems with application/database systems in a timely manner.
• Follow change management process and participate in related meetings.
• Responsible for managing Development, Test, QA and Production databases and implementing future SQL Server enhancements to meet the business needs of the end users.
• Monitor database health - availability, reliability, performance, capacity planning, server clustering, replication, re-indexing. Tune system to ensure maximum system efficiency and 100% system availability. Resolve any problems that arise with the database
• Develop, manage and test back-up and recovery plans and procedures during bi-annual Disaster Recovery exercise
• Responsible for implementation and release of database changes as requested by the application team
• Configure and maintain DR/COB solutions like Logshipping/Mirroring/AlwaysOn ; proficient in replication : Snapshot/Transactional/Merge ; Experience in installation and maintenance of SQL Server Clusters and Always On Clusters
• Create and maintain database/application architecture and standards following Microsoft Best practices for physical structures, logical databases, user management.
• Act as a database project leader for critical, time driven, visible projects, if needed.
• Integrate/collaborate with application development and support teams on various IT projects.
• Provide thought leadership and assist in setting strategic direction for Database, infrastructure and technology

• Provide off hours support and maintenance as required, part of the 24x7 operations support on call rotations as needed
• PowerShell Automation and Linux/MySQL experience is desirable.

**** 24 X 7 environment. Willingness to work in night Shift on rotational basis.

Contributing Responsibilities

• Good understanding of Microsoft operating systems as needed to manage SQL Server Databases

• Good understanding of Microsoft operating systems as needed to manage SQL Server Databases
• Power Shell Scripting experience , Automation and Linux/MySQL experience is desirable.
• Experience with SQL Server database architecture concepts.
• Excellent customer service and operations/support temperament is key for this role

Technical & Behavioral Competencies

Knowledge on latest versions of SQL Server database (2012 and above),including troubleshooting and fixing performance issues, replication, backup/restore etc.

Good team player and ability to work on own initiatives with minimal direction

Good analytical, problem solving and documentation skills

Ability to adapt to changing business needs (flexible) and learning new skills quickly

Good written and verbal communication skills, together with the ability to communicate with management and other business and technical groups

Specific Qualifications (if required)

Skills Referential

Behavioural Skills: (Please select up to 4 skills)

Ability to collaborate / Teamwork

Attention to detail / rigor

Client focused

Communication skills - oral & written

Transversal Skills: (Please select up to 5 skills)

Choose an item.

Choose an item.

Choose an item.

Choose an item.

Choose an item.

Education Level:

BS degree in Computer Science, Engineering, Mathematics, Statistics

Bachelor Degree or equivalent

Experience Level 4- 6

At least 5 years

Other/Specific Qualifications(if required)