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.

Disclaimer : This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.