Database Technical Expert

4 weeks 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 Oracle Full time

    Oracle is seeking a highly skilled Database Support Specialist to join our Advanced Customer Support team. This is a global position that requires expertise in Oracle Database, with a strong focus on delivering mission-critical support services to our customers.About the RoleThis role involves providing proactive and preventive support using diagnostic and...


  • Singapore MongoDB Full time

    MongoDB is a leading developer data platform that empowers innovators to create, transform, and disrupt industries. As a Technical Database Services Engineer, you will play a critical role in delivering exceptional support to our Financial Services Industry (FSI) customers. Your primary focus will be on addressing complex technical issues, conducting root...


  • 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 MongoDB Full time

    About MongoDBMongoDB is a leading developer data platform that empowers innovators to create, transform, and disrupt industries by unleashing the power of software and data. Our mission is to provide organizations of all sizes with the tools they need to easily build, scale, and run modern applications.We achieve this through our industry-leading developer...

  • Analytical expert

    4 days ago


    Singapore Expert Thaller Full time

    Analytical Expert - ICP, XRFLeadership role Exciting scope and challenges Dynamic and collaborative work environment. Job DetailsWe have partnered with a leading Industrial Service provider to help identify an Analytical Expert specializing in Inductively Coupled Plasma (ICP) and X-ray Fluorescence (XRF) techniques. The successful candidate will play a key...


  • Singapore Unison Consulting Pte Ltd Full time

    We are seeking an experienced Oracle PL/SQL Developer to join our team at Unison Consulting Pte Ltd.Key Responsibilities:Application Development: Develop, optimize, and maintain complex PL/SQL applications for database systems.Procedure Design: Design and implement procedures, functions, triggers, and packages using PL/SQL.Code Review and Best Practices:...


  • Singapore UPPER SPRING CONSULTING PTE. LTD. Full time

    Roles & Responsibilities We are helping our client, an established healthcare group, find an experienced IT Database Administrator (Oracle and MS SQL) to join their team.Responsibilities: Manage day-to-day support of operational tasks, requests, incidents, and changes meeting customer's requirements and SLAs Subject Matter Expert on technologies - MS SQL &...

  • Technical Expert

    4 weeks 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 weeks 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

    4 weeks 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...


  • Singapore Couchbase Full time

    OverviewCouchbase, a leader in modern cloud database platforms, is seeking a highly skilled Cloud Database Solutions Consultant to support its rapidly growing user community and drive customer success. As a Solutions Consultant, you will be the primary technical field expert responsible for actively driving and managing the technical aspects of sales...

  • Database Specialist

    1 month 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 TRINITY CONSULTING SERVICES PTE. LTD. Full time

    We are looking for a seasoned Technical Expert in Java DevelopmentAbout TRINITY CONSULTING SERVICES PTE. LTD.A leading consulting firm, TRINITY CONSULTING SERVICES PTE. LTD., seeks highly skilled professionals to join our team of innovators and technologists.Compensation Package:The estimated salary for this position is SGD $12,500 - $15,000 per month,...


  • Singapore PERCEPT SOLUTIONS PTE. LTD. Full time

    We are seeking a highly skilled SQL Database Administrator to join our team at Percept Solutions PTE. LTD. in Singapore. This is an exciting opportunity to work with cutting-edge technologies and contribute to the success of our cloud-based database solutions.As a key member of our team, you will be responsible for installing, upgrading, and migrating MS SQL...


  • Singapore China Mobile International Limited Full time

    China Mobile International Limited is a leading global telecommunications company seeking a skilled Technical Solutions Expert to join our team in Singapore.About UsWe are a subsidiary of China Mobile, one of the largest mobile operators in the world. Our company provides innovative communication solutions to businesses and individuals globally.SalaryThe...


  • 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 Specialized Asia Pacific Pte. Ltd. Full time

    Job OverviewA key member of our team, the Cycling and Technical Expert plays a crucial role in delivering exceptional customer service and technical expertise. This position is responsible for providing expert advice on bicycle maintenance and repairs, ensuring that customers receive top-notch service and support.