SQL Developer

Job Description

Role & responsibilities As a a SQL Developer candidate will be responsible for designing, developing, and maintaining databases and data-centric solutions using Microsoft SQL Server. This role involves creating optimized SQL queries, stored procedures, and other database objects to support business applications and reporting needs. Key Responsibilities 1. Database Design & Development Design and develop logical and physical database structures based on business requirements. Create and maintain tables, indexes, views, stored procedures, functions, and triggers. Normalize and denormalize databases as appropriate for performance and integrity. 2. Query Development & Optimization Write complex SQL queries to extract, manipulate, and analyze data. Optimize queries and database objects for performance, including indexing and execution plans. Troubleshoot and resolve slow-performing queries and long-running transactions. 3. Data Integration & ETL Integrate data from various sources (Excel, flat files, APIs) into SQL Server databases. 4. Data Quality & Integrity Implement data validation, cleansing, and transformation rules. Enforce referential integrity and data constraints. Perform data profiling to identify and correct anomalies. 5. Reporting & Business Intelligence Support reporting needs by developing datasets, views, and stored procedures for use in BI tools (e.g., Power BI, SSRS, Crystal Reports). Create ad hoc and scheduled reports as needed. 6. Database Maintenance & Monitoring Perform regular database maintenance tasks such as backups, index rebuilding, and update statistics. Monitor system health and performance using SQL Server tools (SQL Profiler, Activity Monitor, Extended Events). Set up alerts and automate routine tasks using SQL Server Agent. 7. Security & Compliance Implement and manage user permissions, roles, and security policies. Ensure compliance with data protection standards (e.g., GDPR, HIPAA). Audit access and data changes to maintain data integrity and accountability. 8. Collaboration & Documentation Work closely with developers, data analysts, and business stakeholders to understand data requirements. Document database designs, schemas, and processes. Provide support for application development teams on database-related issues.