Cloud DataBase Engineer

Job description

Description

Why P&G?

P&G is the largest consumer packaged goods company in the world. We have operations in about 80 countries, building 65 trusted brands that make life better for 5 billion consumers in more than 180 countries. This brings many advantages, including the opportunity for our employees to enjoy a diverse and rewarding lifelong career filled with new and exciting challenges.

From Day 1, you’ll help fulfill our purpose of improving lives in 180 countries through leading, billion-dollar brands. We believe great ideas emerge from the creative connections that happen between our talented employees and we encourage our multi-functional teams to work together to come up with new ideas to address challenges we face.

Our Opportunity

Our move to a “Cloud-First” strategy has quickly led to a massive shift of application development and hosting to the major public clouds. With this shift has come the challenge to engineer, operate and secure these environments. To address this, we are building an elite engineering team and seeking to staff up rapidly with both external and contract-to-hire resources. While the initial focus will be more traditional database areas (e.g. Oracle, SQL Server, MySQL, etc.), resources are expected to flex into different DBMS areas when needed.

This position is for a DBA engineering role with specialization in a major database technology and knowledge of cloud DB technologies and database types, such as transcational databases, data warehouses, NoSQL, Big Data, etc. The role will include the major cloud environments (AWS, Azure, GCP), so hands-on experience in at least one cloud environment required, with deep experience preferred. The applicant should have at least 5 to 10+ years of experience as a hands-on DBA and act as a “leader with vision” with respect to database management. Specific types of potential responsibilities for this role include:

·  Build new cloud-based database environments for P&G cloud initiatives.
·  Serve as overall domain expert on all database technologies (Oracle, SQL Server, NoSQL, etc.) and market capabilities/trends.
·  Collaborate with internal and external parties to transform high-level technical objectives into comprehensive technical requirements.
·  Formulate detailed design specifications for stable and secure database computing operations in a dynamic cloud-based environment.
·  Own database engineering, enhancements, and improvements for reliability, security, scalability, manageability, and performance across a wide variety of network, storage, and compute technologies.
·  Explore, identify, plan, and embrace emerging cloud database and storage technologies, features, and capabilities.
·  Analyze on-premise and cloud database installations and evaluate transformation opportunities.
·  Define database reference architectures and migration approaches to help transform and migrate on-premise databases into public clouds.
·  Provide L3 operational support for data feeds, system performance and availability events.
·  Install database management systems (DBMS) and provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance. Independently perform administration for a particular application portfolio as needed.
·  Configure and manage database environments, including database physical structure and functional capabilities, security, test case planning, back-up, and recovery specifications.
·  Perform tasks such as loading data, monitoring database health, tuning, and other administration task.
·  Design, maintain, and enhance design data dictionaries, physical and logical database models, maintain a central repository of database information.
·  Ensure database security and integrity. Performs audit reviews including authorization check, cross-database dependency checks, review initialization parameters, connect permissions, server security settings etc.
·  Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
·  Ensure software compliance and usage to regulatory and licensing constraints.
·  Create debugging procedures and other database objects as appropriate for problem investigation and resolution.
·  Develop capacity plans, forecast capacity growth, and build changes needed to scale database infrastructure to meet business demand while balancing cost with performance.

Qualifications

Required:

·  Oracle DBA or SQL Server DBA (or equivalent) in a cloud environment, with at least 5 to 10+ years’ experience as a DBA
·  Bachelor's Degree in an IT related field
·  Strong knowledge of automation concepts, tools, and scripting languages (e.g. Python, JavaScript, Bash Shell, PowerShell, Puppet, Terraform)
·  Knowledge of database monitoring and alerting tools, both cloud-native and third-party
·  Experienced in administration of DBMS systems with working knowledge of UNIX/Linux OS administration, disk configuration, and network configuration
·  Understand interaction between database and non-database components with expertise in SQL and database programming languages (PL/SQL, TSQL, etc.)
·  Independently led database administration for multiple projects in similar industry or function
·  Experience in automating routine administrative tasks
·  Excellent verbal and oral communication skills (English) with both technical and non-technical colleagues from geographically distributed teams on all organizational levels.

Preferred Qualifications

·  Results-oriented with a strong ability to prioritize and deliver results.
·  Problem-solving attitude (blameless post-mortem).
·  Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations
·  Deep understanding of database logging, replication options including CDC (Change Data Capture)
·  Hands on systems administration for Windows, Linux, and/or UNIX
·  Cloud vendor (Azure, GCP, AWS) certification at the administrator or developer level
·  Awareness of basic information security awareness protocols, software security in the SDLC lifecycle, and OWASP Top 10 concepts
·  IT operations background and/or ITIL foundations knowledge

The Value of a P&G Career

•Ongoing coaching and career development – you will work with passionate people and have access to best in class training through our P&G Leadership Academy as well as day-to-day mentoring from your manager.
•We provide a market-competitive salary benchmarked against the finest companies, so you'll be able to spend your generous vacation time doing more of the things you love with the people you love.
•We offer a suite of benefits, including but not limited to: flexible working arrangements, remote working options, generous paid vacation increasing with service, generous parental leave policies, group life insurance, health insurance, and dedicated support to help you find the right child care or elder care.
•Additional perks include discounted P&G products from our company shops and a discount platform offering you unbeatable savings on everything from groceries to exotic holidays.
•What's more, your financial package might include things like interest-free loans, a tax-advantageous share purchase plan, a contributory pension plan, and financial education and advisement on topics including purchasing real estate and generating wealth.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, disability status, age, sexual orientation, gender identity and expression, marital status, citizenship, HIV/AIDS status or any other legally protected factor.
No immigration sponsorship is available for this position. Procter & Gamble does not sponsor candidates for permanent residency except in some areas that in Procter & Gamble's sole discretion require highly specialized backgrounds.
Procter & Gamble participates in e-verify as required by law.

Job locations:
Cincinnati, Ohio, United States Job Type: Full-time Req No: IT 00002140