Sr SQL DBA/Developer

InSource - Philadelphia, PA

Full-time - Mid Level

Remote - Philadelphia, PA

Insurance Carriers and Related Activities

About the position

The Sr SQL DBA/Developer will collaborate with various IT teams to optimize application and database performance in a hybrid work environment. This role requires extensive experience in database administration and development, particularly with Microsoft SQL Server, and involves working with high transaction volumes in large-scale environments.

Responsibilities

• Advanced Database Development experience with Microsoft SQL Server Database.
• Senior level Database Administration support including Installing, Upgrading, Backup and Recovery, Configuring, SSMS, SSIS, SSRS, Always on Failover Clustering, Performance Tuning, and Troubleshooting.
• Evaluating SQL Server Query performance and providing guidance on query redesign, index modifications, and database configuration changes.
• Utilizing tools like Idera SQL Diagnostic monitor, Query Store, SQL Server Profiler, Dynatrace, and Query plans to evaluate and tune database queries.
• Creation of SQL Server performance documentation and best practices for Database Development and Administration teams.
• Participate in evaluations and recommendations for database solutions based on business requirements and user needs.
• Provide performance monitoring and measuring of all database components and input on capacity and performance planning.
• Escalate issues for technical assistance as required.
• Participate in basic to moderately complex database tuning efforts as required.
• Apply administration best practices in daily operations.

Requirements

• BA/BS in Computer Science, Information Systems, or equivalent work experience.
• 10+ years related IT experience as a SQL Server database administrator.
• Familiarization with related technologies and tools.
• Industry-recognized technical certification preferred (e.g. SQL, MCDBA).
• Working knowledge of database file structure, retrieval and access methods, and performance analysis.
• Demonstrated analytical skills and excellent written and verbal communication skills.
• Ability to work effectively with clients and IT associates in a collaborative manner.
• Basic understanding of the development process and business process.
• Database Development experience in large scale environments with high transaction volumes such as ecommerce or banking.

Nice-to-haves

• Extensive Java experience.
• Experience with Mule.

Benefits

• Hybrid work environment (1 day onsite, 4 days remote).
• Contract-to-Hire opportunity.