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 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
