Database Developer

Jsr Tech Consulting - Newark, NJ

Full-time

Newark, NJ

Professional, Scientific, and Technical Services

About the position

The Database Developer role involves designing and implementing efficient database structures to support application functionality. The position requires writing and optimizing complex SQL queries, testing databases, and collaborating with IT teams and business users to meet data needs. The developer will also be responsible for ensuring database security and performance, as well as maintaining documentation for best practices.

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.
• 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.
• Collaborate with IT teams and business users to understand business needs and translate them into implementation.
• Develop security processes for database management.
• Develop and maintain documentation for database schemas, procedures, and best practices.
• Verify that all database programs adhere to organizational standards and performance metrics.
• 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 including data discovery, data analysis, transformation, data quality, security, and monitoring.
• Experience with SQL Tuning techniques to prevent performance degradation and familiarity with Explain Plan/Query Analyzer/Optimization Tool.
• Knowledge of software development and Agile delivery methodology.
• Proficiency in working with specific databases like DB2, Oracle, and SQL Server.
• Working knowledge of ETL processes and tools, such as Informatica for data extraction, transformation, and loading.
• Excellent analytical and organizational skills.
• Understanding the needs of front-end users and having a problem-solving mindset.
• Excellent verbal and written communication skills.