Cloud Ops Database Administrator

About Guidewire Software

Guidewire is the platform P&C insurers trust to engage, innovate, and grow efficiently. We combine digital, core, analytics, and AI to deliver our platform as a cloud service. More than 450 insurers, from new ventures to the largest and most complex in the world, run on Guidewire.

As a partner to our customers, we continually evolve to enable their success. We are proud of our unparalleled implementation track record with 1000+ successful projects, supported by the largest R&D team and partner ecosystem in the industry. Our Marketplace provides hundreds of add-ons that accelerate integration, localization, and innovation.

For more information, please visit www.guidewire.com and follow us on Twitter: @Guidewire_PandC.

Guidewire Software Inc. provides equal employment opportunities to all applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. All offers are contingent upon passing a criminal history and other background checks where it's applicable to the position.

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

The Position

Guidewire is looking for a highly motivated individual to join our Cloud Operations team as a Database Administrator. As a DBA at Guidewire, assignments, decision-making, and complexity are not limited to just carrying out established work processes and operations. You will be learning new and exciting AWS processes as we embrace our journey to the cloud. In addition, you will learn additional database platforms which will expand your skills in both database administration, performance tuning, and Cloud Computing.

Duties

• Assist in daily administration activities including setup, configuration and monitoring of databases to ensure backups, availability and performance are all maintained to the highest standards.
• Tuning, trouble shooting and on-call production support for database environments deployed in multi-AZ AWS environments both on the EC2 and RDS/Aurora platforms.
• Monitor and work the JIRA ticket queue for request to make schema changes, security changes, execute scripts against the databases and refresh non-production databases.
• Advise application development and support teams on process bottlenecks and provide database tuning to ensure optimal performance.
• Assist the support staff to troubleshoot SQL and any other database errors.
• Provide 24*7 on-call support (includes holidays) for the Oracle, Microsoft SQL Server and Aurora (MySQL/PostgreSQL) production and non-production databases.
• Report weekly to management about abnormalities and critical issues; provide root cause analysis and recommendations; work with infrastructure team, application team and/or other teams for problem resolutions, following the escalation path if needed.

Requirements

Desired Skills

• Deploying or migrating databases into AWS (ec2 or RDS) or any hands-on experience working with AWS or other public cloud providers a distinct advantage.
• Highly proficient in one or more of these RDBMS technologies:
• MS SQL Server
• AWS RDS/Aurora (mySQL)
• PostgreSQL
• Oracle
• Working knowledge of one or more database high availablilty scenarios such as:
• AWS Multi-AZ database deployments
• MS SQL Server Always on Availability Groups
• Oracle Dataguard
• Knowledge of one or more database data replication tools such as:
• MS SQL Server transactional replication
• Oracle Golden Gate
• AWS DMS/DMT
• Unix/Linux general administration skills and/or bash/python/powershell scripting a distinct advantage
• Knowledge of ANSI SQL Language (SELECT, INSERT, UPDATE, DELETE, JOIN, WHERE, etc…).
• Strong analytical, communication both written and verbal and quality control skills.
• Ability to manage multiple tasks with different deadlines.
• Detail oriented, self-motivated and uses sound judgment.
• A team player who works well with others.
• Desire to learn and improve your skills.

Minimum Qualifications

• Proficient in Microsoft Office Suite products.
• General desktop with Windows and Linux server experience.
• Be available after hours and weekends as necessary for customer maintenance's.

Education and Experience

• Bachelor’s Degree in related area preferred
• 5+ years’ experience in database administration
• 3+ years’ experience in Oracle, MySQL, MSSQL or other database scripting language

Our Hiring Process

The process varies depending on the job you applied for. In general, you can expect to meet with one of our recruiters or sources for an exploratory call to see if you are a fit for the role. After that, if it’s a technical role you’ll be invited to complete a code test. Based on the results you’ll move to the next stage to meet the hiring manager and other team members during an online Zoom interview. There’ll be one more round of Zoom interviews if you’re one of the top candidates being considered for the role. For other non-technical roles, the process is pretty similar - except no code test required. Your recruiter will make sure you clearly understand what’s needed at every stage!

1. Choose your starting point...

Your adventure begins when you discover a role that excites you on our careers listings. Think you and the role are a great match for each other? Then set it as your journey's starting point, and submit an application to help you stand out from the crowd. Remember, this is your time to shine. So show us why you and our role are a great match!

2. Get prepared...

If your application is successful, a recruiter will chat with you before arranging a Zoom interview. This is your chance to get prepared and really investigate the role. Ask our recruiters all about Guidewire and the specifics of the job; make sure it’s right for you. Share your story with our recruiters too; what motivates you, what drives you to seek challenges, what makes you dig deeper? Of course, if you don’t feel this is the right role for you but you still want to work at Guidewire in the future, we can stay connected.

3. Meet the crew...

If your chat with our recruiter goes well, it’s time for the next step: an interview, where you can show us what you’re made of. The process can differ from team to team here. You may take an online code test for more technical roles, share ideas in a group presentation, or even take a live programming and theoretical questions interview. Whatever route you take, though, one thing remains constant: the Guidewire team is super excited to get to know you. Your recruiter will be there to support and help prepare you at every step. And you’ll get to meet lots of members of the Guidewire team, discovering first-hand that we all want you to do your best here. We’re rooting for you!

4. Adventure

Once the interview process is complete, our teams get together and decide whether you’re the best match for the role. If you’re the one, then our recruiter will share the details of the offer with you. Then the ball is in your court: you can decide whether you’re joining the Guidewire crew. If it’s a yes, it’s a pretty streamlined process from here on out. Sign all your documents via DocuSign, and work with our dedicated coordination team to go through the background check process and final steps. It’s only a matter of time until you join our team of explorers—and we are beyond excited to have you on board!

Benefits

• FINANCIAL - Receive market-competitive pay and incentive programs—because you deserve it! To help future-proof your income, we offer generous support through retirement savings plans.
• HEALTH AND WELLNESS - Keep your physical and emotional health in tip-top shape with health insurance for you and your family, an employee assistance program, annual wellness reimbursement, and access to wellness resources.
• FLEXIBLE WORKING - Work in an environment where you’ll have the freedom and trust to make an impact, with time for your life outside of work.
• DOWNTIME - Relax and kick back through our generous paid time-off programs. Make a difference in your community with three volunteer days each year. Take your own personal day of rest with My Day. We also offer ample paid leave for all new parents.
• CONTINUAL DEVELOPMENT - We encourage self-directed learning, giving you every chance to become a better version of yourself, both professionally and personally. At Guidewire, lifelong learning is here for the taking.
• CAREER MOBILITY - Your career opportunities are only limited by your own imagination. Guidewire’s community is filled with chances to expand your horizons across any of our teams or worldwide‌‌‌‌‌‌‌ locations.