Note: The job is a remote job and is open to candidates in USA. Greenberg Traurig (GT) is a global law firm with an exciting opportunity for a Senior Database Administrator. The role involves architecting, administering, and optimizing enterprise SQL Server databases while ensuring security, reliability, and scalability, and collaborating with IT teams to support business operations.

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

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
• Bachelor's degree or equivalent work experience
• 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

Benefits

• 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
• Employee assistance program
• Voluntary accident insurance
• Voluntary life
• Voluntary disability
• Voluntary critical illness and cancer insurance
• Pet insurance
• Commuter and Transit programs may also be available in certain markets

Company Overview

Company H1B Sponsorship