Job Title : Senior SQL / Database Developer
Job ID: 2022-11813
Job Location: Whippany, NJ (onsite 3 times a week)
Job Travel Location(s):
# Positions: 1
Employment Type: W2
Candidate Constraints:
Duration: Long Term
# of Layers: 0
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 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. Projects will involve outbound data sharing with clients, hubs, data aggregator/analysis companies, and payment processors.
This role includes developing and supporting database functionality in applications where significant business logic is implemented in the underlying PostgreSQL platform. These applications include front-end customer service portals and numerous inbound and outbound data feeds. Deliverables will include tables and complex stored procedures, functions, views, and reports.
- Participate in the full project life cycle, including elaborating requirements, documenting system design, implementation, testing, deployment, and support of applications relying on an extensive Postgres platform.
- Estimate assigned work effort and be accountable for completion dates.
- Design and document coded assets for maintainability and extensibility.
- Document database structural design and data flows.
- Troubleshoot critical production issues.
- Support production releases.
- Mentor junior developers on implementation as needed.
- Follow standard software development methodologies and Agile practices in a collaborative team environment.
- Manage multiple project deliverables concurrently 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 skills (stored procedures, functions, views, triggers), performance optimization, and data modeling (OLTP / OLAP)
- 2-3 years implementing data migrations, data analytics platform hydration, or custom data pipelines
- 2-4 years PostgreSQL experience
- 1-3 years with 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
- Unix/Linux command familiarity
- Agile (Kanban / Scrum) experience
- ETL platform experience (e.g., AWS Glue, Talend)
Education:
- Bachelor’s Degree in Computer Science or equivalent experience in a software development role