DB/PostgreSQL Developer

Job Title: DB/PostgreSQL Developer

Job ID: 2022-11795

Job Location: Whippany, NJ (2-3 days a week Tues-Thursday, remote to start)

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: Database, PostgreSQL

Job Responsibilities:

• Analysis, design, coding, performance tuning, migration of data and implementation of database solutions using PostgreSQL
• Evaluation, maintenance, and enhancement of existing processes, stored procedures, and functions, load and performance tuning of existing procedures
• Data analysis, produce ad hoc queries and develop reports to support business needs
• Create documentation for applications and processes
• Daily triage of bugs and tasks

Skills and Experience Required:

Required Skills:

• 4-5+ years working as a database developer working with MySQL/SQL Server/PostgreSQL
• 1+ years working experience of PostgreSQL is a must
• Expertise in stored procedures, functions, triggers, and views.
• Ability to create normalized/de-normalized database schemas
• Excellent verbal, written, and interpersonal communication skills
• Knowledge of DevOps and creating/promoting code through CI/CD pipeline
• Experience in AWS development like Lambda functions, Python, and Glue job

Desired Skills:

• Experienced in the full System Development Life Cycle (Dev, Test, Prod)
• Should be experienced in executing migration projects.
• Experienced in Cloud based Database – Dynamo DB
• Writing and executing Unix shell scripts