RaleighRecruiter Since 2001
the smart solution for Raleigh jobs

SQL Server DBA (Local candidates of Raleigh-Durham area Only, Non locals please do not apply)

Company: Ventures Unlimited
Location: Raleigh
Posted on: September 12, 2020

Job Description:

Job Title SQL DBA - Expert Location Raleigh, NC (Remote Work with occasional visits) Type Of Hire Contract (W2) Duration 6 Months (Extendable) Candidates will be allowed to work remotely. However, heshe does need to be onsite as required, likely once a week. The candidates will need to be in Raleigh so heshe can come onsite at short notice. Key Skills SQL Server Data Analysis and Database Management, SSIS, ETL, Understanding of data quality and validation, Cloud technologies (AWSAzure) Job Description The individual will be accountable for successful design, development and delivery of SQL solutions within on premise and cloud environments. An ideal candidate will be someone who leads, develops, maintains, and integrates processes for a data warehouse that will extract data from standardized or varied data sources and transforms data for storing in proper formats and structures for querying and analysis using SSIS. This would include loading data into an operational data store (ODS), and a dimensional model (EDM). Responsible for architecting, testing, implementation of solution as well as mentoring and training other SSISETL developers in technology and business processes. Expected Skills Able to work without assistance can provide leadership to others able to manage highly complex work efforts may have advanced education may have extensive industry experience. Responsibilities (including, but not limited to) Data analysis and database management Strong experience using SSIS as the ETL tool in a data warehouse environment. Exercises, in conjunction with the enterprise data architect, independent decision making to creates processes which initiate the ETL, developing stream-lined processes for extracted data loading to destination databases. Performs data profiling of source data to identify data quality issues and anomalies, business knowledge embedded in data, gathering of natural keys, and metadata information. Creates data validation rules on source data to confirm the data has correct andor expected values. Creates process cleanup after complex ETL processes which release resources used to run ETL. This would include error handling and SSIS restart. Designs and implements technology best practices, guidelines, and repeatable processes. (Physical) Environment-level administration installationpatchupgrade of database software management of HA, database-level security maintenance of database configuration files and data files completion of database reorganizations, environment tuning, refreshes, exports and imports, backup and recovery performance of capacity planning driven by technology and resource usage trends Qualifications Data Integration and ETL experience with SQL Server Integration Services (SSIS) Experience in SQL programming Experience in designing and developing ETL processes including naming conventions and experience connecting to various systems Experience in identifying and mapping data elements across multiple systems including creating templates and best practices to maintain mappings Strong understanding of data quality and validation Understanding of Master Data Management (MDM), data warehousedata marts Clear understanding and experience with Microsoft platforms to include SSIS, DQS and MDS Working knowledge of cloud technologies, including AWS and Azure Recent professional experience as an MS SQL DBA

Keywords: Ventures Unlimited, Raleigh , SQL Server DBA (Local candidates of Raleigh-Durham area Only, Non locals please do not apply), IT / Software / Systems , Raleigh, North Carolina

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Full Stack Software Engineer
Description: Are you a quality-driven Full Stack Software Engineer with Angular expertise Would you like to join an industry-leading organization in a highly collaborative team environment If so, we may have the ideal (more...)
Company: Eliassen Group, LLC
Location: Durham
Posted on: 09/18/2020

SAS Programmer 5+
Description: 12 months, Raleigh, NC
Company: 3A Soft Inc
Location: Raleigh
Posted on: 09/16/2020

Sr. Clinical Integration Software Engineers (Remote Until covid)
Description: Role DescriptionSr. Clinical Integration Software EngineersLocationRaleigh, NC Remote Until Covid Duration6MonthsPhone, Skype Job DescriptionProjectProjects FHIR-based IT Systems development This role (more...)
Company: Intone Networks Inc.
Location: Raleigh
Posted on: 09/16/2020


VB.NET/SQL Developer - Remote
Description: RESPONSIBILITIES Kforce's enterprise client in Raleigh, NC is immediately seeking an experienced VB.NETSQL Developer to work remotely for their global, intelligent networking and software innovation client. (more...)
Company: Kforce Technology Staffing
Location: Raleigh
Posted on: 09/18/2020

Technology Architect - US
Description: Q2-USSE-RCLA-Technology Architect-Java-WoonsocketRI 09/04/2020 Job Description Infosys is seeking Java Architect . In this role you will interface with key stakeholders and apply your technical proficiency (more...)
Company: infosys
Location: Raleigh
Posted on: 09/16/2020

.NET With IVR Developer
Description: Role .NET with IVR Developer Location
Company: Avance Consulting
Location: Raleigh
Posted on: 09/18/2020

Cable and Harness Assembly Supervisor
Description: Prysmian Group is the world leader in the energy and telecom cable systems industry. Each year, the Group manufacturers thousands of miles of underground and submarine cables and systems for power transmission (more...)
Company: Prysmian Group
Location: Greenville
Posted on: 09/18/2020

Technical Test Lead - US
Description: ecom Loyalty Testing Lead-Raleigh, NC br br 09/15/2020 br br Job DescriptionInfosys is seeking a ecomm Loyalty Testing Lead br br As a QA Test Lead, you will act as a validation and quality (more...)
Company: infosys
Location: Raleigh
Posted on: 09/18/2020

SAP PP QM Lead
Description: We are looking for a solid SAP PP QM Lead Consultant for our project need. Please see below requirement details.Requirement Details:Overall at least 12 years of SAP PP/QM experience is required.
Company: EMERGYS CORPORATION
Location: Raleigh
Posted on: 09/18/2020

Mid-level Developer: C#, ASP.net, SSIS, SSRS and JavaScript
Description: Specific information related to the position is outlined below. To apply, click on the button above. You will be required to create an account or sign in with an existing account . Your account will (more...)
Company: Truist
Location: Raleigh
Posted on: 09/18/2020

Log In or Create An Account

Get the latest North Carolina jobs by following @recnetNC on Twitter!

Raleigh RSS job feeds