Senior Database Developer- Oracle

ADP; King of Prussia (PA); On-site; USD 110,000 - 150,000; Full time

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.

Skills

Oracle PL/SQL

SQL

Data modeling

ETL

SSIS

SQL Server

iPaaS

AI-enabled data

Performance tuning

SDLC

Agile/Waterfall

Education

Bachelor’s degree in Computer Science/IT

Tools

SSIS

SSRS

Power BI

PowerShell

Linux/Unix scripting

iPaaS platforms

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Senior Database Developer- Oracle

Professional King of Prussia, PA, US

The Senior Database Developer will be responsible for designing, developing, configuring, and maintaining enterprise database solutions, with a primary focus on Oracle technologies. This role requires deep hands-on expertise in Oracle PL/SQL, SQL, database design, performance tuning, and troubleshooting. Experience with Microsoft SQL Server, T-SQL, SSIS, or other database and integration technologies is preferred and will provide additional value. The individual will work across the full Software Development Life Cycle (SDLC), including Agile and Waterfall methodologies, and contribute to modern data initiatives such as AI-enabled solutions and iPaaS-based integrations. This position collaborates with cross-functional teams to deliver secure, scalable, reliable, and high-quality data solutions while following established database development and SDLC best practices.

Responsibilities:

• Serve as a primary Oracle database development resource, designing, developing, configuring, optimizing, and maintaining database solutions and objects, including packages, procedures, functions, triggers, views, and data structures using PL/SQL and SQL.
• Support Microsoft SQL Server database solutions using T-SQL, including stored procedures, functions, views, and performance-optimized queries. Prior SQL Server experience is beneficial; candidates must be willing to develop proficiency as needed.
• Develop, enhance, and support ETL and data integration solutions using SQL Server Integration Services (SSIS) and related technologies. Prior SSIS experience is preferred but not required.
• Design and implement database and data warehouse solutions, including relational and dimensional data models, to support operational, analytical, and reporting needs.
• Perform data analysis, validation, and reconciliation to ensure data accuracy, completeness, consistency, and integrity across systems.
• Troubleshoot and resolve complex Oracle and other database, ETL, integration, query, and performance issues across production and non-production environments.
• Participate throughout the full Software Development Life Cycle—including requirements analysis, design, development, testing, deployment, documentation, maintenance, and production support—using Agile and Waterfall delivery approaches.
• Contribute to AI-enabled data solutions and integration initiatives using iPaaS and other modern technologies for data orchestration, system connectivity, and automation, with a willingness to learn and apply emerging technologies.
• Ensure database solutions comply with organizational standards for security, privacy, regulatory compliance, performance, availability, and scalability, while following established IT policies, development standards, change-management procedures, and service-level agreements.
• Conduct code reviews and provide technical guidance, knowledge sharing, and mentoring to junior and mid-level developers.
• Communicate effectively with technical and non-technical stakeholders, translating business requirements into practical, reliable, and supportable technical solutions.
• Perform other related duties as assigned.

Requirements:

• Minimum of 6 years of hands-on experience in database development and data integration.
• Bachelor’s degree in Computer Science, Information Technology, or a related field preferred, or equivalent practical experience.
• Expert-level Oracle database development experience, including PL/SQL, SQL, DML/DDL scripting, performance tuning, and optimization.
• Experience with Microsoft SQL Server, T-SQL, SSIS, and related development tools is preferred. Candidates should be willing and able to learn these technologies as needed.
• 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 working on project teams using Agile or Waterfall methodologies.
• Strong analytical and problem-solving skills, with the ability to translate business requirements into effective technical solutions.
• Strong communication and collaboration skills across technical and business teams.
• Ability to work independently, manage multiple priorities, and maintain quality in a fast-paced environment.
• Willingness to provide technical guidance and mentoring to other 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 to support business-critical activities outside normal working hours.