Platform Support Dba Iii

Guidewire
Municipality of Madrid, Spain
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Shift work
Languages
English, French, German
Experience level
Intermediate

Job location

Municipality of Madrid, Spain

Tech stack

Microsoft Windows
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Server Applications
JIRA
Bash
Bug Tracking Systems
Cloud Computing
Databases
Relational Databases
Oracle Data Guard
Issue Tracking Systems
Python
PostgreSQL
Linux Servers
Microsoft SQL Server
MySQL
Oracle Applications
Performance Tuning
Powershell
Runbook
Software Engineering
SQL Databases
Scripting (Bash/Python/Go/Ruby)
Java Application Server
System Availability
Database Optimization
B2b Software
Amazon Web Services (AWS)
Ansi Sql
Kubernetes
Information Technology
Oracle Golden Gate
Database Replication

Job description

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 the 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 or other public cloud providers is a distinct advantage.Highly proficient in one or more of these RDBMS technologies: MS SQL Server, AWS RDS/Aurora MySQL, AWS RDS/Aurora PostgreSQL, AWS RDS Oracle Working knowledge of one or more database high availability scenarios such as: AWS Multi-AZ database deployments,MS SQL Server Always on Availability, GroupsOracle Data Guard 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 advantageKnowledge 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 Experience using a software defect tracking system such as JIRA preferredSkills 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 SalaryBonus Company pension contributions Fully funded medical insurance for you and your family Annual Wellness Reimbursement 26 annual leave days 16 weeks paid maternity and paternity leave 3 paid days volunteering in the community

Requirements

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 or other public cloud providers is a distinct advantage. Highly proficient in one or more of these RDBMS technologies: MS SQL Server, AWS RDS/Aurora MySQL, AWS RDS/Aurora PostgreSQL, AWS RDS Oracle Working knowledge of one or more database high availability scenarios such as: AWS Multi-AZ database deployments,MS SQL Server Always on Availability, GroupsOracle Data Guard 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 advantageKnowledge 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 Experience using a software defect tracking system such as JIRA preferredSkills 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.

Benefits & conditions

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 SalaryBonus Company pension contributions Fully funded medical insurance for you and your family Annual Wellness Reimbursement 26 annual leave days 16 weeks paid maternity and paternity leave 3 paid days volunteering in the community

Apply for this position