D-TechWorks - SQL Developer - Database Performance Tuning

Mandatory Skills: SQL writing/programming skills, Data Warehouse, ETL,RDBMS.Responsibilities :1. In-depth Knowledge of Relational Databases and Associated Concepts :

• Comprehensive understanding of relational database management systems (RDBMS) such as MySQL, PostgreSQL, SQL Server, and Oracle.
• Strong grasp of database normalization, indexing, constraints, ACID properties, transactions, and concurrency control.
• Knowledge of different storage engines, locking mechanisms, and how databases handle data consistency and integrity.

Proficiency in Working with a Wide Variety of Databases :

• Hands-on experience with multiple database management systems, including both SQL-based (e.g., MySQL, PostgreSQL, Oracle, SQL Server) and NoSQL-based databases (e.g., MongoDB, Cassandra, Redis, etc.).
• Ability to migrate and integrate data across different databases efficiently.
• Understanding of database scalability, replication, sharding, and high-availability configurations.3.

Strong SQL Programming & Performance Optimization/Tuning Skills :

• Expert-level SQL skills, including writing complex queries, stored procedures, triggers, functions, and views.
• Proficiency in query optimization techniques to improve performance, including indexing strategies, execution plans, and partitioning.
• Experience in handling large datasets and optimizing queries to ensure efficient performance.
• Knowledge of profiling and debugging SQL queries to reduce bottlenecks.4.

Knowledge About Data Warehouse and ETL Concepts :

• Understanding of Data Warehousing principles, including dimensional modeling (Star Schema, Snowflake Schema).
• Experience in ETL (Extract, Transform, Load) processes using tools like SSIS, Talend, Apache NiFi, Informatica, or Python-based ETL pipelines.
• Knowledge of data staging, transformation techniques, and data cleansing to ensure high-quality analytics.5.

Knowledge About Analytical Functions in SQL :

• Expertise in SQL analytical functions such as RANK(), DENSE_RANK(), ROW_NUMBER(), NTILE(), LEAD(), LAG(), SUM() OVER(), AVG() OVER(), and other aggregate functions.
• Ability to use these functions for complex reporting, trend analysis, and advanced calculations in analytics-driven environments.6.

Knowledge About Window Functions in SQL :

• Strong understanding of Window (or OLAP) functions, including their use cases in solving problems that require partitioning and sequential calculations.
• Experience in using PARTITION BY and ORDER BY to compute running totals, moving averages, cumulative sums, and trend analysis.
• Ability to apply frame specifications (ROWS BETWEEN, RANGE BETWEEN) to control the computation window for analytical insights.7.

Strong Analytical and Logical Reasoning :

• Ability to analyze complex data problems and design efficient database solutions.
• Strong problem-solving skills to debug and optimize SQL queries, ETL pipelines, and database structures.
• Ability to interpret business requirements and translate them into effective database queries and reports.
• Logical thinking to optimize data structures and ensure data integrity and consistency.8.

Experience in Client Interfacing/Direct Interaction Roles :

• Proficiency in working directly with clients, stakeholders, and business users to gather requirements, provide technical solutions, and resolve issues.
• Experience in conducting requirement analysis meetings, presenting solutions, and providing technical training.
• Strong ability to handle client escalations professionally and provide timely resolutions.
• Exposure to working in cross-functional teams involving business analysts, developers, and product managers.9.

Strong Communication Skills :

• Ability to articulate technical concepts to non-technical stakeholders.
• Excellent verbal and written communication skills to document SQL scripts, create reports, and write clear technical documentation.
• Experience in conducting knowledge-sharing sessions and training for peers and junior team members.
• Strong presentation skills to communicate findings from data analysis effectively.10.

Leadership Qualities: Taking Ownership, Being Proactive, Mentoring :

• Proactive in identifying potential issues and taking preventive measures to avoid escalations.
• Strong sense of ownership and accountability in handling database projects and ensuring their success.
• Ability to mentor junior developers, conduct code reviews, and enforce best practices.
• Leadership in decision-making, driving process improvements, and optimizing database workflows for better efficiency.
• A results-driven mindset with a focus on continuous learning and innovation.

Requirements :1. 4 years of experience in SQL development.2. Strong knowledge of SQL, database design, and development.3. Experience with data warehousing, ETL processes, and RDBMS systems.4. Proficiency in writing complex SQL queries, stored procedures, and functions.5. Strong analytical and problem-solving skills.6. Excellent communication and collaboration skills.7. Bachelor's degree in Computer Science, Information Technology, or related field. Qualifications :

• Bachelor's degree in Computer Science or a related field.
• Strong problem-solving skills and attention to detail.
• Excellent communication and collaboration skills.

)