As a member of the Programming Group, the Database Administrator will perform database administration duties across the Firm’s SQL Server environments (development, production, disaster recovery). The Database Administrator will work closely with other members of the Programming Group, System Administrators, IT Applications, Accounting Systems and Projects, IT Operations, IT Networking, and the IT Help Desk.
Reports directly to the Manager of the Programming Group and works closely with other DBAs in the team in the performance of day to day administration duties. The Database Administrator must communicate effectively with the application owners of the business services departments, peers, and vendors. Communications involves needs analysis, strategizing, describing proposed SQL Server configuration, giving timeframes, troubleshooting, documenting application/database/SQL infrastructure, involving/coordinating other systems resources where appropriate (e.g., IT Operations, System Administrators, Managers). The Database Administrator works with co-workers in NY, DC, London, and Frankfurt.
- Installs, configures, and maintains the Firm’s SQL Server environments.
- Manages database utilities and monitors the relationship between the database users and applications.
- Applies understanding of relational database concepts and query languages to design required summary or aggregation tables to support analysis.
- Liaises with technology/infrastructure staff and vendors and identifies data relationships with functional requirements.
- Maintains the Firm’s databases across multiple platforms, multiple data centers and multiple computing environments.
- Analyzes and resolves issues related to information flow and content.
- Monitors data architecture standards and conventions.
- Maintains database support tools, database tables and dictionaries, recovery and backup procedures.
- Develops and enforces standards for database use.
- Monitors database space usage and performance.
- As needed, applies SQL Server Updates and Hot Fixes, and performs SQL Server Upgrades.
- Installs, configures, and maintains the Firm’s SSRS/Power BI environments; develops reports.
- Performs needed maintenance work outside of business hours.
- Perform database administration duties, as called upon, on other third party solutions such as the Document Management System (DMS), Records Management System (RMS) and Customer Relationship Management (CRM) system.
- Maintains the Programming Group Team Site with database administration know-how, known resolutions to problems, documents related to database administration, user accounts used in databases, and information on servers (SQL Server, Application Server, Utility Server, etc.).
- As needed, participate in special projects that require database skills and technical know-how.
- Investigate and learn new tools and systems which might facilitate the efficient maintenance of SQL. Keep current on existing tools and systems. Pursue classes.
: Minimum Bachelor’s degree in Computer Information Systems, Computer Science, Database Administration or a related field of study, or comparable experience.
: Minimum three years experience with the administration of databases using MS SQL Server. Knowledge of Legal third party solutions such as iManage (DMS), iManage Records Manager (RMS), InterAction (CRM), Power BI is a preference.
Skills and Abilities
: The individual must have strong database administration skills; knowledgeable of client/server technologies, and relational database design; and an understanding of the interdependence of programs. He/she must possess solid communication skills, both oral and written. He/she must have a dedication to quality, willingness to learn, and the ability to wear many hats to resolve issues. The individual must be able to work effectively with other team members towards a common goal and on multiple projects at the same time.
: Individual must have solid experience with MS SQL Server, SSRS/Power BI, cluster/VM technology, and Windows operating systems including a basic understanding of Active Directory.