Lead SQL Server Developer

Job Description:

We are seeking an experienced SQL Server Database Developer to join our team at Lead Allies Inc. As a key member of our database team, you will play a crucial role in designing, developing, and optimizing SQL Server databases to ensure the highest level of performance, reliability, and scalability for our applications.

Responsibilities:

1. Database Development: Design, develop, and implement complex SQL queries, stored procedures, functions, and triggers for various business applications.
2. Performance Tuning & Optimization: Identify and resolve performance bottlenecks using advanced techniques, including index optimization, query tuning, execution plan analysis, and optimization of database configurations.
3. Troubleshooting & Debugging: Troubleshoot and resolve performance issues and errors within SQL Server environments, applying in-depth knowledge of SQL Server internals to quickly identify root causes and implement effective solutions.
4. Database Architecture & Design: Assist in the architectural design and implementation of high-performing SQL Server databases to meet both current and future business requirements.
5. High Availability & Scalability: Design, configure, and maintain high-availability solutions such as Always On Availability Groups, clustering, replication, and other disaster recovery techniques to ensure database uptime.
6. Database Monitoring: Use SQL Server Management Studio (SSMS) and third-party monitoring tools to proactively monitor database performance and make recommendations for improvement.
7. Security & Compliance: Implement database security measures, ensuring that sensitive data is protected and compliant with regulatory requirements (e.g., GDPR, HIPAA).
8. Documentation: Maintain thorough documentation of database configurations, changes, performance improvements, and optimization procedures.
9. Collaboration: Work closely with cross-functional teams (application developers, system administrators, etc.) to ensure the smooth operation of database systems.
10. Stay Current with SQL Server Updates: Continuously evaluate and apply new SQL Server features and best practices, keeping the database systems aligned with industry standards.
11. Cloud SQL Management: Design, implement, and maintain SQL Server databases on cloud platforms such as Microsoft Azure SQL Database, Amazon RDS for SQL Server, or Google Cloud SQL, ensuring high availability, scalability, and security.
12. Cloud Integration: Work with cloud providers and integration tools to ensure seamless interaction between cloud-based databases and other cloud services.

Required Skills & Qualifications:

1. Experience: 5+ years of experience working with SQL Server database development, with a focus on performance tuning, query optimization, and troubleshooting.
2. 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.
3. Performance Tuning: Proven track record in identifying performance bottlenecks and resolving issues related to query performance, indexing, and database configuration.
4. Indexing & Query Optimization: Advanced knowledge of indexing strategies (clustered, non-clustered, filtered, and full text), and ability to optimize complex SQL queries.
5. 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.
6. Tools: Proficient in using SQL Server Management Studio (SSMS), SQL Profiler, and other performance monitoring tools (e.g., Redgate, SolarWinds, etc.).
7. Scripting: Strong ability to write and automate T-SQL scripts and working knowledge of PowerShell or other scripting languages for database management tasks.
8. Problem-Solving Skills: Strong analytical and problem-solving abilities, particularly in high-pressure environments.
9. Communication: Excellent communication skills to effectively collaborate with developers, system administrators, and business stakeholders.
10. Certifications: Microsoft Certified: Azure Data Engineer, Microsoft Certified: SQL Server (or similar) certifications are a plus.

Others:

1. Must be authorized to work in the United States
2. Background check required
3. Willingness to travel up to 10% of the time