What are the responsibilities and job description for the Database Developer position at 1 Point System?
Job Details
Role: Database Developer
Location: Newark, NJ Hybrid
Duration: 12 months
Note: 10 years.
Job Description
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 skills.
