Employment Opportunities

Working for CAI; Concept Analysis and Integration is a collaborative company where employees are empowered to make a difference for our clients and our country.  If you are looking for an environment where you can work with world class individuals, and receive recognition and rewards based on your contributions, CAI is the place for you. At CAI, you can expect to:

• Participate in all aspects of consulting engagements, from initial client contact through proposal development, service delivery and planning the next steps in the customer’s program.
• Be challenged to expand your technical and organizational skills, project management abilities, business development acumen, and leadership qualities
• Grow rapidly through both on-the-job training and formal training experiences in technical areas, teamwork skills, and advanced degrees
• Experience teamwork and be empowered to make decisions that are in the best interest of our clients, our shareholders, other employees, and yourself
• Have opportunities to gain new responsibilities and advance professionally as quickly as your skills and desires can propel you to the next level.

Employees who come to CAI find that they learn more about how a business really operates, and are given more responsibility and leadership opportunities, than they could expect at their old companies.
CAI employees are guided each day by four important core values:

• Integrity: What we think, what we say, and what we do are in alignment.
• Personal Responsibility: We are responsible to make a difference and bring added value to our client’s projects. We don't blame others. Instead, when something goes wrong, as they will at some point in most projects we ask: "What can I do to help?"
• Win-Win Relationships: We ensure that the company, all employees, our clients and our strategic partners achieve their objectives in every engagement.
• Open & Honest Communications: We encourage suggestions and receive feedback in an open, honest and constructive manner with each other, our partners, and with our clients.

Mid Level Oracle DBA

Candidate should have 5 years of Oracle Database Administration Experience with the following skills:

• Profiicent in SQL performance tuning (must be able to recommend tuning solutions)
• Must be able to identify expensive sql statements and recommend tuning alternatives
• Proficient in troubleshooting technical database and network environments
• Ability to monitor for performance
• Knowledge SAN or Cluster technologies a plus
• Knowledge in daily maintenance of the Database

Proficient in RAC, 10G, and 10giAS
Job Description:
The qualified candidate performs complex database management systems (DBMS) functions to include both development and administrative tasks. Assignments, which are in direct support of software development and maintenance teams, include database analysis, security support, design, software use, and performance monitoring and tuning. Reviews and ensures integrity via standardized support tools. Ensures that assignments are performed in accordance with database administration guidelines, standards and procedures for applications development, implementation, testing, and migration. Responds to complex customer-reported systems problems. Evaluates and recommends use of software, guidelines, and procedures. Evaluates and develops project plans. Provides DBMS expertise to other development groups as requested. Works on extremely complex problems. Acts independently to determine methods and procedures to be used on new projects. Regularly interacts with management and customers on matters concerning several functional areas, divisions, and/or customers. Under general direction, designs, implements and maintains complex databases with respect to access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. Includes maintenance of database dictionaries, overall monitoring of standards and procedures, and integration of systems through database design. Competent to work at the highest level of all phases of database management.

Required Skills:

The candidate should have a BS degree and at least 4 years of experience or 8 years of total experience in lieu of degree. Hands-on Oracle RDBMS development and administrative experience to include Installation, Configuration, Troubleshooting, Backup, Recovery, Performance tuning and User administration. Must also have strong Oracle SQLPLUS and PL/SQL skills that include a thorough understanding of packages, stored procedures, functions, and triggers. Must be experienced in Oracle 10g RAC and above on both LINUX and UNIX platforms. Must have strong communication skills and the ability to work independently with the client and effectively with other team members. Capability to research, test, recommend and direct the deployment of security protocols that include application of security patches; provide interpretation and responses to vulnerability assessments from written benchmarks or scanning tools; develop corrective action plans to remediate security vulnerabilities; describe the assessment and mitigation of system and project level risks. The candidate must be a US Citizen or green card holder and able to pass the requirements for a SECRET clearance. Candidate will be required to: " Install, configure and maintain several  Oracle 10x RDMBS’s " Install and upgrade RDBMS related products " Review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations " Assist in the definition and development of database documentation and standards " Conduct application transaction volume and traffic analysis, and interpret impact on database and network performance " Analyze, test, and implement physical database design supporting various business applications (including base definition, structure, documentation, long range requirements, operational guidelines) " Establishes and maintains security and integrity controls including planning / implementing, user management, resource management, password management, and N-tier Authentication/Authorization

 DESIRED SKILLS:
Development capabilities using Java programming skills and web forms. Experience as an on-site contractor working in a team environment with a Government Client. Experience in a CMMI level 2 or higher environment.

Business Intelligence Developer/Analyst

•  Three years experience with Oracle BIEE Plus/ Siebel Analytics  
• Ability to mentor and train others in the BIEE tool
• Experience with Business Intelligence Applications
• Design and Building Reports & Dashboards
• Design and Implementation of Effective and Intuitive User Interfaces
• Design of Metadata Layer for optimum ease of use and efficiency
• Full life cycle experience
• Some experience with Development

Job Description:

Designs and develops detailed business reports supporting the Client organization using Oracle (Seibel/Hyperion) reporting tools and Oracle PL/SQL. Serves as an in-house BIEE plus expert and provides troubleshooting assistance to the business users who design their Ad Hoc Reports.
Responsible for gathering, reviewing, and validating business needs and reporting requirements with business end users in a variety of functional areas and determine/recommend a reporting solution which fits their needs. Also responsible for the design, development, automation and execution of reports based on previously gathered requirements and/or delivered functional specification as determined.
Required Skills:

Strong customer service orientation
Excellent communication skills
Ability to gather, validate, document, estimate and manage requirements
Ability to develop ad-hoc queries using SQL (SQL, Oracle or XML)
Develop and maintain Oracle BIEE Reports files
Develop and maintain Dashboard documents
Development experience with at least one of the following: C#, Java, XML

Data Warehouse Developer

Skills:
Concept Analysis and Integration, LLC. is currently looking for an experienced Data Warehouse Data Modeler/Developer with at least 8 years of relevant experience. The position will be responsible for leading and implementing Data Warehouse modelling and ETL processes.
The Sr. Data Modeler role is responsible for the creation of the data warehouse data models and for ensuring the proper data analysis requirements are captured and documented to achieve the business objectives of the project.
Responsibilities:
• Designs dimensional data models for the needs of a project
• Develops and captures appropriate data model metadata
• Conducts initial data profiling and data quality investigations
• Leads data modeling sessions
• Leads user interviews
• Assists in source to target mapping
• Assists DBA with implementation of physical data model
• Leads and participates in ETL development to meets model's needs
Requirements:
• A BS in MIS or equivalent in related education and related professional
work experience.
• Minimum 4 years experience with Dimensional Data Modeling (conceptual, logical, physical)
• Strong end-user facing communication skills
• Strong Oracle Database Skills
• Strong business analytical skills and strong communication skills
• Experience with Oracle BIEE+ or Siebel Analytics is a big plus.
• Experience with a variety of databases including Oracle and SQL Server.
• Led the development of Data Warehouse, star schema dimensional models.
• Led the development of Data Staging/ETL strategies. Such strategies included the analysis and documentation of data quality issues and the development of extraction and transformation techniques in order to clean, combine and decode data elements.

Oracle JDeveloper

Desirable experience

• 3 Years experience building Applications with JDeveloper
• Experience with Java related technologies (AJAX, etc)
• Java Programming 
• Experience with Oracle BPEL a plus
• Data warehouse experience preferred

Brief Description:

Design, develop, troubleshoot and debug software programs for databases, applications, tools, networks etc.

Detailed Description:

As a member of the enterprise application division, you will assist in defining and developing software for tasks associated with the developing, debugging or designing of software applications. Provide technical leadership to other software developers. Specify, design and implement modest changes to existing software architecture to meet changing requirements.