Job description

The law offices of Marshall Dennehey, a leading defense firm, is seeking a Junior Database Administrator for its Philadelphia, PA office. This is a hybrid role. Position Summary: The Junior Database Administrator is responsible for supporting the Firm’s Microsoft SQL Server environment and sharing the responsibility of maintaining many data-centric systems, such as the Firms’ accounting system and document management systems. RESPONSIBILITIES: • Oversee database development and modification efforts • Primary IT support of Microsoft SQL Server and SQL databases including but not limited to the following: • 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 • User and database security • Installation and configuration of new SQL Server environments as required • Relevant standards, best practices and policies for SQL and the SQL Server environment • Research applicable technologies and solutions, evaluate products and make reasonable • recommendations for improvements to IT management • Design and implement secure, efficient and accurate databases • Primary responsibility 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 • Perform other related duties as assigned REQUIRED SKILLS: • Excellent / Exceptional verbal and written communication skills· Excellent interpersonal skills: respectful and team-oriented, customer-focused, receptive to feedback and embracing continuous improvement • Excellent customer service skills • Excellent organizational skills and attention to detail • Excellent time management skills with a proven ability to meet deadlines • Strong analytical and problem-solving skills • Ability to prioritize tasks and to delegate them when appropriate • Ability to function well in a high-paced and at times stressful environment • Exceptional work ethic: strong sense of ownership of personal and team work, doing what is needed without being asked and following through • Understanding of computer languages used within database • Understanding of database design and construction • Ability to provide high-quality documentation for technical systems; experience in building and/or maintaining standards and procedures • Knowledge of one or more reporting platforms including either Crystal Reports or SSRS • Understanding of SQL, including demonstrated ability to build SQL Servers, databases, • backup and recovery plans, complex queries, integration packages (DTS/SSIS), views and stored • procedures • Proficient with Microsoft Office Suite EDUCATION AND EXPERIENCE: • Bachelor’s degree • Working Knowledge of Microsoft SQL Server 2012 or later. • Experience with PowerShell and/or .NET is a plus Marshall Dennehey is not accepting unsolicited resumes from search firms for this position. Firm offers a sound future, competitive salary and an excellent benefits package. Qualified candidates should submit cover letter and resume for consideration. We are an Equal Opportunity Employer AA/M/F/D/V. #mdadm

Requirements