Database Developernbsp

Database Developer

Location: Kew Gardens NY% onsite

Duration: Long Term Contract

Tax Terms: C2C

Job Description

SCOPE OF SERVICES:

The Level 2 Programmer will serve as a Database Developer within QDAs Information
Technology Bureau (ITB) and will help design implement optimize and support relation database management systems to support inhouse created and offtheshelf commercial applications to aid in tracking and processing cases.
The Database Developer will be part of QDAs Application Development Department of ITB that includes a staff of 12 and serves an office of over 850 staff.
The Database Developers responsibilities will include:
Design redundant highly available database clusters for several inhouse and offtheshelf 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 adhoc techniques to perform onthefly 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 Solar Winds DPA
Develop and maintain entity relationship diagrams of data stores.
Integrate with our current production objectoriented 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 rolebased 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:
Maria DB
Index Tuning
ER Diagramming
Data Normalization
Backup and Restore
Database Mirroring
Cache/Iris DB
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.