Job Description & Details
The demand for data‑driven decision‑making has put Oracle‑centric 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.
Job Summary
The 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.
Top 3 Critical Skills Table
| Skill | Why it's critical | Mastery Level |
|---|---|---|
| Oracle PL/SQL Development | Core for building, maintaining, and optimizing database logic | Senior |
| ETL Tool Proficiency | Enables data extraction, transformation, and loading across systems | Senior |
| CI/CD & DevOps Practices | Supports automated deployments and reliable release cycles | Mid |
Interview Preparation
- 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‑effects.
- 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‑to‑target, handle data cleansing, and ensure idempotency.
- What strategies do you use to optimize long‑running PL/SQL cursors? What the interviewer is looking for: knowledge of bulk operations, indexing, and query plan analysis.
- 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.
- 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‑solving, and impact assessment.
Resume Optimization
- Oracle PL/SQL
- Stored Procedures
- Functions
- Cursors
- ETL Tools
- Data Transformation
- Upgrade Projects
- CI/CD
- DevOps Pipelines
- Distributed Systems
Application Strategy
When 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.
Career Roadmap
| Current Role | Typical Experience | Core Focus | Next Position |
|---|---|---|---|
| SQL Developer | 5‑8 years | Oracle PL/SQL, ETL, CI/CD | Senior SQL Developer |
| Senior SQL Developer | 8‑12 years | Architecture, performance tuning, mentorship | Data Architect |
| Data Architect | 12+ years | End‑to‑end data strategy, platform selection | Data Engineering Manager |