8 Revenue Technology Services Jobs
5-7 years
Revenue Technology Services - Senior Database Developer - SQL Server (5-7 yrs)
Revenue Technology Services
posted 4d ago
Flexible timing
Key skills for the job
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
Functional Areas: Software/Testing/Networking
Read full job descriptionPrepare for Senior Database Developer roles with real interview advice
5-7 Yrs