Senior Database Administrator

Senior Database AdministratorGreenberg Traurig (GT), a global law firm with locations across the world in 15 countries, has an exciting employment opportunity for you. We offer competitive compensation and an excellent benefits package, along with the opportunity to work within an innovative and collaborative environment.Join our Technology Team as a Senior Database Administrator located in various offices.We are seeking a professional who thrives in a fast-paced, deadline-driven environment. The ideal candidate possesses strong problem-solving and decision-making abilities, ensuring efficiency and accuracy in every task. With a dedicated work ethic and a can-do attitude, you will take initiative and approach challenges with confidence and resilience. Excellent communication skills are essential for collaborating effectively across teams and delivering exceptional client service. If you are someone who demonstrates initiative, adaptability, and innovation, we invite you to join our team.This role can be based in various offices, on a remote basis. This role reports to the Director of Network Systems.Position SummaryThe 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.Key ResponsibilitiesMaintains all enterprise SQL database operations including SQL server updates and patchesMaintains 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 systemsArchitects and implements new database systemsProactively monitors database performance and performs database tuning for optimal performanceTroubleshoots enterprise database servers and related systemsSupports system audits and provides documentation as requiredPlans testing and implementation of DR and backup processes to ensure continuous operationCreates custom queries, data-driven SSRS subscriptions, migration scripts, and executes other tasks as neededQualificationsSkills & CompetenciesSound understanding of SQL Server technology features and limitationsIn-depth, advanced knowledge of SQL Server database structures, security, storage solutions, virtualization, replication, and clusteringAbility to create performance projections based upon hardware, OS, databases design, query structures and interactions between external systems with the database serversAbility to evaluate and recommend technological changes in the database environment to support business objectivesProficiency in automation and scripting (e.g., PowerShell)Strong analytical and troubleshooting skillsExcellent verbal and written communication skills, with an ability to effectively communicate technical details to persons without technical experienceExcellent organizational and interpersonal skillsExcellent attention to detail and problem-solving skillsAbility to accurately follow documented procedures and a strong aptitude for learning new technologies as they are incorporated into the computing environmentEducation & Prior ExperienceBachelor's degree or equivalent work experienceMinimum 8 to 10 years' experience in design, development, administration, and maintenance of enterprise-level MS SQL Server database systemsDemonstrable experience configuring, operating and maintaining Microsoft SQL Server, both on-prem and cloud environmentsDemonstrable experience in database design, creating standards and processes, capacity planning, disaster recovery planning, accessibility, scalability and documentation for SQL ServerDemonstrable experience in development of complex queries, SSIS Packages and SSRS reportsThe expected pay range for this position is:$123,371- $136,060 Per yearActual pay will be adjusted based on experience, location, and other job-related factors permitted by law. Full time employees may be eligible for a discretionary bonus, health insurance with an optional HSA, short term disability, long term disability, dental insurance, vision care, life insurance, Healthcare and Dependent Care Flexible Spending Accounts, 401K, vacation, sick time, and an employee assistance program. Additional voluntary programs include: voluntary accident insurance, voluntary life, voluntary disability, voluntary critical illness and cancer insurance and pet insurance. Commuter and Transit programs may also be available in certain markets.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.