Title : Senior PL / SQL Oracle Engineer
Location : Nashville, TN 37203 - Hybrid 1-2 days a week
Benefits : Medical, vison, dental, etc.
Required Skills & Experience
- 5-7+ years of professional experience as an Oracle PL / SQL Developer / Engineer
- Expertise in PL / SQL development, including packages, procedures, functions, triggers, and views
- Strong proficiency in SQL performance tuning and execution plan analysis
- Hands-on experience with Oracle 12c / 19c or later versions
- Deep understanding of query optimization, and index strategy
- Proficiency in debugging performance issues in high-throughput environments
- Experience with database design for large-scale systems (50 TB)
- Experience with database integration in microservices and API-driven architecture
- Knowledge of JSON handling and its use in Oracle for API integrations
- Excellent communication skills and ability to work cross-functionally with architects, developers, QA, and product owners
Nice to Have Skills & Experience
Familiarity with DevOps practices and supporting .database deployments in CI / CD pipelinesFamiliarity with messaging systems (RabbitMQ, Kafka) and their interaction with databasesGood understanding of data modeling concepts, database design, and normalizationJob Description
We are seeking an experienced Oracle PL / SQL Engineer to join our development team. The successful candidate will be responsible for designing, developing, and optimizing complex PL / SQL code, including packages, procedures, functions, and triggers, to support enterprise-scale applications. This role requires strong expertise in Oracle database development, performance tuning, and integration with front-end applications and microservices. The ideal candidate will work collaboratively with architects, application developers, QA, and product owners to deliver reliable and scalable database solutions.
Key Responsibilities
Design, develop, and maintain PL / SQL packages, procedures, functions, and triggers in Oracle DatabaseWrite efficient, maintainable, and scalable SQL queries to support application functionalityPerform database performance tuning, query optimization, and troubleshooting of slow-running SQLCollaborate with application developers to integrate database logic with Java-based microservices, APIs, and front-end applicationsDevelop and maintain data models, ensuring proper database design and normalizationSupport the design and implementation of ETL processes for data integration between systemsEnsure data integrity, consistency, and security across all database operationsWork with messaging systems (e.g., RabbitMQ, Kafka) to design and manage asynchronous data processing where applicableCollaborate with solution architects to align database structures with application designPartner with QA engineers to define testing strategies for stored procedures and database logicSupport DevOps and CI / CD pipelines by automating database deployments and migrationsProvide production support by investigating and resolving database issues, including root cause analysis and preventive measuresDocument technical solutions, database structures, and best practices