What are the responsibilities and job description for the SQL Enterprise Applications Engineer - SSRS / SSIS position at GTN Technical Staffing?
SQL Enterprise Applications Engineer
Location : New Jersey
Work Schedule : On-Site
Position Type : Full-Time
POSITION DETAILS
GTN Technical Staffing is seeking an Enterprise Applications Engineer with a strong emphasis on SQL development, administration, and optimization to join our IT team. This role will be instrumental in maintaining and enhancing the firm’s enterprise applications, with a primary focus on SQL Server administration, query optimization, SSIS / SSRS reporting, and database performance tuning. The ideal candidate will work closely with cross-functional teams, ensuring seamless integration and performance of critical business applications.
Key Responsibilities
SQL Development & Administration :
Develop, optimize, and maintain SQL queries, stored procedures, and views.
- Administer and maintain SQL Server databases, ensuring high availability, security, and performance.
- Design and maintain SSRS reports and SSIS ETL processes to support business intelligence and data integration needs.
- Monitor SQL Server performance, conduct index tuning, and troubleshoot query inefficiencies.
Enterprise Applications Support & Integration :
Manage, support, and enhance business-critical applications, including Elite 3E, Intapp (Time, Risk, Intake), Concur, Iridium, and other finance, legal, and marketing tools.
System Optimization & Maintenance :
Execute routine SQL Server maintenance, including backups, index rebuilds, and security updates.
Documentation & Process Improvement :
Create and maintain technical documentation related to database structures, stored procedures, and system integrations.
TECHNICAL QUALIFICATIONS
Salary : $135,000 - $160,000
