"The demand for data\u2011driven decision\u2011making has put Oracle\u2011centric SQL developers at the forefront of modern enterprises. Companies are modernizing legacy systems while integrating robust ETL pipelines, creating a surge in opportunities for seasoned professionals. This role in Pittsburgh offers a hybrid setting where you can leverage 8+ years of expertise to drive critical data transformations.\n\n# Job Summary\nThe SQL Developer will design, develop, and optimize Oracle PL/SQL objects, implement ETL processes, and support upgrade and transformation initiatives while collaborating with DevOps teams to embed CI/CD practices.\n\n# Top 3 Critical Skills Table\n| Skill | Why it's critical | Mastery Level |\n|-------|-------------------|---------------|\n| Oracle PL/SQL Development | Core for building, maintaining, and optimizing database logic | Senior |\n| ETL Tool Proficiency | Enables data extraction, transformation, and loading across systems | Senior |\n| CI/CD & DevOps Practices | Supports automated deployments and reliable release cycles | Mid |\n\n# Interview Preparation\n1. **Explain the differences between a stored procedure and a function in PL/SQL.** What the interviewer is looking for: understanding of return types, usage contexts, and side\u2011effects.\n2. **Describe how you would design an ETL workflow to migrate data from a legacy Oracle schema to a new structure.** What the interviewer is looking for: ability to map source\u2011to\u2011target, handle data cleansing, and ensure idempotency.\n3. **What strategies do you use to optimize long\u2011running PL/SQL cursors?** What the interviewer is looking for: knowledge of bulk operations, indexing, and query plan analysis.\n4. **How have you incorporated CI/CD pipelines into database deployments?** What the interviewer is looking for: experience with tools like Liquibase, Flyway, or Jenkins and automated testing.\n5. **Walk us through a recent upgrade or transformation project you led. What challenges arose and how did you resolve them?** What the interviewer is looking for: project management, problem\u2011solving, and impact assessment.\n\n# Resume Optimization\n- Oracle PL/SQL\n- Stored Procedures\n- Functions\n- Cursors\n- ETL Tools\n- Data Transformation\n- Upgrade Projects\n- CI/CD\n- DevOps Pipelines\n- Distributed Systems\n\n# Application Strategy\nWhen reaching out to the recruiter, send a concise email that greets the hiring manager, attaches your polished resume, and clearly maps your experience to the role. Highlight your top skills such as Oracle PL/SQL development, ETL implementation, and CI/CD automation, and reference specific projects where you applied these capabilities.\n\n# Career Roadmap\n| Current Role | Typical Experience | Core Focus | Next Position |\n|--------------|-------------------|------------|---------------|\n| SQL Developer | 5\u20118 years | Oracle PL/SQL, ETL, CI/CD | Senior SQL Developer |\n| Senior SQL Developer | 8\u201112 years | Architecture, performance tuning, mentorship | Data Architect |\n| Data Architect | 12+ years | End\u2011to\u2011end data strategy, platform selection | Data Engineering Manager |\n"