Marshall Dennehey

Database Administrator

• Oversee database development and modification efforts
• Primary IT support of Microsoft SQL Server and SQL databases
• Ensure data integrity and availability including monitoring and creation of backups and maintenance of High Availability server installations
• Database maintenance including sizing and provisioning, index maintenance and monitoring of logs and consistency checks
• Database design, tuning and troubleshooting for SQL applications
• Database administration for both relational and non-relational database systems
• Manage SQL Server databases inside Azure and other Data platforms
• User and database security management
• Installation and configuration of new SQL Server environments as required
• Research applicable technologies and solutions, evaluate products and make recommendations
• Work with software engineering teams to build solutions for relational and non-relational database systems
• Responsible for data integration and data transfer jobs using SSIS, DTS and other technologies as needed
• Assist with support of the Firm’s accounting system and related applications such as the data warehouse, conflicts, collections and time entry applications
• Assist IT and Finance personnel with complex database queries and financial reports as needed
• Maintain current and accurate knowledge of data storage and management best practices
• Develop and maintain documentation and standards

Junior Database Administrator