Description :
Job Title: SQL Developer
Experience : 3-10 Years
Location - New Delhi
Job Overview: As a SQL Developer, you will be responsible for designing, implementing, and maintaining databases. You will work closely with software developers, data analysts, and other IT professionals to ensure effective and efficient database management. The role requires expertise in SQL (Structured Query Language) and a deep understanding of database architecture and design principles.
Responsibilities:
Database Design and Modeling:
- Develop and design database architectures based on business requirements.
- Create entity-relationship diagrams, data flow diagrams, and other documentation to illustrate database design.
SQL Coding and Optimization:
- Write and optimize SQL queries for performance and efficiency.
- Troubleshoot and resolve database performance issues.
- Implement best practices for database development and optimization.
Database Implementation and Maintenance:
- Install and configure database systems.
- Ensure data security, integrity, and availability.
- Perform regular database maintenance tasks, such as backups, restores, and updates.
Collaboration:
- Collaborate with software developers to integrate databases into applications.
- Work with data analysts to understand and implement data requirements.
Data Migration and Transformation:
- Design and execute data migration and transformation processes.
- Ensure smooth data transition between different systems and versions.
Documentation:
- Create and maintain documentation for databases, including schemas, procedures, and user guides.
- Document changes and updates to the database structure.
Security:
- Implement and maintain database security measures to protect sensitive data.
- Monitor and audit database access and usage.
Requirements:
Education:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
Experience:
- Proven experience as a SQL Developer or in a similar role.
- Familiarity with database design, implementation, and optimization.
Skills:
- Proficient in SQL and database management systems (e.g., MySQL, PostgreSQL, SQL Server).
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration abilities.
- Knowledge of data warehousing concepts is a plus.