Archive

Archive for the ‘DBMS’ Category

SQL Server Developer <<<>>> Location: Middletown, NJ

11/09/2011 Comments off
  • Looking for an applications DB designer and developer with SQL Server, the emphasis is on design and development experience in a client/server real time transaction system building new features and capabilities on the DB side of the app not an admin job (back ups, conversions, typical operations type DBA work) not reports, data extractions and data warehouse.
  • Design, develop, implement and support database objects such as, stored procedures, functions, triggers, tables, views etc., that meet business requirements.
  • Perform software development, unit testing and debugging, which may include the development of new software, reuse of existing code, modification of existing programs, or integration of purchased solutions.
  • Work with Business Analysts, other team members and clients to review the business requirements and translate them into database objects.
  • Work with Database Administration, Systems Administration and Operations personnel to support the implementation of applications into production.
  • Receive general supervision from the project leader, and work independently through the phases of the software development life cycle.
  • 5-7 years of experience in development in T-SQL.
  • Strong knowledge of DTS packages and SSIS.
  • Strong knowledge of SQL Server performance tuning.
  • Strong knowledge of SQL Server 2000 and SQL Server 2008.
  • Experience in Database Administration using SQL Server is a plus.
  • Ability to work independently and as part of a team.
  • Excellent written and verbal communication skills.
  • Ability to oversee other developers work and mentor them in appropriate coding standards.

 

 

Skill Experience Need
5-7 years of experience in development in T-SQL. Expert Required
DTS packages and SSIS Expert Required
SQL Server performance tuning Expert Required
SQL Server 2000 and SQL Server 2008 Expert Required
Database Administration using SQL Server Intermediate Desired
Excellent written and verbal communication skills Expert Required
Lead Mentor Intermediate Required
READ PROJECT DESRIPTION UPDATED Expert Required

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Blog: http://www.findtherightjobhere.wordpress.com

LinkedIn Profile: http://www.linkedin.com/in/anitparmar

 

SQL Server DBA <<<>>> Location: Atlanta, GA

11/09/2011 Comments off
  • The position is for a Database Administrator / System Administrator.
  • Must be proficient with Microsoft SQL Server administration and programming.
  • Applicant must be adept at performance tuning, writing and understanding Views, Stored Procedures, Functions and Triggers.
  • A strong working knowledge of DTS, SSIS and VBScript is required.
  • The applicant must have experience in Windows 2000, 2003 and 2008 environments.
  • Proficiencies with DTS to SSIS are a must.
  • Other desirable skills include; Oracle to SQL conversion, PL SQL, and Telecommunications experience. System Administration experience is a plus.
  • Additional workload for total revamp of server and database support environment for the organization, including transitioning multiple servers, databases, and operating systems.
  • Also, after initial transition – this will allow the enhancement of and the addition to all metrics including tracking and measuring of ODT initiatives.

 

Skill Experience Need
MS SQL Server Expert Required
T-SQL Expert Required
Oracle Intermediate Required
P-SQL Intermediate Required
SYS Admin Expert Required
Telecom experience Intermediate Desired

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Blog: http://www.findtherightjobhere.wordpress.com

LinkedIn Profile: http://www.linkedin.com/in/anitparmar

Oracle DBA <<>> Location: Alpharetta, GA or Richardson, TX or Bothell, WA

11/09/2011 Comments off
  • Responsible for high level database administration and related tasks on multiple DMBS platforms.
  • Participates in the evaluation, selection and implementation of appropriate DBMS based on client requirements.
  • May create logical model and transform logical design into efficient physical databases, performing data normalization/denormalization, and considering volume, capacity and requirements for performance, data conversion, purge/archive and operation viability.
  • Responsible for in implementing database architecture strategies.
  • Manage database administration projects that may span across parts of the enterprise and ensure deliverables are completed on time.
  • Strives to drive overall costs lower for database performance, data conversion, and administration services.
  • Acts as consultant to clients and other IT organizations on database related issues.
  • Leads efforts to implement standards across the enterprise for ease of support and recovery in relation to database administration (database security, disaster recovery, scripts, database documentation).
  • Evaluates and deploys new technology to improve database efficiency and recoverability.
  • Perform advanced problem determination and recoveries. Mentors Database Administrators and Associate Analysts.
  • Must have 2+ years experience with Oracle GoldenGate, Oracle Enterprise Manager and TOAD.

 

 

Skill Experience Need
TOAD Expert Required
Data Collection & Analysis Intermediate Required
Oracle DB Intermediate Required
ERWIN Intermediate Desired
Informatica Intermediate Desired
2+ years exp with Oracle GoldenGate Intermediate Required

 

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Blog: http://www.findtherightjobhere.wordpress.com

LinkedIn Profile: http://www.linkedin.com/in/anitparmar

OBIEE Consultant <<<>>> Location: Bedminster, NJ

11/09/2011 Comments off
  • Candidate will be involved in performing business analysis and reporting functions for the Supply Chain & Fleet Operations and Network organizations.
  • Analyze business requirements to develop Supply Chain and Business Partner Dashboards and AdHoc Reports using the Oracle Business Intelligence Enterprise Edition (OBIEE) platform.
  • Identify and define requirements for IT to expose additional data elements to be made available for OBIEE reporting.
  • Skills required include OBIEE Release 11g (and earlier versions) for Dashboard and Report generation in conjunction with all Oracle supply chain modules (Purchasing, Inventory Planning, Transportation, Asset Tracking, etc.).
  • Must have good communication skills and be able to work effectively in a team environment.
  • As the OBIEE SME, work with other team members to train and increase their knowledge of the OBIEE reporting environment and tools.

 

Skill Experience Need
OBIEE 11g Expert Required
Oracle Supply Chain Modules Expert Required
Oracle Supply Chain Data Analysis Expert Required
OBIEE Dashboard Creation Expert Required
OBIEE Adhoc Report Creation Expert Required
Data Requirements Definition Expert Required
Communications Skills Expert Required
Mentoring Skills Expert Required
Customer Interaction Expert Required

 

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Blog: http://www.findtherightjobhere.wordpress.com

LinkedIn Profile: http://www.linkedin.com/in/anitparmar

Oracle Database Administrator <<<>>> Location: Alpharetta, GA or Richardson, TX or Bothell, WA

11/09/2011 Comments off
  • Sustainment activities for Data Fabric applications
  • Responsible for high level database administration and related tasks on multiple DMBS platforms.
  • Participates in the evaluation, selection and implementation of appropriate DBMS based on client requirements.
  • May create logical model and transform logical design into efficient physical databases, performing data normalization/denormalization, and considering volume, capacity and requirements for performance, data conversion, purge/archive and operation viability.
  • Responsible for in implementing database architecture strategies.
  • Manage database administration projects that may span across parts of the enterprise and ensure deliverables are completed on time.
  • Strives to drive overall costs lower for database performance, data conversion, and administration services.
  • Acts as consultant to clients and other IT organizations on database related issues.
  • Leads efforts to implement standards across the enterprise for ease of support and recovery in relation to database administration (database security, disaster recovery, scripts, database documentation).
  • Evaluates and deploys new technology to improve database efficiency and recoverability. Perform advanced problem determination and recoveries.
  • Mentors Database Administrators and Associate Analysts.
  • Must have 2+ years experience with Oracle GoldenGate, Oracle Enterprise Manager and TOAD.

 

Skill Experience Need
TOAD Expert Required
Data Collection & Analysis Intermediate Required
Oracle DB Intermediate Required
ERWIN Intermediate Desired
Informatica Intermediate Desired
2+ years exp with Oracle GoldenGate Intermediate Required

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

LinkedIn Profile: http://www.linkedin.com/in/anitparmar

 

Web Database Application Developer <> Location: Richardson, TX

10/01/2011 Comments off
  • The candidate will work in a fast-paced dynamic environment.
  • Communication skills are highly valued as the group’s work-products are presented to executives.
  • Main focus is on Front end GUI development experience.

 

Looking for Candidate with hands on experience developing the following

  • HTML code
  • Javascript
  • Java Servlet
  • JDBC
  • XML
  • Must have experience with RDBMS preferably Mysql and Oracle.
  • Proficiency in SQL will be a key requirement
  • Should have worked in all aspects of the SDLC
  • jQuery and Ajax library experience is a plus

 

Skill Experience Need
HTML code Expert Required
Javascript Expert Required
Java Servlet Expert Required
JDBC Expert Required
XML Expert Required
RDBMS preferably Mysql and Oracle Expert Required
Proficiency in SQL – key requirement Expert Required
Should have worked in all aspects of the SDLC Expert Required
jQuery and Ajax library experience is a plus Intermediate Desired

 

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Oracle Technofunctional Consultant <<>> Location: Hoffman Estates, IL

09/30/2011 Comments off
  • Supply Chain system replacement project
  • Experienced system and user acceptance test lead.
  • This position will help coordinate, track and support the User Acceptance testing for the New Horizons supply chain project.
  • Critical skill sets required: Oracle supply chain system knowledge and experience
  • Prior extensive system testing experience, data conversion expertise, project management skills
  • Self starter and works independently and in teams.
  • Would like help improving the testing quality and efficiency as well.

 

Skill Experience Need
Oracle EPL Expert Required
Oracle WMS Intermediate Desired
Oracle Purchasing Intermediate Desired
User Acceptance Testing Expert Required
Analytics/ Reporting Expert Required
Telecommunications Intermediate Desired
Project Management Intermediate Desired
Data conversion Expert Desired
Supply chain processes Expert Desired

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Techno Functional Consultant – Oracle Financials and SCM <> Location: Alpharetta, GA

09/30/2011 Comments off
  • Implementation of Order to Cash functionality including: Order Management, Inventory, Picking, Shipping, Reservation, Scheduling and Order Holds for various releases of New Horizon Project.
  • This project will develop interfaces to from all legacy wireline systems into the Mobility Oracle 11i application.
  • New functionality in the Ordering and inventory processes will be developed in the Oracle 11i system to enable wireline users to purchase from this application and accommodate wireline specific business rules.
  • New functionality includes:
  • Order Accepatance, validate and interface Legacy Ordering System data elements
  • Integrate Oracle Order Management with Wireline Ordering System as mentioned above.
  • Conditionally check Project Budget based on item and dollar amount.
  • Also sending regular order status updates to Ordering System and other downstream application via interface and emails.
  • Build and Support new Interface with Red Prairie WMS system.
  • Have good experience on Order Management Workflows.

 

Skill Experience Need
Oracle Inventory Acct Mgmt Expert Required
Oracle AR, GL, Inventory, Shipping Expert Required
Oracle Supply Chain/Financials schema and table st Expert Required
Experience in working with EDI Transactions Intermediate Required
Good Communication skills/Team Player Expert Required

 

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Oracle Physical DBA <> Location: Richardson, TX or Alpharetta, GA or Bothell, WA

09/30/2011 Comments off
  • Responsibilities will include Oracle database administration, backup/recovery, Oracle upgrades, installs, database migrations, Dataguard/Standby, Goldengate, RAC, Oracle Grid Control, DB tuning, and performance management of the DB environment.
  • Oracle physical DBA experience (minimum 10 years of exp in USA) in a large and dynamic environment.
  • Solid understanding of core Oracle RDBMS concepts is needed in this large and fast moving environment.
  • Candidates must be expert in using unix-driven, non-GUI based tools for day to day database support.
  • Strong problem solving skills, strong interpersonal communication skills
  • Self- directed with good organizing and planning skills
  • Supportive of standards
  • Must wear pager and participate in 24X7 support
  • Must be willing to work off-shift when necessary
  • Disciplined approach to performing job requirements
  • Effective participant in a team environment and client-focused.
  • Must be extremely cognizant of the demands of supporting high availability mission-CRITICAL DBs in the production environment of a major national company.
  • Must be able to support 50+ oracle instances.
  • Must have production experience.

 

Skill Experience Need
Oracle DBA (10+ yrs in US exp) Expert Required
Oracle upgrades Expert Required
Oracle RAC Expert Required
Oracle backup/recovery Expert Required
Dataguard/Standby Expert Required
Unix Expert Required
Oracle Goldendgate Expert Desired
Production experience Expert Required

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Oracle DBA <<<>>> Location: Bothell, WA

09/30/2011 Comments off
  • This position will be part of the Security Office  Information Management Support team supporting critical information management applications used by the compliance team.
  • Provide DBA support for CSO applications in Oracle and MySQL.
  • Design database schemas, develop ERDs, and support application developers by writing queries and stored procedures. Write scripts to parse data feeds and store data in database.
  • Install new databases and patch existing databases.
  • Monitor, tune, and backup databases using RMAN and other tools.
  • Experience with RAC and Dataguard desired.

 

Skill Experience Need
Oracle 10g Expert Required
UNIX Intermediate Desired
SQL Expert Required
Stored Procedures and Triggers Intermediate Required
Perl Intermediate Desired
UNIX Scripts Intermediate Required
Websphere 6 or 7 Expert Desired
Javascript, Java Intermediate Required
Cold Fusion Intermediate Desired
MS SQL Intermediate Desired

 

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Oracle DBA <<<>>> Location: Atlanta, GA

09/30/2011 Comments off
  • Database Administration for Unified Communications platform.
  • Responsibilities include full support for operations data systems and databases within ecosystem.
  • Candidate will be expected to deliver and prove/test DR/Database designs and also mentor peers/provide leadership in assigned domain(s).

 

To be considered for this DBA position, a candidate must have:

  • This position requires EXPERT level experience and certifications with (Oracle) database and information systems.
  • 7-10 years continuous experience as DBA w/ large-scale & complex databases – (Must be shown on candidate resume)
  • This position will provide 24/7 Tier 3 (or higher) support for database and information infrastructure.
  • Must immediately be able to analyze the current and proposed system(s) and provide feedback through development of technical, structural and organizational specs/requirements.
  • Must be able and willing to work various shifts in on-call rotation and extended periods when required.
  • Must have EXCELLENT oral and written communication skills.

 

 

Skill Experience Need
Oracle DBA Expert Required
Oracle Store procedures Expert Required
Oracle Modeling Expert Required
Oracle backup and restore Expert Required
Oracle RAC (Cluster Redundancy) Expert Required
MvSQL knowledge Expert Required
Oracle Goldengate Expert Required
Informatica Expert Required
BI Reporting (Create & Manage) Expert Required
Excellent written and oral communication Expert Required

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Oracle Database Administrator <> Location: Richardson, TX

09/30/2011 Comments off
  • The candidate will be working in a 24/7 Oracle Production support center
  • Candidate must have previous Enterprise wide experience also manager requires previous production support experience which is mandatory.
  • Provides Production support for Oracle databases

 

Qualifications: Oracle physical DBA expertise (minimum 2-5 years)

  • SQL coding familiarity
  • UNIX environment familiarity and scripting skills
  • Very strong interpersonal communication and problem solving skills
  • Self-directed with outstanding organizing and planning skills
  • Highly motivated to achieve effective and consistent standards and processes across the work group
  • Demonstrate sense of urgency and discipline in pursuing assignments
  • Highly effective participant in a team environment with strong focus on meeting client requirements
  • Consistent with prudent risk management.
  • Current practical experience with PL/SQL, Oracle Enterprise Manager, Oracle 11g, RAC, DataGuard, Enterprise Users, and/or DB monitoring and performance tuning tools (i.e. Precise) is beneficial.

 

Skill Experience Need
Oracle DBA (min 2-5 yrs) Intermediate Required
SQL coding familiarity Intermediate Required
UNIX environment familiarity Intermediate Required
scripting skills Intermediate Required
strong interpersonal communication skills Intermediate Required
problem solving skills Intermediate Required
Enterprise wide experience Intermediate Required
Production Support exp mandatory Intermediate Required

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Oracle Database Administrator <> Locations: Richardson, TX or Bothell, WA or Alpharetta, GA

09/30/2011 Comments off
  • This position will provide Physical DBA Sustainment support for about 60-70 Prod DBs.
  • UNIX Oracle physical DBA for Oracle-based applications.
  • Responsibilities will include Oracle database administration, backup/recovery, Oracle upgrades, installs, database migrations, Dataguard/Standby, Goldengate, RAC, Oracle Grid Control, DB tuning, and performance management of the DB environment.
  • Oracle physical DBA experience (minimum 5 years of exp in USA) in a large and dynamic environment.
  • Solid understanding of core Oracle RDBMS concepts is needed in this large and fast moving environment.
  • Candidates must be expert in using unix-driven, non-GUI based tools for day to day database support.
  • Strong problem solving skills, strong interpersonal communication skills, self- directed with good organizing and planning skills, supportive of standards, must wear pager and participate in 24X7 support, must be willing to work off-shift when necessary, disciplined approach to performing job requirements, effective participant in a team environment and client-focused.
  • Must be able to support 50+ oracle instances.
  • Must have production experience.

 

 

Skill Experience Need
Oracle DBA Expert Required
Oracle upgrades Expert Required
Oracle RAC Expert Required
Oracle backup/recovery Expert Required
Dataguard/Standby Expert Required
Unix Expert Required
Oracle Goldendgate Expert Desired

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Oracle Database Administration <> Location: Austin, TX

09/30/2011 Comments off

Responsibilities:

  • Manage corporate Oracle database architecture, interconnections, and schemas for the storage and retrieval of corporate information in a high transaction rate, mission critical 24×7 environments.
  • Database planning, scaling, and capacity planning activities
  • Database design, index creation, database optimization, and performance tuning
  • Design and implement new data models, tables, and schemas to support new functionality as the business demands
  • Administration and management of all database software patches and upgrades
  • Ensure high availability, backup, and recovery of production databases
  • Manage physical standby/failover servers in remote facilities
  • Support the database application programming activities of the development group
  • Work with developers to move test code into production
  • Develop PL/SQL stored procedures to support applications
  • Develop and support SQL reports as well as reporting methods and tools (including web-based tools)
  • Bachelor Degree in Computer Science, Computer Engineering, Information Systems, or similar discipline (or equivalent work experience)
  • Minimum 5 years of senior level Oracle DBA experience
  • Proven ability to manage an Oracle database infrastructure in a high transaction/high availability environment
  • Knowledge and experience with Oracle database maintenance
  • Experience in database design, index creation, capacity planning, tuning, and optimization
  • Strong skills in database protection, backup, and recovery (RMAN, DataGuard, etc…)
  • Oracle RAC and other high availability architectures experience a must
  • Tools: Quest, Erwin, Toad and SQL*plus, Yasql or equivalent
  • Data Warehousing experience (desired, but not required)
  • SAP experience (desired, but not required)
  • Excellent written and oral communications skills with demonstrated commitment to production of high quality documentation
  • Professional demeanor and strong work ethic
  • Demonstrated commitment to providing excellent customer service
  • Willingness to provide off-hours on-call support and work off-hours as necessary

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Essbase Developer <> Location: Atlanta, GA

09/29/2011 Comments off
  • This project will fully integrate systems and processes supporting allocations and profitability reporting for planning & analysis of enhanced capabilities
  • The developer will need to come onboard to help in the development of Essbase applications that are merging from the Wireline and Wireless Essbase servers.
  • The developer will need to be strong with SQL to work with the data from Teradata as well as be running the jobs on a Solaris UNIX platform
  • Experienced Developer with Hyperion Essbase, SQL, Teradata and UNIX experienced Required

 

Skill Experience Need
Teradata Expert Required
Unix Shell Scripts Expert Required
Application Dev Expert Required

 

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Database Administrator <<>> Location: Middletown, NJ

09/29/2011 Comments off

PRIMARY: SYBASE/ORACLE

SECONDARY: INFORMIX/MSSQL

 

Requirements:

  • Experience with Sybase12.x and exposure to Sybase 15.x
  • Experience with Sybase Replication (Replication Server 12.x, 15.x)
  • 8+ years experience in Sybase database administration, maintenance and implementation
  • Strong working knowledge of DBA tasks, monitoring, troubleshooting, and analytical skills
  • Experience with Sybase design, performance and tuning
  • Ability to anticipate problems and take proactive action
  • Knowledge of Unix OS (preferably Solaris and HPUX), Unix shell scripting, and Database utilities
  • Good communication and team skills

 

ORACLE REQUIREMENT

  • Experience with Oracle 10/11 G.
  • Experience with performance tuning in large environments
  • Strong working knowledge of DBA tasks, monitoring, troubleshooting and analytical skills
  • GoldenGate replication
  • Ability to anticipate problems and take proactive action
  • Ability to gauge scalability in performance/sizing etc.

 

INFORMIX and MSSQL knowledge will be preferred

 

 

Skill Experience Need
SYBASE Expert Required
ORACLE Expert Required
INFORMIX Intermediate Desired
MSSQL Intermediate Desired
UNIX KNOWLEDGE Expert Required
PLSQL Expert Required
SHELL SCRIPTING Expert Required
DB2 Intermediate Desired

 

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Oracle DBA <> Location: San Ramon, CA

07/18/2011 Comments off

The DBA will be involved in designing and implementing the Oracle Object Oriented DB. Will also be responsible for performance tuning of the DB.

 

Skill Experience Need
Oracle DB Expert Required
Database Design Expert Required
Data Modeling Expert Required
Object Oriented Expert Required

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Oracle DBA – Production <> Richardson, TX or Bothell, WA or Atlanta, GA

06/17/2011 Comments off
  • This position will provide PDBA Sustainment support for about 60-70 Prod DBs.
  • Milestones: Meet all PDBA team sustainment and project delivery requirements.
  • UNIX Oracle physical DBA for Oracle-based applications.
  • Responsibilities will include DBMS installation, sizing, and building data bases and tables, monitoring, tuning, and performance management of the DB environment, definition with client and day-shift groups, implementing off-shift maintenance work when necessary to meet team objectives, and providing comprehensive turnover documentation to night team personnel when appropriate.

 

QUALIFICATIONS:

  • Oracle physical DBA expertise (minimum 3 years)
  • SQL coding familiarity, UNIX environment familiarity and scripting skills
  • Strong problem solving skills, strong interpersonal communication skills
  • Self- directed with good organizing and planning skills
  • Supportive of standards, must wear pager and participate in 24X7 support
  • Must be willing to work off-shift when necessary, disciplined approach to performing job requirements
  • Effective participant in a team environment and client-focused.
  • Current practical experience with RMAN, PL/SQL, Oracle Enterprise Manager, Oracle 9i/10g, RAC, DataGuard/Standby, Streams, Grid Control, and DB performance tuning tools (PerfStat, AWR) is required.

 

Skill Experience Need
Oracle DBMS Expert Required
Unix – All varieties Intermediate Required
GoldenGate Replication Intermediate Desired

 

 

.

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Oracle DBA <> Location: Middletown, NJ

06/16/2011 Comments off
  • Install DBMS client software Install and configure generic DBMS connectivity (i.e., transparent gateways, heterogeneous srvs)
  • Create and maintain Application Recovery Manual (ARM) Configure application backups (logical)
  • Restore application data (i.e., refresh DB using either a logical or physical backup)
  • Setup Application alerting of alarms for on call support
  • Monitor DBMS failover environments as necessary
  • Provide DBMS-related assistance to application team in degraded/outage situations
  • Interface with DBMS vendor for technical support for DBMS Client software and SQL issues, log and track trouble tickets
  • Troubleshoot client-DBMS connectivity issues Support tools/software that clients use to access database
  • Perform Database tuning and performance monitoring
  • Perform Application tuning and performance monitoring (e,g, SQL and code tuning)
  • Perform table and index reorganization as required Disk space acquisition
  • Monitor replication of DBMS data replication components
  • Setup and configure Application object replication
  • Assist Application in configuration of snapshot or event monitors
  • Manage database replication conflict resolution
  • Design application schema and DDL
  • Create application objects in DBMS
  • Create schema/application owner Grant access to application objects (stored procedures, triggers, functions, etc.)
  • Manage data content in application objects, includes archive and purge tasks
  • Create scripts and utilities to manage and monitor application objects
  • Notify ODBA when adding new objects
  • Manage application batch processes, including logical backup and restores
  • Inform DBA support groups when excessive application activity is planned
  • Create and maintain materialized views Implement and maintain database security (create and maintain application users and roles) RMAN, OEM, SHELL SCRIPT, PLSQL, LOGIGCAL AND PHYSICAL DATAGUARD, GRID CONTROL,SUPPORT ORACLE DATABASE (9i , 10G, 11G), SYBASE DATABASE, S/W INSTALLATION, MONITORING DATABASES, PERFORMANCE TUNING, TROUBLESHOOTING DB ISSUES, CAPACITY PLANNING,DESIGN FOR COMPLEX PROJECTS, DOCUMENTATION, PROVIDE ONCALL SUPPORT (ROTATION BASIS), WORK WITH VARIOUS TEAMS AND VENDOR SUPPORT TO TROUBLESHOOT PRODUCTION ISSUE IN TIMELY MANNER GOLDENGATE
  • Resources required for Oracle/Sybase/sqlserver Milestone Dates

 

 

Skill Experience Need
ORACLE DBA Expert Required
UNIX SCRIPTING Expert Required
SQL SCRIPTING Expert Required
SQL Server Intermediate Desired

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

OTM – Oracle Transportation Management – Testing Resource <<>> Location: Alpharetta, GA

03/12/2011 Comments off

1) Good Understanding of the overall functionality of OTM Release 6.0. Should know the following with a) Integration (Order Base, Order Release, Locations, Rates)

b) Integration with carriers (Tender Offer, Tender response, Ship manifest )

c) Bulk Plan Functionality

d) Shipment Functionality and applicable integration.

e) Rates setup

f) Other setup like items, locations, service providers etc.

 

 

2) Good integration understanding between Oracle 11i and OTM or OTM with any other supply chain applications

3) Good understanding of agents, monitors and saved queries

4) Exposure to work with various middleware like BPEL etc., ( a Plus )

5) Creation of test scripts.

6) Execution of test scripts

7) Report test results

8) Publish test results and status reporting on test status.

9) Creation of change request tickets pertaining to testing

 

Soft skills

1) Good communication skills

2) Would liaison between the design and technical team.

 

 

Contact:

Anit M Parmar

Collabera

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Oracle Techno functional Consultant <<>> Location: Atlanta, GA

03/12/2011 Comments off
  • Purchasing enhancements and Payables project.
  • Requirements Gathering, Analysis, testing and project delivery.
  • Will perform Oracle Applications Analyst role in Supply Chain Modules and will need to be an expert in Procurements functional area.
  • Strong techno functional skills is a PLUS!

 

 

Skill Experience Need
Oracle Purchasing Expert Required
Cellular Asset Tracking System Intermediate Desired
Oracle EDI Expert Required
Procure to Pay Expert Required
Oracle Receiving Expert Required
Oracle PO Functional Expert Required

 

 

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Title: Oracle Application DBA <<>> Location: Alpharetta, GA

03/12/2011 Comments off
  • This position is focused on supporting application development and operations team with the utilization of Oracle DBMS.
  • Provides Oracle database support to application team developing new commissions functionality.
  • Supports multiple development and testing databases
  • Deploys schema changes across environments as projects deploy
  • Provides guidance to the application team for table definition including relationships, keys, and indexing strategies.
  • Deploys schema changes into production during implementation phases
  • Provides refreshed data from production into various development and testing environments.
  • Supports database links across related application databases.
  • Provides guidance and support to the application team with the use of Oracle techniques and utilities to solve application design and performance problems.
  • Works with application team reviewing complex SQL statements to identifying opportunities for improved performance and simplification.
  • Provides Oracle database support to commission operations team supporting commissions processing.
  • Addresses database performance issues when required.
  • Provides guidance and support to manage database space planning and utilization
  • Develops and maintains ongoing table partitioning strategies.
  • Works with production DBAs managing database releases and patching

 

Skill Experience Need
Oracle 10 / 11 Expert Required
SQL Expert Required
Unix / Linux Intermediate Required
Oracle Performance Analysis Expert Required
Toad Intermediate Desired
Scripting Intermediate Required

 

 

Contact:

Anit M Parmar

Collabera

Email: anit.parmar@collabera.com

Phone: 973-598-3959

 

Implementation Specialist – Oracle SCM <<>> Location: Atlanta, GA

03/10/2011 Comments off
  • Support Oracle Planning Network Supply Chain day-to-day business operations.
  • The major responsibilities for this position are to support day-to-day supply chain operations and planning strategies specifically for Oracle Planning
  • Serve as a liaison with IT groups to understand implementation issues and supply chain impacts on business
  • Conduct system and functional research on behalf of the business-clients.

 

Skill Experience Need
Microsoft Office Intermediate Required
SQL Intermediate Required
Oracle 11i – ERP Intermediate Required
Communication Skills Intermediate Required
Interpersonal Skills Intermediate Required
Project Management Intermediate Desired
Supply Chain (3 – 5 years experience) Intermediate Required
Detail Oriented / Analytical Skills Intermediate Required
Application / Interface Knowledge Intermediate Required

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Title: Database/Reports Developer <<>> Location: St. Louis, MO

03/10/2011 Comments off
  • This job involves the mechanization of Defect Management reports and processes.
  • Three of the major initiatives are Release Risk Value, Defect Density and Client Communication mechanization. Other work will be required.
  • The candidate will also be responsible for cross training the resources on SQL server skills and provide up to date documentation for any developed systems.
  • The job requires someone who has SQL server DB skills that can write SQL code that will interface with SharePoint, Access DBs, Excel spreadsheets and other back end corporate databases like Vantive and Quality Center.

 

Skill Experience Need
Microsoft Office Intermediate Required
SQL Expert Required
SQL Server Expert Required
MS Access Expert Required

 

 

Contact:

Anit M Parmar

Collabera

Email: anit.parmar@collabera.com

Phone: 973-598-3959

 

Data Modeler <<>> Location: Middletown, NJ

03/10/2011 Comments off

System Engineer/Data Modeler:

  • IT experience in Business Intelligence: Analysis, Design, Development and Implementation of Data Warehousing, Client / Server Applications and Web based Applications.
  • Strong knowledge in all phases of Software Development Life Cycle (SDLC), including Full Life Cycle experience including requirement analysis, design, development, testing, implementation and documentation.
  • Experienced in documenting requirements. Which involve gathering, analyzing and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Knowledge of BO Universe Designing, Web Intelligence and InfoView Administration, creating Ad-hoc reports, Xcelsius and Live Office.
  • Experienced in deployment of Business Objects products from various sources like: Oracle, TeraData, MS SQL Server, DB2 and Access.
  • Experience with presenting documented requirements and conducting reviews and the ability to perform training sessions.
  • Expertise in analyzing, architecting, designing and modeling data warehouses, data marts Star Schema, Snowflake, FACT and Dimensions tables, slowly changing dimensions (SCDs) using ERWIN. Development experiences a plus.
  • Strong knowledge on Data Migration applications: such as Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse.
  • Understanding of RDBMS concepts and experience using database: Tables, Views, Stored Procedures, Functions, Packages, Triggers ODBC, SQL, Trans SQL, PL/SQL, etc.
  • Must be an excellent Team Player with ability to perform independently, have exceptional communication, analytical, interpersonal and presentation skills.

 

Skills Inventory

1) System Requirements Expert  Required

2) Database Design Expert  Required

3) Oracle DB Expert  Required

4) Data Modeling Expert  Required

5) Business Objects Intermediate  Desired

6) Application Design Architecture Expert  Required

 

 

Contact:

Anit M Parmar

Collabera

Address: 25 Airport Road, Morristown, NJ – 07960

Phone: 973-598-3959

Email: anit.parmar@collabera.com

 

Consultant – Oracle EBS – Financials, SCM and Project Accounting Apps <<>> Location: Alpharetta, GA

  • The Oracle 11i project is the implementation of corporate financials, project accounting and supply chain management systems in support of the financial, supply chain and network
  • Resource will be performing installation and configuration of highly available infrastructure for our middleware application – Install, deploy, size, scale, and manage SOA Suite 11g
  • Create a baseline Fusion Middleware Suite 11g architecture and help automate the installation procedures
  • Create a baseline SOA Suite 11g architecture and help automate the installation procedures
  • Build SOA infrastructure that is high available (HA), clustered and Disaster Recovery (DR) ready
  • Define SOA Composite Applications administration strategy, specifically around deploying, securing, managing and monitoring of the Composite Applications.
  • Will also perform day to day issues resolution

 

Skill Experience Need
Oracle Fusion/SOA Administration Expert Required
BEA WebLogic 10.X Administration Expert Required
Oracle Database Expert Required
Oracle Business Intelligence Suite – Admin Intermediate Required
Informatica – ETL Expert Required
Java development Entry Level Required
Oracle E-Business Suite Entry Level Desired

 

 

Contact:

Anit M Parmar

Collabera

Email: anit.parmar@collabera.com

Phone: 973-598-3959

 

Title: Analyst – Research – Wireless Network Data <<>> Location: Middletown, NJ

03/09/2011 Comments off

-          Basic understanding of GSM, WCDMA, and LTE wireless networks (desired)

-          High level of analytical skills

-          Ability to work with large data sets

-          Unix shell required

-          Perl highly desired

-          Ability to work with Oracle databases (SQL/PLSQL)

-          Data mining skills

-          Ability to produce quick results using meaningful assumptions, working with fuzzy network data.

-          Outstanding verbal and written communication skills, ability to interact with clients and business partners

-          MS or BS Degree from a strong school in Math/Science/Statistics/Computer Science or any Engineering field with extremely good academic standing

-          Ability to work senior managers effectively

 

 

Skill Experience Need
Exposure to telecom Entry Level Desired
Unix, Shell Entry Level Desired
Strong analytical skills Expert Required
Perl Entry Level Desired
Data mining skills Intermediate Required
Oracle SQL & PLSQL Intermediate Required
Strong communication skills Expert Required
MS Degree from a strong university Expert Desired
BS Degree from a strong university Expert Required
Skills in Excel Expert Required

 

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

Title: Oracle DBA – GoldenGate Experience <<>>Location: Chicago, IL

  • Resource will serve as ADBA SME for GoldenGate technology.
  • Will participate in full SDLC, including analysis, PoC, design, development, testing, performance tuning and improvements, implementation and post-deployment support of GoldenGate in an active / hot-standby configuration.
  • Resource will assist with configuration/installation of GoldenGate to insure company best practices are adhered to.
  • They will create scripting to enable, disable, reverse direction, synchronize, and validate replication between multiple DBs.
  • Resource will support interfacing the GoldenGate scripts with operational failover scripts.

 

 

Skill

  • SQL
  • Oracle
  • Golden Gate
  • SQL Developer
  • UNIX
  • Toad

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

 

 

Title: Oracle DB Developer <<>> Location: Piscataway, NJ

03/09/2011 Comments off
  • The Resale corporate project to shutdown applications and add functionality to other applications, significantly impacts FDW.
  • Therefore, FDW must staff up to meet the aggressive deadlines and key milestone dates.
  • The Financial Data Warehouse (FDW) is the financial repository and reporting system for Oracle Financials information.
  • The FDW runs on an Oracle/AIX platform located in the St. Louis data center. Business Objects is the adhoc & Corporate reporting tool.
  • This is a request for a temporary Systems Analyst/developer to support this release.
  • This person will be responsible for assessing requirements, completing documentation as defined by the development life cycle process, performing testing functions, performing developer activities such as coding via SQL, transferring files via Connect: Direct, and interfacing with internal clients.

 

Skill

  • Oracle DB
  • SQL
  • Unix Shell Scripting
  • Analysis
  • Life Cycle Methodology
  • Testing concepts and execution

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959

 

 

Title: Database Engineer – Oracle 11g <>> Location: Atlanta, GA

03/09/2011 Comments off
  • This project is to develop a user facing tool and supporting services that allow users to do administrative functions like enter or edit information in their profile, assign or revoke people or sets of people who can see elements of their information, add devices to their profile, enter credentials for other services to support federation.
  • Sr. Data Engineer must have an exceptionally strong technical background and experience to learn, maintain and if required re-architect enterprise data.
  • Must be able to analyze information requirements specified by multiple database projects, and follow through by architecting and designing the required data design.
  • Must be creative, innovative, bringing new and better ways of managing very large distributed and non-distributed datasets.
  • Must have the requisite people skills to interact with the business and engineering groups and sub-groups.
  • Ability to work with application architects, business and project managers to understand requirements and help define the data architecture to satisfy the requirements.
  • Must have proven track record managing technical aspects of large and complex projects with DBA and DBE teams.
  • Must be able to meet and exceed quality criteria for high-quality technical deliverables.
  • Must work to maintain and if required re-architect/re-design the enterprise wide view of the data.
  • Analyze available information requirements specified by the existing projects/products and architect and design the required solution after logically designing the data model.
  • Develop and maintain all standards pursuant to data, data structures and data models.
  • Will serve as the data technical strategy expert and will lead the creation of all technical data requirements and design deliverables.

 

Skill

  • Oracle 11g RAC
  • Database Configuration and Deployment
  • DBA
  • Stored Procedures
  • Scripting (broad knowledge)
  • Middle-ware Orchestration
  • Web Logic Application Server
  • Security Technology
  • Sequence/Interaction Diagrams

 

Contact:

Anit M Parmar

Collabera Inc

Email: anit.parmar@collabera.com

Phone: 973-598-3959