Oracle Hiring for Principal Solution Architect – GoldenGate Solution Architect at Atlanta Full Time

Job Description

As a Principal Solutions Architect, you will play a pivotal role in designing, implementing, and optimizing complex software solutions. Your expertise will span various databases, including Oracle, Kafka, SQL Server, Snowflake, and Big Data platforms. You’ll collaborate closely with customers, development teams, and other collaborators to address intricate technical challenges. Additionally, your ability to troubleshoot and optimize systems will be essential.

Career Level – IC4

Responsibilities

Responsibilities

1. Architectural Leadership:

2. Provide comprehensive consultations to business leaders, IT management, and technical staff.

3. Offer guidance on architecture, integration, standard methodologies, and industry standards.

4. Evaluate and select appropriate technologies for solution design.

5. Technical Design and Documentation:

6. Collaborate with software architecture design teams to create scalable, reliable, and maintainable systems.

7. Design technical architectures for complex solutions.

8. Develop and document design models, ensuring clarity and alignment with business requirements.

9. Troubleshooting and Optimization:

10. Investigate and resolve complex technical issues related to replication software (e.g., Golden Gate).

11. Drill down into subsystems, including databases, SQL performance tuning, network tuning, and I/O optimization.

12. Create troubleshooting documents and step-by-step guides for problem resolution.

13. Innovation and Collaboration:

14. Influence key architects’ viewpoints regarding system design and technology selections.

15. Analyze systems and try to predict failures and optimize performance based on historical data.

16. Collaborate with domain experts, data scientists, and big data platform architects to design efficient data ingestion frameworks.

Qualifications

• An understanding of Replication processes. GoldenGate, etc.

• A basic understanding of REST

• What is it?

• A basic understanding of JSON

• A basic understanding of DBMS endpoints (Oracle, MySQL, SQL Server, DB2, PostgreSQL):

• How do you connect to a database from a shell?

• How do you create a table?

• How do you get a table’s metadata?

• How do you assign user privileges?

• A basic understanding of Snowflake.

• How do you connect to a database from a shell?

• How do you find out what databases exist?

• How do you create a table?

• What are Snowflake primary keys used for?

• A basic understanding of Kafka.

• What is kafka?

• What is a Broker, Producer, and Consumer?

• What is a Topic?

Disclaimer

Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates.

Range and benefit information provided in this posting are specific to the stated locations only

Canada: Hiring Range from $76,700 to $167,000 CAD per annum

US: Hiring Range: from $94,200 to $223,500 per annum. May be eligible for bonus and equity.

Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle’s differing products, industries and lines of business.

Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.

Oracle US offers a comprehensive benefits package which includes the following

1. Medical, dental, and vision insurance, including expert medical opinion

2. Short term disability and long term disability

3. Life insurance and AD&D

4. Supplemental life insurance (Employee/Spouse/Child)

5. Health care and dependent care Flexible Spending Accounts

6. Pre-tax commuter and parking benefits

7. 401(k) Savings and Investment Plan with company match

8. Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.

9. 11 paid holidays

10. Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.

11. Paid parental leave

12. Adoption assistance

13. Employee Stock Purchase Plan

14. Financial planning and group legal

15. Voluntary benefits including auto, homeowner and pet insurance

This job requires proficiency in the English language. Oracle is a global company with operations in dozens of countries around the world and our teams, including the team this position is part of, are comprised of individuals located in various jurisdictions. As is required of employees in all jobs at Oracle in North America, candidates for this position are required to understand, and communicate, in English so that in the course of performing their work, they can interact with teammates in other locations who are not fluent in the French language.

About Us

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s problems. True innovation starts with diverse perspectives and various abilities and backgrounds.

When everyone’s voice is heard, we’re inspired to go beyond what’s been done before. It’s why we’re committed to expanding our inclusive workforce that promotes diverse insights and perspectives.

We’ve partnered with industry-leaders in almost every sector-and continue to thrive after 40+ years of change by operating with integrity.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer a highly competitive suite of employee benefits designed on the principles of parity and consistency. We put our people first with flexible medical, life insurance and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by calling +~~~, option one.

Disclaimer:

Oracle is an Equal Employment Opportunity Employer*. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

*** Which includes being a United States Affirmative Action Employer**