Database Technical Expert

3 days ago


Singapore ADVANCED E-SOLUTIONS PTE. LTD. Full time
Roles & Responsibilities

Database Technical Expert (Application Performance Tuning – Oracle & Java)


Position Purpose


• To perform deep technical audit of large-scale eBanking application to identify performance bottleneck areas and propose/implement solutions for top performance of application.


• Technical expert specialized in Database model design and architecture as well as runtime Database queries and procedures execution focused on the Oracle database & Java based web application.


Responsibilities


Direct Responsibilities

• Take a lead role in analyzing the current application design and Database model for performance point of view.

• Be the main contributor in auditing the Database queries and procedure/packages that are (potential) source of performance issues of application.

• Propose/suggest improvements techniques/schemas of the Database model and queries.

• Work in a tight collaborative environment with an Offshore vendor (locate in India) to improve Database assets and resources.

• Identify the 20% of the queries that cause 80% of the slowness issues.

• Analyze the possibility of cartesian product in the SQL queries used.

• Pinpoint the queries which involve full table scan.

• High ability to read and analyze AWR reports.

• Interact with teams and communicate findings and areas of improvements.


Technical & Behavioral Competencies


• Expertise in Oracle 19C, 21 Database Product

• Expertise in SQL Language for performance tuning

• Expertise in writing efficient SQL queries considering Server and Network resources.

• Expertise in the Oracle database runtime configuration and optimization parameters.

• Exposure to Relational database Object Mapping frameworks such as iBatis and Hibernate.

• Hands-On Java experience would be a plus.

• Good communication skills.

• Excellent troubleshooting and analytical skill with Accuracy


Specific Qualifications


• Graduate degree in IT/Computer Science or equivalent

• 10-15 years of total experience with last 5 years as Database application performance specialist, preferably in banking domain.

• IT Design and development exposure is a definite plus.

• Certification in database optimization/tuning areas is preferred.


Tell employers what skills you have

NHibernate
COBOL
Troubleshooting
Oracle
Private Banking
Hibernate framework
Auditing
Manufacturing Operations
SQL
Good Communication Skills
Writing
Banking
Performance Tuning
Oracle Database
DB2
Java
iBatis
Hibernate ORM
Hibernate

  • Singapore V4 IMPACT PTE. LTD. Full time

    Roles & ResponsibilitiesJob Description: To perform deep technical audit of large-scale eBanking application to identify performance bottleneck areas and propose/implement solutions for top performance of application. Technical expert specialized in Database model design and architecture as well as runtime Database queries and procedures execution focused...


  • Singapore KG INFORMATION SYSTEMS PTE. LTD. Full time

    Roles & ResponsibilitiesDatabase Technical Expert (Application Performance Tuning – Oracle & Java) in Supply Chain Financing IT TeamPosition Purpose • To perform deep technical audit of large-scale eBanking application to identify performance bottleneck areas and propose/implement solutions for top performance of application. • Technical expert...


  • Singapore NEW TONE CONSULTING PTE. LTD. Full time

    Roles & ResponsibilitiesSummary:The Database Technical Expert will be responsible for performing a deep technical audit of large-scale eBanking applications, identifying performance bottlenecks, and implementing solutions to ensure optimal application performance. This role focuses on the Oracle database and Java-based web applications, requiring expertise...


  • Singapore OVERSEA-CHINESE BANKING CORPORATION LIMITED Full time

    Database Administration OpportunitiesWe seek a skilled Database Administrator to join our team at OVERSEA-CHINESE BANKING CORPORATION LIMITED. The successful candidate will be responsible for ensuring the high availability and performance of our database systems.Main ResponsibilitiesConfigure and manage standalone and High Availability database...


  • Singapore Cognizant Full time

    Job SummaryAs a seasoned technical expert, you will be responsible for leading the database administration team and providing advanced technical knowledge in Oracle and PostgreSQL RDBMS systems. Your expertise in performance tuning, high availability technologies, and disaster recovery solutions will be instrumental in ensuring the smooth operation of our...

  • Technical Expert

    1 week ago


    Singapore Selby Jennings Full time

    Job SummaryAs a Technical Specialist at Selby Jennings, you will be responsible for providing expert technical support to our clients. This role requires a strong knowledge of Windows operating systems, Microsoft Office Suite, and common desktop applications.Key Responsibilities* Familiarity with networking concepts and troubleshooting (TCP/IP, VPN, DNS,...

  • Technical Lead

    3 days ago


    Singapore TXT TECHNICAL PTE. LTD. Full time

    Job Summary:TXT TECHNICAL PTE. LTD. is seeking a highly skilled Senior Engineer to lead the design, development, and implementation of our trading systems. The ideal candidate will have a strong background in software engineering and a passion for financial technology. The successful candidate will be able to design and develop high-performance trading...

  • Database Engineer

    3 days ago


    Singapore HIGOGAME PTE. LTD. Full time

    Roles & ResponsibilitiesCompany DescriptionHigogame is a trailblazer in the mobile gaming and entertainment industry. Since our inception in late 2020, we have been dedicated to transforming the gaming landscape in Southeast Asia and beyond, delivering innovative and immersive experiences that engage millions of players around the globe. Our revenue has...

  • Database Specialist

    2 weeks ago


    Singapore Cognizant Full time

    Job SummaryAs a seasoned expert in Oracle and PostgreSQL RDBMS systems, you will be responsible for driving service improvement initiatives and automations in the region. Your advanced technical knowledge and expertise in performance tuning, high availability technologies, and disaster recovery solutions will be instrumental in managing databases on hybrid...


  • Singapore HIGOGAME PTE. LTD. Full time

    Roles & ResponsibilitiesCompany DescriptionHigogame is a trailblazer in the mobile gaming and entertainment industry. Since our inception in late 2020, we have been dedicated to transforming the gaming landscape in Southeast Asia and beyond, delivering innovative and immersive experiences that engage millions of players around the globe. Our revenue has...


  • Singapore PERSOLKELLY SINGAPORE PTE. LTD. Full time

    Job Title: Senior SAP Technical ExpertAbout the Role:We are seeking a highly skilled Senior SAP Technical Expert to join our team at PERSOLKELLY SINGAPORE PTE. LTD. As a Senior SAP Technical Expert, you will be responsible for ensuring the successful implementation of SAP systems and providing technical expertise to our clients.Key Responsibilities:Act as...

  • Service Engineer

    3 days ago


    Singapore RECRUIT EXPERT PTE. LTD. Full time

    Job SummaryAt RECRUIT EXPERT PTE. LTD., we are seeking a highly skilled Service Engineer - Asset Maintenance Expert to join our team. As a key member of our maintenance team, you will be responsible for ensuring the optimal performance of our customers' surveillance systems.Key Responsibilities:Attend to service calls at customers' premises and respond to...


  • Singapore NTT Data Singapore Full time

    As a Senior MongoDB Database Administrator at NTT Data Singapore, you will be responsible for ensuring the smooth operation of our MongoDB databases. Your expertise in database software installation and configuration will be crucial in meeting our client-defined standards.Key responsibilities include:Designing and implementing high-performance MongoDB...

  • Data Systems Expert

    3 days ago


    Singapore TRINITY CONSULTING SERVICES PTE. LTD. Full time

    Demanding Role:We are seeking a highly skilled and experienced Database Administrator to join our team at TRINITY CONSULTING SERVICES PTE. LTD. The ideal candidate will possess a strong background in database administration, with a focus on Oracle and SQL. They will be responsible for ensuring the smooth operation of our database systems, providing...


  • Singapore BSI Full time

    At BSI, we are seeking a highly skilled Medical Device Technical Expert to join our team. As a key member of our team, you will be responsible for delivering Medical Device CE Marking technical reviews under MDD and MDR requirements, scheme management, and ISO 13485 QMS assessment services.The ideal candidate will possess a Bachelor's degree or higher in a...


  • Singapore Careers@Gov Full time

    **Key Responsibilities**As a Technical Operations Expert at Careers@Gov, you will be part of our team of maritime professionals ensuring safe navigation in Singapore waters by providing hydrographic, cartographic, and aids to navigation products and services.**Your Duties Will Include:**Producing high-quality paper nautical charts, electronic navigational...


  • Singapore GREENLANE PRIVATE LTD. Full time

    Roles & ResponsibilitiesWe are seeking an experienced Database Administrator to manage and maintain our complex database environments and ensure seamless operations across platforms.Key Responsibilities:• Database Design & Documentation: Develop and maintain up-to-date database design documents, ensuring accuracy and relevance.• Database Management:...

  • Database Administrator

    2 months ago


    Singapore D L RESOURCES PTE LTD Full time

    Roles & ResponsibilitiesJob Description:Functionally reports to the Service Build Engineering Lead under Group Infrastructure Platform Services, the Build engineer will be responsible for detail design, build, post provision support and continuously optimize and automate the end-to-end build and provisioning process in accordance to the bank standard.This...


  • Singapore BSI Full time

    At BSI, we are seeking a Medical Device Technical Specialist with expertise in contraceptives, including condoms and lubricant gel related medical devices.Our Technical Specialists are industry experts who are analytical, communicative, diligent, and always curious.The ideal candidate will possess a Bachelor's degree or higher in a discipline relevant to...


  • Singapore Cognizant Full time

    Job SummaryAs a seasoned Database Administrator, you will be responsible for providing advanced technical expertise in Oracle and PostgreSQL RDBMS systems. Your expertise in performance tuning, high availability technologies, and disaster recovery solutions will be crucial in managing databases on hybrid platforms, including AWS and Azure cloud platforms.Key...