Oracle PLSQL Technical Lead
Oracle PLSQL Technical Lead
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Title: Oracle PL/SQL Technical Lead
Location: Olathe KS
Duration: Contract
JD:
Database Engineer with expertise in SQL PL/SQL Java and Stored Procedures (SPs) to design develop and optimize database solutions. The ideal candidate will be responsible for performance tuning process automation and collaborating with development teams to enhance system efficiency.
Key Responsibilities:
- Design develop and optimize complex SQL queries stored procedures (SP) functions and triggers.
- Develop and maintain PL/SQL scripts packages and functions for database automation and process improvements.
- Implement and optimize database indexing query performance tuning and partitioning strategies.
- Collaborate with Java developers to integrate databases with Java-based applications.
- Design and maintain ETL processes for data migration transformation and integration.
- Troubleshoot database issues deadlocks slow queries and performance bottlenecks.
- Manage database security backups and recovery strategies.
- Ensure compliance with data governance and security policies.
- Maintain documentation for database architectures configurations and best practices.
Required Skills & Qualifications:
- 8 years of experience in SQL and PL/SQL development.
- Strong expertise in Stored Procedures (SPs) development.
- Hands-on experience in Java programming for database integration and application development.
- Proficiency in Oracle PostgreSQL MySQL or MS SQL Server databases.
- Experience in query optimization performance tuning and indexing.
- Knowledge of database design normalization and data modeling.
- Familiarity with ETL tools scripting and batch processing.
- Experience with Unix/Linux shell scripting.
- Strong analytical and problem-solving skills.
- Ability to work independently and collaboratively in a fast-paced environment.
Employment Type
Full-time
