SQL DBA in Chicago, IL at APEX Systems

Date Posted: 1/14/2020

Job Snapshot

Job Description

Job #:  1039076

SQL DBA Job Description
Senior Enterprise Database Administrator to be based in Canada. This position reports to the Enterprise Applications Infrastructure Lead. The Senior 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.
  • 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 application’s primary stakeholder and the firm’s disaster recovery and data retention policies.
  • Provide day-to-day support for the firm’s 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.
  • Plan and coordinate data migrations between systems.
  • Develop, implement, and maintain change control and testing processes for modifications to databases.
  • 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.
  • Support Applications implementation projects from initiation to completion.
  • Installation of middle tier application layer when required.
  • Provide third line applications support and database administration support; troubleshoot and resolve escalated issues.
  • Provide timely responses and resolution towards database backup, restore, mirroring, and synchronization requests.

Experience and qualifications
  • Bachelor’s 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 (Microsoft Azure, Amazon Web Services, etc…).
  • 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).
  • SQL administration experience in versions 2000 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.

EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at 844-463-6178.