SQL Database Developer

Summary

NPAworldwide is a thriving financial services company headquartered in Amherst, NY, and they are seeking a SQL Database Developer to join their Oracle Database Development team. The role involves writing queries, building stored procedures, and designing database solutions from business requirements while ensuring data integrity and performance.

Responsibilities

• Design and develop SQL-based ETL processes to extract, transform, and load data from structured and unstructured sources into Oracle databases
• Write and maintain Oracle stored procedures, functions, and triggers to support backend performance and business logic
• Partner with business stakeholders to translate business ideas and requirements into practical database solutions
• Troubleshoot and resolve data integrity and accuracy issues
• Build and maintain reports of low-to-medium complexity, ensuring data consistency across applications
• Create and maintain technical documentation including requirements, design specs, and user guides
• Participate in brainstorming sessions and development discussions your ideas matter here

Skills

• Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field
• Strong SQL skills not just writing queries, but writing stored procedures, functions, and understanding how to structure and manipulate data at the database layer
• Ability to articulate how you would take a business problem and design a database solution to solve it
• Strong foundation in relational database concepts (Oracle, SQL Server, or another enterprise relational database platform)
• Strong analytical, problem-solving, and communication skills
• High attention to detail and comfort handling confidential data
• Professional experience in a SQL-heavy environment where you can speak to real-world work beyond academic projects
• Experience with PL/SQL and code-based ETL development
• Proficiency in a scripting or programming language such as Python, Java, or similar
• Prior exposure to DBA (Database Administration) tasks or concepts

Qualifications

Must Haves

• Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field
• Strong SQL skills not just writing queries, but writing stored procedures, functions, and understanding how to structure and manipulate data at the database layer
• Ability to articulate how you would take a business problem and design a database solution to solve it
• Strong foundation in relational database concepts (Oracle, SQL Server, or another enterprise relational database platform)
• Strong analytical, problem-solving, and communication skills
• High attention to detail and comfort handling confidential data

Nice to Haves

• Professional experience in a SQL-heavy environment where you can speak to real-world work beyond academic projects
• Experience with PL/SQL and code-based ETL development
• Proficiency in a scripting or programming language such as Python, Java, or similar
• Prior exposure to DBA (Database Administration) tasks or concepts

Benefits

• Generous annual bonus
• Collaborative, supportive team culture
• Opportunity to grow within a stable, established financial services company with a long track record
• Hands-on, meaningful work you won't be a small cog in a large machine