Associate,Data & Technology,Database Adm

  • Ankura
  • Salt Lake City, UT, USA
  • Jun 29, 2021

Job Description

Ankura is a team of excellence founded on innovation and growth. Practice Overview At Ankura,we tailor our services to support our clients' requirements across a variety of matter sizes and types. Our team of eDiscovery and digital forensic advisors provide consulting expertise and end-to-end project management across the full information lifecycle from identification through production,including managed review for investigations,or litigation. Our consultants work collaboratively with clients to design efficient workflows,proactively identify and mitigate risk,apply quality control checkpoints,solve technological challenges,and provide cost-effective solutions. Our eDiscovery and digital forensics advisory team has significant experience with a broad range of industry-standard technologies and procedures. Also,our professionals have served in some of the largest and most globally recognized eDiscovery investigations. For every unique engagement,we carefully customize our approach to ensure an efficient and well-planned deployment of resources and technology. Role description: Ankura is looking for a Database Administrator with the desire to be a critical member of our team. Under minimal supervision,you will work as a member of the Data & Technology team,often collaborating with business clients and stakeholders to document business requirements and create database specifications. You will also be responsible for the enforcement of standards and guidelines for data access and security by teaming with analysts,developers,and end users. This role would help support our UK and Asian offices,providing a unique opportunity to support our growing international offices. *The role can be located remotely in the United States. Within your first year,you will: + Provide estimates and task planning as needed to support business cases and portfolio prioritization. + Respond to requests for database administration of corporate or business practice databases. + Work directly with applications owners and support personnel to ensure service level agreements are enabled in technical infrastructure. + Specify software and hardware in support of database requirements. + Install and deploy database solutions to achieve service level agreements. + Monitor and assess database performance and recommend tuning modifications to maintain service level agreements. + Participate in capacity planning for storage,servers and network components as needed to ensure performance and service level agreements. + Maintain up-to-date data dictionary and resolve data conflicts with users. + Provide on-call support for database support as needed to ensure operational and project objectives. + Stay current with database technology advances to enable production support and incident resolution that meets service level agreements. + Document databases in support of system development life cycle compliance. You will best be set up for success in this role if you have: + BA/BS in related field and 2 - 6 years of experience with SQL Server database technologies,including SQL,T-SQL,SSIS development,& Windows. + Strong experience of relational databases,backup and restore operations,AOAG / HA,locking,mirroring,clustering,DB logins/permissions,stored procedures,schema,triggers,database maintenance / troubleshooting activity. + Advanced knowledge of writing SQL and T-SQL scripts. + Experience with data warehouse deployment in cloud/virtual environments including mount points. + Experience with system development lifecycle methodologies,deliverables,controls Your resume will stand out if you also have: + Experience with other database technologies such as: Oracle,MySQL is plus + Experience with database monitoring tools such as Spotlight or Foglight is a plus. + MSFT SQL Server Certification preferred + Experience and knowledge of service oriented architecture preferred. + Experience with E-Discovery for kCura Relativity a significant plus + Background in system engineering (server,networking,security,etc) preferred. #LI-Remote #LI-NA1 * Ankura is proud to be an equal opportunity employer committed to fostering a diverse and inclusive environment where mutual respect and collaboration is paramount. All qualified applicants will receive consideration for employment without regard to age,race,color,religion,sex,sexual orientation,gender identity and expression,disability,protected veteran status,national origin,or any other legally protected status. Ankura Consulting Group,LLC is an independent global expert services and advisory firm that delivers services and end-to-end solutions to help clients at critical inflection points related to change,risk,disputes,finance,performance,distress,and transformation. The Ankura team consists of more than 1,500 professionals in more than 30 offices globally who are leaders in their respective fields and areas of expertise. Collaborative lateral thinking,hard-earned experience,expertise,and multidisciplinary capabilities drive results and Ankura is unrivaled in its ability to assist clients to Protect,Create,and Recover Value . For more information,please visit: http://www.ankura.com