ITS - SQL- BI Database Administrator (L2) 1582

Found in: Talent SG 2A C2 - 3 weeks ago

Singapore RECRUIT EXPRESS PTE LTD Full time
Roles & Responsibilities

Job summary
He/She will be a technical RUN expert for all MSBI instances. As such, he/she will provide support and act as the last level of escalation point for all production support activities within the Grid 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 have control over the scope of technical activities, develop best practices, manage knowledge and ensure the necessary trainings are imparted to the team wherever applicable.

Job detailed description
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,
  • Supports new technologies and leverages them to provide consistency of service across streams,
  • Documents, reviews, maintains and shares relevant technical information to the team,
  • Provides technical direction, supports services both proactively and reactively to maintain the availability and reliability of system infrastructure in accordance to the sla,
  • Implements and develops improvements based on best practices,
  • Focuses on automation and optimum use of the team to improve efficiency,
  • Drives and delivers root cause for any high severity issue,
  • Reviews technology changes to identify potential risks,
  • Is responsible for problem management and resolution,

As an experienced professional in MSBI he/she:

Setup & Installation

  • Install and test SSIS Instance
  • Install and test SSAS Instance
  • Install, configure and test SSRS Instance
  • Install and test SCOM agents on BI Server
  • Configure Monitoring
  • Patch Management
  • Applying CU, SP, HF on BI Components
  • Monitoring
  • Check & Resolve errors
  • Backup of components
    - Cubes
    - DTSX Files(SSIS)
    - SSRS Keys
  • Monthly metric reporting
  • Storage & Memory for SSAS Multidimensional Instances
  • Storage & Memory for SSAS Tabular Instances
  • Storage & Memory for SSAS Tabular Instances
  • Scheduling of SSIS package execution based CTRL-M
  • Perform applicative deliveries on BI Platform
  • Perform Delivery on ASSEMBLY (automated operation by CTRL-M)
  • Perform Delivery on PRE-PROD (manual operation)
  • Perform Delivery on PROD (manual operation)
  • Define Control-M Jobs
  • Create & Configure Control-M Job for SSIS package Execution

Troubleshooting

  • Troubleshoot issue on performance > First level of assessment
  • Troubleshoot issue with MOE > Second level of assessment
  • Work with DBA for DB optimization (STG, DWH, DMT)
  • Identify Resources consuming queries
  • Optimization
  • Optimize Instance settings
  • Perform Migration
  • Organize Software Upgrade & Migration
  • Is involved in Middleware Standardization
  • Is involved in Capacity Planning
  • Is part of Senior Admin Benchmarks Validation
  • Is involved in the Client Relationship Management in DevOps mode
  • Is purposing Enhancement and Improvement Roadmaps definitionsupports his/her team during diagnosis when technical issues rise in his/her scope ofexpertise, is aware of the global IT structure so that he/she anticipates interrelationships within the organization, engages with technical peer, Service managers, Architect and project teams on technology roadmap and projects, facilitates transformation projects and suggest future directions for new areas of improvement and change, guarantees the production readiness and license to operate of new projects and solutions is available and able to drive technically, any complex or high severity incidents that occur within the scope of their role, actively engages to understand new technologies and technology trends and reviews them with a view to incorporating them into CACIB operations, actively assists in identifying the most technical skilled candidates for open roles. technically coach and develop partner resources to improve quality and productivity, define the technical skillset required to support technologies,

As the escalation point of contact for Clients, he/she:
* manages the daily relationship with Clients including planning, requests clarification, risks mitigation and service quality

  • Job specific environment and/or organization
    Working hours will match Europe business hours
  • On-call support will be expected on a rotational basis

Candidate profile
Mandatory track record
* Minimum 4-5 years of experience in MSBI with about 3-5 years of experiencein financial institutes
* Must be a bachelors/engineering graduate
* Subject matter expert on technologies MSBI
* In depth hands on knowledge/experience on system Windows and MSSQL
* In depth hands on knowledge/experience on Microsoft SQL SSAS
* In depth hands on knowledge/experience on Microsoft SQL SSIS
* In depth hands on knowledge/experience on Microsoft SQL SSRS
* In depth hands on knowledge/experience on Microsoft SQL DB Engine

* In depth hands on knowledge/experience onPowerBI Report Server
* Excellent communication, interpersonal and logical skills
* Customer service oriented and a strong team player
* Ability to work under pressure and a commitment to solving issues

Interestedapplicants, please email your resume to ShaunQuek Yew Meng.

Email: shaunquek@recruitexpress.com.sg

CEI Reg No: R1660732

EA Licence No: 99C4599


Tell employers what skills you have

Excellent Communication Skills
Control M
Optimization
MSSQL
Troubleshooting
Ability To Work Under Pressure
Interpersonal Skills
Technical Direction
SSAS
problem solving skills
PowerBI
Middleware
Windows
Client Relationship Management
Automation
Capacity Planning
Team Player
SSIS
technical issues
SSRS

  • ITS - SQL- BI Database Administrator (L2) 1582

    3 weeks ago

    Singapore Recruit Express Pte Ltd Full time

    Job summary He/She will be a technical RUN expert for all MSBI instances. As such, he/she will provide support and act as the last level of escalation point for all production support activities within the Grid 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...

  • SQL Database Administrator

    Found in: Talent SG 2A C2 - 2 weeks ago

    Singapore ARISTON SERVICES PTE. LTD. Full time

    Roles & ResponsibilitiesGood day!Currently looking for MS SQL DBA who will be involved with the following responsibilities: Administrating MS SQL SERVERS including DB maintenance, technical guidance, and security in coordination with the Technology Infrastructure team. The overall objective is to use MS SQL knowledge to provide L3 DBA support for CTI/GFT...

  • SQL Database Administrator

    2 weeks ago

    Singapore Ariston Services Pte. Ltd. Full time

    Good day!Currently looking for MS SQL DBA who will be involved with the following responsibilities:Administrating MS SQL SERVERS including DB maintenance, technical guidance, and security in coordination with the Technology Infrastructure team. The overall objective is to use MS SQL knowledge to provide L3 DBA support for CTI/GFT apps using MS SQL...

  • L2 Production support- Unix

    2 weeks ago

    Singapore Tata Consultancy Services Asia Pacific Pte. Ltd. Full time

    Must Have :Ready to work in Production Support/L2 SupportKnowledge of Unix, shell script, SQL, Open shift/KubernetesShould be proficient in one of the technologies - Java / Python / Database / HadoopStrong knowledge of ITIL processesGood to HaveSRE knowledgeCloud concepts - preferably GCP

  • Database Administrator

    Found in: Talent SG 2A C2 - 3 weeks ago

    Singapore ST ENGINEERING ADVANCED NETWORKS & SENSORS PTE. LTD. Full time

    Roles & ResponsibilitiesResponsibilities Managing, monitoring and maintaining databases Maintaining database backup and recovery Provide solution related to database design and SQL writing to Application Developers Implement change requests related to development in database such as table design, triggers, and stored procedures Support application...

  • L2 Production support- Unix

    Found in: Talent SG 2A C2 - 2 weeks ago

    Singapore TATA CONSULTANCY SERVICES ASIA PACIFIC PTE. LTD. Full time

    Roles & ResponsibilitiesMust Have : Ready to work in Production Support/L2 Support Knowledge of Unix, shell script, SQL, Open shift/Kubernetes Should be proficient in one of the technologies – Java / Python / Database / Hadoop Strong knowledge of ITIL processesGood to Have SRE knowledge Cloud concepts – preferably GCPTell...

  • Database Administrator

    Found in: Talent SG 2A C2 - 2 weeks ago

    Singapore METAVERSE CLOUD SOLUTION PTE. LTD. Full time

    Roles & ResponsibilitiesJob Highlights database administration, maintenance & support Proficiency in MySQL,PostgreSQL, mongoDB Solid experience in Windows platforms and Linux Solid experience of cloud-based database services (AWS RDS); SQL performance tuning, monitoring usageJob Description Administration, maintenance, configuration, installation and...

  • Power Bi Developer

    Found in: beBee jobs SG - 2 weeks ago

    Singapore Michael Page Full time

    Our client is a reputable brand in the paper and packagind industry. They are looking for a Power BI Developer who is able to independently develop visual reports, dashboards and KPI scorecards.Client Details Our client is a reputable brand in the paper and packagind industry. They are looking for a Power BI Developer who is able to independently develop...

  • Database Administrator

    2 weeks ago

    Singapore Metaverse Cloud Solution Pte. Ltd. Full time

    Job Highlightsdatabase administration, maintenance & supportProficiency in MySQL,PostgreSQL, mongoDBSolid experience in Windows platforms and LinuxSolid experience of cloud-based database services (AWS RDS)SQL performance tuning, monitoring usageJob DescriptionAdministration, maintenance, configuration, installation and support of databasesMaintaining the...

  • Database Administrator

    Found in: Talent SG 2A C2 - 2 weeks ago

    Singapore BANK OF CHINA LIMITED Full time

    Roles & ResponsibilitiesJob Description:1. Database Management: Design, implement, and manage database systems, including configuration, maintenance, and troubleshooting.2. Performance Tuning: Monitor database performance and proactively optimize database configurations, queries, and indexes for optimal speed and efficiency.3. Data Security: Implement and...

  • MySQL & Oracle Database Administrator (Contract, MySQL DBA, PL/SQL, Oracle DBA)

    Found in: Talent SG 2A C2 - 3 weeks ago

    Singapore TANGSPAC CONSULTING PTE LTD Full time

    Roles & ResponsibilitiesPosition: MySQL & Oracle Database Administrator (ASIA)Employment Type: 1 year Agency Contract (Highly Renewable)Location: Changi Business ParkResponsibilities:MySQL Server DBA The MySQL Database Administrator will be responsible for administering development/test and production database servers. This person will support and develop...

  • MSSQL Database Administrator

    Found in: Talent SG 2A C2 - 3 weeks ago

    Singapore PCCW SOLUTIONS INSYS PTE. LTD. Full time

    Roles & ResponsibilitiesDatabase Administrator (SQL) – In this new role, you will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS server, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as...

  • Database Administrator

    Found in: Talent SG 2A C2 - 2 weeks ago

    Singapore AVENSYS CONSULTING PTE. LTD. Full time

    Roles & ResponsibilitiesJob Scope:The APPS DBA will be responsible for database system administration and support.The DBA will be required to assist application team on databases system implementation, setup, maintenance, support and troubleshooting application database related issue for clients. To provide effective and efficient delivery of infrastructure...

  • Database Administrator

    Found in: Talent SG 2A C2 - 2 weeks ago

    Singapore Metaverse Cloud Solution Pte Ltd Full time

    Responsibilities•Responsible for administration, maintenance, configuration, installation and support of databases;•Maintain the normal operation of the database;•Perform platforms running including backup and restoration, troubleshooting and SQL performance tuning, monitoring usage and capacity planning;•Participate in technical and administration...

  • Database Administrator

    Found in: Talent SG 2A C2 - 2 weeks ago

    Singapore ADVANCED E-SOLUTIONS PTE. LTD. Full time

    Roles & Responsibilities A bachelor's degree in computer science or a related field. A minimum of 3 years' experience as a database administrator. Experience in Rational Database Management System such as MSSQL, Teradata, Oracle, Postgres Collect and document user requirements Design and develop database architecture for information systems projects ...

  • Database Administrator

    Found in: Talent SG 2A C2 - 3 weeks ago

    Singapore STAR CAREER CONSULTING PTE. LTD. Full time

    Roles & ResponsibilitiesDatabase Administrator (MSSQL)Job Scope: Heavily involved in MSSQL Database Construction, Migration, Upgrade and Maintenance. Responsible for Database table traffic, solution for MSSQL query tuning, Store Procedure and database storage and integrityInvolved in gathering of Business User's requirements, Analysis and Support. ...

  • Database Administrator

    Found in: Talent SG 2A C2 - 2 weeks ago

    Singapore EXASOFT PTE. LTD. Full time

    Roles & ResponsibilitiesResponsibilities: Build database systems of high availability and quality depending on each end user’s specialized role. Design and implement database in accordance to end users information needs and views. Define users and enable data distribution to the right user, in appropriate format and in a timely manner. Use high-speed...

  • MSSQL Database Administrator

    3 weeks ago

    Singapore Pccw Solutions Insys Pte. Ltd. Full time

    Database Administrator (SQL) - In this new role, you will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS server, to ensure the availability and consistent performance of our corporate applications. This is a 'hands-on' position requiring solid technical skills, as well as excellent...

  • Database Administrator

    Found in: Talent SG 2A C2 - 2 weeks ago

    Singapore JONDAVIDSON PTE. LTD. Full time

    Roles & ResponsibilitiesJob and Responsibilities :- Scope is DBA Production Support of Sybase Database MongoDB and MariaDB (MySQL).Requirements :- Production Support experience in Sybase or SQL MySQL or MariaDB Preferred Skills : MongoDB Banking experience would be plus Good knowledge in Sybase , MYSQLMandatory Skills :-Sybase , MYSQLTell employers...

  • Oracle Database Administrator

    Found in: beBee jobs SG - 3 weeks ago

    Singapore TEKsystems Full time

    Introduction to the role:Top tier financial services organization requires an experienced Oracle DBA Work within a team of dedicated project managers and DBAs The focus for this role is on (1) Oracle Database Projects, (2) L2-L3 operations support, and other projects. Responsibilities include:Migration, building of database and maintenance, troubleshooting...