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
Greenberg Traurig, LLP (GT) has approximately 2,650 attorneys in 45 locations in the United States, Latin America, Europe, Asia, and the Middle East. It was founded in 2003, and is headquartered in Amsterdam, North Holland, NL, with a workforce of 51-200 employees. Its website is https://www.gtlaw.com/en/locations/amsterdam.Company H1B Sponsorship
Greenberg Traurig Amsterdam has a track record of offering H1B sponsorships, with 1 in 2020. Please note that this does not guarantee sponsorship for this specific role.