SQL Server DBA
- 12 months contract
- Hybrid work arrangement after 6 months
- 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 environmentExcellent written and oral English language skills
- Only Singaporeans
Interested parties please click Apply Now or contact May Anne Ramos (EA Reg no: R1110127) at [Confidential Information] for more information.
Peoplebank Singapore Pte Ltd, EA Licence Number: 08C5248.
