Database Developer / Engineer

Full-time - Mid Level

Philadelphia, PA

Administrative and Support Services

About the position

We are seeking a talented and passionate Database Developer/Engineer to join our dynamic Tech Services team. This permanent position involves designing, developing, and maintaining our database systems, utilizing cutting-edge technologies. The ideal candidate will possess a deep understanding of database structures, theories, principles, and practices, and will have the opportunity to make significant contributions to our organization.

Responsibilities

• Develop, implement, and optimize stored procedures and functions using T-SQL.
• Analyze existing SQL queries for performance improvements.
• Develop procedures and scripts for data migration.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide technical assistance and support for incoming queries and issues related to database systems.
• Collaborate with application developers to determine the best solutions to meet project goals.
• Develop and maintain data warehouses for business intelligence efforts.
• Participate in all aspects of the software development lifecycle, including requirements analysis, design, coding, testing, debugging, implementation, and support.
• Ensure that all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO).
• Test backups to ensure we can meet the business' Recovery Time Objectives (RTO).

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience in database development and support in MS SQL Server environments.
• Strong experience with database technologies (ElasticSearch, Solr, Stored Procedures, NoSQL Databases, PostgreSQL).
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
• Experience in implementing operational automation using scripts.
• Knowledge of indexes, index management, and statistics.
• Experience working with Windows server, including Active Directory and proper disk configurations.
• Good communication and documentation skills.
• Strong problem-solving and analytical skills.
• Ability to work both independently and in a team-oriented, collaborative environment.

Benefits

• Competitive Base Salary
• Company paid health plan for employees
• Flexible Hours
• Very generous PTO
• Dental and Vision, FSA, HSA
• Small team, Remote FIRST culture!
• Many more great perks!