Sr. Database Developer

MetaForgeIT; Maharashtra; On-site; INR 800,000 - 1,200,000; Full time

Job summary

MetaForgeIT is looking for a skilled Database Developer in Maharashtra, India. The role involves designing databases, optimizing performance, and collaborating with software developers and data analysts.

Ideal candidates will have over 5 years of experience, strong SQL skills, and familiarity with DBMS like SQL Server and Oracle. The position offers a dynamic environment and opportunities for professional growth.

Qualifications

• 5+ years of experience with database design, performance tuning, optimization, data warehousing and ETL processes.
• Proficiency in SQL and various DBMS.
• Familiarity with programming languages like Python or C# is a plus.

Responsibilities

• Design and develop database schemas, tables, views, and indexes.
• Write and optimize complex SQL queries and stored procedures.
• Monitor database performance and implement tuning strategies.
• Develop ETL processes for data integration.

Skills

Database design

SQL proficiency

Data warehousing

ETL processes

Performance tuning

Tools

SQL Server

Oracle

MySQL

PostgreSQL

Python

C#

Job description

Job Description

Database Design and Development:

• Design and develop database schemas, tables, views, and indexes based on application requirements.
• Write and optimize complex SQL queries and stored procedures.
• Implement data normalization and denormalization strategies to improve database performance.

Database Maintenance and Optimization:

• Monitor database performance and implement tuning strategies to ensure optimal efficiency.
• Regularly backup and restore databases, ensuring data integrity and availability.
• Manage database security, including user access control and data encryption.

Collaboration and Support:

• Work closely with software developers, data analysts, and system administrators to support application development and data integration.
• Provide technical support and troubleshooting for database related issues.
• Document database design, procedures, and standards.

Data Integration and Migration:

• Develop ETL (Extract, Transform, Load) processes to integrate data from various sources.
• Plan and execute data migration strategies for system upgrades or changes.

Reporting and Analysis:

• Create and maintain reports and dashboards to support business analysis and decision-making.
• Analyze and interpret complex data sets to provide actionable insights.

Experience & Skills Necessary for Position:

• 5+ years of experience with database design, performance tuning, optimization, data warehousing and ETL processes.
• Proficiency in SQL and database management systems (e.g., SQL Server, Oracle, MySQL, PostgreSQL).
• Proficiency with programming languages such as Python, or C# is a plus.