Senior Oracle DB Developer & Data Solutions Leader

ADP

King of Prussia (PA)

On-site

USD 110,000 - 150,000

Full time

5 days ago

Be an early applicant

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Job summary

ADP in King of Prussia, PA, seeks a Senior Database Developer to design, develop, and maintain enterprise Oracle-based databases. You will specialize in PL/SQL, SQL, data modeling, and performance tuning, with exposure to SQL Server and SSIS.

The role spans the full SDLC, collaborating with cross-functional teams and supporting AI-enabled data initiatives and iPaaS integrations. The ideal candidate has 6+ years of database development experience, a BS in CS/IT, strong analytical abilities, and a

Qualifications

6+ years of hands-on experience in database development and data integration.
Expert-level Oracle database development experience with PL/SQL, SQL, DML/DDL scripting, performance tuning, and optimization.
Experience with Microsoft SQL Server, T-SQL, SSIS, and related development tools is preferred; willing to learn.
Experience with ETL, data integration, data pipelines, and database or data warehouse design.
Knowledge of relational and dimensional data modeling, including star and snowflake schemas.
Understanding of SDLC best practices, including coding standards, documentation, version control, testing, and deployment.
Experience with Agile or Waterfall methodologies.
Strong analytical and problem-solving skills; ability to translate business requirements into technical solutions.
Strong communication and collaboration skills across technical and business teams.
Willingness to mentor junior team members.
Experience with AI-enabled data solutions, iPaaS platforms, SSRS, Power BI, PowerShell, Linux/Unix scripting, or job-scheduling tools is a plus.
Occasional schedule flexibility may be required.

Responsibilities

Serve as a primary Oracle database development resource, designing, developing, configuring, optimizing, and maintaining database solutions using PL/SQL and SQL.
Support Microsoft SQL Server database solutions using T-SQL, including stored procedures, functions, views, and performance-optimized queries.
Develop, enhance, and support ETL and data integration solutions using SSIS and related technologies.
Design and implement database and data warehouse solutions to support operational, analytical, and reporting needs.
Perform data analysis, validation, and reconciliation to ensure data accuracy across systems.
Troubleshoot and resolve complex Oracle and other database, ETL, integration, query, and performance issues.
Participate in the full SDLC—requirements, design, development, testing, deployment, maintenance, and production support.
Contribute to AI-enabled data solutions and iPaaS integrations; learn and apply emerging technologies.
Ensure database solutions comply with security, privacy, regulatory, performance, and availability standards.
Conduct code reviews and provide mentoring to junior/mid-level developers.
Communicate effectively with stakeholders to translate business requirements into practical solutions.
Perform other related duties as assigned.