• Primary responsibilities of this role includes owning, tracking and resolving database related incidents and requests within provided SLAs, reviewing service related reports primarily but not limited to the Production and KC/DR Data Center database servers and services (e.g.: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems.
• Ensuring and maintaining the readiness and operability in the Production and KC/DR datacenter database servers for the Ria Financial databases. Actual readiness and availability in the KC DR datacenter in the actual event of the Production database systems failover from the LA production data center to ensure the business continuity of the Ria Financial databases running in the KC data center
• High sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication 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 will be part of the Production DBA Team, which is required to follow an on-site/on-call rotation including weekends to support the production environment.
Qualifications
• At least 3 years experience as a Microsoft SQL Server DBA in SQL Server 2014 and above
• Experience with SQL Server Replication.
• Experience in Performance Tuning and Optimization using monitoring and troubleshooting tools
• Experience in troubleshooting and resolving database problems.
• Experience with SQL Server Integration/Reporting Services.
• Experience/knowledge of Log Shipping
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server, such as AlwaysOn Availability Groups
• Knowledge of indexes, index management, and statistics.
• Experience writing at least 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.
• 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.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking/deadlocking issues, connectivity issues, data replication issues etc.
• Experience with using SQL Profiler or Server Side Traces/Extended Events to help troubleshoot performance bottlenecks
• 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 Server databases in a 24x7 production environment
• Familiarity with release and change management principles and processes.
• Proficiency in capturing and analyzing requirements, presenting alternative solutions, recommending 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 in computer science or related field or equivalent experience
• Knowledge of productivity tools and software such as Office and Visio
Seniority Level
Associate
Industry
Employment Type
Full-time
Job Functions
Skills
- SQL
- Windows Server
- Microsoft SQL Server
- Database Administration
- High Availability (HA)
- Databases
- Performance Tuning
- SQL Server Reporting Services (SSRS)
- SQL DBA
- SQL
ABOUT US
We’re Ria Money Transfer
A subsidiary of Euronet Worldwide, Inc. (NASDAQ: EEFT), Ria is a leading expert in cross-border payments that delivers innovative financial services including fast, secure, and affordable international money transfers. With the second most extensive cash settlement network and the largest direct bank deposit network in the world, Ria gets money to where it matters. We’re focused on harnessing technology and, as part of Euronet Worldwide, we provide a suite of state-of-the-art fintech products and services that bridge the gap between digital and physical transactions. Our omnichannel products and services, provide unprecedented choice to our customers and growth opportunities for our partners.
With presence in more than 160 countries, and more than 490,000 locations worldwide, we’re committed to helping millions of people send money home to their loved ones around the world, knowing that our customers deserve much more than just a fair price: they deserve empathy, hope, and ultimately respect. Join us in our mission to open ways for a better everyday life.
