Click here to login or register
Reference # : 18-00077 Title : SQL Server Data Developer/DBA
Location : Horsham, PA
Experience Level : Start Date : 10/17/2018  
Description

Hello, this is a heard-up on an immediate opening (6-month Contract-to-Hire) with Toll Brothers for a SQL Server Database Developer/DBA.  The selected candidate will provide SQL Server Database Architecture, Design, Development, and back-up DBA expertise for our clients SQL Server Database and Data Integration environments.  Interested candidates should forward their resume to: skirkwood@htpartners.com

Thanks- Shaun (ph: 847-202-6567) - see ad below

 

Needed: SQL Server Database Developer/DBA; 6-month Contract-To-Hire; Horsham, PA 19044; skirkwood@htpartners.com

 

*Please note that this is a Contract-to-hire position, U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.***Local Candidates preferred, 2nd round in person interviews will be required.**

 

Horizon Technology Partners has an immediate opening for an experienced SQL Server Database Developer/DBA. Your skills are needed to assist a publicly traded residential construction company located in Horsham, PA 19044You will be called upon to provide SQL Server Database Architecture, Design, Development, and back-up DBA expertise for our clients SQL Server Database and Data Integration environments.  Activities will include gathering and creating technical specifications, process flow, data integration diagrams and support documentation. You will also assist in establishing and maintaining guidelines, data processing and programming best practices as well as lead and participate in reviews and quality assurance processes to ensure that the data architectures and standards are being enforced. Knowledge of Salesforce and experience supporting E1 databases is a plus.

 

Activities/Knowledge required will include:

- Design and development of data models and database objects: Perform physical database design at the object level, create DDL scripts, define database snapshots, table partitions, and backup/recovery strategy

- Understating concept of Data Warehouse, Data Marts

- Design, develop and maintain ETL processes to load Data Warehouse, Data Marts

- Creation of SSIS packages to load, transform and process data

- Development and support Microsoft MDM system

- Develop and enhance TSQL stored procedures, triggers, functions

- Resolving database production issues, code troubleshooting

- Database tuning and monitoring: instance performance monitoring, table space utilization, schema object management, database capacity planning, *bottlenecks* and *offensive* T-SQL activity monitoring and resolution

- Release database changes into production

- Migration SQL Server into upcoming version: Currently using SQL Server 2012/2014 and will be migrating to 2017

- Interface with internal clients to gather requirements and provide coding and development as well as assist developers with application design and performance tuning.

- Develop scripts to automate administration and management of the environment

- Understanding database administration support including backups, recovery, security

- Backup for production DBA responsibilities

- Create technical specifications and support documentation

- Research and introduce new database tools and technologies

 

Technical Skills Required:
- 3-5 years database development and administration using Microsoft SQL Server (2012-2016)
-Knowledge of Microsoft's SQL Server system stored procedure and tables, dynamic views etc

- In depth T-SQL knowledge is required, including advanced tuning skills: Must have experience with multi table joins, sub queries, in-line views, cursors, aggregate and analytic functions, merge, user defined data types, and collection types and an ability [Bulk Collects], collection types and an understanding of how to create efficient queries.
- SQL Profiler, SQL Server Management Studio
- Experience with Microsoft SSIS
- Knowledge of XML technologies
- Erwin
- Experience with MS TFS (Team Foundation Server)
- Knowledge of Salesforce is a plus
- Knowledge of E1 system is a plus
- Knowledge of FTP server Required

 

Interested candidates should forward their resumes to: skirkwood@htpartners.com