Location: Nashville, TN
Work Arrangement: Onsite
Duration: 6 Months
Experience Required: 10+ Years
ROLE SUMMARY
We are seeking an experienced Oracle PL/SQL Developer with strong expertise in developing, optimizing, and supporting large-scale, high-volume transactional and analytical data-processing solutions.
The ideal candidate will have extensive experience with SQL/PL/SQL development, database performance tuning, ETL processing, batch processing, data integration, and production support within enterprise environments.
KEY RESPONSIBILITIES
-
Develop and maintain complex Oracle SQL and PL/SQL solutions.
-
Design scalable database solutions for high-volume transactional and analytical workloads.
-
Optimize complex SQL queries, stored procedures, packages, functions, and ETL processes.
-
Perform database performance tuning for systems processing millions of records.
-
Implement indexing, partitioning, query execution plans, and bulk-processing strategies.
-
Develop scalable batch-processing and real-time data-integration solutions.
-
Ensure data integrity, consistency, and optimal system performance.
-
Monitor Oracle database performance and troubleshoot production issues.
-
Support database optimization and performance-monitoring initiatives.
-
Implement appropriate data-archiving strategies.
-
Provide production support and resolve database-related technical issues.
-
Collaborate with application, data, and business teams to deliver reliable database solutions.
REQUIRED QUALIFICATIONS.
-
Strong hands-on experience with Oracle SQL and PL/SQL.
-
Extensive experience with stored procedures, packages, functions, and triggers.
-
Strong experience with SQL query optimization and performance tuning.
-
Experience with database indexing and partitioning.
-
Strong knowledge of query execution plans and database performance analysis.
-
Experience with bulk data processing and high-volume data environments.
-
Experience developing ETL and data-integration solutions.
-
Strong understanding of Oracle database architecture.
-
Experience with production support and database troubleshooting.
-
Strong understanding of data integrity and performance optimization.
NICE-TO-HAVE
-
Experience with Symphony GOLD.
-
Experience with Aldata.
-
Experience with retail merchandising applications.
-
Experience supporting large-scale retail or supply-chain data environments.
PRIMARY SKILLS
Oracle SQL, PL/SQL, Oracle Database, SQL Performance Tuning, PL/SQL Development, Database Optimization
SECONDARY SKILLS
Stored Procedures, Packages, Functions, Indexing, Partitioning, Query Execution Plans, ETL, Batch Processing, Real-Time Data Integration, Data Archiving, Production Support, Database Monitoring, Symphony GOLD, Aldata
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, and gender identity), national origin, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.
We are committed to providing reasonable accommodations to qualified applicants with disabilities and for sincerely held religious beliefs, as required by applicable law. Applicants who require a reasonable accommodation during the hiring process may request assistance.
Employment may be contingent upon the successful completion of job-related pre-employment screening, which may include background and reference checks and, where permitted by applicable law and applicable to the position, drug testing. All such screening will be conducted in accordance with applicable federal, state, and local laws.
Never miss an opportunity! Create an alert based on the job you applied for.
