Database Developer
Summary
Designs, develops, and maintains database systems; optimizes queries, writes SQL/stored procedures, and manages ETL processes using tools like SSIS, Informatica, or Talend. Works with relational databases (Oracle, MySQL, PostgreSQL, Microsoft SQL Server) and collaborates with teams to meet data requirements.
Job Title: Database Developer
Location: Parsippany, NJ
Duration: Full-Time
Onsite: 2-3 days per week
NEED ONLY GC OR US CITIZENS.
NEED ONLY GC OR US CITIZENS.
Job Responsibilities:
Database Design and Development:
- Design, develop, and maintain database systems for applications.
- Optimize database structures and queries for performance.
- Design, develop, and maintain database systems for applications.
Query and Script Writing:
- Create and optimize SQL queries, stored procedures, and triggers.
- Address complex query performance issues.
- Create and optimize SQL queries, stored procedures, and triggers.
Data Integration and ETL:
- Develop and manage data integration processes using ETL tools.
- Ensure accurate data migration and transformation between systems.
- Develop and manage data integration processes using ETL tools.
Database Maintenance:
- Monitor database performance and implement optimizations.
- Conduct routine maintenance tasks such as backups, indexing, and troubleshooting.
- Monitor database performance and implement optimizations.
Collaboration:
- Collaborate with software developers, data analysts, and business teams to meet data requirements.
- Provide ongoing support for applications interacting with databases.
- Collaborate with software developers, data analysts, and business teams to meet data requirements.
Compliance and Security:
- Ensure database security and privacy in compliance with organizational policies and regulations.
- Maintain and manage database access controls.
- Ensure database security and privacy in compliance with organizational policies and regulations.
Documentation:
- Create and update technical documentation for databases.
- Maintain logs of system changes and updates.
- Create and update technical documentation for databases.
Required Skills:
Technical Proficiency:
- Expertise in SQL and relational databases (e.g., Oracle, MySQL, PostgreSQL, Microsoft SQL Server).
- Expertise in SQL and relational databases (e.g., Oracle, MySQL, PostgreSQL, Microsoft SQL Server).
Programming Knowledge:
- Familiarity with programming languages like Python, Java, or C# for database integration.
- Experience with ORMs (Object-Relational Mapping), such as Hibernate, is a plus.
- Familiarity with programming languages like Python, Java, or C# for database integration.
Tools and Platforms:
- Proficient with database management tools and platforms.
- Proficient with database management tools and platforms.
Problem-Solving Skills:
- Strong ability to troubleshoot performance issues efficiently.
- Analytical mindset to address complex data-related challenges.
- Strong ability to troubleshoot performance issues efficiently.
ETL and BI Tools:
- Experience with ETL tools like SSIS, Informatica, or Talend.
- Familiarity with BI tools like Tableau or Power BI is a plus.
- Experience with ETL tools like SSIS, Informatica, or Talend.
Version Control and CI/CD:
- Experience with version control systems (e.g., Git) and CI/CD pipelines for database changes.
- Experience with version control systems (e.g., Git) and CI/CD pipelines for database changes.
Qualifications:
Education:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Bachelor's degree in Computer Science, Information Technology, or a related field.
Experience:
- 4-5 years of hands-on experience in database development or administration.
- 4-5 years of hands-on experience in database development or administration.