Database architect serp_jobs.h1.location_city

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 MS 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

Architect and develop scalable database solutions using MS Fabric and SQL Server.

Develop, implement and optimize ETL Package, stored procedures, trigger, views and functions using T-SQL

• Analyze existing SQL queries explain plan and improvement improvements
• Develop procedures and scripts for data migration
• Create and Optimize Data Model
• 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 AzureDevOps(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.

Qualifications

Soft Skills :

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-Verify is 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