Database Developer

$104,000 - $104,000/Yr

Spectraforce Technologies - Newark, NJ

Full-time - Mid Level

Newark, NJ

Administrative and Support Services

About the position

The Database Developer role at SPECTRAFORCE involves designing and implementing efficient database structures, writing and optimizing SQL queries, and ensuring database performance and security. This position requires collaboration with IT teams and business users to meet data needs and support business projects. The role is hybrid, based in Newark, NJ, and is initially for 8 weeks with a possibility of extension.

Responsibilities

• Design and implement efficient database structures and schemas to support application functionality
• Write and optimize complex SQL queries for data retrieval, manipulation, and reporting
• Write SQL queries to extract and manipulate data
• Test databases and identify and fix issues related to performance, security, or data integrity
• Research, design, document, and modify software specifications
• Analyze the company's data needs and assist in data migration and transformation projects to support business needs
• Work across IT teams and with business users to understand the business needs and translate it to implementation
• Develop security processes
• Develop and maintain documentation for database schemas, procedures, and best practices
• Verify that all database programs adhere to the organization's performance standards
• Assess the effectiveness and performance of database systems and applications

Requirements

• 5-7 years of experience working in Oracle and DB2 Databases
• Proven work experience as a Database developer
• In-depth understanding of data management (e.g. data discovery, data analysis, transformation, data quality, security and monitoring)
• SQL Tuning techniques to prevent performance degradation and understanding on how to use Explain Plan/Query Analyzer/Optimization Tool
• Knowledge of software development and Agile delivery methodology
• Proficiency in working with specific databases like DB2, Oracle & SQL server
• Working knowledge of ETL processes and tools (i.e., Informatica for data extraction, transformation, and loading from various sources into existing databases)
• Excellent analytical and organizational skills
• Understanding the needs of front-end users and having a problem-solving mindset
• Excellent verbal and written communication skills

Benefits

• ACA compliant health benefits
• Dental insurance
• Vision insurance
• Accident insurance
• Critical illness insurance
• Voluntary life insurance
• Hospital indemnity insurance
• Commuter benefits
• 401K plan with matching
• Referral bonus program
• Paid sick leave when required by law
• Unpaid leave