SQL Developer

Key Responsibilities · Develop, maintain, and optimize SQL queries, stored procedures, views, functions, and triggers. · Design and manage database structures to ensure data integrity, security, scalability, and performance. · Write complex SQL queries for data extraction, transformation, validation, and reporting purposes. · Create efficient reports, dashboards, and datasets to support business intelligence and operational requirements. · Perform database performance tuning, query optimization, execution plan analysis, and indexing strategies. · Develop and optimize joins, subqueries, CTEs, window functions, and aggregate queries for large datasets. · Support data migration, integration, ETL, and data transformation activities across multiple systems. · Collaborate with software developers, business analysts, and stakeholders to understand and implement data requirements. · Troubleshoot and resolve database-related issues, including query performance bottlenecks and data inconsistencies. · Monitor database health, performance metrics, and system availability to ensure reliable operations. · Create, maintain, and update technical documentation for database objects, processes, and data flows. · Ensure compliance with data governance, security standards, backup, and recovery procedures. · Validate data accuracy and perform data quality checks using SQL scripts and automated processes. · Assist in database deployment, release management, and production support activities. Requirements Qualifications · Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field. · 2–3 years of experience in SQL Development, Database Administration, or related roles. · Strong understanding of relational database concepts and data modeling. · Experience working with enterprise-scale databases and reporting environments. Skills Required · Strong proficiency in SQL programming. · Experience with PostgreSQL, MySQL, Microsoft SQL Server, or similar RDBMS. · Knowledge of Stored Procedures, Functions, Triggers, Views, and Indexing. · Hands-on experience in query optimization and database performance tuning. · Understanding of ETL processes and data transformation techniques. · Proficiency in MS Excel and data analysis methodologies. · Familiarity with Power BI, Tableau, or other reporting tools is an added advantage. · Strong analytical, problem-solving, and communication skills.

Preferred Skills · Experience with database backup, recovery, and security practices. · Knowledge of cloud-based database platforms (AWS, Azure, or GCP). · Familiarity with version control systems such as Git.