About PROCYON Technostructure
Sourced by ZipRecruiter
Industry
It services
Company size
11 - 50 Employees
Headquarters location
San Rafael, CA, US
Year founded
2004
$48.75 - $61.50/hr
Other
Posted 2 days ago
New
Job description
ONLY LOCAL TO GEORGIAJob Title: Senior Oracle SQL DeveloperJob Summary
We are seeking an experienced Oracle SQL Developer to support the development, maintenance, and optimization of complex SQL and PL/SQL solutions within a large Oracle transactional database environment. This role focuses primarily on writing SQL from scratch against normalized Oracle databases to extract, validate, transform, and analyze operational data.
The ideal candidate should be able to analyze business requirements, identify appropriate database tables and relationships, and develop efficient SQL solutions to support operational reporting and business analysis.
Key Responsibilities- Develop, maintain, and optimize complex Oracle SQL and PL/SQL programs.
- Write simple to advanced SQL queries from scratch against normalized Oracle transactional databases.
- Analyze business requirements and determine the appropriate tables, relationships, joins, and business rules to meet reporting and analytical needs.
- Extract, validate, transform, and analyze operational data for reporting and business initiatives.
- Develop and maintain automated SQL processes, scheduled database jobs, and recurring data refreshes.
- Troubleshoot SQL scripts, automated jobs, and data quality issues.
- Create efficient, reusable, well-documented SQL code following best practices.
- Support operational reporting, KPI reporting, and ad hoc data requests.
- Collaborate with business stakeholders to understand reporting requirements and communicate analytical findings.
- Provide support for Tableau dashboards and other data visualization initiatives as needed.
- 5+ years of Oracle SQL development experience.
- 5+ years of experience writing complex SQL queries, including joins, CTEs, subqueries, CASE statements, aggregate functions, and analytic/window functions.
- 5+ years of experience working with normalized relational database structures and table relationships.
- 3+ years of experience translating business requirements into SQL solutions.
- 3+ years of experience developing SQL job scheduling and automated database processes.
- 3+ years of experience in operational reporting and data analysis.
- 3+ years of Oracle PL/SQL development, including procedures, functions, packages, and views.
- Experience with SQL performance tuning, query optimization, and data validation.
- Experience supporting Tableau or other data visualization tools.
- Experience working with large, high-volume transactional database environments.
procyonts.com
Most Popular Oracle PL SQL Developer Job Categories
Oracle Pl Sql Developers
Senior Oracle Pl Sql Developer
Pl Sql Developer
Oracle Pl Sql Etl Developer
Oracle Sql Developer
Java Pl Sql Developer
Senior Pl Sql Developer
Lead Pl Sql Developer
Oracle Developer
Oracle Database Developer
Other Helpful Pages Related To Oracle PL/SQL Developer/Oracle SQL Developer
Remote Oracle Developer Salaries
Remote Oracle Developer Career Research
Frequently asked questions
Q: What skills or qualities help someone succeed as a Oracle PL SQL Developer?
A: To succeed as an Oracle PL/SQL Developer, key technical skills include proficiency in Oracle database management systems, expertise in PL/SQL programming language, and knowledge of database design principles. Soft skills such as strong analytical and problem-solving abilities, effective communication, and collaboration with cross-functional teams are also crucial for success in this role. By combining these technical and soft skills, Oracle PL/SQL Developers can design, develop, and implement efficient database solutions, drive business growth, and advance their careers in the field of database development.
Q: What is the career path for a Oracle PL SQL Developer?
A: A typical career progression for an Oracle PL SQL Developer involves starting as a Junior Developer, where they design, develop, and test database applications using PL SQL, and gradually moving to mid-level roles such as Senior Developer or Database Analyst, where they lead projects, optimize database performance, and implement data security measures. As they gain experience, they can transition to senior roles like Technical Lead or Database Architect, where they oversee large-scale database projects, design complex database systems, and mentor junior developers. With advanced skills and experience, Oracle PL SQL Developers can also pursue leadership positions, such as IT Manager or Director of Database Services, or transition into related fields like data science, business intelligence, or IT consulting.
