Junior Database Administrator (Hybrid) – Philadelphia, PA

Marshall Dennehey


Date: 19 hours ago
City: Philadelphia, PA
Contract type: Full time
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
    • Database administration, for both relational and non-relational database systems
    • SQL Server databases inside Azure and other Data platforms
    • 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
    • Work with Software engineering teams to build solutions for both relational and non-relational database systems that add value to service offerings
    • Responsible for data integration, 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

    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
    • Perform other related duties as assigned
    • 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 and the 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

    How to apply

    To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

    Post a resume