Dinsmore Inc
Database Applications Administrator
Dinsmore Inc, Cincinnati, Ohio, United States, 45208
With over 725 lawyers in 31 offices across the U.S., Dinsmore is committed to maintaining and developing a strong market profile. This is both to facilitate an understanding of the firm's capabilities by current and prospective clients, and to support the recruitment of talented attorneys and business professionals.
WE DO NOT OFFER SPONSORSHIP.
Reporting to the Director of Data and Digital Services the Database Applications Administrator (DBAA) is responsible for the installation, management, support and maintenance of the firms SQL Server database environment. This role is responsible for ensuring critical and sensitive business data is maintained and available based on firm requirements and best practices. The DBAA is also responsible for providing SQL and data analytics support to application support staff and other firm personnel.
Responsibilities
Installation and configuration of Microsoft SQL Server and Reporting services on server hardware using documented standardsCreation, configuration and/or restoration of user databasesPerforming database data imports and exportsCreation of scripts or stored procedures to automate repetitive or complex tasksCreation, management and monitoring of database backup jobsTest backup and restoration processes routinely to ensure Disaster Recovery and Business Continuity objectives for the firm are metMaintaining database and log file size for optimal disk capacityRecommends and implements security measures to ensure confidential data stored in databases and SQL-based applications is securedCreation of reports utilizing MS Reporting Services for regular reporting needsCreation of SQL Server objects such as Stored Procedures, Views and Linked ServersIdentify and escalate technical issues; take corrective actions to ensure long term resolutionStay current on technology trends and make recommendations for upgrade paths or improvements of existing technologyAid in the optimization of SQL server and/or queries to resolve performance issuesWork with internal development staff on the design and creation of new databasesProvide support and/or work with firm personnel or vendors who need or require access to databasesMaintains positive contact with firm personnel and clients.Observes confidentiality in all firm and client matters.Other duties as assignedRequirements
Good written and oral communication skillsMinimum five years supporting and maintaining MS SQL EnvironmentBe a contributing member in a team-oriented environmentExpert understanding of MS Transact-SQLSolid understanding and background of various SQL Server versionsEnterprise Manager and SQL Management StudioSQL Server Reporting Services (SSRS)SQL Server Integration Services (SSIS)Knowledge of legal environment and applications, preferredExperience with database hardening, preferredEqual Opportunity Employer
Other details
Pay Type Salary
Apply Now
WE DO NOT OFFER SPONSORSHIP.
Reporting to the Director of Data and Digital Services the Database Applications Administrator (DBAA) is responsible for the installation, management, support and maintenance of the firms SQL Server database environment. This role is responsible for ensuring critical and sensitive business data is maintained and available based on firm requirements and best practices. The DBAA is also responsible for providing SQL and data analytics support to application support staff and other firm personnel.
Responsibilities
Installation and configuration of Microsoft SQL Server and Reporting services on server hardware using documented standardsCreation, configuration and/or restoration of user databasesPerforming database data imports and exportsCreation of scripts or stored procedures to automate repetitive or complex tasksCreation, management and monitoring of database backup jobsTest backup and restoration processes routinely to ensure Disaster Recovery and Business Continuity objectives for the firm are metMaintaining database and log file size for optimal disk capacityRecommends and implements security measures to ensure confidential data stored in databases and SQL-based applications is securedCreation of reports utilizing MS Reporting Services for regular reporting needsCreation of SQL Server objects such as Stored Procedures, Views and Linked ServersIdentify and escalate technical issues; take corrective actions to ensure long term resolutionStay current on technology trends and make recommendations for upgrade paths or improvements of existing technologyAid in the optimization of SQL server and/or queries to resolve performance issuesWork with internal development staff on the design and creation of new databasesProvide support and/or work with firm personnel or vendors who need or require access to databasesMaintains positive contact with firm personnel and clients.Observes confidentiality in all firm and client matters.Other duties as assignedRequirements
Good written and oral communication skillsMinimum five years supporting and maintaining MS SQL EnvironmentBe a contributing member in a team-oriented environmentExpert understanding of MS Transact-SQLSolid understanding and background of various SQL Server versionsEnterprise Manager and SQL Management StudioSQL Server Reporting Services (SSRS)SQL Server Integration Services (SSIS)Knowledge of legal environment and applications, preferredExperience with database hardening, preferredEqual Opportunity Employer
Other details
Pay Type Salary
Apply Now