22951 Los Alisos Blvd. #4
Mission Viejo, CA 92691
   Contact     Login  
Finding high quality technical consultants in today’s market is extremely difficult.  This is especially true for fast-paced software companies. We are fortunate in finding high-quality services from CGS in screening and selecting high-level consultants, which has helped us in meeting our product development goals.  
John D.
News & Events

CGS - CV - Facebook  
Posted: October 25th, 2016

CGS Business Solutions In a recent interview, CGS Business Solutions was selected tell us what the company has been doing to become the successful recruitment firm it is today. CGS specializes in IT business solutions, staffing and consulting services. With a strong focus in IT applications, network infrastructure, information security, and engineering.

See full article here:  http://bit.ly/2f4IOds

Posted: September 21st, 2016

Orange County Business Journal Acknowledges CGS Business Solutions


Irvine, CA, September 21, 2016 – CGS Business Solutions, a Minority Owned IT Services Company, has been recognized for the 4th time as one of the fastest growing private companies out of 60 total companies on the Small Companies List of the Orange County Business Journal‘s (OCBJ) list of Fastest-Growing Private Companies in Orange County.  CGS is honored to be recognized for it’s fourth consecutive achievement recognizing the continued success.

“We are honored to be recognized again by Orange County Business Journal on its respected list of fastest-growing private companies in Orange County.” said Nick Chavis, Founder & CEO of CGS Business Solutions.  The people are a corporation’s intellectual property, the heart and soul and the driving force behind the success or failure of an organization. As the war for talent gets more aggressive, companies call upon CGS to help deliver the invaluable talent to stay competitive and win in today’s employment market.“

The OCBJ’s list of Fastest-Growing Private Companies in Orange County is divided into three sections:  large companies, midsize companies and small companies.  The Orange County Business Journal is a weekly print and online newspaper covering business in Orange County, California and is the second largest business journal in California after the Los Angeles Business Journal.

About CGS Business Solutions

CGS Business Solutions is honored to be selected as one of the Best IT Recruitment Firms in California. After four consecutive fastest growing company titles, CGS continues to break into new markets across the USA. CGS is a Native American, certified minority owned company, with their roots tied to the North Carolina Lumbee Indian Tribe. CGS specializes in IT business solutions, staffing and consulting services. With a strong focus in IT applications, network infrastructure, information security, and engineering.

Posted: May 10th, 2016

CGS Business Solutions is now able to deliver 282 Cyber Security courses. Learn on-demand from top instructors who are industry subject matter experts. CGS is able to offer 100′s of Contact Hours/Professional Development Units (PDUs), courses that lead prepare you for certifications, pre-tests for certification tracks and much more. Certification Series for CISSP, CISA, CISM, CISSO, CIHE, CDFE, CompTia Security + and many more.




Posted: February 16th, 2015

Posted: November 7th, 2013

Sr. SQL Server Database Developer

The Senior SQL Developer will support Applications developed for the company and will utilize a solid understanding of Business Systems Development using SQL Server (2008, 2012) Reporting Services, Integration Services, and database design; will demonstrate teamwork, initiative, and support skills to assist business end-users with custom applications; will play a key role in the development of a new Financial Data Repository and related Management Reporting and Planning Platform tools including Data Relationship Manager.

Duties and Responsibilities: (including the following, other duties may be assigned)

  • Maintain and provide production support for existing financial SQL databases including the Financial Data Repository & Assets under Management system
  • Design and develop new systems for Finance & Accounting, Legal & Compliance, HR and other teams supported by Corporate Business Systems
  • Design and implementation of automated validations from various source systems based on record counts and sum totals
  • Maintenance and building of new interfaces to/from SQL databases, including those sources from Hyperion ASO/BSO Cubes, Data Relationship Manager (DRM), SAP and PeopleSoft
  • Requirements gathering for database modifications from end-users; design, test and implementation of those modifications to the agreed upon specifications
  • Requirements documentation


  • Minimum 3 – 5 years of SQL database development experience, SQL 2008/2012.
  • Minimum 3 – 5 years of Business Systems Development or Financial Systems Administration.
  • Minimum 2 years of experience in the Financial Service Industry required.
  • Experience developing and supporting Finance and Compliance SQL databases and non-technical end-users.
  • Experience using SSIS – importing text files and XML files. Using Loop containers and package configurations.
  • Working knowledge of the following functions essential functions using SQL 2005/2008:
    • Knowledge of T-SQL, including transactions, begin..try…, merge, common table expressions, ROW_NUMBER/OVER, bulk insert, FT searching
    • Partitioned Tables/Indexes (Switching/Merging/Splitting)
    • Performance tuning/code debugging
    • Replication (transactional)
  • Experience with Reporting Services (SSRS) which would include creating reports, handling permissions, installing, configuring and troubleshooting.
  • Experience and/or exposure to DRM
  • Demonstrated ability to work independently or as part of a team to accomplish critical business objectives and make sound decisions under pressure.
  • Demonstrated ability to communicate effectively and maintain honest and open communication consistently with vendors and end-users at all levels internally
  • Demonstrates ability to work well under pressure and handle multiple tasks, challenges, and aggressive deadlines in a fast paced and professional environment.
  • Demonstrates ability to respond effectively to inquiries from various levels of management.
  • Experience working with a remote team
  • Proven ability to carefully manage multiple priorities is essential as well as a strong sense of urgency towards meeting deadlines and resolving open issues.

Education and Additional Experience:

  • BS/BA in related discipline or combination of education and experience
  • Experience in the Asset Management industry is a plus.
    • Experience providing non-technical end users data and metadata load tools to target SQL financial databases is a plus.


Next Page »


Engagement Models

Understanding the dynamics of what employers and employees seek...

Strategic Thinking

One of the many differences between us and the rest is our ability to look...
QuikTime bt CGS
Any Place | Any Time | Any Device