Senior Oracle PL SQL Developer

16 hours, 27 minutes ago
Lead
Software Development
Coforge

Coforge

Coforge is a global digital services provider specializing in transforming businesses through technology and industry expertise, powering growth with innovative solutions and platforms.

IT Services
10K-50K
Founded 1992

Description

  • 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 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 SDLC, from requirements gathering to post-production support.
  • Work closely with business users and cross-functional teams across infrastructure, security, risk, compliance, legal, and finance.
  • 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 improvements to performance, scalability, and reliability.

Requirements

  • Minimum 10 years of Oracle database development experience.
  • Minimum 8 years of advanced PL/SQL development experience.
  • Strong experience with Oracle 10g, 11g, 12c, and 19c, with Oracle Autonomous Database (ADB) preferred.
  • 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, including logical and physical data design.
  • 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 experience, including deployment, monitoring, backup, recovery, and production support.
  • Minimum 5 years of L3 production support experience in mission-critical environments.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Yardi Systems Administrator (Commercial Retail CRE)

Bridge33 11-50 Real Estate

Yardi Systems Administrator for a commercial retail real estate firm, responsible for owning and optimizing the Yardi environment that supports leasing, accounting, and portfolio operations.

SQL
15 hours, 57 minutes ago

Sr. SAP IQ (formerly Sybase IQ) Database Administrator

Enterprise Horizon Consulting Group 11-50 Internet Software & Services

Enterprise Horizon Consulting Group is seeking a remote Sr. SAP IQ Database Administrator to support the design, optimization, and administration of SAP IQ database environments for government stakeholders.

Java Linux Perl Python RHEL Shell Scripting SQL
16 hours, 12 minutes ago

Senior SQL Server DBA

CodeRoad 51-250 Internet Software & Services

CodeRoad is hiring a Senior SQL Server DBA & Performance Specialist to own and optimize mission-critical Microsoft SQL Server infrastructure for an automotive client in a 100% remote Latin America role.

PowerShell SQL SQL Server
16 hours, 27 minutes ago

Database Reliability Engineer

Fuse Energy 11-50 Renewable Electricity

Fuse Energy is hiring a data-focused engineer to own and improve the reliability, performance, and modeling of its database and analytics infrastructure for a rapidly scaling renewable energy platform.

AWS CDK CI/CD ClickHouse Dagster dbt PostgreSQL Pulumi Python SQL
1 day, 16 hours ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers