Reed Smith LLP: SQL Database Engineer Remote

Reed Smith LLP: SQL Database Engineer – (Remote)

Reed Smith is a dynamic international law firm dedicated to helping clients move their businesses forward. With an inclusive culture and innovative mindset, we deliver smarter, more creative legal services that drive better outcomes for our clients. We operate as one global partnership with 3,000 people, including over 1,600 lawyers, across more than 30 offices worldwide.

• Design, implement, and maintain high‑performance database systems to support our applications and business operations.
• Optimize database performance through capacity planning, query optimization, index tuning, and other performance‑tuning techniques.
• Perform database engineering and administration tasks, including installation, configuration, tuning, monitoring, backup, recovery, and troubleshooting.
• Develop and implement data management policies, procedures, and best practices to ensure data integrity, availability, and security.
• Implement and maintain database security measures, including access controls, encryption, and auditing.
• Collaborate with software developers, system administrators, and other stakeholders to design and deploy database solutions that meet business requirements.
• Lead database‑related projects, including upgrades, migrations, and deployments, from planning through execution.
• Design and implement backup and recovery strategies to ensure the integrity and availability of data; perform regular backups and test restore procedures.
• Configure user access, roles, permissions, and auditing to design and maintain database security.
• Implement security best practices to protect sensitive data.
• Design, configure, and maintain high availability solutions such as Always On Availability Groups.
• Develop and test disaster recovery plans to minimize downtime in the event of failure.
• Apply patches and updates to SQL Server instances and related components in a timely manner; perform regression testing to ensure compatibility with existing applications.
• Develop proactive monitoring and alerting solutions to detect and respond to database issues in real time; create automated scripts and jobs to streamline monitoring tasks.
• Provide cloud‑related expertise and administration of PaaS‑based database platforms, including Azure SQL, Azure Data Factory, and more.
• Lead and work on projects related to the firm’s Document Management System (DMS), including upgrades, conversions, integrations, and migrations.
• Manage data transfers, document imports/exports, user access, advanced troubleshooting, and escalation with vendors for DMS systems.
• Support Knowledge Management systems, full‑text indexing/searching functions, Records Management systems, ethical wall systems, and related integrations.
• Develop documentation of database configurations, procedures, and best practices; provide training and support for application owners and developers.
• Stay current with emerging technologies, trends, and best practices in database administration and recommend innovative solutions to enhance the infrastructure.
• Maintain current skill level through formal and informal means; volunteer or serve on committees and project teams related to firm‑wide IT initiatives.
• Perform any other duties assigned; responsibilities may be supplemented as necessary.

• Education:
  
  Bachelor’s degree strongly preferred or comparable training and experience in an IT discipline.
• Microsoft Certifications (MCSE and/or MCDBA) a plus.
• 5+ years of experience in database administration, focusing on enterprise‑level database systems such as Microsoft SQL Server and MySQL.
• Strong proficiency in database design, implementation, optimization, and troubleshooting; extensive experience with performance tuning, query optimization, and capacity planning.
• In‑depth knowledge of database security principles and best practices.
• Hands‑on experience with backup and recovery procedures, Always On Availability Groups, multi‑tier high‑availability architecture, SAN environments, virtual SQL Server environments, Power
  
  BI, Power Shell, and productivity tools.
• Familiarity with Document Management Systems a plus.
• Strong analytical, organizational, and…