Job description
Position: SQL Database Engineer - (Remote in Pittsburgh)
US
Job Description
Firm Information
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. Our deep industry knowledge, long-standing relationships and collaborative structure make us the go-to partner for complex disputes, transactions and regulatory matters.
Our team of 3,000 people (including more than 1,600 lawyers) across more than 30 offices in the United States, Europe, the Middle East and Asia, operate as one global partnership to drive progress for our clients, for ourselves and for our communities.
Position Summary
The SQL Database Engineer is responsible for ensuring the performance, availability, and security of our SQL Server databases.
They will work closely with applications owners and development teams to design, develop, implement, and maintain database solutions that meet business requirements. The SQL Database Engineer will also be involved in troubleshooting database-related issues and providing support to users as needed.
They will perform database administration tasks associated with various enterprise-wide systems, as well as some enterprise application responsibilities.
This role requires a deep understanding of database administration principles, information security, and proficiency in relevant technologies.
Serve as an internal consultant and resource to others in the department.
Job Duties and Responsibilities
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 to ensure recoverability.
Design and manage database security by configuring user access, roles, permissions, and auditing.
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.
Design, develop, and maintain proactive monitoring and alerting solutions to detect and respond to database issues in real-time.
Develop automated scripts and jobs to streamline monitoring tasks.
Provide cloud related expertise and administration of PaaS based database platforms, including but not limited to Azure SQL, Azure Data Factory, and more.
Lead, take ownership, and work on projects related to the firms’ Document Management System (DMS) including upgrades, conversions, integrations and migrations. Document Management System (DMS) tasks related to managing data transfers, document imports/exports, user access, advanced troubleshooting of issues, and escalating with vendors to resolve system related issues.
Advanced support of DMS related systems including Knowledge Management systems, full text indexing/searching functions, Records Management systems, ethical…
