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: