SQL Database Administrator – N.Raleigh (Permanent)

SUMMARY: This is a unique opportunity for an individual with prior experience seeking new challenges and broad database responsibility. The Database Administrator will be responsible for planning, coordinating, and supervising all activities related to the integration of software programs, business applications, data sources, and some of the data retrieval systems into the organization’s information systems.

RESPONSIBILITIES: • Responsible for the design and implementation of multi-dimensional database models, data warehousing, and data transformations • Understands all data sources required for the organization’s core business • Ensures the cost-effective management of all data sources (including inventories) and data feeds to and from the organization • Administers all corporate databases, including ERP databases • Responsible for the 24x7x365 availability of mission-critical data • Responsible for the effective integration with other data streams • Ensures the integrity, availability, security, and performance of all corporate data, including traditional DBA responsibilities • Maintain and support the organization’s business intelligence application • Maintain and monitor database backups and rotating archives of backup files • Production database disaster recovery • Responsible for the strategic design and implementation of data warehouses, marts, and stores, while ensuring high levels of data availability • Defines data standards and models for warehouse architectures • Manages the creation and management of sound data management process • Standardizes data naming, establishes consistent data definitions, and monitors overall data quality • Some travel required

KNOWLEDGE / SKILLS / ABILITIES: • Strong familiarity with the SQL language • Familiarity with MDX queries • SharePoint Administration • MS Performance Point Administration • Excel pivot tables • Excellent verbal and written communication skills • Strong organizational skills • Shows attention to detail • Ability to work independently, and in a team • Demonstrated knowledge of Finance and Accounting Principles • Ability to analyze business issues when forming requirements for a project • Familiarity with Windows Server Administration • Remain current in technology as appropriate to this position through training and web resources

EDUCATION / EXPERIENCE: • Bachelor’s degree in Computer Science or related field preferred • Three plus years in database administration required • Experience with MS SQL Server 2005/2008 required • Experience with MS IIS preferred • Experience with MS SharePoint preferred • Experience writing DTS or SSIS packages • Experience writing SSAS cubes • Experience supporting users (i.e., help desk, field support) is also a plus

Data Engineer- Rocky Mount, NC (Perm)

Primary Responsibilities:

• Assist and Lead in start-up of supply chain information solutions
• Work toward an enterprise-wide Information Solution.
• Lead pre-sales/sales technical efforts in the areas of data integration, business intelligence and reporting
• Analyze customer, vendor and/or carrier requirements and lead development of formal technical responses with all parties
• Work with customers, vendors, and/or carriers to define and document their data integration, BI and reporting requirements
• Architect and code web applications and desktop tools as required to fulfill customer, vendor, carrier, and/or user needs
• Architect and code BI environments (ad hoc queries and reports) for these integration platforms
• Recommend new technologies when appropriate
• Provide support for created applications and reports, as well as current FACTS
• Performance programming
• Strategic planning of database design and reports
• Experience with MS SQL in a clustered environment
• Strong problem solving skills

 

 

Requisite Skills, Knowledge & Abilities:

• Integration experience with multiple platforms and data sources.
  • mainframes, mid-range machines, UNIX, LINUX, etc.
  • relational DBMS, flat files, digital images, etc.
• Experience with or clearly demonstrated aptitude for creating, organizing, querying and reporting on data with SQL 2008, or similar data management packages
• Experience with MS SQL Server 2008 replication, scripting, job scheduling, maintenance
• Experience with T-SQL
• Experience with Crystal Reports, MS SQL Reporting Services, Oracle Business Intelligence tools or other reporting tools.
• Knowledge of XML, .Net, ASP, C#, C++ and VB.
• Experience with web and desktop application design and testing
• Experience in the transportation or foodservice industry
• Strong communication and interpersonal skills
• Able to work comfortably with both technical and business customer users at all levels
• Able to work on multiple projects at a time, to work under deadlines, to work independently and in a team environment
• Able to adapt quickly to change and respond to demands of multiple customers
• Ability and drive to deliver outstanding customer service
• BS degree in computer science or related technical field or equivalent experience
• 3+ years experience in a similar role

 

Senior Solutions Architect – RTP, NC (permanent)

Accentuate Staffing has this great new opening with one of our top local clients.  If qualified and interested please apply directly to scott@accentuatestaffing.com

The Senior Application Infrastructure Architect role is to identify, recommend, develop, implement and support stable, cost-effective technology solutions.  Responsibilities include estimating total cost, managing deliverables of cross-functional team-members, delivering stable IT solutions, troubleshooting application infrastructure issues, ensuring customer satisfaction.

The Application Infrastructure Architect will work closely with the IT professionals in both the applications and infrastructure teams, company decision makers, and vendors to provide information technology solutions to benefit our customers and increase the value of our client.

 

• Identify, recommend and design application architecture solutions including recommendations for the application configuration layer, database and operating system.
• Create document according to internal standards including project management, Software Development Lifecycle (SDLC) and other compliance related documents.
• Cost assessment including hardware, software, maintenance, support and operating costs.
• Perform risk assessments of the solution, service delivery and support.
• Develop, test, update and implement continuity of operations processes.
• Develop, document, and establish Standard Operating Procedures.
• Install, configure, test, manage, maintain, upgrade software including database, operating system and application.
  • Resolve escalated Help Desk issues.

 

• Bachelor of Science degree in Computer Science, Information Technology, Information Science, Management Information Systems, or a related discipline from an accredited college or university.
•  Must have a minimum of five years’ experience in the IT-related field.
• Must have an understanding of software architecture and design principles as well as the software lifecycle processes.
•  Ability and experience in applying and maintaining patch levels and security configurations.
• Experience in supporting production applications including resolution of end user issues and requests.
• Understanding of Sarbanes Oxley (SOx), Food and Drug Administration (FDA) requirements.
• Three years of project management experience.
• Preferred:
• Master of Science degree in Computer Science, Information Technology, Information Science, Management Information Systems, or a related discipline from an accredited college or university.
• Seven or more years of IT experience.
• SAP Basis or development experience.
• Software vendor certification.
• ITIL V3 Foundation.
  • Experience working with remote and global teams.

 

• Strong understanding of technology and internal strategic platforms, solutions, products.
• Excellent oral and written communications.
• Strong interpersonal ability.
• Ability to blend strategic thinking & tactical delivery of solutions.
• Ability to work under pressure of multiple projects and deadlines.
• Ability to interpret and apply required policies and procedures.
• Experienced in designing robust solutions.
• Experienced at identification and resolution of incidents and problems.
• Display leadership qualities in a team setting.
• Preferred Skills:
• AIX, Linux,  Windows Enterprise Operating systems
• DB2, MSSQL, MFG Pro,  MaxDB
• ERP Systems such as SAP, QAD
• TivoliStorage Management
• Disaster recovery
  • Virtualized environments

IT Director- Raleigh, NC (Permanent)

Position Purpose:

Directs the corporate information systems programs and telephony at our client site.  Epicor experience is a must have for this opportunity.

Nature & Scope

Designs, develops and implements comprehensive computer based information systems and telephony solutions to ensure users needs are met and data is processed according to company specifications and requirements. 

 

Defines user information requirements by conferring with users and analyzing functions.  Recommends and develops computer-based business solutions.  Plans system applications and assigns staff to develop, test and complete programs.  Evaluates effectiveness of programs and offers solutions to enhance effectiveness.

 

Prepares and maintains technical specifications and related documentation to secure procedures and prevent systems failure.  Responsible for company’s technology disaster recovery plan.

 

Research and recommends hardware and software purchases.  Negotiates pricing with vendors to ensure cost-effective systems purchasing decisions.

 

Improves existing software programs and develops new applications to meet future business needs.  Ensures that hardware and software is maintained and secured with proper back-ups and training.

 

Manages and controls departmental human resources and expenses effectively.  Hires, trains, develops, and appraises staff effectively. 

 

Maintains up to date information on technology affective functional area to increase innovation and ensure compliance.

 

Education and Experience Required

BS/BA in computer science or equivalent; Minimum

 

10 years of progressively more responsible experience in information systems department management in a medium to large size firm with a minimum of 3 years of Epicor management experience.  Solid technical information of AS 400, networks, digital and satellite technology, telephony and PC based applications.

 

Proven project management, problem solving, and broad management expertise, as well as the ability to communicate effectively with technical and non-technical audiences.  Solid writing skills. 

 

Thorough understanding of general business, financial and related procedures.

 

IT Project Manager (2) – RTP, NC (4 month contracts)

PRINCIPAL OBJECTIVE OF POSITION:

This position will support multiple business units across the standard functions involved in the development and delivery of projects: Initiation, Planning, Execution, Control and Closure.  This position will be involved with a variety of operational activities in support of the above, but also should have experience in process improvement, business change management and training.

 MAJOR DUTIES AND RESPONSIBILITIES:

1. Act as a liaison between business and information systems staff in resolving IT-related problems
2. Work closely with quality assurance, regulatory affairs, engineering standard committees, vendors or clients as appropriate.
3. Chair various project review and pre-submittal meetings commensurate with experience.
4. Establish project objectives and milestones within boundaries of company policy and contract specifications.
5. Participate in the conceptual development of a project and oversee its organization, scheduling, implementation and financial analysis in accordance with corporate or business unit procedures.
6. Work with team leads and/or functional department heads to plan, organize and direct activities concerned with project development and delivery into production on time and budget.
7. Represent the company in project meetings and take part in strategy meetings.
8. Provide input to Contracts on technical aspects of contracts to protect company’s interest and simultaneously maintain good relationship with customers/vendors.
9. Authorize requisition or payment for project supplies and materials.
10. Interpret and explain project plans and contract terms to administrative staff, workers, management and clients.
11. Formulate management reports concerning such areas as work progress, costs and scheduling against plan.
12. Be able to extract information for analysis from different levels of the organization
13. Document technical requirements, develop and oversee project plans and implement change control procedures on simple, single thread projects.
14. Ensure project products are effectively handed off to operations for ongoing maintenance and troubleshooting.
15. Ensure regular team meetings are held as appropriate for project stage, duration and complexity.
16. Arrange, manage and maintain relevant outsourcing relationships.
17. Identify and recommend new business opportunities, new systems and processes, and improvements in operations to upper management. 
18. Analyze information requests and discuss with user to assemble all elements required to produce the requested information, including ROI to justify approval.
19. Ability to define problems, establish facts, and draw valid conclusions based on observed and collected data.
20. Document technical requirements, develop and oversee project plans and implement change control procedures for multi-thread, moderately complex projects.
21. Investigate potentially serious situations, perform root cause analysis and implement corrective measures.
22. Provide highly skilled process, technical and management advice and assistance to department management and personnel.
23. Assist in developing corporate or business unit plans, goals, objectives, policies and procedures as appropriate.
24. Mentor associates and foster a learning and growth-oriented environment.
25. Ownership of project budget(s) with a fundamental understanding of corporate financial strategy and policy for capitalization, expense and depreciation of assets.
26. Excellent understanding of resource management, including development of recovery strategies for project work running or projected to be behind schedule.
27. Experience in International Project and/or Program Management.
28. Document technical requirements, develop and oversee project plans and implement change control procedures for multi-thread, complex projects.
29. Provide highly skilled process, technical and management advice and assistance to business unit and corporate management and relevant personnel.
30. Assist in the Management of the PMO team.
31. Capable of independently managing a project or program with a project cost up to $10 million, duration of up to 2 years and staff up to 30 people. 

 KNOWLEDGE/SKILL:

1. BA/BS Degree plus at least 15 yrs work experience or Masters Degree plus 12 years experience.
2. Including at least 8 years Project Management and 3 years process and/or analyst experience.
3. Experience working in a regulated work environment, preferably FDA related.
4. Experience in work environments outside IT.
5. Technical and administrative aspects of all phases of project management.
6. Experience building teams.
7. PMP Certification or equivalent required.

 

 

IT Support Manager – Raleigh, NC (Permanent)

Position Summary:

The IT Support Manager supervises Tier 3 (System Admins), who addresses all support and maintenance of back-end technology in the company’s data center and disaster recovery location.   Along with IT top management, the IT Infrastructure Manager develops effective procedures for maximizing infrastructure performance, uptime, and data consistency.  The IT Infrastructure Manager is a member of the IT Project Team, which leads the implementation of new IT initiatives in the organization. 

 

Essential Job Functions:

 

• Lead and manage System Administrators, including responsibility for maintenance, backups, disaster recovery, security, and uptime.
• Along with VP of Information Technology, act as collaborator/executor in network and server architecture/design
• Develop and enforce associated policies.
• Periodically conduct trending/analysis and quality management of IT Network and Server Infrastructure.
• Serve as POC, SME, and/or implementer on various IT projects
• Assists VP of Information Technology in IT related purchasing and budget usage.
• Exercises staff oversight to ensure new operations plans, policies, procedures, and transition/management plans are consistent with the overall organizational goals and objectives as defined by the VP of Information Technology.
• Approves Tier 3 timesheets, expense reports, and PTO.

 

Minimum Qualifications:

 

• 5 – 7 years of experience in a Microsoft based support and server environment serving 200+ employees in multiple locations
• Bachelor’s degree in Information Technology or related field strongly preferred.  In lieu of degree, equivalent work experience required.
• Experience maintaining server and networking infrastructure for a Microsoft based server environment
• Experience maintaining databases, including administration and querying.
• Experience with Server Virtualization and SAN technologies.
• Ability to develop/lead projects which improve efficiency of existing technology services and improves uptime while decreasing costs.
• Contribute/Facilitate technology awareness, team work  and customer service
• Strong analytical, communication and critical analysis mindset
• Ability to manage and execute several projects and competing priorities within SLAs and/or project deadlines.

ETL Programmer – Raleigh, NC (Permanent)

POSITION SUMMARY This position will write ETL and SQL code, provide advice on data structures, and provide needed technical assistance to support front end interfaces.

ESSENTIAL FUNCTIONS • Prepare/Author ETL tools and packages with external or third-party data sources • Write and modify stored procedures and create database structures as required in a SQL Server environment • Participate in and gather requirements from workgroup meetings • Document, test and implement solutions using applicable SSIS and SSRS technologies • Create reports using Microsoft SQL Reporting Services • Assist in OLAP cube analysis and implementations The position will work with other developers and Special Projects staff to populate data systems, to write code in support of specific tasks and/or applications and in general to use their expertise with IT processes and systems to complete needed requirements.

QUALIFICATIONS 2-3 years’ experience: • Creating extraction, transformation and load programs and scripts using Microsoft SSIS • Using a wide range of SSIS data flow tasks to transform data • Writing ETLs to process very large data. • Coding reports using Microsoft SQL Reporting Services.

Jr. IT Developer – RTP,NC (3 month contract to permanent)

Essential Duties and Responsibilities

• Design and develop internal applications and web content.
• Program and script for internally developed systems.
• Formally present new technologies and design concepts.
• Test and document modifications, patches and changes to deployed technology.
• Train users with deployed software and technologies.
• Identify and resolve technical issues relating to deployed technology.
• Other duties as assigned by IT Management.

Minimum Qualifications

• Bachelor’s degree in Computer related field (Software Development preferred).
• Demonstrated ability to code in HTML, ASP/PHP, Javascript. *
• Demonstrated ability to code in object-orientated languages (Java, C# or C++). *
• Experience with web servers, especially Microsoft IIS.
• Must have a valid NC Driver’s License.

Minimum Skills/Abilities

• Familiarity with business processes and practices.
• Familiarity with software development lifecycle methodologies.
• Familiarity with Microsoft based office environment.
• Must have excellent logical problem solving ability.
• Must possess a strong attention to detail.
• Must have excellent organizational skills.
• Must have excellent verbal and written communication skills.

 

Preferred Knowledge / Skills / Abilities

• Experience with Adobe software.
• Experience with SQL.
• Experience with VB.NET.
• Knowledge of Business Intelligence software and data warehousing principles.
• Experience with ODBC/ADO/Data Source linking.
• Experience in technical writing.

* Code examples from previous work, together with a summary of the problem and solution, will be required.

Accentuate Staffing Newsletter- January 2012

 

Positive Energy – A Newsletter for Clients, Candidates and Friends   January 2012
Oh, you didn’t know?!   Thanks to the absence of a backbone, a 70 lb octopus can ooze through an opening no wider than a silver dollar.   The most recent employment figures: NC Unemployment Nov 2011 = 10.0% NC Unemployment Dec 2011 = 9.9%	Hot Market Trends   Information Technology: IT Support Light Industrial: Manufacturing/Maintenance Technicians Accounting: Staff Accountant Office Professional: Customer Service Representatives Clinical/Scientific: Chemists
Congratulations to Vicki Price for winning 2 tickets to the Carolina Hurricanes for joining our LinkedIn group!!   Go Canes!!
The Power of Positive By Chris Mullan, Senior IT Recruiter   I met Ryan close to 5 years ago – a very green IT support candidate with minimal corporate IT experience.  Ryan desperately wanted to break into IT and he had two things on his side, his personality and his drive.  After working with him for about 6 months, I received a job order that would work as a win/win for the client and Ryan.  The role was a 6 week project to assist with first level support while the client upgraded systems.  Ryan’s 6 week project evolved into a full-time opportunity with the client.    Four and a half years later, Ryan found himself looking for work again.  This time Ryan came equipped with 3+ years of Systems Administration experience.  When I reached out to him, he was ecstatic that I remembered him.  On the flip side I was happy he remembered me.   I contacted one of our RTP biotech clients about Ryan and they proceeded with a phone screen, face-to-face interview and a job offer all within 24 hours.   Accentuate Staffing has great relationships with our candidates because of the time we put in on the front end to get to know them and understand their stories.  Ryan knew that I had his best interests at heart every step of the way.     Office Professional  ▪  Accounting  ▪  Information Technology  ▪  Scientific/Clinical  ▪  Light Industrial  ▪ On-Site

SW Tools Engineer- RTP, NC (6 month contract to permanent)

Accentuate Staffing has a growing client in RTP,NC that is looking to hire someone with the following skills.  If you have a knack of creating software tools that make life easier for everyone that uses them, are driven by fixing problems with slow software tools, and are creative and flexible then this may be the job for you.  The right candidate will have experience administering source code repositories, working with Linux in writing various shell scripting languages, web design and development, and experienced in a “Make” environment. 

Requirements:

• BS in Computer Science or related
• 3 years of experience in software tools development
• Must have C/C++, PERL, PHP, Linux Shell scripts, Make, Clearcase and Subversion
• Experience with Javascript, Apache andAJAXis desirable.
• Exposure to Jira, Klocwork or Hudson is a plus

Please contact scott@accentuatestaffing.com or reach out to me thru LinkedIn.