Description :

Title - SQL Developer

Exp - 5 - 10 years

Location - Delhi

Job Description

Key Responsibilities:

Database Development:

• Design, implement, and maintain database structures and schemas.
• Develop stored procedures, triggers, and functions to support application requirements.

Data Modeling:

• Design and implement data models to support business requirements.
• Ensure database normalization and optimization for efficient data retrieval.

Query Optimization:

• Write and optimize complex SQL queries for performance and scalability.
• Identify and resolve performance bottlenecks in database systems.

Data Integration:

• Integrate data from various sources into the database.
• Collaborate with application developers to ensure seamless data flow between systems.

Database Security:

• Implement and maintain database security measures to protect sensitive data.
• Regularly audit and update access controls to ensure data integrity.

Backup and Recovery:

• Develop and implement backup and recovery strategies.
• Test and document disaster recovery procedures.

Performance Monitoring:

• Monitor database performance and proactively address issues.
• Provide recommendations for improving database efficiency.

Documentation:

• Create and maintain documentation for database architecture, procedures, and best practices.

Collaboration:

• Collaborate with cross-functional teams, including software developers and system administrators.
• Participate in project planning and provide database-related insights.

Requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as an SQL Developer or in a similar role.
• Proficient in SQL programming and database design principles.
• Strong knowledge of relational database management systems (RDBMS) such as MySQL, PostgreSQL, or Microsoft SQL Server.
• Experience with database performance tuning and optimization.
• Familiarity with data modeling tools and techniques.
• Excellent problem-solving and analytical skills.
• Strong attention to detail and commitment to data integrity.
• Effective communication and collaboration skills.

Preferred Qualifications:

• Certification in database administration or related field.
• Experience with NoSQL databases (e.g., MongoDB, Cassandra).
• Knowledge of ETL (Extract, Transform, Load) processes.
• Familiarity with version control systems (e.g., Git).