Note: The job is a remote job and is open to candidates in USA. Greenberg Traurig (GT) is a global law firm with locations across the world, offering an exciting employment opportunity. They are seeking a Senior Database Administrator to architect, administer, and optimize enterprise SQL Server databases, ensuring security, reliability, and scalability while 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

• We offer competitive compensation and an excellent benefits package
• Opportunity to work within an innovative and collaborative environment

Company Overview

Company H1B Sponsorship