Database Developer

Spruce
Kew Gardens, NY Contractor
POSTED ON 4/4/2023 CLOSED ON 1/8/2024

What are the responsibilities and job description for the Database Developer position at Spruce?

Title: Database Developer
Duration: 14 months
Location: Kew Gardens, NY 11415 (80% onsite work)

SCOPE OF SERVICES:

The Level 2 Programmer will serve as a Database Developer within QDA’s Information Technology Bureau (ITB), and will help design, implement, optimize, and support relation database management systems to support in-house created and off-the-shelf commercial applications to aid in tracking and processing cases. The Database Developer will be part of QDA’s Application Development Department of ITB that includes a staff of 12 and serves an office of over 850 staff.

The Database Developer’s responsibilities will include, but are not limited to:

  • Design redundant, highly available database clusters for several in-house and off-the-shelf enterprise applications
  • Implement and maintain zero loss database mirroring across multiple nodes in multiple clusters.
  • Develop stored procedures that conform to specific outputs and performance requirements to support.
  • Create and maintain SQL agent jobs that provide customer reporting and data maintenance.
  • Carry out monitoring, tuning, and database performance analysis.
  • Design and implement SQL queries, triggers, and new reports to support business needs.
  • Utilize ad-hoc techniques to perform on-the-fly analysis of data.
  • Design, implement and maintain ETL processes, procedures, and policies in support of business analytics and reporting.
  • Work with data analysts on refining ETL business rules.
  • Contribute to organizational and program goals, objectives, and development.
  • Perform index tuning and optimization tasks using SolarWinds DPA
  • Develop and maintain entity relationship diagrams of data stores.
  • Integrate with our current production object-oriented, Iris, databases.
  • Design disaster recovery plan, schedule and implement the plan on a regular basis.
  • Create and document various data views for use in data visualization tools, such as Power BI
  • Maintain object relationship consistency across all related data stores, enforcing foreign key constraints on dependent tables.
  • Implement role-based security access, leveraging SSO and MFA where required.

REQUIRED SKILLS/EXPERIENCE:
Experience in database administration planning, design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management including:

  • MariaDB
  • Index Tuning
  • E-R Diagramming
  • Data Normalization
  • Backup and Restore
  • Database Mirroring
  • Cache/Iris DB
  • Microsoft SQL Server (HA / Always On)
  • MongoDB
  • Comfortable with shell scripting and UNIX shell scripting.
  • Comfortable with debugging and frameworks.
  • Experience with ETL, SQL, SQL Server, PL/SQL, and MYSQL.
  • Must have excellent communication skills and experience in handling confidential information

Job Type: Contract

Salary: $65.00 - $80.00 per hour

Benefits:

  • 401(k)

Schedule:

  • Monday to Friday
  • On call

Ability to commute/relocate:

  • Kew Gardens, NY 11415: Reliably commute or planning to relocate before starting work (Required)

Work Location: One location

Salary : $65 - $80

Software Developer
Jafar and Sons -
Rosedale, NY
Job Developer
The Fedcap Group -
Jamaica, NY
Android Developer
InterSources Inc -
Jamaica, NY

For Employer
Looking for Real-time Job Posting Salary Data?
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

Sign up to receive alerts about other jobs with skills like those required for the Database Developer.

Click the checkbox next to the jobs that you are interested in.

  • Bug/Defect Analysis Skill

    • Income Estimation: $88,145 - $114,532
    • Income Estimation: $90,521 - $120,704
  • Business Analytics Skill

    • Income Estimation: $140,643 - $186,390
    • Income Estimation: $151,959 - $200,435
This job has expired.
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Spruce

Spruce
Hired Organization Address Reno, NV Other
Job Details Level : Entry Job Location : Reno Sparks Region - Reno, NV Position Type : Full-Time/Part-Time Education Lev...
Spruce
Hired Organization Address Alpharetta, GA Full Time
Skills Required - High school diploma required - 1-2 years' experience - Excellent communication and organizational skil...

Not the job you're looking for? Here are some other Database Developer jobs in the Kew Gardens, NY area that may be a better fit.

Database Administrator #23

St. John's Episcopal Hospital, Far Rockaway, NY

Android Developer

ACS Consultancy Services, Inc, Jamaica, NY