See more Collapse

Systems Programmer

4 weeks ago

Singapore RECRUIT EXPRESS PTE LTD Full time
Roles & Responsibilities

Job Summary

MSSQL DBA Expert is a technical expert role within the Database team and will be responsible for managing, administration and supporting the MSSQL Database technologies for the bank.

Person will be the technical point of contact for the Run team. He/She will be a technical L2 resource for MSSQL database services in CA-CIB. As such, he/she will provide support for all production support activities within the Database team in Singapore. He/She is accountable for the overall health and stability of the technical solutions within his scope. He/She has to effectively work with technical peers such as architects, peer experts and project teams on technology road maps and projects. He/She will work with L3/Service Manager to gain control over the scope of technical activities, develop best practices and gain knowledge over all aspects of support.

MSSQL team in Singapore is responsible for day-to-day operational services on the infrastructure of Europe (mainly France and UK) and Asia remotely from Singapore. France infrastructure represents approximately 80% of the worldwide production activities of CA-CIB in Singapore.

Team works in Europe time zones and this role will be aligned primarily to Paris working hours. Flexible rotations are followed based on the nature of duties.

The operational support of the team covers the following technical scope:

  • DB advanced performance tuning both Server & DB level
  • Very good Experirnce in high availability & DR solutions. – Clustering/Log shipping, Always on, Distributed availability groups.
  • Encryption Solutions: Always encrypted , TDE,SSL
  • Database Audit Monitoring solutions
  • Vulnerability Management
  • Automations -Powershell/TSQL/Python,perlscript

Job Detailed Description

The Expert has a wide spectrum of responsibilities and actions. Person will be responsible for following (but not limited to) responsibilities in day-to-day work:

As the Expert of the team, he/she:

  • act as the last 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
  • participates to recruitment process for the team

As the Expert of his/her scope of activity, he/she:

  • is actively involved in incident management (fault investigation, resolution escalations of all monitoring alerts and user initiated problem calls/tickets) and request management
  • Is the final technical approver for any changes into MSSQL technology and is accountable for any technical changes in the environment from a RUN/BAU perspective
  • Is involved in projects like End of Life, New Builds, migrations and technical upgrades of the solution managed by the team
  • 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 drive and deliver 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
  • maintain programmable code outlined in technical instructions and specifications for operating systems.

Work Schedule

  • Work schedule is mainly focused to support Asia and EMEA (Paris) time zone; however, may have to support during non-offce hours for critical incidents or escalation as per the assigned on-call support requirements;
  • Rotational Shift schedule is followed;

Work Hours: 2 PM – 11 PM SGT (with 1 week of General shift 9 AM – 6 PM SGT).


Functional

  • 6 - 8 years of MSSQL DBA experience in administration and management of IT Database technologies primarily SQL,MSBI solutions;
  • Should be a bachelors/masters/engineering graduate or equivalent technical degree in Information Technology or Computer Science;
  • Knowledge of different domains of IT Security;
  • Working & hands-on experience in administering the DB technologies;
  • 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;
  • Excellent in analytical, communication and documentation skills;
  • 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;
  • Ability to work independently and as well as a part of team and is able to work under minimal supervision;
  • Should have time management skills and able to manage work in fast moving environment;

Technical

  • Hands-on experience on Configure and maintain database servers and processes experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  1. Highly proficient in data leakage prevention (DLP) technologies - troubleshooting and configuration management;
  • Deployment, integration and administration experience of various components of DB technologies:

- MSSQL

- SSAS

- SSRS

- SSIS

- Power BI


  • Must have experience in defining, designing and configuring Database solution as per the business requirements;
  • Deploy, upgrade and troubleshooting knowledge on MSSQL technology solution;
  • Scripting knowledge (Phyton, Powershell,TSQL ) is desirable;
  • Professional Certifications: Microsoft SQL certified is highly preferred
  • Must be experienced to cover the scope as mentioned in the SKILLS MATRIX section of this document.
  • At least a Bachelor’s degree in any of these faculties:
  • Computer Science
  • Information Technology
  • Programming & Systems Analysis
  • Science (Computer Studies)

Interested applicants, please email your resume to Shaun Quek Yew Meng

Email: shaunquek@recruitexpress.com.sg

CEI Reg No: R1660732

EA Licence No: 99C4599


Tell employers what skills you have

Powershell
Scripting
SSAS
Microsoft SQL
SQL
Python
Operating Systems
TSQL
SSIS
Power BI
SSRS

We have other current jobs related to this field that you can find below

  • IT Programmers

    2 weeks ago

    Singapore ALLTECH SYSTEMS PTE. LTD. Full time

    Working Experience And Skill Requirement IT Programmera. Must be able to speak and write English proficiently;b. Have at least three (3) years' post graduate experience working with Personal computers or compatibles;c. Have at least three (3) years' post graduate experience using MS OS such as Windows 7 or higher and Microsoft Outlook;d. Able to conduct...

  • Systems Programmer

    2 weeks ago

    Singapore MANPOWER STAFFING SERVICES (SINGAPORE) PTE LTD Full time

    Roles & ResponsibilitiesResponsibilities:Responsible for end to end management, administration of PostgreSQL Database technologies. Main point of contact for any changes in Sybase and PostgreSQL technology and is accountable for any technical changes in the environment from a RUN/BAU perspective. Maintain programmable code outlined in technical instructions...

  • Cnc Programmer

    4 weeks ago

    Singapore Akribis Systems Full time

    COMPANY DESCRIPTIONFounded in Singapore in 2004, Akribis Systems is a motion control company that provides high precision direct drive motors. We construct products for a range of industries including renewable energy, semiconductor, communication, biomedical, robotics or any industry that requires precise motion.We produce direct drive motors with a high...

  • Cnc Programmer

    4 weeks ago

    Singapore Akribis Systems Full time

    COMPANY DESCRIPTIONFounded in Singapore in 2004, Akribis Systems is a motion control company that provides high precision direct drive motors. We construct products for a range of industries including renewable energy, semiconductor, communication, biomedical, robotics or any industry that requires precise motion.We produce direct drive motors with a high...

  • Systems Engineer

    2 weeks ago

    Singapore EPAM Systems Full time

    WHAT YOU'LL DO Design the solution and develop the software using Agile methodology Investigate, and troubleshoot issues by developing scripts, and SQL queries Collaborate with deployment team/DevOps team on setting up continuous integration, build and release automation Provide estimates for stories during sprint planning for Agile projects Convert...

  • Programmer / System Development

    2 weeks ago

    Singapore Simmtech International Pte. Ltd Full time

    CompanySimmtech International Pte. LtdDesignationProgrammer / System DevelopmentDate Listed15 Mar 2023Job TypeEntry Level / Junior Executive Intern/TSJob PeriodFrom Apr 2023, For At Least 4 MonthsProfessionIT / Information TechnologyIndustryElectronicsLocation NameJalan Besar, SingaporeAddressJln Besar, SingaporeMapAllowance / Remuneration$800 - 1,200...

  • Systems Programmer

    2 weeks ago

    Singapore SPEEDMARK AIR TRANSPORTATION PTE LTD Full time

    Roles & ResponsibilitiesKey Responsibilities & Requirements Responsible for designing and delivering the Speedmark Intranet application system. Creating and maintaining applications based on technical design and requirements. Developing and reviewing System Development Life Cycle (SDLC) deliverables and incorporating feedback from stakeholders. Determining...

  • Systems Engineer

    2 weeks ago

    Singapore EPAM SYSTEMS PTE. LTD. Full time

    Roles & ResponsibilitiesAbout EPAMEPAM is a leading global provider of digital platform engineering and development services. EPAM has been expanding in Singapore since 2013 and delivering the best solutions to our customers. As a recognized leader, EPAM Singapore achieved Great Place to Work Certification in 2023 and is committed to providing our team with...

  • Programmer

    2 weeks ago

    Singapore JOULE AIR PTE. LTD. Full time

    PLC Programmer Responsibilities: Discuss their mechanical or electrical automation needs. Drawing electrical or mechanical schematics to demonstrate how processes will work. Developing and installing machine programs using automation software and custom coding languages. Determining machine automation test criteria before the final installation. Testing...

  • Systems Programmer

    2 weeks ago

    Singapore TRINITY CONSULTING SERVICES PTE. LTD. Full time

    At least a Bachelor's degree in any of these faculties:Computer Science Information Technology Programming & Systems Analysis Science (Computer Studies) Minimum 15 years of experience in supporting and IT infrastructure. Experience with Citrix environment (Xenapp/Desktop) is desirable. Experience in supporting Windows operating systems desirable.

  • Systems Programmer

    2 weeks ago

    Singapore AURUS CONSULTING PTE. LTD. Full time

    Roles & ResponsibilitiesAs part of System Development Life Cycle (SDLC),Gathering requirements, Development, Testing, Implementation and post production support using below technologies,  Knowledge Required Must Have Database: Oracle, SQL Server Programming Language: Oracle PL/SQL  Data Integration Tool: INFORMATICA Power Centre  Reporting Tool:...

  • systems programmer

    2 weeks ago

    Singapore APAR TECHNOLOGIES PTE. LTD. Full time

    Roles & ResponsibilitiesJob DescriptionExperience with AS400 COBOL development is preferred (familiarity with Open Systems is a bonus)Proficient in managing stakeholders and collaborating with other IT teamsBackground in Banking sector with expertise in Trade Finance and Loans is desirableAdaptable and skilled in handling multiple projects...

  • Senior Security Systems Engineer

    2 weeks ago

    Singapore EPAM Systems Full time

    We are looking for a Senior Cloud Security Engineer to play a crucial role in safeguarding an organization's digital assets and infrastructure. They will be responsible for implementing and maintaining robust security measures to protect the organization's critical data and systems. The role involves conducting regular security assessments, identifying and...

  • Systems Engineer

    2 weeks ago

    Singapore EPAM SYSTEMS PTE. LTD. Full time

    Software Engineer - EPAM SingaporeAbout EPAMEPAM is a prominent global company specializing in digital platform engineering and development services. Since 2013, EPAM has been steadily growing in Singapore, delivering top-notch solutions to its clients. Recognized for its excellence, EPAM Singapore obtained the Great Place to Work Certification in 2023,...

  • Head, Air Systems Programme Centre

    2 weeks ago

    Singapore DSTA - Defence Science & Technology Agency Full time

    Job no:Work type: PermanentLocation: DSTA SingaporeCategories:NAThe Defence Science and Technology Agency (DSTA) brings you to the forefront of cybersecurity, digital transformation and engineering. From working on software development and systems integration to unmanned technologies and artificial intelligence, you can have an impact on Singapore's...

  • Programme Executive

    2 weeks ago

    Singapore NTUC Health Full time

    COMPANY DESCRIPTIONNTUC Health Co-operative Limited (NTUC Health) is an NTUC social enterprise that provides a comprehensive and integrated suite of quality and affordable health and eldercare services to meet the growing needs of families and their dependents. Building on more than four decades of experience and expertise, NTUC Health is among the largest...

  • Programme Executive

    2 weeks ago

    Singapore Unity Denticare Full time

    About Us:NTUC Health Co-operative Limited (NTUC Health) is an NTUC social enterprise that provides a comprehensive and integrated suite of quality and affordable health and eldercare services to meet the growing needs of families and their dependents. Building on more than four decades of experience and expertise, NTUC Health is among the largest senior day...

  • Scheduler/programmer

    2 weeks ago

    Singapore WSH EXPERTS PTE LTD Full time

    Job Description & RequirementsJob responsibilities Track, monitor the baseline programme and working programme; Review Scurve, cost loading and highlight areas; Prepare dashboard report on Progress Status, S-Curve and areas of concerns, etc., including presentation to stakeholders Assessment and evaluation of extension of time Develop and update various...

  • Programme Director

    4 weeks ago

    Singapore NTU (Nanyang Technology University- Main Office-HR) Full time

    The Energy Research Institute @ NTU (ERI@N) invites applications for the position of Programme Director. Key Responsibilities: The job is to lead an ERI@N Interdisciplinary Research Programme focusing on Energy Storage Systems which will enable a future low carbon economy. The PD has to assist the Executive Director in Scientific and Technical matters...

  • Programme Director

    4 weeks ago

    Singapore NTU (Nanyang Technology University- Main Office-HR) Full time

    The Energy Research Institute @ NTU (ERI@N) invites applications for the position of Programme Director. Key Responsibilities: The job is to lead an ERI@N Interdisciplinary Research Programme focusing on Energy Storage Systems which will enable a future low carbon economy. The PD has to assist the Executive Director in Scientific and Technical matters...