SQL Server Database Developer
Description: • We are seeking an experienced SQL Server Database Developer with expertise in performance tuning and a strong technical understanding of SQL Server's internal workings. • Database Development: Design, develop, and implement complex SQL queries, stored procedures, functions, and triggers for various business applications. • Performance Tuning & Optimization: Identify and resolve performance bottlenecks using advanced techniques, including index optimization, query tuning, execution plan analysis, and optimization of database configurations. • Troubleshooting & Debugging: Troubleshoot and resolve performance issues and errors within SQL Server environments. • Database Architecture & Design: Assist in the architectural design and implementation of high-performing SQL Server databases. • High Availability & Scalability: Design, configure, and maintain high-availability solutions. • Database Monitoring: Use SQL Server Management Studio (SSMS) and third-party monitoring tools to proactively monitor database performance. • Security & Compliance: Implement database security measures, ensuring that sensitive data is protected and compliant with regulatory requirements. • Documentation: Maintain thorough documentation of database configurations, changes, performance improvements, and optimization procedures. • Collaboration: Work closely with cross-functional teams to ensure the smooth operation of database systems. • Stay Current with SQL Server Updates: Continuously evaluate and apply new SQL Server features. • Cloud SQL Management: Design, implement, and maintain SQL Server databases on cloud platforms such as Microsoft Azure SQL Database. • Cloud Integration: Work with cloud providers and integration tools to ensure seamless interaction between cloud-based databases and other cloud services. Requirements: • Experience: 5+ years of experience working with SQL Server database development, with a focus on performance tuning, query optimization, and troubleshooting. • SQL Server Expertise: Deep technical knowledge of SQL Server (2016 or later) architecture, internals, and background processes such as transaction logs, locking, and resource management. • Performance Tuning: Proven track record in identifying performance bottlenecks and resolving issues related to query performance, indexing, and database configuration. • Indexing & Query Optimization: Advanced knowledge of indexing strategies (clustered, non-clustered, filtered, and full text), and ability to optimize complex SQL queries. • High Availability & Disaster Recovery: In-depth knowledge of SQL Server high availability technologies such as Always On Availability Groups, database mirroring, replication, and log shipping. • Tools: Proficient in using SQL Server Management Studio (SSMS), SQL Profiler, and other performance monitoring tools (e.g., Redgate, SolarWinds, etc.). • Scripting: Strong ability to write and automate T-SQL scripts and working knowledge of PowerShell or other scripting languages for database management tasks. • Problem-Solving Skills: Strong analytical and problem-solving abilities, particularly in high-pressure environments. • Communication: Excellent communication skills to effectively collaborate with developers, system administrators, and business stakeholders. • Certifications: Microsoft Certified: Azure Data Engineer, Microsoft Certified: SQL Server (or similar) certifications are a plus. Benefits: Apply Job! Apply tot his job