SQL Database Developer

Responsibilities:

• Design, develop, and maintain SQL Server databases, ensuring efficient data storage and retrieval.
• Write, optimize, and troubleshoot complex SQL queries, stored procedures, functions, and triggers for performance improvements.
• Work closely with application developers to ensure seamless integration of database components with applications.
• Perform database tuning and optimization (PTO), including indexing strategies, query execution plans, and partitioning.
• Develop and maintain ETL (Extract, Transform, Load) processes to facilitate data movement and transformation between systems.
• Implement database security best practices, including user authentication, role-based access control, and encryption.
• Monitor and analyze database performance, addressing bottlenecks and optimizing resource utilization.
• Design and implement backup and recovery strategies to ensure data integrity and business continuity.
• Collaborate with data analysts and Product/business teams to support reporting and data visualization needs using SQL-based reporting tools.
• Maintain documentation of database structures, procedures, and best practices to ensure knowledge sharing and compliance.
• Ensure data quality and consistency across multiple environments, including Development, Staging, and Production.
• Develop and maintain data models, including logical and physical data design.
• Stay updated with the latest SQL Server features, best practices, and industry trends.
• Implement High Availability (HA) and Disaster Recovery (DR) options such as failover clustering, database mirroring, log shipping, and replication.
• Manage user security, including logins, roles, and privileges to ensure data integrity and security compliance.
• Optional: Experience with Business Intelligence (BI) tools such as SSIS, SSRS, and SSAS for advanced analytics and reporting.
• Optional: Experience working in financial markets or similar data-intensive domains is an added advantage.

Required Skills & Qualifications:

• Strong expertise in SQL Server development, including T-SQL, query optimization, and stored procedures.
• Experience in database design, normalization, and data modeling.
• Knowledge of performance tuning techniques, indexing, and execution plan analysis.
• Familiarity with ETL tools and data warehousing concepts.
• Proficiency in working with version control tools such as Git.
• Excellent problem-solving skills and ability to troubleshoot database-related issues.
• Strong communication skills and ability to collaborate with cross-functional teams.
• Bachelor's degree in Computer Science, Information Technology, or a related field.