Sr Database Developer

Responsibilities

• Owning, tracking, and resolving Monitoring database related incidents and requests, reviewing service-related reports to all database servers and services ( database backups, maintenance, monitoring) on a daily basis to ensure service-related issues are identified and resolved within established SLAs, configuring and ensuring that database related monitors, alerts and escalations are working properly and being the most efficient as possible.
• Generating health reports based on monitors and metrics collected and managed by DBA DevOps.
• Provide tools to Ria Financial NOC team to monitor Database servers and quickly identify potential issues that may impact Ria Financial business.
• Ensuring and maintaining the readiness and operability in all Ria Financial datacenter database servers for the Ria Financial databases
• High sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintainingmunication with technology customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes.
• The MS SQL Server DBA DevOps will be part of the DevOps Team, which is required to follow an on-site / on-call rotation including weekends to support the production environment.
• This position will include the Brazil DBA DevOps shift (from 5AM to 2PM Pacific Time) with a rotating weekend schedule.
• Provide support and new implementation of custom Database objects deployment process, developed using PowerShell scripts and Redgate SQLpare product.
• Support MariaDB / MySQL instances; Monitoring, maintenance, performance tuning.

Qualifications

• At least 3 years of experience as a Microsoft SQL Server DBA in SQL Server 2014 and above
• Experience with Database monitoring tools, Grafana, Icinga, Zabbix, Redgate, DBForge.
• Experience with Scripting languages to create custom monitoring scripts using PowerShell, Python, Ruby.
• Experience with SQL Server Replication.
• Experience in Performance Tuning and Optimization using monitoring and troubleshooting tools.
• Knowledge of indexes, index management, and statistics.
• Experience writing basic T-SQL queries and reports.
• Experience in implementing operational automation using scripts.
• Experience working with Windows server, including Active Directory and proper disk configurations.
• Experience with MySQL / MariaDB management; monitoring; performance tuning.
• Pro-active monitoring of databases both from a performance and capacity management perspective.
• Perform database maintenance activities such as backup / recovery, replication, rebuilding, and reorganizing indexes.
• Ability to detect and troubleshoot and resolve database related CPU, memory, I / O, disk space and other resource contention issues.
• Experience supporting and managing SQL databases in a 24x7 production environment.
• Familiarity with release and change management principles and processes.
• Proficiency in capturing and analyzing requirements, presenting alternative solutions, rmending the appropriate design, developing the solution to meet the requirements and exceed customer expectation and maintaining the required documentation.
• Excellent organizational and workflow skills; ability to work on simultaneous projects with diverse working groups.
• Team player with collaborative nature
• Ability to work independently with little to no supervision in operational database projects.
• 4-year degree inputer science or related field or equivalent experience
• Knowledge of productivity tools and software such as Office and Visio

Job ID 300000157692946