About Colgate-Palmolive

Do you want to come to work with a smile and leave with one as well? In between those smiles, your day is comprised of connecting with others across the world, full of stimulating discussions, and making impactful contributions.

If this is how you see your career, Colgate is the place to be! Our trustworthy household brands, dedicated employees, and sustainability commitments make us a company passionate about building a future to smile about for our employees, consumers, and surrounding communities. As the brand with the highest household presence in the world, we transcend physical boundaries. We win as a global organization by continually learning and collaborating. The pride in our brand fuels a workplace that encourages creative thinking, fosters experimentation, and promotes authenticity which has contributed to our enduring success. If you are passionate about working for a company that lives by their values, then give your career a reason to smile...every single day.

Why work for Colgate-Palmolive?

• The learning & development opportunities: You will refine your commercial mind-set and continue to learn new skills working closely with a multi-functional team giving you exposure to all local market departments

• The challenge & variety: You will operate in a fast paced operational environment, directly impacting the day-to-day performance of the business, with personal accountability for your business

• The global experience: You will have the opportunity to work with global brands, participate in global strategies with potential to develop your career internationally

• The Colgate Values: Caring, global collaboration and continuous improvement are integral to how we operate every day

The Role

We are 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 proficient 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.

Key Responsibilities

• Build and maintain databases access systems including tables, indexes, views, stored procedures, and triggers

• Configure and administer relational databases

• Set up, test and maintain database backup and recovery systems and processes

• Tune and optimize database objects

• Develop new databases using sound problem solving techniques including performing root cause analysis and identification of corrective action for given problems

• Uses tools and scripting to efficiently manage technology

• Translate business requirements into action through detailed data design and development

• 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 optimally in a large team or departmental setting

Basic Requirements

• Bachelor Degree in Computer Science or related field, or equivalent.

• 5+ years of proven ability using Oracle 11g or newer and other RDBMS including MS-SQL or MySQL

• 5+ years of demonstrated ability with large scale databases and environments.

• Experience in UNIX/Linux environments with a detailed understanding of the underlying operating system.

• Experience in SQL/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 troubleshooting and database performance tuning principles.

• Excellent written and verbal communication.

• Define policies and establish standards for data modeling, structuring, naming, describing, securing and formatting data

• Experience with Agile and Waterfall project management methodologies

Preferred Requirements

• Google Cloud Platform; Fire Store

• Working experience with Amazon Web Services (AWS), Amazon API Gateway

• 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.