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!