Senior Database Developer

Compunnel, Inc.; Smithfield (RI); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading IT solutions provider based in the USA is seeking an experienced Senior Database Developer to design and optimize database applications. The ideal candidate will have expert-level proficiency in Oracle PL/SQL and a strong background in database development. This role involves working in an Agile environment and developing high-performance database solutions. Key responsibilities include writing complex queries, developing ETL workflows, and collaborating with cross-functional teams to ensure effective database solutions.

Qualifications

• Expert-level proficiency in Oracle PL/SQL required.
• Background in database development including packaging and optimization.
• Hands-on experience with version control and deployment processes.

Responsibilities

• Perform database development, primarily in Oracle PL/SQL.
• Write complex queries, PL/SQL functions, procedures, triggers, and packages.
• Develop ETL workflows, especially using Informatica.

Skills

Oracle PL/SQL

Performance tuning

Data engineering

Agile methodology

SQL Server

Education

Bachelor's degree in Computer Science

Tools

Informatica

Control-M

Job description

The Senior Database Developer will design, develop, and optimize database applications and frameworks using Oracle, SQL Server, Informatica, and Control-M.

The role requires strong Oracle PL/SQL expertise, advanced performance-tuning skills, and the ability to translate business requirements into technical design specifications.

The developer will work in an Agile environment, contributing to high-performance database solutions while providing technical leadership and operating with minimal supervision.

Key Responsibilities

• Perform database development, primarily in Oracle PL/SQL
• Write complex queries, PL/SQL functions, procedures, triggers, and packages
• Diagnose data issues and analyze performance metrics
• Develop ETL workflows, with strong preference for Informatica experience
• Contribute to the design and development of robust, high-performance database solutions
• Translate business requirements into clear technical design specifications
• Optimize sophisticated queries to ensure efficiency and reliability
• Participate in Agile development processes and ceremonies
• Define technical vision for features and components, ensuring alignment with overall architecture
• Assess existing platform implementations and recommend improvements
• Collaborate with cross-functional teams to support database and application initiatives

Required Qualifications

• Expert-level proficiency in Oracle PL/SQL
• Experience with SQL Server
• Background in database development including packaging, optimization, and performance tuning
• Experience with data engineering, data modeling, and data analysis
• Hands‑on experience with version control and deployment processes in enterprise environments
• Strong communication and stakeholder‑management skills
• Ability to work independently, multi‑task, and deliver high‑quality solutions in dynamic environments
• Experience working with Agile methodology
• Ability to create BRDs, technical specifications, and process documentation
• Familiarity with containerization and cloud deployment concepts

Preferred Qualifications

• Enterprise Data Lake experience
• Financial domain knowledge
• Cloud exposure (any major cloud provider)
• Experience working with geographically distributed teams
• Strong presentation and interpersonal skills
• Curiosity for continuous learning and exploring new technologies
• Bachelor’s degree in Computer Science (preferred)
• Coursework or knowledge in finance, business, math, or accounting