Job Title : Senior SQL / Database Developer
Job ID: 2022-11813
Job Location: Whippany, NJ (onsite 3 times a week)
Employment Type: W2
Duration: Long Term
Work Eligibility: All Work Authorizations are Permitted – No Visa Transfers
Key Technology: SQL, data modeling, PostgreSQL, AWS RDS, DynamoDB
Job Responsibilities:
As a DB/SQL Engineer, you will work closely with full stack developers, business analysts, and QA analysts on features and watch them go from conception to deployment in weeks. You will be responsible for implementing database enhancements required to deliver committed customer project objectives, data migrations, and new program launches while ensuring data accuracy and integrity. This role involves outbound data sharing with clients, hubs, data aggregator/analysis companies, and payment processors.
Your responsibilities include developing and supporting database functionality in applications where a significant portion of the business logic is implemented in the underlying PostgreSQL platform. These applications include front-end customer service portals as well as numerous inbound and outbound data feeds. Deliverables will include tables, complex stored procedures, functions, views, and reports.
- Participate and contribute to the full project life cycle, including requirements elaboration, system design documentation, implementation, testing, deployment, and support of applications relying on an extensive Postgres platform with numerous data feeds.
- Estimate assigned work effort and be accountable for completion dates.
- Design and document coded assets for better maintainability and extensibility.
- Document database structural design and data flows.
- Troubleshoot critical production issues.
- Support production releases.
- Help and mentor junior developers on implementation as needed.
- Follow standard software development methodologies and Agile practices in a collaborative team environment to produce high-quality applications efficiently.
- Manage multiple project deliverables concurrently, communicate effectively with stakeholders, and maintain positive working relationships with teammates and customers.
Skills and Experience Required:
Critical Skills:
- 4-7 years as a database developer with strong SQL (stored procedures, functions, views, triggers), performance optimization, data modeling (OLTP / OLAP)
- 2-3 years implementing data migrations, data analytics platform hydration, or custom data pipelines
- 2-4 years PostgreSQL
- 1-3 years AWS RDS, DynamoDB, S3
- 2-3 years with GIT – source control, pull request, and release management
Desirable Skills:
- Python, JavaScript, or shell scripting
- AWS EC2, Glue, EventBridge, Lambda, Step Functions, CloudWatch
- Navigating Unix/Linux commands
- Agile (Kanban / Scrum) Experience
- ETL platform experience a small plus, e.g., AWS Glue, Talend
Education:
- Bachelor’s Degree in Computer Science or additional work experience in a software development role