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