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.