Senior Enterprise Database Administrator
Senior Enterprise Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Senior Enterprise Database Administrator
Dentons US LLP is currently recruiting for a Senior Enterprise Database Administrator to be based in the United States. The Enterprise Database Administrator is directly involved in the execution of tactical and strategic projects in direct support of core business functions. The successful candidate will take ownership of resolution of production issues implementation and maintenance of the overall data services infrastructure.
Responsibilities
- Assess and develop long-term strategic goals for production databases in conjunction with data owners.
- Design and implement redundant systems policies and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
- Work with the Infrastructure teams to ensure databases and critical data are properly backed up and protected in accordance with the needs of the applications primary stakeholder and the firms disaster recovery and data retention policies.
- Provide day-to-day support for the firms SQL systems and applications including monitoring database health to ensure a stable environment as well as diagnosing and resolving database access and performance issues.
- Gather requirements and translate them into data distribution and utilization needs; design databases meeting specifications addressing content management content indexing reporting and workflow requirements.
- Support Applications implementation projects from initiation to completion.
- Installation of a middle tier application layer when required.
- Provide third line applications support and database administration support; troubleshoot and resolve escalated issues.
- Gather requirements and translate them into data distribution and utilization needs; design databases meeting specifications addressing content management content indexing reporting and workflow requirements.
- Design implement and maintain cloud-based database systems when required.
- Plan and coordinate data migrations between systems.
- Develop implement and maintain change control and testing processes for modifications to databases.
- Implement support and troubleshoot various authentication protocols to include Oauth2 SAML and Single Sign-on trusts
- Follow enterprise procedures such as monthly patching change and inventory requests health checks and escalation and outage protocols
- Monitor system performance identify potential bottlenecks or issues and implement necessary optimizations or upgrades to ensure smooth operations
- Conduct regular system audits security reviews and data integrity checks to maintain the integrity and confidentiality of the firms documents
- Document system configurations processes and troubleshooting steps to create comprehensive technical documentation for future reference and training purposes
- Design implement and maintain cloud-based database systems when required.
- Ensure all proposed changes to the live application or infrastructure environments are suitably tested with roll-back capability and change controls exercised accordingly.
- SQL High-Availability Cluster Implementation configuration and management.
- Provide timely responses and resolutions towards database backup restore mirroring and synchronization requests.
- Contribute to patching change control maintenance activities and on-call rotation.
- You will work closely with the Architecture team to design and build enterprise solutions
- Have a thorough understanding of the Firms technology goals and objectives
- Assist with end user issues and service desk tickets where Level 3 support is required
- Participate in outage calls where Enterprise Applications team representation is required or requested
- Other duties as assigned to fully meet the requirements of the position.
Experience & Qualifications
- Bachelors degree in business computer science information systems or related certifications.
- Law firm or professional services experience preferred.
- Proven experience as technical SME in a 24 x 7 global support environment.
- Expert understanding of SQL Clustering/High-Availability Implementations.
- Expert understanding of concepts of High Availability and Disaster Recovery with respect to database systems.
- Strong understanding of cloud database technologies specifically Microsoft Azure.
- Strong understanding of the client/server application stack.
- Working knowledge of Transact-SQL Stored Procedures SQL Mail SSRS and triggers.
- Working knowledge of Windows Server IIS DNS DHCP and Active Directory.
- Experience supporting standard legal systems preferred (iManage DMS Elite Interaction).
- Experience installing managing and troubleshooting enterprise applications
- Experience with a systematic approach towards software testing
- Ability to conduct and direct research into IT issues and products as required
- SQL administration experience in versions 2012 forward with confidence in converting databases to upper versions
- Ability to document processes and procedures including technical diagrams towards organizational data flow.
- Understands the need for documentation and well-defined procedures.
- Able to interact positively and with tact with all levels and be a good team player.
- Able to demonstrate excellent client/customer facing skills.
- Strong problem solving and analytical skills; can clearly explain and present problems and issues to others and contribute to their resolution.
- Able to make decisions and remain calm while under pressure particularly when dealing with difficult situations.
- Methodical approach to work with a strong focus on accuracy and quality.
- Able to work under pressure to meet tight project deadlines and can adapt to differing demands; prioritizing tasks where appropriate.
- Demonstrates confidence and resilience to overcome obstacles to deliver what is required.
- Excellent written and verbal communication skills.
Salary
Chicago and DC Only DOE: $124700 - $163600
Dentons US LLP offers a competitive salary and benefits package including medical dental vision 401k profit sharing short-term/long-term disability life insurance tuition reimbursement paid time off paid holidays and discretionary bonuses.
Dentons US LLP is an Equal Opportunity Employer - Disability/Vet. Pursuant to local ordinances we will consider for employment qualified applicants with arrest and conviction records.
If you need any assistance seeking a job opportunity at Dentons US LLP or if you need reasonable accommodation with the application process please call our Talent Acquisition Specialist at 1 or contact us at
About Dentons
Redefining possibilities. Together everywhere. For more information visit
Required Experience:
Senior IC
Employment Type
Full Time
