Share this Job

Site upgrade in progress. You will not be able to apply at this time. Please be patient and check back with us later.

Established in 1806 as a small soap and candle business in New York City, Colgate-Palmolive is now a truly global company with products sold in over 200 countries under such internationally recognized brand names as Colgate, Palmolive, Softsoap, Irish Spring, Protex, Sorriso, Kolynos, elmex, Tom's of Maine, Sanex, Ajax, Axion, Soupline, Haci Sakir, Suavitel, PCA SKIN, EltaMD, Filorga and Hello as well as Hill's Science Diet, Hill's Prescription Diet and Hill's Ideal Balance.

Colgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more enjoyable, and programs that enrich communities around the world.

Every day millions of people trust our products to care for themselves and the ones they love. Our goal is to use our technology to create products that will continue to improve the quality of life for our consumers wherever they live.

A career at Colgate-Palmolive is an excellent opportunity if you seek a global experience, constant challenge, and development opportunities in an environment that respects work/life effectiveness.

Job Title:  Database Architect

Travel Required?:  Travel - up to 10% of time
Date: 
Remote working option during the current situation

No Relocation Assistance Offered
# 87747 - Piscataway, New Jersey, United States

Colgate-Palmolive is seeking an Oracle Database Architect to join our team in Piscataway, NJ. 
As a Database Architect at Colgate-Palmolive GIT, the position will help support and reinforce the company's websites and applications. This role is largely responsible for the configuration, implementation, and maintenance of database systems to ensure high performance with excellent reliability. We are looking to fill this position with a highly competent and motivated individual that enjoys working across all environments including production. This role requires a service oriented mentality with a high sense of ownership. A focus on problem prevention, managing and resolving issues, performing changes on production systems, and proactively communicating issues internally. 

 

Responsibilities: 

  • Create and maintain database access systems including tables, indexes, views, stored procedures, and triggers
  • Configure and administer relational databases
  • Administer database replication between servers, across Local Area Network and Wide Area Network
  • Set up, test and maintain database backup and recovery systems and processes
  • Tune and optimize database objects
  • Provides reliable solutions to a variety of problems using sound problem solving techniques including performing root cause analysis and identification of corrective action for given problems
  • Performs and plans minor version upgrades
  • Uses tools and scripting to efficiently manage technology
  • Experience with modeling tools like PowerDesigner or ERWIn
  • Develop and maintain ETL processes that import and export data from various sources in a variety of formats.
  • Design and develop automated interfaces to 3rd party systems using stored procedures and shell scripts.
  • Design logical and physical data models and flowcharts for both relational and dimensional solutions
  • Translate business requirements into action through detailed data design and development
  • Makes recommendations for component level improvements
  • Identifies interdependencies in system and application components
  • Work directly with consultants and technicians from vendor companies
  • Demonstrates proficient use and knowledge of standards and procedures
  • Communicates in written and verbal form effectively in a large team or departmental setting

Basic qualifications:

  • Bachelor Degree in Computer Science or related field, or equivalent.
  • 5+ years experience using Oracle 11g or newer and other RDBMS including MS-SQL or MySQL
  • 5+ years experience with large scale databases and environments.
  • Experience in UNIX/Linux environments with a thorough understanding of the underlying operating system. 
  • Experience in shell scripting. 
  • Experience in database change management/data management through the various stages of the system development life cycle. 
  • Oracle tools (SQL*Plus, Data Pump, SQL Loader, RMAN, Data Guard) experience is a major plus
  • Knowledge and experience in database security management. 
  • Knowledge and experience in database architecture and system design. 
  • Knowledge and experience in database performance tuning principles. 
  • Excellent written and verbal communication.
  • Experience/ability to learn Business Intelligence Tools and Data Warehouse design
  • PL/SQL scripting skills 
  • Define policies and establish standards for modeling, structuring, naming, describing, securing and formatting data
  • Experience with Agile and Waterfall project management methodologies

 

Preferred Qualifications:

  • Google Cloud Platform; Fire Store
  • Working experience with Amazon Web Services (AWS), Amazon API Gateway, DynomoDB
  • Experience with Adobe Experience Manager (AEM) or other Content Management Systems
  • Experience with Oracle Real Application Clusters (RAC) 
  • Experience with Managed Dedicated and Cloud Computing Services
     

Equal Opportunity Employer
Colgate is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity, sexual orientation, national origin, ethnicity, age, disability, marital status, veteran status (United States positions), or any other characteristic protected by law.

Are you interested in working for Colgate-Palmolive? You can apply online and attach all relevant documents such as a cover letter and resume or CV. Applications received by e-mail are not considered in the selection process. Become part of our team. We look forward to your application.

Colgate-Palmolive is a leading global consumer products company, tightly focused on Oral Care, Personal Care, Home Care and Pet Nutrition. Colgate sells its products in over 200 countries and territories around the world under such internationally recognized brand names as Colgate, Palmolive, elmex, Tom’s of Maine, Sorriso, Speed Stick, Lady Speed Stick, Softsoap, Irish Spring, Protex, Sanex, Elta MD, PCA Skin, Ajax, Axion, Fabuloso, Soupline and Suavitel, as well as Hill’s Science Diet and Hill’s Prescription Diet. 

For more information about Colgate’s global business, visit the Company’s web site at http://www.colgatepalmolive.com. To learn more about Colgate Bright Smiles, Bright Futures® oral health education program, please visit http://www.colgatebsbf.com. To learn more about Hill's and the Hill’s Food, Shelter & Love program please visit http://www.hillspet.com. To learn more about Tom’s of Maine  please visit  http://www.tomsofmaine.com.

Reasonable accommodation during the application process is available for persons with disabilities. Please contact Application_Accommodation@colpal.com with the subject "Accommodation Request" should you require accommodation.


Nearest Major Market: New Jersey

Job Segment: Database, Architecture, Warehouse, Oracle, Developer, Technology, Engineering, Manufacturing