Oracle Database Engineer
Core
Senior Oracle Database Engineer developing, troubleshooting, and supporting enterprise-scale Oracle database applications, focusing on SQL/PL/SQL development, production debugging, and data feed maintenance.
Role type
Senior hands-on IC Oracle Database Engineer
Builds
Enterprise-scale Oracle database applications, data feeds, and integration endpoints
Domain
Enterprise IT / Oracle Database
Required skills
Oracle SQL, PL/SQL, Oracle Exadata, Apache NiFi, AWS services, SQL performance tuning, database security, RAC, RMAN backup and recovery, Data Guard, AWR, ASH, ADDM, SQL Trace, TKPROF, Oracle Enterprise Manager Cloud Control
Preferred skills
Oracle Database Vault, Label Security, large-scale data migration, Oracle 10g through current versions
Technologies
Oracle Database, Apache NiFi, AWS, SQL, PL/SQL
Responsibilities
Debug and resolve complex SQL, PL/SQL, data, and production-processing issues; Review, rewrite, refactor, and optimize existing SQL and PL/SQL scripts; Develop ad hoc queries and scripts to support investigations, reporting, reconciliation, data correction, and operational requests; Maintain and enhance PL/SQL packages, procedures, functions, triggers, batch jobs, and database interfaces; Monitor, troubleshoot, and maintain data feeds involving Oracle, Apache NiFi, AWS endpoints, APIs, files, and connected applications; Investigate failed or incomplete data flows and coordinate resolution across database, integration, application, and infrastructure teams; Perform data validation and root-cause analysis to identify discrepancies between source and target systems; Support application releases, database deployments, production incidents, and post-deployment validation; Tune SQL and PL/SQL workloads to improve performance, scalability, and reliability; Partner with Oracle DBAs on database configuration, RAC, recovery, Data Guard, security, performance, and environment-related issues; Create and maintain technical documentation, support procedures, deployment instructions, troubleshooting guides, and operational runbooks.
Seniority
Senior, hands-on IC