Overview
Full Time
Part Time
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 9 Month(s)
Skills
Video
Database Design
Writing
Reporting
SQL
Data Integrity
Research Design
Data Migration
Collaboration
Documentation
WebKit
Data Management
Data Analysis
Data Quality
SQL Tuning
SQL Query Analyzer
Optimization
Software Development
Agile
IBM DB2
Oracle
Microsoft SQL Server
Extract
Transform
Load
Informatica
Data Extraction
Database
Analytical Skill
Organizational Skills
Problem Solving
Conflict Resolution
Communication
Job Details
Role: DB2 Database Developer
Location: Newark, NJ (Hybrid Onsite)
Duration: 12+ Months
Interview Mode: Video
Responsibilities:
- Database design: Design and implement efficient database structures and schemas to support application functionality Code writing: Write and optimize complex SQL queries for data retrieval, manipulation, and reporting Database queries: Write SQL queries to extract and manipulate data Testing and troubleshooting: Test databases and identify and fix issues related to performance, security, or data integrity Software specifications: Research, design, document, and modify software specifications Business requirements: Analyze the company's data need and assist in data migration and transformation projects to support business needs
- Collaboration: Work across IT teams and with business users understand the business needs and translate it to implementation.
- Security processes: Develop security processes Best practices: Develop and maintain documentation for database schemas, procedures, and best practices
- Standards: Verify that all database programs adhere to the organization's and performance standards.
- Database performance: Assess the effectiveness and performance of database systems and applications
Requirements and Skills:
- 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 is required.
- Knowledge of software development and Agile delivery methodology.
- Proficiency in working with specific database 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 skill.
Thanks and Regards,
GTECH LLC
Deepak Kumar | Recruitement Manager
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.