Marshall Dennehey
Junior Database Administrator (Hybrid) - Philadelphia, PA
Marshall Dennehey, Phila, Pennsylvania, United States, 19117
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.
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.