Spectraforce Technologies
Database Developer
Spectraforce Technologies, Newark, New Jersey, us, 07175
Location: Newark, NJ (Hybrid)
Duration: 8 Weeks (Possibility of extension)Job Title: Database DeveloperResponsibilities: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 needs and assist in data migration and transformation projects to support business needs.Collaboration: Work across IT teams and with business users to 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 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 databases 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.
#J-18808-Ljbffr
Duration: 8 Weeks (Possibility of extension)Job Title: Database DeveloperResponsibilities: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 needs and assist in data migration and transformation projects to support business needs.Collaboration: Work across IT teams and with business users to 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 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 databases 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.
#J-18808-Ljbffr