22951 Los Alisos Blvd. #4
Mission Viejo, CA 92691
   Contact     Login  
CGS takes customer relationship very seriously.  They constantly stays in touch with us and addresses our needs and concerns as they occur.  I have had the opportunity to work with several companies, but would like to mention the high standards and attention to details that the CGS provides.  
Thomas J.
News & Events

Sr. SQL Server Database Developer
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.


« Back to Posts


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