DurhamRecruiter Since 2001
the smart solution for Durham jobs

SQL DBA only local to Raleigh, NC.

Company: Lightning Minds Inc.
Location: Durham
Posted on: September 15, 2020

Job Description:

Greetings from Lightning Minds Inc., Below is the urgent requirement from one of my clients Position SQL DBA Location Durham, North Carolina Duration 12+ Months Job Description 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. Candidates need to be local to Raleigh, NC. The individual will be accountable for successful design, development and delivery of SQL solutions within on prem 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) 1. Data analysis and database management 2. Strong experience using SSIS as the ETL tool in a data warehouse environment. 3. 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. 4. 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. 5. Creates data validation rules on source data to confirm the data has correct andor expected values. 6. Creates process cleanup after complex ETL processes which release resources used to run ETL. This would include error handling and SSIS restart. 7. Designs and implements technology best practices, guidelines, and repeatable processes. 8. (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 This work order is essential for service delivery of the following A new System Office Analytical Data Warehouse in the cloud. The DBA Team has one (1) SQL Server Administrator on staff. These positions will work with the DBA team in conjunction with the Data Warehouse team. Skill Required Desired Amount of Experience IT Industry Experience Required 8 Years Data Integration and ETL experience with SQL Server Integration Services (SSIS) Required 10 Years Experience in SQL programming Required 8 Years Experience in designing and developing ETL processes including naming conventions and experience connecting to various systems Required 5 Years Experience in identifying and mapping data elements across multiple systems including creating templates and best practices to maintain mappings Required 4 Years Strong understanding of data quality and validation Required 3 Years Understanding of Master Data Management (MDM), data warehousedata marts Required 3 Years Clear understanding and experience with Microsoft platforms to include SSIS, DQS and MDS Required 3 Years Understanding of ITSMITBM. Preference given to staff who have knowledge of ServiceNow. Highly desired 2 Years Understanding and implementation of Amazon Redshift Highly desired 3 Years Working knowledge of cloud technologies, including AWS and Azure Required 3 Years Experience using Agile Scrum methodology Highly desired 3 Years Recent professional experience as an MS SQL DBA Thanks and Regards, Mahesh Technical Recruiter Lightning Minds Inc Office 919-374-5133 Extn 101 Email mailtoSDL2017

Keywords: Lightning Minds Inc., Durham , SQL DBA only local to Raleigh, NC., IT / Software / Systems , Durham, 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


Software Engineering Manager (Remote) - $100,000/year USD
Description: Are you a great coder or an awesome tech lead Do you want a leadership role that fully utilizes your technical skills Do you have the highest standards for code quality If so, we are looking for you (more...)
Company: Crossover for Work
Location: Raleigh
Posted on: 09/24/2020

Java Full stack role
Description: Job Duties Review and estimate requirements while working with your team to plan agile sprints related to application and process development roadmaps Develop web applications
Company: Datamatics Global Services, Inc.
Location: Raleigh
Posted on: 09/24/2020

Telecommute Salesforce Technical Architect
Description: An IT management company has an open position for a Telecommute Salesforce
Company: VirtualVocations
Location: Raleigh
Posted on: 09/24/2020


Sr. Software Tester
Description: Job Title Sr. Software Tester to perform quality control and assurance on the integrated casefinancial management system and ensure the legacy system performs correctly during roll-out. LOCAL CANDIDATES (more...)
Company: Promantus, Inc
Location: Raleigh
Posted on: 09/24/2020

Remote Web Analytics Principal Analyst
Description: An online freelance marketplace that connects businesses to talent is searching for a person to
Company: VirtualVocations
Location: Raleigh
Posted on: 09/24/2020

Software Engineer
Description: SunIRef:it Important Note: During the application process, ensure your contact information email and phone number is up to date and upload your current resume when submitting your application for consideration. (more...)
Company: Wells Fargo
Location: Raleigh
Posted on: 09/24/2020

SQL Application Support Engineer - Biotech - REMOTE
Description: My client is expanding and seeks a SQL Application Support person to support their biotech and pharma clients. The ideal candidatewill take on the following tasks: Test
Company: Affinity Executive Search
Location: Raleigh
Posted on: 09/24/2020

Remote Bilingual French Web Hosting Support Specialist
Description: A web hosting service company is seeking a Remote Bilingual French Web Hosting Support Specialist.Core
Company: VirtualVocations
Location: Raleigh
Posted on: 09/24/2020

Remote Senior Java Software Engineer
Description: A staffing and recruiting firm is seeking a Remote Senior Java Software
Company: VirtualVocations
Location: Raleigh
Posted on: 09/24/2020

Telecom Network Engineer
Description: Apex Systems has a contract opportunity for a Network Engineer who had lead some migration/cutover projects that wants to do some Project Management tasks .-- Ideally someone with a Networking/CCNA R (more...)
Company: Apex Systems
Location: Raleigh
Posted on: 09/24/2020

Log In or Create An Account

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

Durham RSS job feeds