Description
Key Responsibilities
- Design, develop, and maintain complex Oracle database applications using PL/SQL.
- Develop and enhance Stored Procedures, Functions, Packages, Triggers, Collections, Dynamic SQL, Analytical Functions, and Autonomous Transactions.
- Perform advanced SQL and PL/SQL performance tuning using tools such as AWR, ADDM, ASH, SQL Trace, and Explain Plan.
- Design scalable database architectures, schema structures, indexing strategies, partitioning models, and high-availability solutions.
- Lead data modelling activities, including logical and physical data design, normalization, constraints, indexes, and governance standards.
- Design and implement ETL processes and data integration solutions for large-volume data environments.
- Manage Materialized Views, replication mechanisms, and distributed database environments.
- Execute data migration initiatives and large-scale data loading activities using SQL Loader and Oracle migration utilities.
- Develop and maintain UNIX shell scripts for automation, batch processing, and operational support.
- Support application database deployments, environment setup, release management, monitoring, backup, recovery, and production support activities.
- Provide L3 production support, perform root cause analysis, and resolve critical incidents within SLA timelines.
- Participate throughout the full Software Development Life Cycle (SDLC), from requirements gathering to post-production support.
- Work closely with business users, infrastructure teams, security, risk, compliance, legal, and finance stakeholders.
- Lead code reviews, establish development standards, and mentor junior developers.
- Produce technical documentation, solution designs, operational procedures, and governance artifacts.
- Drive database modernization initiatives and recommend innovative solutions to improve system performance, scalability, and reliability.
Mandatory Requirements
Technical Skills
- Minimum 10 years of Oracle database development experience.
- Minimum 8 years of advanced PL/SQL development experience.
- Strong experience with Oracle 10g, 11g, 12c, 19c, and preferably Oracle Autonomous Database (ADB).
- Minimum 7 years of hands-on performance tuning and optimization experience.
- Strong expertise in database architecture, schema design, partitioning, indexing, and high-volume database solutions.
- Minimum 6 years of data modelling experience (logical and physical).
- Minimum 5 years of ETL and data integration experience; Talend exposure is advantageous.
- Experience managing Materialized Views and replication strategies.
- Strong experience with SQL Loader and database migration projects.
- Proven experience performing database migrations to Oracle environments.
- Minimum 4 years of UNIX Shell Scripting experience.
- Strong Application DBA exposure, including deployment, monitoring, backup, recovery, and production support.
- Minimum 5 years of L3 production support experience in mission-critical environments.
Similar jobs
Day-to-Day Responsibilities The Software Engineer will collaborate with business users, business analysts, project managers, and other stakeholders, assuming responsibility for the successful delivery of projects, system…
About the Role We are seeking a skilled and experienced Database Administrator (DBA) to join our team. The ideal candidate will have 3 to 5 years of hands-on experience with MySQL, ProxySQL, and PostgreSQL, specializing…
About the Role We are looking for an experienced AS400 RPG Developer to support and enhance enterprise applications running on IBM i (AS400) platforms. This role involves maintaining legacy systems, developing new featur…
About the Role We are looking for a Senior Data Engineer with strong experience in modern data platforms and cloud-based architectures. The ideal candidate has deep hands-on experience with Snowflake or Databricks, has b…
Est. 124,000 USD
Position Overview: Senior Oracle Database Administrator (Sr. DBA) plays a critical role in maintaining and optimizing the databases that support our corporate and municipal clients. This position operates under the guida…
BOLD seeks a senior professional to provide support for various MS SQL databases. This person will perform database structure and software maintenance and implementations, support database tuning and consultation, and as…
Est. 124,000 USD
Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and…
Est. 120,000 USD
Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and…
About the Role We are seeking an experienced COBOL Developer to support and enhance legacy systems within a critical enterprise environment. The ideal candidate will have strong experience in mainframe technologies and b…
We are seeking a Mid-Level Java Spring Boot Developer with experience in the Banking or Financial Services domain to join our team. The ideal candidate should have hands-on experience developing scalable microservices-ba…
We are looking for an experienced OCI Cloud Engineer with at least 5 years of hands-on experience in designing, implementing, and supporting Oracle Cloud Infrastructure (OCI) environments. The ideal candidate should have…
Est. 124,000 USD
Position Overview: The Senior Oracle Cloud Database Administrator is responsible for architecting, implementing, securing, and optimizing Oracle Cloud-based database solutions utilized by our corporate and municipal cust…
Est. 95,000 EUR
At Sonatus, we’re driving the transformation to AI-enabled software-defined vehicles. Traditional automotive software methods can’t keep pace with consumer expectations shaped by the mobile industry—where features evolve…
Key Responsibilities Install, configure, administer, and support enterprise middleware platforms. Monitor system performance, troubleshoot issues, and ensure high availability. Perform middleware upgrades, patching, depl…
DB2 DBA Supporting Applictaion Important Information Location: Singapore Responsibilities: a) Reviewing and optimising SQL queries written by application developers to ensure optimal performance and adherence to database…
Key Responsibilities Design and implement real-time and batch data pipelines using Qlik Replicate Manage and administer Qlik Replicate environments (monitoring, performance tuning, upgrades) Handle data replication acros…
We are representing a leading force in the decentralized exchange (DEX). We are seeking a seasoned Data Engineer to spearhead the development of robust data architectures. In this role, you will be responsible for the en…
Job Title - Java Full Stack Developer Key Skills - Java (8/11/17+) Experience - 5+ years Location - Singapore Mandatory Skills & Experience Strong experience with Java (8/11/17+). Hands-on experience with Spring Boot…
Job Title - Full-stack Developer Key Skills - Java 8, Microservice & Docker Experience - 5+ years Location - Singapore Key Skills Required Technical Skills: Must-have: Strong hands-on experience in Java 8, Microservi…
Established in 2004, we are a tech pioneer offering world-class adult entertainment and games on some of the internet’s safest and most popular platforms. With the support of an international team of dynamic and collabor…
Job Title - Complex Project Manager – Global SAP S4HANA Key Skills - SAP S/4HANA Experience - 10+ years Location - Singapore Role Overview We are seeking an experienced Complex Project Manager to lead a large-scale Globa…
Est. 120,000 PLN
Xebia is a global AI-first, digital transformation, and engineering partner. With over 25 years of experience and a team of 5,000 professionals across 16 countries, we help organizations design and build scalable product…
Responsibilities Participate in the end-to-end design, development, and deployment of complex software solutions, leveraging deep proficiency in Java. Collaborate closely with cross-functional teams—product managers, des…
Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and…
Job Title: L2 Application Support EngineerKey Skills: Java, C, ETL, Shell script.Location: São PauloMode: In-personWe at Coforge are hiring L2 Application Support Engineer with the following skill set.Key Responsibilitie…
Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and…
Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and…
Est. 140,000 USD
Position Overview: The Senior SQL Database Administrator (DBA) is a strategic technical leader responsible for the design, optimization, security, and scalability of enterprise database platforms. This role partners clos…
Overview:We are looking for an experienced Mainframe Developer (L3) with strong COBOL-based development skills to support banking projects, particularly in cards domain. The role will involve integration work between bac…
We are looking for an experienced AS400 / COBOL Life/Asia Developer to support application development, system enhancements, implementation, and production support activities within the insurance domain. The ideal candid…