Snowflake, DBT, SQL, Kafka

Krazy Mantra Group of Companies is looking for Snowflake, DBT, SQL, Kafka to join our dynamic team and embark on a rewarding career journey

A SQL Developer, also known as a Database Developer, is responsible for designing, implementing, and managing database systems and writing SQL queries to retrieve and manipulate data.

The job description (JD) of a SQL Developer typically includes the following responsibilities and qualifications:Job Database Design and Modeling: Create and maintain database schema designs, including tables, indexes, and relationships, using tools like ER diagrams.

SQL Query Development: Write complex SQL queries, stored procedures, and triggers to extract, manipulate, and manage data efficiently.

Database Optimization: Identify and resolve performance bottlenecks by optimizing SQL queries, indexing, and database configurations.

Data Integration: Develop ETL (Extract, Transform, Load) processes to move data between different systems and databases.

Data Security: Implement and maintain database security measures, including user access control, encryption, and data masking as necessary.

Backup and Recovery: Establish and manage database backup and recovery procedures to ensure data integrity and availability.

Performance Monitoring: Monitor database performance using tools like performance counters and query execution plans, and make necessary adjustments.

Data Validation and Testing: Verify data accuracy through validation checks and perform unit testing and integration testing of SQL scripts.

Documentation: Maintain comprehensive documentation of database schemas, processes, and code changes.

Collaboration: Collaborate with other teams, such as software developers and data analysts, to understand their data needs and provide necessary support.

Version Control: Use version control systems to manage database code changes and collaborate effectively with team members.

Troubleshooting: Diagnose and resolve database-related issues and provide technical support when needed.