The Role:
As a SQL Developer you will be responsible for managing administrative tasks for SQL Server databases as well as azure hosted data lake houses. You'll have the opportunity to develop and thrive in an environment where cutting-edge technology is a reality.
Responsibilities: Install, configure, manage, and secure SQL Server database servers in a 24/7 production environment, including version upgrades and patch management. Proficient in database and server performance tuning, including indexing, query execution, and concurrency control to enhance efficiency. Diagnose and resolve database performance issues (e.g., SQL timeouts, deadlocks, blocking), capacity constraints, and high availability challenges (e.g., replication). Drive technical and procedural improvements to ensure database security, high availability, and reliability. Provide support and ensure availability and performance requirements are met outside of normal working hours to support 24/7 operations. Proactively maintain the health of the SQL Server database environment. Maintain the Azure Cloud Synapse environment, including configuration, monitoring, and performance optimization. Have knowledge in Azure cloud environment configuration. Collaborate with application developers to design, test, implement, and maintain efficient data models. Optimize and maintain backup jobs, schedules, and environments (Production, DR, Development). Troubleshoot database and data issues, create, and manage administrative scripts, and document data processes. Help maintain database administration documentation and best practices. Requirements: 7+ years of experience as an SQL Developer or in a similar role. Extensive IT experience using database technologies, specifically Microsoft SQL Server and analytical databases. Advanced experience in writing, debugging, optimizing and performance tuning stored procedures, views, UDFs and complex Transact SQL (T-SQL) Queries for highly concurrent OLTP (online transactional processing) systems. Extensive experience writing Transact SQL (T-SQL) Queries, dynamic queries, indexes, constraints, views, functions. Experience in performance tuning and query optimization. Familiarity with ETL tools and data warehousing concepts. Leads the design, development, and planning for solutions and technology standards to solve complex business problems. Works with business, support, or development teams recommending system improvements. Responsible for the core database development for a custom application. Experience with SQL Server Integration Services (SSIS). Experience managing multi-DB environment setup (including production). Extensive experience in maintenance of highly concurrent OLTP (online transactional processing) systems. Prior experience troubleshooting SQL Server service data issues and able to solve it without causing data loss. Preferred: Experience with cloud data solution (e.g., Azure Fabric). Knowledge of big data technologies (e.g., Vertica, Synapse). Wakapi Web
#J-18808-Ljbffr