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.
Before applying for this position, please ensure you can answer "Yes" to all of the following questions :
- Can you commit to a hybrid work schedule, including mandatory weekly in-office presence at our Philadelphia location?
- Are you legally authorized to work in the United States without requiring visa sponsorship now or in the future?
- Are you available to complete a technical test within the next 2-3 days?
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 effortsPrimary 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 checksDatabase design, tuning and troubleshooting for SQL applicationsUser and database securityInstallation and configuration of new SQL Server environments as requiredRelevant standards, best practices and policies for SQL and the SQL Server environmentResearch applicable technologies and solutions, evaluate products and make reasonable recommendations for improvements to IT managementDesign and implement secure, efficient and accurate databasesPrimary responsibility for data integration and data transfer jobs using SSIS, DTS and other technologies as neededAssist with support of the Firm's accounting system and related applications such as the data warehouse, conflicts, collections and time entry applicationsAssist IT and Finance personnel with complex database queries and financial reports as neededMaintain current and accurate knowledge of data storage and management best practicesDevelop and maintain documentation and standardsPerform other related duties as assignedREQUIRED SKILLS :
Excellent / Exceptional verbal and written communication skillsExcellent interpersonal skills : respectful and team-oriented, customer-focused, receptive to feedback and embracing continuous improvementExcellent customer service skillsExcellent organizational skills and attention to detailExcellent time management skills with a proven ability to meet deadlinesStrong analytical and problem-solving skillsAbility to prioritize tasks and to delegate them when appropriateAbility to function well in a high-paced and at times stressful environmentExceptional work ethic : strong sense of ownership of personal and team work, doing what is needed without being asked and following throughUnderstanding of computer languages used within databaseUnderstanding of database design and constructionAbility to provide high-quality documentation for technical systems; experience in building and / or maintaining standards and proceduresKnowledge of one or more reporting platforms including either Crystal Reports or SSRSUnderstanding of SQL, including demonstrated ability to build SQL Servers, databases, backup and recovery plans, complex queries, integration packages (DTS / SSIS), views and stored proceduresProficient with Microsoft Office SuiteEDUCATION AND EXPERIENCE :
Bachelor's degreeWorking Knowledge of Microsoft SQL Server 2012 or later.Experience with PowerShell and / or .NET is a plusMarshall 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
