Position Summary:
We are seeking an experienced Senior Database Developer to design, develop, optimize, and maintain SQL Server databases that power our critical applications. The ideal candidate will have a strong understanding of database architecture, extensive experience in writing and optimizing T-SQL code, and the ability to lead database-related projects and mentor junior team members.
Key Responsibilities:
- Design and develop scalable, reliable, and secure database solutions using SQL Server.
- Create and maintain database schemas, tables, indexes, and relationships.
- Develop and optimize complex T-SQL scripts, stored procedures, functions, and triggers.
- Analyze and resolve performance issues by optimizing queries, indexing, and database configurations.
- Monitor and troubleshoot database performance using tools such as SQL Profiler and Extended Events.
- Collaborate with application developers to integrate database solutions seamlessly into applications.
- Provide guidance and mentorship to junior database developers and team members.
- Participate in technical discussions, architecture reviews, and project planning.
- Implement data governance and security measures, including access controls and encryption.
- Develop and maintain ETL processes for data integration and transformation.
- Ensure compliance with data regulations and company policies.
- Document database structures, procedures, and workflows for knowledge sharing and maintenance.
- Identify opportunities for automation and process improvements in database operations.
Educational Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or a related field.