Job Description

Role & responsibilities Database Design and Development: Design and implement robust and scalable database schemas. Develop and maintain database objects (tables, views, stored procedures, functions, triggers). Ensure data integrity and consistency. SQL Query Optimization: Write and optimize complex SQL queries for performance. Identify and resolve performance bottlenecks. Conduct query performance tuning and analysis. Database Maintenance and Administration: Perform database backups and recovery. Monitor database performance and troubleshoot issues. Implement database security measures. Data Analysis and Reporting: Extract and analyze data to support business requirements. Generate reports and dashboards. Work with Data warehousing concepts. Collaboration: Collaborate with developers, testers, and project managers to ensure seamless integration of database solutions. Participate in code reviews and provide constructive feedback. Understand and implement data migration strategies Preferred candidate profile Bachelor's degree in Computer Science, Information Technology, or a related field. 3+ years of professional experience as a SQL Developer. Strong proficiency in SQL (preferably SQL Server, MySQL, PostgreSQL, or Oracle). Extensive experience in database design, development, and optimization. Solid understanding of relational database concepts and principles. Experience with query performance tuning and optimization techniques. Knowledge of database administration and maintenance. Familiarity with data warehousing processes is a plus. Excellent problem-solving and analytical skills. Strong communication and collaboration skills. Experience with version control systems (e.g., Git). Understanding of normalization and denormalization