MS SQL Database Developer - Randstad USA
Charlotte, NC 28225
About the Job
Description:
- Experienced MS SQL database developer who will be responsible for developing / maintain TSQL code. 5+ years of full time experience as MS SQL / TSQL Developer with stored procedures, views, triggers, cursors, tables and index creation.
- Experience with Autosys, BIDS/SSIS, TFS, C# and familiarity with object oriented database design and development.
- Experience in database and query optimization will be important. Must have familiarity with IT Infrastructure management domain.
- Candidate Expected to have good communication and documentation skills.
- Solid understanding of data architecture, efficient database design, writing complex queries and query tuning and troubleshooting.
- Resource will be responsible for creating the table structures and will process data that is required to meet a critical reporting need within the technology group. In addition, resource should able to work independently with minimal guidance, in understanding requirements provided by Business Analysts and writing ETL programs to source data from upstream database systems as well as data sourced with various file formats such xml, csv etc.
Required Skills:
- 7+ years' full time experience in MS SQL development
- MSSQL Server 2012 or higher
- SSIS (SQL Server Integration Services)
- SSRS (SQL Server Reporting Services)
- Knowledge of TFS (Team Foundation Service) or a similar service like Bit Bucket
- Visual Studio 2013 or higher
- Writing complex queries and query tuning and troubleshooting
- Ability to write complex stored procedures, functions as well as support/enhance existing
- Ability to create/modify database schema, tables, indexes, etc.
- Knowledge of Indexes, cursors, triggers
- Experience working with partitioned tables and other database design patterns
- SQL Database backup, restore experience with working knowledge of log shipping, log mirroring
- SQL code optimization, tuning with ability to work with large datasets
- Extensive knowledge of Data transformation and validation
- ETL Processing (Autosys Preferred)
Desired Skills: Good to have: C# scripting, Tableau
location: CHARLOTTE, North Carolina
job type: Contract
salary: $70 - 80 per hour
work hours: 9am to 5pm
education: Bachelors
responsibilities:
- Experience with Autosys, BIDS/SSIS, TFS, C# and familiarity with object oriented database design and development.
- Experience in database and query optimization will be important. Must have familiarity with IT Infrastructure management domain.
- Candidate Expected to have good communication and documentation skills.
- Solid understanding of data architecture, efficient database design, writing complex queries and query tuning and troubleshooting.
qualifications:
- Experience level: Experienced
- Minimum 5 years of experience
- Education: Bachelors
skills:
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.