Database Developer (DB2)

Jsr Tech Consulting - Newark, NJ

Full-time - Mid Level

Newark, NJ

Professional, Scientific, and Technical Services

About the position

The Database Developer (DB2) position at JSR Tech Consulting involves designing, implementing, and optimizing database structures and schemas to support application functionality. The role requires collaboration with IT teams and business users to analyze data needs and assist in data migration and transformation projects. The developer will also be responsible for writing complex SQL queries, testing databases, and ensuring adherence to security processes and 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.
• 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.
• Collaborate across IT teams and with business users to understand business needs and translate them to 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 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 including data discovery, data analysis, transformation, data quality, security, and monitoring.
• SQL Tuning techniques to prevent performance degradation and understanding of 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, and SQL Server.
• Working knowledge of ETL processes and tools, specifically 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.