Job Description :
As a Database Engineer at Google, you own and support the needs of part of Client''s Oracle systems.
You''re highly technical and work directly with other Database Engineers, server and service owners to ensure reliability and sustainability of the Client service infrastructure as well as compliance with internal policies.
Success in this role means you are able to support
databases and work efficiently with our internal technology providers as well as other operations groups.
Client Team Members rely on your guidance when it comes to design decisions so you''ll have a direct impact in keeping the business productive.
AppOps Team Background:
AppOps team manages 3rd party services in Client (eg. gTime, GUTS
We provide support for the database layer; specifically we build, deploy and operate databases.
We primarily operate Oracle and MS SQL.
We manage 40+ services so being able to manage databases at scale is critical. (go/appops for more information)
Job responsibilities:
DBEs are expected to be able to build and automate aspects of database administration. (For eg. DB installs or refresh automation) and support Client''s complex corporate server and service environment.
Partner with internal customer teams to drive projects and improvements.
Work with customer teams to drive project goals and prioritization.
Develop, coordinate and drive small projects at service level.
Ensure compliance of service infrastructure with Google policies.
Optimize existing environment based on business and security needs.
Ensure the overall reliability and scalability of services that Googlers are dependent on.
Work with internal partner teams to collaborate on developing automated solutions.
Keep operational documentation up to date
Be part of on-call rotation.
Responsibilities of a DBE include:
Perform Database administrator (“DBA”) toil such as Tablespace extensions, adding users, schema export/import without Oracle Enterprise Manager (“OEM”)
Perform Database administration (DBA) duties in a large-scale, complex environment which includes tasks like Table and Tablespace management, Schema/User Management, Export/Import of schema, tables/tablespace, Index Rebuild/Reorganize Indexes.
Perform RMAN cloning and refreshes
Implement Physical Database Backup Strategies using RMAN (Recovery Manager) Full, Cumulative and Incremental backups.
Encrypt backups using Oracle Wallet methodology and TDE (Tablespace Data Encryption) for Data Protection and Secure data across intranets and the Internet
Perform Database Cloning based on user requirements
Performance analysis and Performance Tuning
Provide SME (Subject Matter Expertise) on Database Performance Analysis and Database Performance Tuning
Setup/Configuration of data guard broker
Design and Configure Data Replication by Log Shipping between Primary and Standby sites to ensure that there is no data loss in the event of a disaster
Provide Shell/PLSQL/Python scripts for DBA activities
Develop complex scripts that will automate repeatable solutions to support Database activities for Cloud Platform implementation.
Generate PL/SQL packages, procedures and functions, program using Python/Perl, Shell scripts and “GoLang” code, Client’s proprietary programming language tool
Provide Operational Support of Oracle and SQL server databases.
Installation and Configuration of Oracle Software and Oracle Databases on Linux and Cloud Based Platforms.
Design and Create Oracle Databases adhering to Client''s business needs and organization standards.
Troubleshoot and Resolve high severity tickets
Implement Database Migration from legacy applications to cloud platform/infrastructure
Apply OS (Operating System) and Database Level Security Vulnerability Patches such as PSU (Patch Set Updates) and (CPU) Critical Patch Updates, Security Patches and One-Off Patches for Bug Fixes to ensure an error free environment and sustain Strong database level security
Install, configure and maintain Oracle High Availability solution, Real Application Clusters (RAC), to ensure minimal to no disruption of services to users and Client Customers in an event of software/hardware failures.
Analyse using the DMAIC (Define, Measure, Analyse, Improve, Control methodology to arrive at the RCA (Root Cause Analysis)
Qualifications:
BS degree in Computer Science or related field or equivalent practical experience.
2 years of experience with Oracle databases (versions 11g and 12c
Coding experience in one or more multi-purpose languages such as Python, Perl or Go.
Experience with bash scripting.
Oracle replication with Data guard.