Database Developer

Pentalpha Surveillance is hiring a Database Developer for a full-time, hybrid role based in Buffalo, New York. The position focuses on ETL data loading and validation, the development and maintenance of database functionality for in-house applications, and the production of low to medium complexity reports.

Responsibilities

• Design, implement, and maintain ETL processes to load data from structured and unstructured sources into relational databases.
• Develop and manage database functions, procedures, and triggers.
• Create and maintain technical documentation, including requirements, design specifications, and user manuals.
• Identify, troubleshoot, and resolve data-related issues to ensure data accuracy, consistency, and reliability.
• Collaborate with business stakeholders to build, enhance, and support database functionality while ensuring alignment with business requirements.

Requirements

• Strong experience with SQL, PL/SQL, or T-SQL and solid understanding of relational database concepts.
• Excellent analytical and problem-solving abilities.
• Strong written, verbal, and interpersonal communication skills.
• High attention to detail and a commitment to data quality.
• Ability to professionally manage confidential and sensitive information.

Technologies

• Oracle Database
• SQL
• PL/SQL
• T-SQL
• Python
• Git

Benefits

• 401(k)
• 401(k) matching
• Flexible spending account
• Health insurance
• Health savings account
• Paid time off
• Parental leave
• Professional development assistance

Application Question(s)

• Will you now or in the future require sponsorship for employment visa status (e.g., H-1B visa status)?

Education

• Bachelor's (Preferred)

Experience

• Professional SQL Development: 1 year (Preferred)
• Code based ETL: 1 year (Preferred)
• Python for Automation: 1 year (Preferred)

Location

Buffalo, NY 14228 (Preferred)

Work Location

Hybrid remote in Buffalo, NY 14228

Salary

$70,000.00 - $100,000.00 per year