Job Description
Job Description
Job Title : Senior SQL Developer
Labor Grade : Department : IT
Department : IT
Reports To : Team Lead, Data Integration
FLSA Status : Exempt
Summary : Under the supervision of the Team Lead, Data Integration, the Senior SQL Developer is responsible for designing, developing, and maintaining complex SQL databases, queries, and procedures.
The role involves deep collaboration with business analysts and other developers to create efficient database systems that meet organizational needs.
The Senior SQL Developer leverages expertise in SQL Server, performance tuning, and database architecture to ensure the reliability, security, and efficiency of database-driven applications.
Essential Duties and Responsibilities :
- Design, develop, and optimize complex SQL databases, tables, queries, stored procedures, triggers, views, and functions.
- Maintain and enhance existing SQL databases, ensuring high availability and performance.
- Participate in requirement analysis sessions with business analysts and users to gather and document database requirements and develop technical solutions to support business needs..
- Develop and manage database models, database schema, database normalization, indexing strategies, and data migration plans.
- Optimize and fine-tune SQL queries to improve performance and scalability.
- Monitor and troubleshoot database performance issues, implementing optimizations as necessary.
- Provide production and end-user support for database-related issues.
- Work closely with application developers and architects to design and implement efficient database structures.
- Create and maintain detailed database documentation, including data models, schemas, and stored procedures.
- Ensure adherence to industry standards and best practices for database development, backup & recovery, replication, and security.
- Assist in the estimation and planning of database development tasks, reporting progress to management.
- Mentor junior developers and provide guidance on SQL best practices and coding standards.
- Research and recommend new database technologies and tools to improve existing systems.
- Production and End User Support Activities
- Work on multiple projects at the same time
- Assist and support other programmers in development procedures, techniques and coding assignments
- Research and recommend new and existing technologies to meet business needs, including creating prototypes, design documents, and solution designs
- Perform tasks as required by management / supervisory staff.
- Provide support after hours as required.
Qualifications : To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
The requirements listed below are representative of the knowledge, skill, and / or ability required.
- 7+ years of experience in SQL development, including database design, performance tuning, and query optimization.
- Proven experience with Microsoft SQL Server (versions 2016 and later) and SQL Server Reporting Services (SSRS).
- Extensive experience in writing complex T-SQL queries and developing stored procedures.
- Experience in database performance tuning and optimization (PTO), using native monitoring and troubleshooting tools.
- Solid understanding of database security, backup / restore strategies, and high availability solutions (e.g., Always On, replication).
- Familiarity with data warehousing concepts, ETL processes, and Azure SQL Database.
- Experience with cloud-based database solutions, particularly in Azure (e.g., Azure SQL, Azure Data Factory).
- Familiarity with other database technologies such as Oracle, MySQL, or PostgreSQL.
- Experience with modern data integration tools and processes.
- Knowledge of DevOps practices and CI / CD pipelines for database changes.
- Ability to work with business analysts and business users
- Candidate must have excellent communication (verbal and written) and interpersonal skills
- Working knowledge of Oracle and Java programming is a big plus
- Microsoft SharePoint is a plus
- Understanding of Microsoft Dynamics is a plus
Interpersonal Skills :
- Detail oriented with excellent organization and analytical skills;
- Ability to plan and take initiatives to accomplish objectives in timely fashion;
- Ability to prioritize work and meet deadlines;
- Ability to establish and maintain effective working relationships with project team members, supervisors, and employees from other departments.
Education and / or Experience : Bachelor’s degree in Computer Science, or a related discipline.
Language Skills : Speak, read, write and understand English
Reasoning Ability : High
Certificates, Licenses, Registrations : None
Physical Demands : The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
Reasonable accommodations may be made to enable individuals to perform the essential functions.
- Under 1 / 3 of the time : Standing, Walking, Climbing or Balancing, Stooping, Kneeling, Crouching, or Crawling
- 1 / 2 to 2 / 3 of the time : Sitting, Reaching with Hands & Arms
- Over 2 / 3 of the time : Talking or Hearing
- 100% of the time : Using Hands
Work Environment : The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- 1 / 3 to 2 / 3 of the time : Work near moving or mechanical parts, exposure to radiation, moderate noise.