SENIOR ORACLE/ORACLE GOLDENGATE ENGINEER (REMOTE)
Company: GovCIO
Location: Olympia
Posted on: October 2, 2024
|
|
Job Description:
OverviewGovCIO is currently seeking an experienced Senior Oracle
and Oracle GoldenGate Engineer with Cloud Experience to join our
dynamic team. This is a fully remote position located within the
United States.ResponsibilitiesIn this role, you will be responsible
for designing, implementing, and managing Oracle database
environments both on-premises and in the cloud (AWS, Azure, Oracle
Cloud) and Oracle GoldenGate. You will manage complex database
environments, perform migrations, and ensure seamless data
replication for high-availability and disaster recovery.The ideal
candidate has extensive experience with Oracle Database (12c, 19c),
Oracle GoldenGate, performance tuning, and data replication
strategies. You will work closely with cross-functional teams,
including DevOps, infrastructure, and application development, to
deliver reliable and scalable database solutions.Oracle Database
Administration:Install, configure, and maintain Oracle databases
(12c, 19c).Perform database tuning, capacity planning, and
optimization.Manage Oracle RAC, Data Guard, and ASM environments
for high availability.Implement and manage backup/recovery
processes using RMAN.Oracle GoldenGate Implementation:Design and
implement Oracle GoldenGate solutions for real-time data
replication across heterogeneous environments.Set up and configure
Oracle GoldenGate for disaster recovery, data integration, and
migrations.Monitor and troubleshoot GoldenGate processes to ensure
high availability and data integrity.Implement and support Oracle
GoldenGate processes for multi-master replication.Database
Migrations and Upgrades:Plan and execute database migrations to new
versions of Oracle or from other database platforms using Oracle
GoldenGate.Ensure minimal downtime and data consistency during
migrations.Cloud Architecture & Migration:Design and implement
Oracle databases on cloud platforms (AWS RDS, Oracle Cloud
Infrastructure, or Azure).Lead database migration projects from
on-premises to cloud environments, ensuring minimal downtime and
data integrity.Configure and optimize cloud infrastructure (e.g.,
AWS EC2, S3, RDS, Oracle Cloud) to support Oracle
workloads.Performance Tuning and Optimization:Analyze and resolve
performance bottlenecks within the Oracle Database and Oracle
GoldenGate environment.Perform SQL query optimization and analyze
AWR, ASH, and ADDM reports for performance tuning.Automate database
tasks, such as backups, scaling, and monitoring, using cloud-native
tools (AWS Lambda, CloudWatch, etc.).Analyze database performance
and optimize queries, indexes, and configurations for both on-prem
and cloud databases.Collaboration and Documentation:Collaborate
with cloud infrastructure, DevOps, and application development
teams to design, deploy, and maintain database solutions that meet
application requirements.Work closely with DevOps, infrastructure,
and application development teams to integrate databases with
business applications.Develop and maintain documentation for
database configurations, processes, and procedures.Provide
mentoring and support to junior database administrators and
engineers.Support operational excellence in a Cloud DevOps
environment.Security and Compliance:Implement security best
practices for Oracle Database and Oracle GoldenGate
environments.Ensure database environments meet compliance
requirements for security, auditing, and data
protection.QualificationsRequired Qualifications:Bachelor's with
12+ years (or commensurate experience) with Oracle Database
administration (versions 12c, 19c).5+ years of experience working
with Oracle GoldenGate (configuration, tuning,
troubleshooting).Extensive experience with Oracle RAC, Data Guard,
ASM, and RMAN.Strong knowledge of Linux/Unix environments and shell
scripting.Ability to work with minimal supervision.Clearance
Required: Public TrustExpert in Oracle GoldenGate architecture,
bi-directional replication, and troubleshooting.Hands-on experience
with database performance tuning and optimization.Experience in
database migrations, especially cross-platform using Oracle
GoldenGate.Hands on with Redhat Linux.Solid understanding of
PL/SQL, SQL, and database design best practices.Proficiency with
C/C++.Scripting proficiency, in a language such as Python, Perl or
Bash.Hands-on experience developing multi-threaded embedded Linux
application/infrastructure.Desired Skills and Attributes:Strong
analytical and problem-solving skills.Excellent communication
skills and ability to work collaboratively with cross-functional
teams.Self-driven and capable of working in a fast-paced
environment.Detail-oriented with strong documentation and process
skills.Certifications (Preferred):Oracle Certified Professional
(OCP) or Oracle Certified Expert (OCE).Oracle GoldenGate
certification is a plus.Clearance Required: Ability to obtain and
maintain Public Trust/SuitabilityCompany OverviewGovCIO is a team
of transformers--people who are passionate about transforming
government IT. Every day, we make a positive impact by delivering
innovative IT services and solutions that improve how government
agencies operate and serve our citizens.But we can't do it alone.
We need great people to help us do great things - for our
customers, our culture, and our ability to attract other great
people. We are changing the face of government IT and building a
workforce that fuels this mission. Are you ready to be a
transformer?We are an Equal Opportunity Employer. All qualified
applicants will receive consideration for employment without regard
to race, color, religion, sex, gender, gender identity or
expression, sexual orientation, national origin, disability, or
status as a protected veteran. EOE, including
disability/vets.Posted Pay RangeThe posted pay range, if
referenced, reflects the range expected for this position at the
commencement of employment, however, base pay offered may vary
depending on multiple individualized factors, including market
location, job-related knowledge, skills, education, experience, and
internal equity. The total compensation package for this position
may also include other compensation elements, to be discussed
during the hiring process. If hired, employee will be in an
"at-will position" and the GovCIO reserves the right to modify base
salary (as well as any other discretionary payment or compensation
program) at any time, including for reasons related to individual
performance, GovCIO or individual department/team performance, and
market factors.Posted Salary RangeUSD $140,000.00 - USD $180,000.00
/Yr.Submit a referral to this job
(https://careers-govcio.icims.com/jobs/4735/senior-oracle-oracle-goldengate-engineer-%28remote%29/job?mode=apply&apply=yes&in_iframe=1&hashed=-1834385473)Location
US-RemoteID 2024-4735Category Information TechnologyPosition Type
Full-Time
Keywords: GovCIO, Seattle , SENIOR ORACLE/ORACLE GOLDENGATE ENGINEER (REMOTE), IT / Software / Systems , Olympia, Washington
Click
here to apply!
|