About the Role
The Senior Database Administrator (DBA) is responsible for architecting, administering and optimizing all enterprise SQL Server databases, ensuring security, reliability, and scalability. The DBA collaborates with application owners and IT teams to support business operations and provides technical guidance to users accessing enterprise data.
Responsibilities
- Maintains all enterprise SQL database operations including SQL server updates and patches
- Maintains database security and compliance with company, industry and government standards (GDPR, HIPAA, etc.)
- Reviews current architecture and updates and optimizes all the firm's enterprise database systems
- Architects and implements new database systems
- Proactively monitors database performance and performs database tuning for optimal performance
- Troubleshoots enterprise database servers and related systems
- Supports system audits and provides documentation as required
- Plans testing and implementation of DR and backup processes to ensure continuous operation
- Creates custom queries, data-driven SSRS subscriptions, migration scripts, and executes other tasks as needed
Requirements
- Minimum 8 to 10 years’ experience in design, development, administration, and maintenance of enterprise-level MS SQL Server database systems
- Demonstrable experience configuring, operating and maintaining Microsoft SQL Server, both on-prem and cloud environments
- Demonstrable experience in database design, creating standards and processes, capacity planning, disaster recovery planning, accessibility, scalability and documentation for SQL Server
- Demonstrable experience in development of complex queries, SSIS Packages and SSRS reports
Skills
- Sound understanding of SQL Server technology features and limitations
- In-depth, advanced knowledge of SQL Server database structures, security, storage solutions, virtualization, replication, and clustering
- Ability to create performance projections based upon hardware, OS, databases design, query structures and interactions between external systems with the database servers
- Ability to evaluate and recommend technological changes in the database environment to support business objectives
- Proficiency in automation and scripting (e.g., PowerShell)
- Strong analytical and troubleshooting skills
- Excellent verbal and written communication skills, with an ability to effectively communicate technical details to persons without technical experience
- Excellent organizational and interpersonal skills
- Excellent attention to detail and problem-solving skills
- Ability to accurately follow documented procedures and a strong aptitude for learning new technologies as they are incorporated into the computing environment
Location
- various offices
- remote basis
Work Type
- full-time
Experience Level
- Senior
Education Level
- Bachelor's degree or equivalent work experience
Benefits
- competitive compensation
- excellent benefits package
About the Company
- Greenberg Traurig (GT) is a global law firm with locations across the world in 15 countries.
- GT is an EEO employer with an inclusive workplace committed to merit-based consideration and review without regard to an individual’s race, sex, or other protected characteristics and to the principles of non-discrimination on any protected basis.
- With 51 locations, Greenberg Traurig's global network provides the platform clients need to operate in today's legal marketplace.
- Our team is recognized by rankings in current Chambers & Partners Guides in jurisdictions and practices around the world, based on thousands of interviews with practicing lawyers and clients.
- In addition, Greenberg Traurig is proud to have more lawyers listed in The Best Lawyers in America than any other law firm, a position we have held since 2008.
- Greenberg Traurig (GT) is committed to ensuring a safe and transparent recruitment process.
- From our humble beginnings in 1967 in South Florida, our focus has never been changed: serve clients better.
- Since 1967, we’ve built our firm by welcoming attorneys and professionals from all backgrounds who share our drive and commitment to excellence.
- GT thrives on the passion and drive of our people, emphasizing merit, innovation, belonging, and collaboration first.
- This commitment has been at the center of our story since our founding and has been essential to our and our client’s success.
- We are thankful for the trust our clients place in us and we are proud of being recognized for the service we provide.
Equal Opportunity
- GT is an EEO employer with an inclusive workplace committed to merit-based consideration and review without regard to an individual’s race, sex, or other protected characteristics and to the principles of non-discrimination on any protected basis.
