Job DescriptionAs 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 - IC4ResponsibilitiesResponsibilities
Architectural Leadership:
Provide comprehensive consultations to business leaders, IT management, and technical staff.
Offer guidance on architecture, integration, standard methodologies, and industry standards.
Evaluate and select appropriate technologies for solution design.
Technical Design and Documentation:
Collaborate with software architecture design teams to create scalable, reliable, and maintainable systems.
Design technical architectures for complex solutions.
Develop and document design models, ensuring clarity and alignment with business requirements.
Troubleshooting and Optimization:
Investigate and resolve complex technical issues related to replication software (e.g., Golden Gate).
Drill down into subsystems, including databases, SQL performance tuning, network tuning, and I/O optimization.
Create troubleshooting documents and step-by-step guides for problem resolution.
Innovation and Collaboration:
Influence key architects’ viewpoints regarding system design and technology selections.
Analyze systems and try to predict failures and optimize performance based on historical data.
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 onlyCanada: Hiring Range from $76,700 to $167,000 CAD per annumUS: 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:
Medical, dental, and vision insurance, including expert medical opinion
Short term disability and long term disability
Life insurance and AD&D
Supplemental life insurance (Employee/Spouse/Child)
Health care and dependent care Flexible Spending Accounts
Pre-tax commuter and parking benefits
401(k) Savings and Investment Plan with company match
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.
11 paid holidays
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.
Paid parental leave
Adoption assistance
Employee Stock Purchase Plan
Financial planning and group legal
Voluntary benefits including auto, homeowner and pet insurance
About UsAs 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 +1 888 404 2494, 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