SQL Server Database Developer / Application Analyst

Lowenstein Sandler is one of the most sophisticated law firms in the United States, with over 375 lawyers and 300 business services professionals serving clients from offices in New York, Palo Alto, New Jersey, Utah, and Washington, D.C. We recruit candidates who seek a collaborative, entrepreneurial culture that prioritizes our clients, our colleagues, and the communities where we work and live. Committed to career development and to a diverse, equitable, and inclusive workplace, the firm offers many programs and opportunities for personal and professional growth. We seek professionals for our business services group who share these values.

The SQL Server Database Developer / Application Analyst is responsible for creating insightful reports, developing and maintaining our database systems, and analyzing applications to ensure optimal performance and functionality under the guidance of senior engineers.

Database Development:

• Write and optimize complex SQL queries, stored procedures, and triggers.
• Develop and maintain SSRS reports and alerts.
• Develop and maintain inbound and outbound data feeds between external third-party cloud platforms and within internal firmwide applications.
• Create and manage Power BI reports and dashboards.
• Keep current on latest database development trends.

Database Administration:

• Develop, maintain and upgrade SQL Server databases.
• Implement and maintain high availability (HA) and disaster recovery (DR) strategies such as SQL Server Clustering or Always On Availability Groups.
• Perform regular database maintenance tasks such as backups, indexing, and performance tuning.
• Monitor database performance and troubleshoot issues.
• Ensure data integrity and security across all database systems.

Application Analysis:

• Work with development team to integrate database solutions with applications.
• Provide technical support and troubleshooting for application-related issues.
• Technical resource on financial application configuration, enhancements and upgrades in conjunction with third party vendors.
• Analyze and optimize application performance.

Skills, Knowledge and Abilities:

• Bachelor’s degree in computer science, Information Systems, or a related field.
• Minimum of 3 years of experience in database development and administration.
• Proficiency in SQL Server, including T-SQL, SSRS, SSIS, and SSAS
• Knowledge or experience with PowerShell, Power Automate, Power Apps and low code platforms.
• Experience with data warehousing and ETL processes.
• Some experience with Power BI development and data visualization.
• Knowledge or experience with Web Services, REST, APIs, XML, JSON a plus.
• Familiarity with cloud-based database solutions (e.g., Azure SQL Database).
• Law firm application experience including Aderant and Intapp a plus.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.

Disclaimers:

This job description is not designed to cover or contain a comprehensive listing of all activities, duties or responsibilities required by employee.

Lowenstein Sandler LLP is not accepting resumes from search firms for this position. Regardless of past practice, all resumes submitted by search firms are to be deemed the sole property of Lowenstein Sandler LLP, and no fee will be paid in the event the candidate is hired by Lowenstein Sandler LLP as a result of the referral.

Lowenstein Sandler LLP is committed to equal employment opportunity and providing reasonable accommodations to applicants with physical and/or mental disabilities. We value and encourage diversity and solicit applications from all qualified applicants without regard to race, color, gender, sex, age, religion, creed, national origin, ancestry, citizenship, marital status, sexual orientation, physical or mental disability, medical condition, veteran status, gender identity, genetic information, or any other characteristic protected by federal, state, or local law.