- 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.
- 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.
Skills Required
- Minimum 10 years of Oracle database development experience
- Minimum 8 years of advanced PL/SQL development experience
- Experience with Oracle 10g, 11g, 12c, 19c
- Experience with Oracle Autonomous Database (ADB)
- Minimum 7 years of hands-on performance tuning and optimization experience (AWR, ADDM, ASH, SQL Trace, Explain Plan)
- 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
- 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
- Application DBA experience including deployment, monitoring, backup, recovery, and production support
- Minimum 5 years of L3 production support experience in mission-critical environments
Encora Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Encora and has not been reviewed or approved by Encora.
-
Healthcare Strength — Health coverage is described as employer-provided in multiple locations, with private plans and family coverage highlighted in Spain and Mexico. Medical insurance quality is presented as a recurring bright spot alongside standard coverage.
-
Leave & Time Off Breadth — Time off includes paid holidays and PTO, with regional materials indicating additional leave provisions in certain countries. Leave is generally portrayed as conventional to generous depending on location.
-
Flexible Benefits — Work-from-home flexibility is frequently highlighted as a plus, though it varies by role and client needs. Remote and hybrid options are positioned as part of the overall package.
Encora Insights
What We Do
Headquartered in Santa Clara, California, and backed by renowned private equity firms Advent International and Warburg Pincus, Encora is the preferred technology modernization and innovation partner to some of the world’s leading enterprise companies. It provides award-winning digital engineering services including Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering. Encora's deep cluster vertical capabilities extend across diverse industries, including HiTech, Healthcare & Life Sciences, Retail & CPG, Energy & Utilities, Banking Financial Services & Insurance, Travel, Hospitality & Logistics, Telecom & Media, Automotive, and other specialized industries. With over 9,000 associates in 47+ offices and delivery centers across the U.S., Canada, Latin America, Europe, India, and Southeast Asia, Encora delivers nearshore agility to clients anywhere in the world, coupled with expertise at scale in India. Encora’s Cloud-first, Data-first, AI-first approach enables clients to create differentiated enterprise value through technology
