What are the responsibilities and job description for the Database Developer position at 3M Consultancy?
Job Title: Database Developer
Location: Parsippany, NJ
Duration: Full-Time
Onsite: 2-3 days per week
NEED ONLY GC OR US CITIZENS.
Job Responsibilities:NEED ONLY GC OR US CITIZENS.
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.
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.
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.