Vacancy expired!
About Kirkland & Ellis
At Kirkland & Ellis, we are united in our ambition and drive to move forward. We share core values that help us achieve excellence: collaboration, talent empowerment, service, inclusion, respect and gratitude. Our people are our greatest asset, and we invest in the brightest talent and encourage a diversity of perspectives and strengths to create dynamic teams that operate at the pinnacle of their field. Our talented professionals show up every day knowing they will engage in meaningful work, continuous learning and professional development. As one of the world's leading law firms, we serve a broad range of clients with market-leading practices in private equity, M&A and other complex corporate transactions; investment fund formation and management; restructurings; high-stakes litigation and trials; and government, regulatory and internal investigations. We handle the most complicated and sophisticated legal matters because we don't just meet industry standards, we create them. We bring innovation and entrepreneurialism to every engagement and, as a result, have long-standing client relationships with leading global corporations and financial sponsors. With 6,500 employees (including 3,000+ lawyers) operating from 18 offices across the United States, Europe and Asia, we are one of the largest law firms in the world and a top financial performer. Essential Job Functions The Senior Database Administrator I is responsible for the deployment, administration, and maintenance of all databases hosted on the Microsoft SQL Server platform. This person will work as a member of the firm wide database administration team which provides advanced Level 3 support for the SQL Server environment. They will investigate operational or systematic problems, provide resolution using advanced analytical skills and tools as necessary as well as be responsible for analyzing database performance issues, recommending tuning changes to improve performance. They will assist various project team(s) in completing project(s) with an advanced level of complexity. Essential Functions:- Support, administer, and maintain development, test, and production environments.
- Work with project teams comprised of project managers, developers, application vendors, application engineers, and application users to provide DBA support for database deployments and upgrades.
- Create and maintain SQL Server Integration Services (SSIS) packages and/or Talend jobs.
- Review, deploy, and administer security for SQL Server Reporting Services (SSRS) reports.
- Troubleshoot server and database performance problems and identify solutions to resolve the problems.
- Administer SQL Server security and protect sensitive data.
- Adhere to the Firm's IT Service Delivery standards and Change Control processes.
- Adhere to the Firm's Security and Governance requirements across all administered applications.
- Develop and maintain troubleshooting, configuration, and integration documentation for administered systems.
- Function as a primary or backup DBA for assigned applications. Have a working knowledge of all database applications.
- Work with server engineers, storage engineers, and network engineers to resolve issues and prevent downtime.
- Provide 24x7 operational support. On-call support responsibilities are rotated among the members of the DBA team.
- Database administration experience with SQL Server 2014, 2016, 2017, and 2019.
- Proficiency with Transact-SQL including the ability to write, debug, and maintain scripts, stored procedures, functions, and views.
- Experience configuring and maintaining AlwaysOn Availability Groups, replication, log shipping, and database mirroring.
- Experience installing and configuring SQL Server on virtual machines and stand-alone servers.
- Experience developing SSIS packages.
- Experience optimizing and administering SSRS reports.
- A solid understanding of normalized database design and modeling.
- A working knowledge of SolarWinds, RedGate, and Idera database tools.
- Proficiency with PowerShell scripting.
- Experience with SSRS report development.
- Experience with PostgreSQL
- Experience with Talend Data Fabric
- Microsoft SQL Server (Enterprise, Standard, & Express editions)
- Database Engine, Integration Services, Reporting Services
- AlwaysOn Availability Groups, Replication, Log Shipping, & Database Mirroring
- Transact-SQL
- Microsoft Windows Server (Enterprise & Standard editions)
- SAN Storage
- Third-party SQL Server Tools & Utilities
- Microsoft Office (including Visio)
- Structured Programming or Scripting (e.g. PowerShell)
- Team Foundation Studio
- FTP & sFTP
- Talend Data Fabric
- SQL Server 2014, 2016, 2017 & 2019
- SQL Server Integration Services 2016 & 2017
- SQL Server Reporting Services (SSRS) 2019
- SQL Server AlwaysOn 2014, 2016, 2017 & 2019
- Transactional & Merge Replication
- Synchronous & Asynchronous Database Mirroring
- Transact-SQL scripts, stored procedures, functions, & views
- Windows Server 2016 & 2019
- Server Virtualization Solutions such as Hyper-V & VMWare
- SolarWinds SQL Sentry
- Idera Admin Toolset
- RedGate SQL Monitor, SQL Compare, & SQL Data Compare
- CozyRoc SSIS+
- Microsoft Office 365
- PowerShell
- A high-speed internet connection is required to connect to our systems. At an undetermined point in the future, we may once again be required to work in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, and filing cabinets.
Vacancy expired!