Apply on Employer Site

Marshall Dennehey · 3 months ago

Junior Database Administrator (Hybrid) – Philadelphia, PA

Philadelphia, PA

Full-time

Hybrid

New Grad, Entry Level

Marshall Dennehey is a leading defense firm seeking a Junior Database Administrator for its Philadelphia office. The role involves supporting the Firm’s Microsoft SQL Server environment and maintaining various data-centric systems, including the Firm's accounting and document management systems.

Law EnforcementLegalProfessional Services

No H1B

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

Qualification

Microsoft SQL ServerSQLSSISDTSReporting platformsCustomer service skillsAnalytical skillsPowerShell.NETCommunication skillsInterpersonal skillsOrganizational skillsTime management skillsProblem-solving skillsDocumentation skills

Required

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?

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

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

Bachelor's degree

Working Knowledge of Microsoft SQL Server 2012 or later