Application Architect III

Immediate need for a talented SQL Developer This is a 18-month contract opportunity with long-term potential and is in Pennington, NJ/ Charlotte, NC (Hybrid). Please review the job description below and contact me ASAP if you are interested.
 
Job ID: 25-94152

Pay Range: $70 - $72/hour.  Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
 
Key Responsibilities:

• Database Development & Design Leadership: Lead the design, development, enhancement, and maintenance of MS SQL Server (2012 and above) databases using advanced T-SQL, including complex stored procedures, functions, views, triggers, cursors, tables, indexes, and partitioned tables, ensuring scalable and efficient data architecture to support mission-critical reporting and dashboard needs.
• Performance Optimization & Data Integrity: Perform intensive SQL query optimization, tuning, troubleshooting, and large-scale data processing to ensure high performance and reliability, including database backup, restore, log shipping, and mirroring strategies, while maintaining data accuracy through robust validation and transformation techniques.
• ETL, Integration & Automation: Develop and manage ETL pipelines using SSIS and Autosys to ingest and transform data from multiple upstream systems and file formats (XML, CSV, etc.), support automated scheduling, enable seamless data movement across platforms, and support reporting through SSRS, Tableau, and C# scripting.

Key Requirements and Technology Experience: 

• Key Skills; SQL, T-SQL, SSIS, ETL
• Financial services
• Must Have: 7 – 10 years of SQL Developer in Database development.
• 8 years of SQL experience
• 5 years of ETL.
• 5 years of SSIS.

Our client is a leading Financial Industry; we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.
 
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
 
By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy .
 
#BOAJ2W:CB3