Application Manager/CRM-DBA
Job Details
Management
Corporate HeadQuarters - Washington, DC
Full Time
4 Year Degree
$65,000.00 Salary/year
Day
Information Technology
Position Overview

About Equal Justice Works

The mission of Equal Justice Works is to create a just society by mobilizing the next generation of lawyers committed to equal justice. Equal Justice Works is a recognized leader in the public interest law movement. Please go to www.equaljusticeworks.org to learn more about Equal Justice Works.
 

Equal Justice Works provides a continuum of opportunity that begins with incoming law school students and extends into later careers in the profession. From advocating for law school programs that instill public service values among students, to creating summer and postgraduate public interest jobs, to addressing the staggering educational debt that blocks lawyers from going into public service, Equal Justice Works inspires and provides opportunities for the legal community to change lives, make careers, and deliver on the promise of justice for all.

 

Position Overview
The Applications Manager/ CRM-DBA is a member of the Administration unit, which serves as the primary application manager and database administrator for EJW’s SQL server databases. This would include from initial database architecture design through implementation, administration, monitoring, tuning, backup, migration, and support. The Applications Manager/CRM-Database Administrator will be responsible for the integration of new database systems and services. This position will also be responsible for designing, administering, and maintaining complex database projects as well as ensuring highly efficient operations of SQL Server and other database applications/ services.

Responsibilities

This person will support the management and administration of SQL server databases such as CRM and other business applications. This individual will collaborate with staff, senior leadership, consultants, and service providers to manage the successful implementation and management of all database services, systems and applications.

The Applications Manager/CRM-Database Administrator must have demonstrated experience managing SQL Server 2008 & 2005 database systems. This person will work with the IT Director to develop, maintain, and administer database end user training and support, as well as oversee governance of policies & procedures.

The Applications Manager/CRM-Database Administrator will have demonstrated experience in project delivery, and previous experience with database implementation and administration. This position requires strong technical and organizational skills with an emphasis on leading the translation of business requirements into solutions. Excellent writing and communication skills are necessary, as well as the ability to problem solve in a quick-paced environment and work collaboratively with others.

 

 The responsibilities of the Application Specialist/Database Administrator also include:

  • Responsible for EJW staff utilization of CRM database, including identifying ways to use CRM to support core business functions and writing standard operating procedures that outline EJW’s specific use
  • Handle system configurations and customizations, including workflows, modern flows, form & field customization, and system views & dashboards
  • Maintain and modify CRM DB import/export procedures with external data sources
  • Become the lead internal expert on CRM
  • Maintain, modify, and evaluate disaster recover procedures for CRM
  • Responsible for the data integrity of the production and the test databases
  • Support end user CRM clients
  • Responsible for the support of the CRM web modules
  • Research new modules and add-on programs and make recommendations when appropriate
  • Liaison with vendor, if required, on design enhancements or database modifications to meet new business needs
  • Perform system functionality testing and quality assurance
  • Perform database administration and maintenance on core business applications used by EJW, including but not limited to developing, running, and monitoring nightly stored procedures, scripts and/or triggers, etc.
  • Plan, schedule and implement system upgrades and/or enhancements on core business (database) applications
  • Manages the integration of the database with other related internal databases, creates and maintains documentation
  • Perform timely analysis, diagnosis, and resolution of complex database issues
  • Provide technical consulting in identifying, implementing, and supporting new database functionality
  • Create and modify reports and reporting tools for staff to query against Equal Justice Works database using both CRM and PowerBI
  • Work with staff to identify (key) data collection needs and maximize utilization of data
  • Creates, oversees, and catalogues internal reports to ensure accuracy, ease of use, and to minimize duplication of effort
  • Recommend improvements to services and systems policies and procedures
  • Proactively follow and actively promote all department policies and procedures and conduct yourself within the framework of EJW’s Core Values
  • Assist Equal Justice Works staff on implementing procedures for ensuring data integrity within core business applications
  • Ensure that all system documentation is completed and maintained on core business (database) applications
  • Provide user support on help desk requests related to business applications
  • Monitor the use of system codes, assign new codes as needed
  • Manage open issues list on system functionality bugs and work with vendor to resolve
  • Establish Equal Justice Works data entry standards, train staff on procedures and monitor compliance

 

Direct Reports

  • 1 Direct Report
Qualifications

 

Education & Experience

  • 5 or more years in Information Technology, with 3 or more years in ERP software implementation, Project Management, Requirements Planning, and Business Analysis.
  • Considerable experience with Microsoft Dynamics 365 corporate ERP system.
  • 5+years’ experience in SQL database administration, utilities, and tools
  • SSRS Report writing with Fetch XML
  • Working knowledge of relational databases and advance knowledge/programming experience with SQL is required
  • Proficiency in database design, validation, operating systems, database maintenance and reporting strongly preferred
  • Proficiency in SQL security, backup and recovery procedures preferred
  • Experience with PowerBI or similar business intelligence tools is required
  • Experience with application logging / tracing / performance monitoring and tools.
  • Understanding source code management, branching, merge strategy and tools (GIT, Bit Bucket, Azure Repos etc.)
  • Demonstrated project management skills and the ability to manage multiple, changing priorities
  • Proficiency with MS Office applications
  • Bachelor’s degree or equivalent required
  • Preferred Certifications: Microsoft Certified Database Administrator (MCDBA); Microsoft Dynamics 365 Certification

 

Location
Equal Justice Works has a policy to support employee flexibility when making decisions regard work arrangements.

A cover letter and resume are required to apply for this role. Applications without a cover letter and resume will not be considered for selection.

Apply