Senior Database Developer

Position Overview:

We are seeking a highly skilled and experienced Senior SQL Database Developer to join our team. The ideal candidate will be responsible for designing, developing, and maintaining complex SQL databases, ensuring their efficiency, security, and scalability. This position requires deep expertise in SQL development, performance tuning, database design, and optimization, along with a solid understanding of database architecture and troubleshooting. The Senior SQL Database Developer will work closely with cross-functional teams to ensure the successful delivery of high-quality data solutions.

Key Responsibilities:

Database Development & Design:

• Develop and maintain complex SQL queries, stored procedures, triggers, function and views.
• Design, implement, and optimize relational database schemas.
• Create and maintain database objects (tables, indexes, views, etc.) ensuring data integrity and optimization.

Performance Tuning & Optimization:

• Analyse query performance and optimize SQL statements for maximum efficiency.
• Use indexing, partitioning, and other techniques to improve database performance.
• Monitor and resolve database performance issues using profiling tools and techniques.

Data Integration & Migration:

• Lead data integration efforts between multiple data sources, ensuring accurate data flow and consistency.
• Support data migration projects, converting and importing data between systems.

Collaboration & Communication:

• Work closely with application developers, data architects, business analysts, and other stakeholders to deliver database solutions.
• Provide technical guidance and mentoring to junior developers.
• Participate in code reviews, ensuring SQL best practices are followed and adhered to.

Troubleshooting & Issue Resolution:

• Identify and resolve complex database issues related to performance, functionality, and data integrity.
• Provide support for production database environments and resolve urgent database issues quickly.

Documentation & Reporting:

• Document database structures, processes, and procedures to ensure consistency and compliance with internal standards.
• Provide status reports, performance insights, and recommendations to management.

Key Qualifications:

• Education:

• Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent work experience).

• Experience:

• Minimum of 5-8 years of experience in SQL development and database management.
• Proven experience working with large-scale SQL databases (Microsoft SQL Server, Azure SQL Server).

Skills & Expertise:

• Strong proficiency in SQL, including complex queries, joins, subqueries, indexing, and optimization.
• Experience with SQL Server, T-SQL, or other relational database management systems.
• Expertise in database performance tuning, troubleshooting, and query optimization.
• Strong knowledge of database security best practices (user roles, encryption, etc.).
• Familiarity with cloud databases and technologies (e.g., Azure SQL, etc.) is a plus.
• Experience with data integration and ETL processes.
• Familiarity with version control tools such as Git.

Soft Skills:

• Strong analytical and problem-solving abilities.
• Ability to work independently and as part of a team.
• Excellent communication skills, both written and verbal.
• Strong attention to detail and ability to handle complex tasks with minimal supervision.

Preferred Skills:

• Experience with AZURE SQL Server, SQL Server.
• Knowledge of database monitoring tools (e.g., SQL Profiler, New Relic, SolarWinds).
• Familiarity with DevOps practices and CI/CD pipelines related to database development.
• Experience in agile or scrum development environments.

Working Conditions:

• Full-time position with flexible work hours.
• Only Work from Office available.
• Occasional on-call support for production database systems may be required.

Why Join Us?

• Competitive salary and benefits package.
• Opportunities for career growth and professional development.
• A dynamic, collaborative, and innovative work environment.
• Exposure to cutting-edge database technologies and large-scale systems.