Senior Database Developer

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.

Skills

• Expertise in SQL Server, including database design, query optimization, and troubleshooting.
• Proficiency in T-SQL, with the ability to write complex queries, stored procedures, and triggers.
• Strong understanding of indexing, partitioning, and database normalization principles. Experience with database monitoring and performance tuning tools (e.g., SQL Profiler, Extended Events, DMVs
• Familiarity with ETL processes and tools such as SSIS or similar.
• Knowledge of high-availability solutions like clustering, replication, or Always On Availability Groups.
• Experience working PostgreSQL, MongoDB and applications hosted on Azure/AWS will be a plus.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Experience working in travel and transportation domain will be a plus.

Experience

• Minimum 5 years