Database Developer

K-Tek Resourcing - Newark, NJ

Full-time

Newark, NJ

Professional, Scientific, and Technical Services

About the position

The Database Developer role focuses on designing, implementing, and optimizing database structures and schemas to support application functionality. The position requires writing complex SQL queries, testing and troubleshooting databases, and collaborating with IT teams and business users to meet data needs. The developer will also be responsible for ensuring database security, adhering to best practices, and assessing database performance.

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.
• Work across IT teams and with 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 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.
• Proficiency in SQL Tuning techniques to prevent performance degradation and understanding of 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.

Nice-to-haves

• Excellent analytical and organizational skills.
• Understanding the needs of front-end users and having a problem-solving mindset.
• Excellent verbal and written communication skills.