Let’s get started
By clicking ‘Next’, I agree to the Terms of Service
and Privacy Policy
Jobs / Job page
Platform Support DBA III image - Rise Careers
Job details

Platform Support DBA III

Guidewire is looking for a proactive and solution-driven Cloud Platform Support DBA to join our dynamic Platform Support team. The Platform Support DBA will work collaboratively within the Product Development Operations (PDO) team, serving our customers in both Guidewire Cloud and on-premise environments. This role requires a keen understanding of our platform, backed by the continuous learning provided by Guidewire Education, Product Development, and Cloud Engineering teams.  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. The successful candidate will be part of the Product Development Operations (PDO) organization working in a hybrid environment that delivers 24x7 service to customers who are using our software in the Guidewire Cloud.


Responsibilities:
  • Function as a primary contact to research, address, and promptly fulfill Database requests and resolve cases in adherence to team standards, thereby ensuring we meet and exceed customer satisfaction. Provide support for the Oracle, Microsoft SQL Server and Aurora (MySQL/PostgreSQL) production and non-production databases.
  • Document and maintain technical articles, including troubleshooting guides, knowledge base articles, and runbooks, in order to meet objectives for customer request fulfillment and issue resolution. 
  • Develop and maintain in-depth knowledge of our database through company-sponsored training and experience 
  • 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, troubleshooting and production support for database environments deployed in multi-AZ AWS environments both on the EC2 and RDS/Aurora platforms.
  • Monitor and work Salesforce/ JIRA ticket queue for requests to make schema changes, security changes, execute scripts against the databases and refresh non-production databases.
  • Collaborate with the application development and support teams on process bottlenecks and provide database tuning to ensure optimal performance.  Develop and maintain strong relationships with customers and stakeholders, acting as a trusted advisor and technical point of contact.
  • Assist the support staff to troubleshoot SQL and any other database errors.
  • 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.
  • Contribute to an environment that encourages information sharing, team-based resolution activity, cross-training, and an absolute focus on doing what is best for the customer


Required skills and experience:
  • Bachelor’s Degree in Computer Science (or a related STEM field), or related experience
  • General desktop with Windows and Linux server experience.
  • 5+ years’ experience in database administration
  • 3+ years’ experience in Oracle, MySQL, MSSQL or other database scripting language
  • Deploying or migrating databases into AWS (ec2 or RDS) or any hands-on experience working with AWS.
  • Highly proficient in one or more of these RDBMS technologies:
a) AWS RDS/Aurora MySQL 
b) AWS RDS/Aurora PostgreSQL
c) AWS RDS Oracle
d) MS SQL Server
  • Working knowledge of one or more database high availability scenarios such as:
a) AWS Multi-AZ database deployments
b) MS SQL Server Always on Availability Groups
c) Oracle Data Guard
  • Knowledge of one or more database data replication tools such as:
a) AWS DMS/DMT
b) MS SQL Server transactional replication
c) Oracle Golden Gate
  • 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.
  • Experience in working with AWS services, such as EC2, S3, RDS, and (Kubernetes) ECS/EKS, to deploy and manage Java applications in a cloud environment is a plus.
  • Experience solving problem software code and reporting progress; preference for experience with a commercial customer incident tracking or CRM like Salesforce.com
  • Experience using a software defect tracking system such as JIRA preferred
  • Skills to read and interpret application server log files
  • 3+ years’ experience working directly with customers or key internal partners; preference for support for a B2B software company
  • Outstanding troubleshooting skills; ability to think critically and display an aptitude for problem-solving
  • We provide 24x7 support and while the many of our shifts are Monday through Friday during daytime hours, we rotate shifts monthly so there will be some evening and weekend shifts included in order to cover after-hours production emergencies
  • Read, write, and speak fluent English. Score bonus points if you can also have skills in another language such as French or German


Personal Qualities and Soft skills:
  • You enjoy teaching and being a mentor to others
  • Good communication and presentation skills
  • Display a strong work ethic and do whatever it takes to get the job done
  • A highly positive can-do attitude with a knack for being a team player
  • Excellent communication skills and ability to explain complex technical concepts to a varied audience
  • Demonstrate strong follow-through and consistently keep commitments to customers and employees


Benefits:
  • Competitive Market Salary
  • Bonus
  • FlexWork options
  • Group Medical Insurance
  • Annual Wellness Reimbursement
  • 15 days paid annual leave(Earned leave)
  • 26 weeks paid maternity leave
  • 16 weeks paid paternity leave
  • 3 paid days volunteering and many more


About Guidewire

Guidewire is the platform P&C insurers trust to engage, innovate, and grow efficiently. Guidewire combines core, data, digital, analytics, and AI to deliver our platform as a cloud service. 380 insurers, including 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 700+ 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.

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.

Average salary estimate

$80000 / YEARLY (est.)
min
max
$70000K
$90000K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About Platform Support DBA III, Guidewire Software

Guidewire is on the lookout for a proactive and solution-driven Cloud Platform Support DBA III to become a vital part of our enthusiastic Platform Support team in Bangalore. In this role, you will collaborate within our Product Development Operations (PDO) team, addressing the needs of our customers across both Guidewire Cloud and on-premise environments. If you have a knack for database management and a desire to stay ahead of the curve in cloud technologies, this position is perfect for you! You'll dive deep into AWS processes and build a robust knowledge base around Oracle, Microsoft SQL Server, and Aurora databases. There’s more than just technical work; you’ll contribute to a strong culture of collaboration and information sharing while ensuring our clients receive world-class service 24x7. Your day-to-day will involve monitoring database health, administering database environments, troubleshooting issues, and documenting solutions, all while developing valuable relationships with our clients and stakeholders. If you thrive in hybrid environments and enjoy solving challenges in high-pressure situations, we want to hear from you! Join Guidewire, where we empower our employees with continuous education and support as you embark on an exciting journey with our cutting-edge cloud technologies. This is more than just a job; it's your opportunity to grow your skills and engage with a team that values your expertise and fresh ideas.

Frequently Asked Questions (FAQs) for Platform Support DBA III Role at Guidewire Software
What does a Cloud Platform Support DBA III do at Guidewire?

As a Cloud Platform Support DBA III at Guidewire, you will serve as a primary resource for ensuring optimal database management. Your duties will include administering Oracle, Microsoft SQL Server, and Aurora databases, troubleshooting issues, and collaborating across teams to enhance application performance. You will be pivotal in providing 24x7 service support for our clients using Guidewire software.

Join Rise to see the full answer
What qualifications are required for the Platform Support DBA III position at Guidewire?

To qualify for the Platform Support DBA III role at Guidewire, you should possess a Bachelor's Degree in Computer Science or a related field, along with over 5 years of experience in database administration. Proficiency in Oracle, MySQL, and MSSQL, along with hands-on experience in AWS services, particularly RDS/Aurora, is essential for success in this role.

Join Rise to see the full answer
What technologies will I work with as a Platform Support DBA III at Guidewire?

In the role of Platform Support DBA III at Guidewire, you will work with various databases including Oracle, Microsoft SQL Server, and AWS RDS/Aurora databases. Additionally, you will gain experience in cloud technologies and services like AWS EC2 and S3 while supporting our cloud platform and participating in migrations.

Join Rise to see the full answer
What is the work environment like for a DBA III at Guidewire?

At Guidewire, the work environment for a DBA III is dynamic and collaborative. You will be part of the Product Development Operations team, engaging with various stakeholders and team members to resolve database-related challenges. It's a supportive atmosphere where continuous learning and professional growth are highly encouraged.

Join Rise to see the full answer
Are there opportunities for growth and learning as a Cloud Platform Support DBA III at Guidewire?

Yes! Guidewire offers extensive training and mentorship programs, allowing you to expand your technical knowledge and skills continually. You will have the opportunity to learn about AWS processes and other database platforms, ensuring you are well-equipped to tackle new challenges and advance your career.

Join Rise to see the full answer
How does Guidewire ensure 24x7 support for its clients?

Guidewire ensures 24x7 support by fostering a team-centric atmosphere and rotating shifts among team members. This allows us to provide timely responses and solutions to our clients’ database needs, regardless of the time of day. The commitment to customer satisfaction is foundational to our operations.

Join Rise to see the full answer
What personal attributes are important for success as a DBA III at Guidewire?

Being detail-oriented, self-motivated, and a strong communicator are crucial for a DBA III at Guidewire. You should be a collaborative team player, demonstrate excellent analytical skills, and flourish in a fast-paced environment while maintaining a positive can-do attitude.

Join Rise to see the full answer
Common Interview Questions for Platform Support DBA III
What are the primary responsibilities of a Cloud Platform Support DBA III at Guidewire?

As a Cloud Platform Support DBA III at Guidewire, your primary responsibilities will include providing database support for Oracle, MS SQL Server, and MySQL databases, performing troubleshooting, and collaborating with development teams to enhance performance. Additionally, documenting processes and maintaining technical articles will play a significant role in your duties.

Join Rise to see the full answer
How do you approach troubleshooting database performance issues?

When troubleshooting database performance issues, I first assess the database logs and monitoring statistics to identify potential bottlenecks. Then, I collaborate with internal teams, such as application developers, to analyze query performance and execute necessary optimizations, ensuring we maintain the highest standards of service.

Join Rise to see the full answer
Can you describe your experience with AWS services relevant to this role?

In previous positions, I have gained hands-on experience with AWS services, including deploying databases in RDS and EC2. I have migrated several on-premise databases to AWS and regularly leveraged services like S3 for storage and backup, ensuring high availability and redundancy in a cloud environment.

Join Rise to see the full answer
What steps do you take to maintain database security?

To maintain database security, I follow best practices such as implementing user authentication, setting proper access controls, and regularly applying security updates. I also monitor database activity for any suspicious behavior and ensure compliance with any internal security protocols.

Join Rise to see the full answer
How do you keep updated with the latest developments in database technologies?

I stay updated on the latest developments in database technologies by participating in online forums, attending webinars, and enrolling in training sessions. Subscribing to industry publications and staying active within professional communities also helps me keep my skills current and relevant.

Join Rise to see the full answer
Describe your experience working in a team-based environment.

I have consistently worked in team-based environments where collaboration is key. I contribute by sharing knowledge, offering support to teammates in troubleshooting tasks, and actively participating in team discussions to foster a positive team dynamic and encourage shared success.

Join Rise to see the full answer
What methodologies do you use for database backup and recovery?

I employ the methodology of regular, automated backups combined with periodic manual backups for sensitive databases. Recovery processes are documented and tested to ensure rapid restoration capabilities in the event of a failure, thereby mitigating data loss and maintaining consistency.

Join Rise to see the full answer
How do you approach documenting database processes and resolutions?

I find documentation to be critical in establishing a knowledge base for troubleshooting and resolution processes. I document resolutions as they occur and maintain a structure that allows for easy access and retrievability, ensuring that knowledge can be easily shared across the team.

Join Rise to see the full answer
What is your experience with SQL scripting languages?

I have over three years of experience working with various SQL scripting languages, including ANSI SQL, T-SQL, and PL/SQL. I am comfortable writing, modifying, and troubleshooting complex queries to ensure optimal performance within our database environments and applications.

Join Rise to see the full answer
Why do you want to work as a Cloud Platform Support DBA III at Guidewire?

I want to work as a Cloud Platform Support DBA III at Guidewire because I admire the company’s commitment to innovation in the insurance sector. The exposure to cloud technologies and the emphasis on continuous learning align perfectly with my career aspirations, and I am excited to contribute to such a pioneering team.

Join Rise to see the full answer
Similar Jobs
Posted 12 days ago
Photo of the Rise User
Verinext Remote No location specified
Posted 9 days ago
Photo of the Rise User
Convergint Federal Solutions Remote 8260 Greensboro Dr, McLean, VA 22102, USA
Posted 16 hours ago
Photo of the Rise User
Posted 4 days ago
Photo of the Rise User
Posted 14 days ago
Photo of the Rise User
NBCUniversal Remote 4100 E Dry Creek Road, Centennial, COLORADO
Posted 3 days ago
Photo of the Rise User
Accurx Remote London, England, United Kingdom
Posted 14 days ago

Founded in 2001, Guidewire is a software publisher that offers an industry platform for property and casualty insurance carriers in the U.S. and worldwide. The company is headquartered in San Mateo, California.

33 jobs
MATCH
Calculating your matching score...
FUNDING
SENIORITY LEVEL REQUIREMENT
TEAM SIZE
EMPLOYMENT TYPE
Full-time, hybrid
DATE POSTED
November 29, 2024

Subscribe to Rise newsletter

Risa star 🔮 Hi, I'm Risa! Your AI
Career Copilot
Want to see a list of jobs tailored to
you, just ask me below!