Senior Database Developer

Job Description

We are a global law firm with a powerful strategic focus and real momentum. Our industry-focused strategy is seeing us take on pioneering work in places that others have yet to reach. Our shared values define our culture and our workplace. You will find us to be unusually collegial, team-oriented, and ready to innovate. We work seamlessly across practices, offices and around the world. This elimination of boundaries has allowed us to evolve into a law firm that works as hard for its culture as it does for its clients.

The Senior Database Developer will play a crucial role in designing, developing, and maintaining complex database systems. This position requires a deep understanding of Microsoft Fabric, SQL Server, and cloud database migration processes. The ideal candidate will have extensive experience working with large-scale databases and cloud platforms, ensuring data integrity, performance optimization, and seamless migration. 

Responsibilities Include but are not limited to:

• Architect and develop scalable database solutions using Microsoft Fabric and SQL Server 

• Develop, implement and optimize ETL package, stored procedures, trigger, views and functions using Microsoft Fabric Pipelines, Data Flows, and Notebooks 

• Analyze existing SQL queries explain plan and improvement improvements 

• Develop procedures and scripts for data migration 

• Creating logical and physical ERD designs. 

• Lead cloud database migration projects, ensuring minimal downtime and data loss 

• Integrate various data sources to create unified data models 

• Analyze and optimize database performance, ensuring efficient query execution and resource utilization 

• Database changes deployment automation using Azure DevOps(ADO) pipeline 

• Implement security measures to protect sensitive data and ensure compliance with industry standards 

• Maintain comprehensive documentation of database designs, configurations, and migration processes 

• Work closely with cross-functional teams to understand business requirements and deliver tailored database solutions 

• Mentor junior database developers and conduct training sessions to enhance team skills 

• Stay updated with the latest database technologies and trends and implement innovative solutions 

Other duties 

Please note this job description does not cover or contain all activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. 

Qualifications

• Bachelor's degree in computer science, information technology, or a related field required 

• Minimum 7 years of experience in database development, with a focus on SQL server, ETL design and build, database design/build and cloud migration 

• Minimum of 1 year experience with Microsoft Fabric. building Pipelines, Data Flows, Airflows, Service Bus and Notebooks 

• Expertise in Microsoft Fabric and its applications in database development 

• Proficient in SQL Server, including T-SQL programming, stored procedures, and triggers 

• Experience with cloud database platforms 

• Experience with following SDLC and Agile processes 

• Experience with assisting business in creating functional specifications 

• Experience with creating technical specifications document based on functional specifications 

• Experience with database mirroring (e.g. CDC etc.) 

• Strong understanding of database architecture and design principles 

• Experience with ETL/ELT design, creation and tools using SSIS and other ETL tools 

• Familiarity with data warehousing and BI solutions 

• Certifications: Relevant certifications in Microsoft Fabric, SQL Server, and cloud platforms are preferred 

• Microsoft Azure and Azure pipelines experience is a plus 

• Excellent problem-solving and analytical skills 

• Strong communication and interpersonal skills 

• Ability to work independently and as part of a team 

• Sense of ownership and pride in your performance and its impact on company’s success 

• Detail-oriented with a focus on quality and accuracy 

• Proactive and self-motivated with a drive for continuous improvement 

N