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.

• 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

• 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

Norton Rose Fulbright US LLP is committed to providing employees with a comprehensive and competitive benefits package that supports you, your health, and your family. Benefit packages include access to three medical plans, dental, vision, life, and disability insurance. Employees can also access pre-tax benefits such as health savings and flexible spending accounts. Norton Rose Fulbright helps provide financial security by allowing employees to participate in a 401(k) savings plan and profit-sharing plans if eligible. Full- time employees are eligible to access fertility benefits designed to support fertility and family-forming journeys.

In addition to the Firm's health and welfare benefits above, we offer a competitive paid time off plan, which provides a minimum of 20 days off based on your role and tenure with the firm. The firm offers a generous paid parental leave benefit allowing parents to take a minimum of 14 weeks of paid leave to bond with your newborn, or adopted child(ren). Employees are also entitled to 11 Firm holidays.

Norton Rose Fulbright US LLP is an Equal Opportunity Employer and complies with all applicable federal laws and their implementing regulations that require the collection and recording of certain data and information. The information we receive will not be used to make any decision regarding employment and will be kept separate from your application. Similarly, self-identification information is kept confidential and used only in accordance with applicable federal laws and regulations. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status.Norton Rose Fulbright is committed to providing reasonable accommodation as an Equal Opportunity Employer to applicants with disabilities. If you require assistance or accommodation to complete your application, please contact us.hr@nortonrosefulbright.com. Please provide your contact information and a description of your accessibility issue. We will make a determination on your request for reasonable accommodation on a case-by-case basis.

E-Verifyis a registered trademark of the U.S. Department of Homeland Security. This business uses E-Verify in its hiring practices to achieve a lawful workforce.

Equal Employment Opportunity