Database Applications Administrator

Dinsmore & Shohl Llp - Cincinnati, OH

Full-time - Mid Level

Cincinnati, OH

501-1,000 employees

Professional, Scientific, and Technical Services

About the position

Dinsmore & Shohl LLP is seeking a Database Applications Administrator (DBAA) to join our team in Cincinnati, OH. This full-time position reports directly to the Director of Data and Digital Services. The DBAA will be responsible for the installation, management, support, and maintenance of the firm's SQL Server database environment. This role is critical in ensuring that sensitive business data is maintained and readily available in accordance with firm requirements and best practices. The DBAA will also provide SQL and data analytics support to application support staff and other personnel within the firm. The successful candidate will be tasked with the installation and configuration of Microsoft SQL Server and Reporting Services on server hardware, adhering to documented standards. Responsibilities will include the creation, configuration, and restoration of user databases, performing data imports and exports, and developing scripts or stored procedures to automate complex tasks. The DBAA will manage and monitor database backup jobs, routinely testing backup and restoration processes to meet the firm's Disaster Recovery and Business Continuity objectives. In addition to these responsibilities, the DBAA will maintain optimal database and log file sizes, recommend and implement security measures to protect confidential data, and create reports using MS Reporting Services. The role also involves the creation of SQL Server objects such as Stored Procedures, Views, and Linked Servers, as well as identifying and escalating technical issues to ensure long-term resolutions. Staying current on technology trends and making recommendations for upgrades or improvements to existing technology is also a key aspect of this position. The DBAA will collaborate with internal development staff on the design and creation of new databases and provide support to firm personnel or vendors requiring database access. Maintaining positive relationships with firm personnel and clients while observing confidentiality in all matters is essential.

Responsibilities

• Installation and configuration of Microsoft SQL Server and Reporting services on server hardware using documented standards
• Creation, configuration and/or restoration of user databases
• Performing database data imports and exports
• Creation of scripts or stored procedures to automate repetitive or complex tasks
• Creation, management and monitoring of database backup jobs
• Testing backup and restoration processes routinely to ensure Disaster Recovery and Business Continuity objectives for the firm are met
• Maintaining database and log file size for optimal disk capacity
• Recommending and implementing security measures to ensure confidential data stored in databases and SQL-based applications is secured
• Creation of reports utilizing MS Reporting Services for regular reporting needs
• Creation of SQL Server objects such as Stored Procedures, Views and Linked Servers
• Identifying and escalating technical issues; taking corrective actions to ensure long term resolution
• Staying current on technology trends and making recommendations for upgrade paths or improvements of existing technology
• Aiding in the optimization of SQL server and/or queries to resolve performance issues
• Working with internal development staff on the design and creation of new databases
• Providing support and/or working with firm personnel or vendors who need or require access to databases
• Maintaining positive contact with firm personnel and clients, observing confidentiality in all firm and client matters.

Requirements

• Good written and oral communication skills
• Minimum five years supporting and maintaining MS SQL Environment
• Be a contributing member in a team-oriented environment
• Expert understanding of MS Transact-SQL
• Solid understanding and background of various SQL Server versions
• Experience with Enterprise Manager and SQL Management Studio
• Proficiency in SQL Server Reporting Services (SSRS)
• Experience with SQL Server Integration Services (SSIS)
• Knowledge of legal environment and applications (preferred)
• Experience with database hardening (preferred)

Nice-to-haves

• Knowledge of legal environment and applications
• Experience with database hardening