A large civil defense firm located in Philadelphia, PA is seeking a full-time Junior Database Administrator. This position is remote work eligible. The candidate must reside in PA, NJ, NY, DE, CT or FL.
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
PHYSICAL REQUIREMENTS:
- Prolonged periods of sitting at a desk and working on a computer
- Repetitive movements that may include the wrists, hands and/or fingers
- Must be able to understand the speech of another person and comprehend detailed information
- Must be able to speak accurately, clearly and quickly so listens can understand
- Must be able to see details of objects that are less than a few feet away
- Visual acuity to determine the accuracy, neatness and thoroughness of work assigned; and perform activities including but not limited to viewing a computer terminal, extensive reading and preparing reports
- Must be able to push, pull and lift objects up to 15 pounds
Firm 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, resume and salary requirement for consideration.
We are an Equal Opportunity Employer AA/M/F/D/V.
Job Type: Full-time
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Life insurance
- Paid time off
- Vision insurance
Schedule:
Work Location: Hybrid remote in Philadelphia, PA 19103