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