Description
We are working with a client seeking a SQL Database Developer to design, develop, and maintain scalable, high-performance solutions within SQL Server. The client is based in Smyrna. This role focuses on creating and optimizing stored procedures, functions, triggers, and views, as well as developing and supporting ETL processes for data integration and data warehousing initiatives. In addition to SQL Server, the position will contribute to development efforts within the Snowflake data platform. The ideal candidate demonstrates strong analytical and critical-thinking skills, excels in performance tuning and query optimization, and possesses a solid understanding of database security and industry best practices to ensure data integrity, reliability, and accessibility across applications and reporting environments.
Major Tasks, Responsibilities, and Key Accountabilities:
o Design, develop, and implement high-quality, efficient database objects, including stored procedures, functions, views, and triggers using T-SQL.
o Participate in the database design process, including data modeling and normalization, ensuring adherence to best practices
o Optimize and tune complex, high-volume T-SQL queries, stored procedures, and indexes to ensure optimal application performance.
o Identify and resolve database performance issues, including deadlocks, long-running queries, and poor execution plans.
o Develop and implement solutions for data migration, replication, and synchronization.
o Ensure data integrity and security by implementing appropriate constraints, indexes, and user access controls.
o Collaborate with application development teams to understand data requirements and translate them into effective database solutions.
o Conduct code reviews of database scripts and stored procedures written by other developers.
o Create and maintain technical documentation related to database design, code, and operational processes.
o Assist in the development process of Power BI Semantic Models to be used by Report Developers.
Requirements
Required Qualifications/Skills:
Competently write secure and efficient T-SQL scripts.
Proficiently develop ETL pipelines utilizing SSIS and PowerShell for data on Prem and in the Cloud.
Thoroughly understand business logic requirements to fulfill the accurate results needed for making business decisions.
Maintain accurate documentation of ETL pipelines.
Optimize existing queries for improved performance through reduced I/O, decreased execution times, and streamlined logical processing.
Mentor entry level colleagues, fostering a culture of database best practices and knowledge sharing.
Analyze complex, legacy ETL processes and offer solutions to improve efficiency and follow developmental best practices.
Work effectively in Azure DevOps, utilizing User Stories, Source Control, and Documentation.
Strong verbal and written communication skills.
Documentation skills for processes and procedures.
Ability to collaborate effectively with cross-functional teams, including developers, DevOps, and security teams.
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use and Privacy Notice.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: rhalfint
- Position Id: 00900-0013379010
- Posted 24 days ago
Never miss an opportunity! Create an alert based on the job you applied for.