SQL Server DBA Itasca, IL

Copy-of-CA-planet2-Mobile.jpg

SQL Server DBA  Itasca, IL 60143

Company will be moving downtown Chicago May 2015

At this time, company will not sponsor.

Salary commensurate with experience.

Ideally local candidate. Will consider sign-on bonus to help offset relocation. 

 

Key Points: This role is mostly operational taking care of the SQL Server Database. Must be able to install, maintain, troubleshoot 2008 / 2012 SQL Server , deploy applications and review syntax in scripts. Env. is approximately 25 servers ( Blades and virtual). Largest database 5 Terabytes.

Summary: The SQL Server DBA will provide operational support for all MS SQL database environments. The DBA will administer a mixture of MS SQL 2012 and 2008 database servers. The DBA will also provide application development database support as well as database strategic planning, database architectural design and implementation.

Qualifications:

The ideal candidate will have strong technical skills and a solid MS SQL Server database administration background. Experience and/or interest in the Airline and/or Telecommunications industries are desired.
• Minimum 5 years of Microsoft SQL server production support experience;
• Must have experience implementation and configuration experience in a multi-tiered (web/ application/ database) environment with ability to learn quickly;
• Experience with Database Administration for MSSQL Server 2012 / 2008;
• Experience in troubleshooting and resolving database problems;
• Experience in Capacity planning, Performance Tuning and Optimization, using native monitoring tools;
• Experience with backups, restores and recovery models;
• Experience working with Windows server, including Active Directory and proper disk configurations
• Experience with working on SSIS packages;
• Experience with SSRS;
• Experience in implementing operational automation using scripts;
• Experience with working on Oracle 11g and MySQL 5.x would be a plus;
• Experience in Administering and managing SQL Server in a Data ware house environment would be plus;
• Knowledge of indexes, index management, and statistics;
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server;
• Strong knowledge of Windows Server operational use;
• Logical and physical data modeling;
• Good knowledge of SQL and PowerShell scripting;
• Good technical knowledge of client/server environments including virtualization;
• Education: Bachelors’ Degree in computer science, mathematics, or Information Systems;
• MCSE – SQL Server 2012 a plus.

 

Recruitment1“Does This Interesting/Exciting Position…Sound Like Your Background & Expertise?

” Who Do You Know That Might Be Interested In This Exciting Career Opportunity?

OK, Now, Tell Them!

Candidate Career Interest: Please send your resume as a MS-word (.doc) or PDF attachment along with a short summary for the position of interest:  jchrconsuling@sbcglobal.net

Review our “Outstanding Career Opportunities and Stay Updated by Subscribing to our RSS feed! Cotledge & Associates, Inc. – J. Cotledge #312-965-5278.

www.cotledgeassociates.com

www.twitter.com/CotledgeAssoc

www.google.com/+JeanetteCotledge

www.facebook.com/CotledgeAssociates

diversity4

Permanent link to this article: https://www.cotledgeassociates.com/sql-server-dba-itasca-il/

Informatica Senior Programmer Analyst – Enterprise Data Warehouse, Skokie, IL.

Copy-of-CA-planet2-Mobile.jpg

 

Informatica Senior Programmer Analyst – Enterprise Data Warehouse

Skokie, IL. 60077

Full time 

Salary is commensurate with experience.

Company will not provide sponsorship or relocation for positions. 

 

Key Points:  Data Warehouse Enterprise – someone with  Informatica ETL  and SQL development.

Environment – Oracle 11g, Cognos 10.1, company working with over 4 Terabytes of data, (Mainly looking with Experience in Informatica PowerCenter platform). 

Summary: Our client is one of the leaders in the healthcare industry.  We are currently seeking a Senior Programmer Analyst – Enterprise Data Warehouse.  In this role, you will:

·         Design and develop the data warehouse/data mart applications utilizing Informatica tool to extract data from our Epic electronic medical record system and/or other sources.

·         Responsible for the identification of data items through research, analysis, profiling, data mining, and data discovery of the source data from Epic and other clinical ancillary systems.

·         Gathers business requirements by conducting meetings/interviews, and facilitating large-group/cross-functional sessions with customers, while containing the scope of the initiative.

·         Interact with business analysts and IT analysts to efficiently and clearly interpret business requirement specification into detail data mappings.

·         Design and develop complex SQL queries.

·         Document data standards, requirement specifications, and business processes.

·         Responsible for establishing best practices for several developers working in the same environment on different projects.

Qualifications: 

·         4 year college degree in computer science/data processing or equivalent on the job experience

  • 2+years of enterprise data warehouse industry experience.
  • 2+ years of experience with ETL design, development, architecture and implementing data warehouse data marts, Informatica Power Center experience a plus
  • 2+ years of experience in writing complex SQL

·         Strong analytical, problem solving, negotiation, issue resolution and facilitation skills are required

·         Excellent written and verbal communication and decision making skills

  • Experience and understanding of data sources including 3rd party RDBMS, SQL server and Oracle

·         Experience in QA/QC testing a plus

·         Project management skills a plus

·         Experience with Business Intelligence tool a plus

·         Familiarity with healthcare industry or healthcare information systems is a plus

imagesTV1M1JS3“Does This Interesting/Exciting Position…Sound Like Your Background & Expertise?

” Who Do You Know That Might Be Interested In This Exciting Career Opportunity?

OK, Now, Tell Them!

Candidate Career Interest: Please send your resume as a MS-word (.doc) or PDF attachment along with a short summary for the position of interest:  jchrconsuling@sbcglobal.net

Review our “Outstanding Career Opportunities and Stay Updated by Subscribing to our RSS feed! Cotledge & Associates, Inc. – J. Cotledge #312-965-5278.

www.cotledgeassociates.com

www.twitter.com/CotledgeAssoc

www.google.com/+JeanetteCotledge

www.facebook.com/CotledgeAssociates

diversity3

 

Permanent link to this article: https://www.cotledgeassociates.com/informatica-senior-programmer-analyst-enterprise-data-warehouse-skokie-il/

Cognos Business Analyst / Business Intelligence P/A, Skokie, IL. 60077

CA planetLogo

“Outstanding Career Opportunity within the Technology/Healthcare arena!”

Cognos Business Analyst / Business Intelligence P/A – Enterprise Data Warehouse

Skokie, IL. 60077

Salary is commensurate with experience.

Company will not provide sponsorship or relocation for positions.

 

Environment – Oracle 11g, Cognos 10.1, company working with over 4 Terabytes of data.

Key points: Business Analyst / Business Intelligence looking for someone with  business intelligence tool required, Cognos is preferred and QA / QC testing.  

Summary: Our client is one of the leaders in the healthcare industry.  We are currently seeking a Senior Programmer Analyst 1 – Enterprise Data Warehouse. 

In this role, you will:

·         Design and develop the data warehouse/data mart applications by providing innovative solutions with a focus on research projects

·         Responsible for the identification of data items through research, analysis, profiling, data mining, and data discovery of the source data.

·         Gathers business requirements by conducting meetings/interviews, and facilitating large-group/cross-functional sessions with customers, while containing the scope of the initiative.

·         Interact with user / customer to efficiently and clearly interpret business requirement specifications into detailed technical specifications.

·         Design and develop complex REDCap forms.

·         Design and develop complex SQL queries.

·         Document data standards, requirement specifications, and business processes.

·         Responsible for establishing best practices for several developers working in the same environment on different projects.

Qualifications: 

4 year college degree in computer science/data processing or equivalent on the job experience

  • 2+ years of enterprise data warehouse / business intelligence industry experience
  • 2+ years of experience with a business intelligence tool required, Cognos is preferred
  • Experience in QA / QC testing a plus
  • Project management skills a plus
  • REDCap experience a plus
  • Experience with ETL design and development a plus

·         Familiarity with healthcare industry or healthcare information systems is a plus

·         Strong analytical, problem solving, negotiation, issue resolution and facilitation skills are required

·         Excellent written and verbal communication and decision making skills

 

imagesDW467OES“Does This Interesting/Exciting Position…Sound Like Your Background & Expertise?

” Who Do You Know That Might Be Interested In This Exciting Career Opportunity?

OK, Now, Tell Them!

Candidate Career Interest: Please send your resume as a MS-word (.doc) or PDF attachment along with a short summary for the position of interest:  jchrconsuling@sbcglobal.net

Review our “Outstanding Career Opportunities and Stay Updated by Subscribing to our RSS feed! Cotledge & Associates, Inc. – J. Cotledge #312-965-5278.

www.cotledgeassociates.com

www.twitter.com/CotledgeAssoc

www.google.com/+JeanetteCotledge

www.facebook.com/CotledgeAssociates

Diversity2

Permanent link to this article: https://www.cotledgeassociates.com/cognos-business-analyst-business-intelligence-pa-skokie-il-60077/

Java Web Applications Software Engineer, Franklin Park, IL.

Copy-of-CA-planet2-Mobile.jpg

 

“Outstanding Career Opportunity within the Technology arena!”

Java Web Applications Software Engineer

Location: Franklin Park, Il 60131

Full time permanent role

Salary commensurate with experience

Summary: The main responsibility of the Web Applications Software Engineer is developing, implementing, and providing support for planned and existing web applications. We are looking for someone who can come up to speed quickly on a wide variety of systems, and who has the ability to develop features for customer-facing applications. Development is done primarily in Java and based around Spring, Hibernate and Ibatis. UI development is currently GWT.

Requirements:
• 2+ years of experience in Java programming in scalable environment and in object-orientated design principle and methodologies
• Working knowledge in enterprise Java programming environment and frameworks, including J2EE, JDBC, Spring, Servlets, JavaScript /GWT /AJAX, HTTP, HTML5, CSS3
• General knowledge of the Web Service and REST frameworks

• Experience with interfacing with teams (product development, business analysis, third party) located in other regions. Very strong autonomy required.
• Research and application of new technologies and development tools
• Experience working with or developing Open Source projects
Education:Bachelor of Science degree or higher in Computer Science or related discipline

 

imagesTV1M1JS3“Does This Interesting/Exciting Position…Sound Like Your Background & Expertise?

” Who Do You Know That Might Be Interested In This Exciting Career Opportunity?

OK, Now, Tell Them!

Candidate Career Interest: Please send your resume as a MS-word (.doc) or PDF attachment along with a short summary for the position of interest:  jchrconsuling@sbcglobal.net

Review our “Outstanding Career Opportunities and Stay Updated by Subscribing to our RSS feed! Cotledge & Associates, Inc. – J. Cotledge #312-965-5278.

www.cotledgeassociates.com

www.twitter.com/CotledgeAssoc

www.google.com/+JeanetteCotledge

www.facebook.com/CotledgeAssociates

diversity3

Permanent link to this article: https://www.cotledgeassociates.com/java-web-applications-software-engineer-franklin-park-il/

Amazon Web Services Development Operations Engineer, Franklin Park, IL.

Copy-of-CA-planet2-Mobile.jpg

“Outstanding Career Opportunity within the Technology arena!”

Development Operations Amazon Engineer

Location: Franklin Park, Il 60131

Full time permanent role

Salary commensurate with experience

 

Summary: Do you want to work with the latest cloud and server technologies including Amazon Web Services and NoSQL databases or contribute to development of infrastructure used by popular fitness iOS and Android Apps? 

Responsibilities:
– Build, deploy and destroy servers, from quick testbeds to mission-critical clusters
– Scaling our platform
– Debugging runtime problems and solving complex problems
– Continuous Integration and deployment
– Collaborate with other senior engineers on perfecting our processes, tools and platform architecture.

REQUIREMENTS:
– Bachelor of Science degree or higher in Computer Science or related discipline
 2-4 years of experience
– Strong Systems Engineering experience (any systems administration experience is a plus)
– Solid command of system automation frameworks and concepts
– Unix mastery

– – Experience working with Java, Ruby, JavaScript and or Python
– Chef or Puppet or Salt or Ansible experience
– Solid experience with Amazon Web Services such as EC2, S3, EBS, ELB, Cloudfront, etc.
– Experience with rSpec, Selenium, Cucumber, Jasmine, Jenkins, or Hudson. 

 

Recruitment1“Does This Interesting/Exciting Position…Sound Like Your Background & Expertise?

” Who Do You Know That Might Be Interested In This Exciting Career Opportunity?

OK, Now, Tell Them!

Candidate Career Interest: Please send your resume as a MS-word (.doc) or PDF attachment along with a short summary for the position of interest:  jchrconsuling@sbcglobal.net

Review our “Outstanding Career Opportunities and Stay Updated by Subscribing to our RSS feed! Cotledge & Associates, Inc. – J. Cotledge #312-965-5278.

www.cotledgeassociates.com

www.twitter.com/CotledgeAssoc

www.google.com/+JeanetteCotledge

www.facebook.com/CotledgeAssociates

diversity4

Permanent link to this article: https://www.cotledgeassociates.com/amazon-web-services-development-operations-engineer-franklin-park-il/

Focus to see the Light

* JC’s #Inspirations *

“It is during our darkest moments that we must focus to see the light!”

Aristotle Onassis

Cotledge & Associates, Inc.

“Human Resource Consulting Services/Contract”

“Relentless, Successful, and Dedicated to Client Satisfaction.”

diversity4

*Embrace Life, Live!*

*Be Present!*

*How May I Serve!*

Permanent link to this article: https://www.cotledgeassociates.com/focus-to-see-the-light/

Permanent link to this article: https://www.cotledgeassociates.com/full-charge-bookkeeper-chicago-il/

Global Supply Chain Manager Bloomingdale, IL 60108

Global Supply Chain Manager

Bloomingdale, IL 60108

Salary commensurate with experience. 

Key points:  Must have Experience with S&OP (Sales and Operations Planning) and with Oracle’s ASCP, top two needs from the position. 5+ years of management experience. Solid understanding of lead-time, safety master scheduling, and Pharmaceutical industry experience a huge plus. 

Summary: Client one of the top-selling manufacturer within the food and nutritional science industries.  We are seeking Global Supply Chain Manager to provide leadership to analyze and optimize the global supply chains to deliver key results (customer service, inventory targets, operational efficiency, financial, etc.) for current and future needs across business units.

  • Lead the formal Sales & Operations Planning process to balance Demand and Supply Plans in alignment with financial goals and objectives. Establish methods of measuring and improving supply chain performance indicators.
  • Leverage Oracle’s Supply Chain Management eBusiness Suite in development of common analytic and planning tools and work processes.
  • Effectively manage and support supply chain staff by training, developing, mentoring and coaching to support and interact with all levels of the organization to achieve set objectives.
  • Support the Performance System by driving Lean and Pull system based activities through the organization to eliminate waste and improve efficiency.  Evaluate and make recommendations on all aspects of the end-to-end supply chain to minimize landed costs.
  • Investigate and evaluate future systems and supply chain methodologies to keep up with best practices.
  • Provide independent judgment on significant  issues; handles time sensitive and confidential matters.  Coordinate  and maintain information, records, and resources for manufacturing and distribution facilities.
  • Comply with all safety and GMP requirements.

 

Qualifications:

Minimum three years of experience leading formal S&OP process required. 

  • Five to seven years of management experience with ERP supply chain software preferred; Oracle ASCP required. 
  • Broad and deep knowledge of supply chain and production processes required; Master Scheduler (Operational planning/scheduling and inventory management – MRP) skills preferred.
  • APICS certification CPIM and/or CSCP preferred. 
  • High proficiency in Microsoft Office software, with Macro experience preferred.  Supervisory experience preferred. 
  • Experience  with Lean systems preferred. 
  • Experience  with Change Management systems preferred.
  • Bachelor degree in Supply Chain Management,  business or closely allied field required; in lieu of degree,  consideration may be given to candidates with 10+ years of relevant experience. 

Cdiversity4andidate Career Interest: Please send your resume as a MS-word (.doc) or PDF attachment along with a short summary for the position of interest:  jchrconsulting@sbcglobal.net

Review our “Outstanding Career Opportunities and Stay Updated by Subscribing to our RSS feed! Cotledge & Associates, Inc. – J. Cotledge #312-965-5278.

 

www.cotledgeassociates.com

www.twitter.com/CotledgeAssoc

www.google.com/+JeanetteCotledge

www.facebook.com/CotledgeAssociatesInc

 

Permanent link to this article: https://www.cotledgeassociates.com/global-supply-chain-manager-bloomingdale-il-60108/

The Right Place At The Right Time

*JC’s Inspirations*:

You need to accept that you’re in the right place at the right time.

Sure, there’s some definite skill involved in your success,

but your great energy and chance circumstances contribute quite a bit!

diversity3

Cotledge & Associates, Inc.

“Human Resource Consulting Services/Contract”

“Relentless, Successful, and Dedicated to Client Satisfaction.”

 *Embrace Life, Live!*

*Be Present!*

*How May I Serve!*

Permanent link to this article: https://www.cotledgeassociates.com/the-right-place-at-the-right-time/

Chief Operations Officer, Nutritional Supplements / Health Foods

Chief Operations Officer – Nutritional Supplements or Health Foods Industry

Bloomingdale, Il 60108

Salary commensurate with experience.

Relocation is an option for this role.

Key Points:

•           At least 10+ years’ experience in successfully managing multiple FDA dealing with regulatory governed manufacturing facilities.

•           Responsibility for at least 1000 employees and Revenues of $250 million plus.

•           Natural products from a Supplement or Health Food company experience desirable.

•           Non-union leadership experience required.

  • Has experience in lean six sigma with either a black or green belt, or equivalent process experience with a strong technology background.

Summary: Company is seeking a mission-focused, seasoned, strategic, and process-minded leader with experience scaling an organization, leading a talented management team, and developing a performance culture among a group of diverse individuals. The COO must be a leader who is able to help others at the company to deliver measurable, cost-effective results that make the vision a reality.

Duties:

  • Advising and counseling management in planning; formulating activities and consulting with department leads on how to conduct these activities; supervising the operations and manufacturing department;
  • Ensuring all activities relating to work are completed according to specifications and in compliance with all legal matters;
  • Mediating between conflicting parties; assigning goals for departments and rewarding them once goals are achieved; motivating personnel to give quality service to the company;
  • Following guidelines set by the CEO and the board of directors; as well as providing business plans to maximize growth and profit, among others.
  • Directs activities for manufacturing operations at multi-site locations, supply chain, packaging, processing, receiving warehouse, purchasing, order fulfillment and engineering.

Qualifications: 

  • Bachelor’s degree (B. A.) from four-year college or university; and advanced degree preferred.  Experience with distribution and inventory management required, preferably in a food-related industry.  Advanced degree preferred.
  • 10 years’ experience in successfully managing multiple FDA governed manufacturing facilities. 
  • Management / Supervisory experience of at least 1000 employees and Revenues of 250 million plus.
  • Natural products experience from a supplement company.
  • Non-union leadership experience required
  • Successful P&L management; the ability to balance the delivery of programs against the realities of a budget; and problem solving, project management, and creative resourcefulness.
  • Has experience in lean six sigma with either a black or a green belt, or equivalent process experience.
  • Supports goals of world-class manufacturing systems.
  • Experience with distribution and inventory management required, preferably in a food-related industry.
  • Must have adaptive agility.
  • Healthy lifestyle a plus.

 

diversity4Candidate Career Interest: Please send your resume as a MS-word (.doc) or PDF attachment along with a short summary for the position of interest:  jeanette@cotledgeassociates.com

Review our “Outstanding Career Opportunities and Stay Updated by Subscribing to our RSS feed!

Cotledge & Associates, Inc. – J. Cotledge #312-965-5278.

 www.cotledgeassociates.com

www.twitter.com/CotledgeAssoc

www.google.com/+JeanetteCotledge

www.facebook.com/CotledgeAssociatesInc

 

 

Permanent link to this article: https://www.cotledgeassociates.com/chief-operations-officer-nutritional-supplements-health-foods/