Sr CloudOps Database Administrator

Job Description

Looking to start an exciting new career as a Cloud Database Administrator? Do you have a basic understanding of relational databases and the SQL language? Guidewire is looking for a highly motivated individual to join our Cloud Operations team as an 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.

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 maintenances.

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

Why Guidewire?

Guidewire exists to deliver the industry platform that P&C insurers rely upon to adapt and succeed in a time of accelerating change—and to ensure that every customer succeeds in the journey. We provide the software, services, and partner ecosystem to enable our customers to run, differentiate, and grow their business.

Guidewire InsurancePlatform is the P&C industry platform that unifies software, services, and partner ecosystem to power our customers’ business. InsurancePlatform provides the standard upon which insurers can engage their customers, optimize their operations, drive smart decisions, and innovate quickly. We are privileged to serve more than 350 P&C insurers in 32 countries. We invest heavily in R&D to build a technology platform that combines three elements—core processing, data and analytics, and digital engagement—to enhance insurers’ ability to engage and empower their customers and employees.