13 Aug
|
Krazy Mantra It
|
Pune
13 Aug
Krazy Mantra It
Pune
Krazy Mantra Group of Companies is looking for Snowflake, DBT, SQL, Kafka to join our energetic 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 pro
📌 Snowflake, DBT, SQL, Kafka (Pune)
🏢 Krazy Mantra It
📍 Pune