Icon hamburger
US
What job do you want?
Apply to this job.
Think you're the perfect candidate?
Apply Now
Thumsup

You’re being taken to an external site to apply.

Enter your email below to receive job recommendations for similar positions.
I2w45w6y5pr06218f2p

Senior SQL Data Architect

Insight Global Philadelphia Full-Time
Apply Now
Our client, a global law firm in Center City, Philadelphia, is looking for a Senior Data Architect to join its mid-sized IT Department. He/she will own the firms existing data systems by architecting, designing, installing and providing operational support for all database environments. Overall, he/she provide firm management and other IT teams with a high level vision of what their data systems should look like and how data should flow. He/she will work directly with development teams to design database schemas when a new application is built and own the firms existing data integration system used to create, modify and maintain ETL processes. He/she will provide support for the firms SQL databases, including performance tuning and optimization, database integrity, replication and mirroring issues and index management and statistics. Lastly, he/she will tune T-SQL queries to improve performance, and work with developers to help improve performance by tweaking queries or modifying indexes.
  • 5+ years of experience with SQL Server (supporting it, disaster recovery & high availability, performance tuning of servers, etc.)
  • 1+ year of experience building a data warehouse from scratch and designing database schemas for applications
  • 3+ years of experience developing T-SQL scripts, testing and debugging in large software application systems
  • 1+ year of lead or management experience
  • 3+ years of experience in SSIS (creating, modifying and maintaining ETL processes)


  • Experience with IntApp Integration Builder
  • Previous experience working at a law firm

Skills required

Relational Databases
Data Architecture
Extract Transform Load (Etl)
Metadata
Teradata Sql
Data Migration
Apply to this job.
Think you're the perfect candidate?
Apply Now

Help us improve CareerBuilder by providing feedback about this job: Report this job

Report this Job

Once a job has been reported, we will investigate it further. If you require a response, submit your question or concern to our Trust and Site Security Team

Job ID: PHL-320147

CAREERBUILDER TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Insight Global is a national staffing and services company that specializes in sourcing information technology, accounting, finance, and engineering professionals and delivering service-based solutions to Fortune 1000 clients. Insight Global completes more than 33,000 placements annually in short-term, long-term, contract-to-hire, and direct placement positions through our network of more than 40 regional offices across the U.S. and Canada. The company has been ranked one of the fastest growing staffing firms for the past 10 consecutive years and named the 3rd largest IT staffing firm in America by Staffing Industry Analysts.

View the full profile