Marshall Dennehey-posted 3 months ago
Full-time • Entry Level
Philadelphia, PA
1,001-5,000 employees

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.

  • 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
  • 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
  • Working Knowledge of Microsoft SQL Server 2012 or later
  • Experience with PowerShell and/or .NET is a plus
  • Competitive salary
  • Excellent benefits package
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service