Job Title: Database Developer
Location: Parsippany NJ
Duration: FullTime
Onsite: 23 days per week
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.
Query and Script Writing:
- Create and optimize SQL queries stored procedures and triggers.
- Address complex query performance issues.
Data Integration and ETL:
- Develop and manage data integration processes using ETL tools.
- Ensure accurate data migration and transformation between systems.
Database Maintenance:
- Monitor database performance and implement optimizations.
- Conduct routine maintenance tasks such as backups indexing and troubleshooting.
Collaboration:
- Collaborate with software developers data analysts and business teams to meet data requirements.
- Provide ongoing support for applications interacting with databases.
Compliance and Security:
- Ensure database security and privacy in compliance with organizational policies and regulations.
- Maintain and manage database access controls.
Documentation:
- Create and update technical documentation for databases.
- Maintain logs of system changes and updates.
Required Skills:
Technical Proficiency:
- 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 (ObjectRelational Mapping) such as Hibernate is a plus.
Tools and Platforms:
- Proficient with database management tools and platforms.
ProblemSolving Skills:
- Strong ability to troubleshoot performance issues efficiently.
- Analytical mindset to address complex datarelated challenges.
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.
Version Control and CI/CD:
- Experience with version control systems (e.g. Git) and CI/CD pipelines for database changes.
Qualifications:
Education:
- Bachelors degree in Computer Science Information Technology or a related field.
Experience:
- 45 years of handson experience in database development or administration.
Oracle, MySQL, PostgreSQL, Microsoft SQL Server