Working hours: 2pm - 11pm (with 1 week of general shift 9am-6pm)
Work location: Pasir Panjang
Our Client
One of the largest investment bank
The Opportunity The L2 has a wide spectrum of responsibilities and actions. Person will be responsible for following (but not limited to) responsibilities in day-to-day work:
Act as the first level of escalation for the team members
Own Incident, Problem and change management process for the team
Assigns technical tasks and manages delegation
Animates the team to encourage collaboration and sharing of practices
As the L2 of his/her scope of activity, he/she:
Actively involved in incident management (fault investigation, resolution escalations of all monitoring alerts and user initiated problem calls/tickets) and request management
Raise any changes into MSSQL technology and is accountable for any technical changes in the environment from a RUN/BAU perspective
Participates in global Infra events (like Power down and DR Tests)
Ensures activity is performed in compliance with norms, standards, processes and procedures
Ensures documentation is up to date and relevant for use
Lead the continuous improvement initiatives
Responsible to assist in finding root cause for any high severity issues
Focus on automation and optimum use of the team to improve efficiency
Maintain appropriate knowledge to ensure to be fully qualified to undertake the role.
Complete all mandatory training as required to attain and maintain competence
Comply with all applicable legal, regulatory and internal Compliance requirements, including, but not limited to, the Singapore Compliance manual and Compliance policies and procedures as issued from time to time
MSSQL Clustering, DB advanced performance tuning both Server & DB level * MSSQL On-Premise, CLOUD & Cross platform migrations Your Background
8 - 10 years of MSSQL DBA experience in administration and management of IT Database technologies primarily SQL Clustering,Always On ,Replication;
Experience with provisioning and decommission of MSSQL/MSBI instances.
Architect HA and DR Solutions for MSBI stack i.e. SSIS, SSAS, SSRS, PowerBI.
Installation and Upgrade of MSBI stack i.e. SSIS, SSAS, SSRS, PowerBI under Window platforms.
Experience in building end-end ETL flows for DWH and other application.
Experience with Cloud technologies and implement pipelines and migrations.
Hands-on expertise in SSAS Multidimensional Cube development with MDX language.
Knowledge of different domains of IT Security;
Automations -Python, shell script,perlscript
Must have experience in working in similar Production setup in Run (Operations) mode;
Ability to apply risk based approach while working on assigned responsibilities;
Experience in defining, implementing, and enforcing Database Security policies for data security solutions;
Must have working experience in a Large enterprise level environment, working experience in financial organization is preferred;
Ability to organize work and be able to priories work as per the needs of Production Operation\'s needs;
Must have strong understanding of ITIL processes and comfortable working in process oriented environment;Excellent written and oral English language skills;
Only Singaporeans
Interested parties please click "Apply Now" or contact May Anne Ramos (EA Reg no: R1110127) at mayanne.ramos@peoplebank.asia for more information. Peoplebank Singapore Pte Ltd, EA Licence Number: 08C5248.