Senior MS SQL Production DBA - EM312
About your role
Your responsibilities include the implementation of changes for both business and technical stakeholders, DB monitoring, maintenance, and performance management. This ensures the availability and retention of critical data and the high-throughput and low-latency of our trading systems. This is a “hands-on” position requiring solid technical skills, and broad experience, as well as strong interpersonal and communication skills.
You will work closely with the in-house development team and IT operations. You will need to perform investigative activities to resolve incidents and to build upon legacy DB business logic. You should be able to leverage your knowledge and judgment to help optimize the activities of the DB Team, and to reduce IT Risk, refresh DB related operational processes, procedures, hardware and software.
This is a key role in helping our organization to achieve a state-of-the-art environment that meets current and future business objectives, while at the same time ensuring that the company’s production databases offer the highest reliability and performance possible.
Main activities and responsibilities
- Perform routine DBA activities & service requests
- Manage SQL Server databases through multiple product lifecycle environments
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
- Write stored procedures, manage execution plans and indexes
- Independently analyze, solve, and correct issues in real time
- Refine and automate regular processes, track issues, and document changes
- Assist developers with query tuning and schema refinement
- Perform scheduled maintenance and support release deployment activities after hours
- Contribute to the documentation of DB Related Incidents and help drive related Improvements
Key requirements
- 6+ years of work experience on Microsoft SQL Server Databases (2012-2016)
- Expert in performing T-SQL DDL/DML/DCL commands using SQL Server Management Studio (SSMS)
- Strong experience in database installation, configuration, capacity planning, implementing backup and recovery strategy for applications and database
- Experience with backups, restores, recovery models, and Security
- Know-how in implementing and monitoring different types of High Availability and Disaster Recovery scenarios like SQL Server clusters, Replication (Transactional and Peer-to-Peer), log shipping
- Installed and maintained SQL Server failover clustering for SQL Server 2016
- Practical knowledge of SSIS and SSRS
- Background in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
- Being Involved in R&D projects (designing & creating DBs, tables, writing functions and procedures)
- Exposure in reverse engineering and documenting legacy DB stored procedures and processes
- An understanding of the SQL locks mechanism/ isolation levels, and their internals
- Flexible, team player, “get-it-done” personality
Will be nice to also have:
- Forex industry and/or Regulatory reporting knowledge
- Maria DB and MySQL experience
- Creating and managing processes to transform data for use in BI, reporting, or data analysis
- Tableau Server experience and optimization
- Power BI and business intelligence methodologies
- Experience in migrating DBs from on-prem/private-cloud to public clouds
- A practical understanding of Incident Management and IT Risk Management
- MCTS, MCITP, and/or MVP certifications
- MCSA (Microsoft Certified Solution Associate)
- MCSE (Microsoft Certified Solutions Expert)
- Microsoft Technology Associate (MTA): Database Fundamentals SQL Certification
What you'll enjoy:
- Competitive remuneration
- Provident fund
- Discretionary yearly performance bonus
- Professional development and learning opportunities
- Friendly and dynamic work environment
- 21 days of annual leave which increases every two years (capped at 24 days)
- Weekly lunches, weekly massages, monthly team outings and quarterly company activities
- Strong culture promoting work-life balance and flexibility
- Fresh fruits, snacks, coffee, sodas at the office and healthy ice cream during the summer
- Hybrid working and flexi time (7:30/9:00 – 16:30-18:00)
- Some Sunday work may be requried
Meet easyMarkets
easyMarkets is a leading global financial services provider, offering innovative and user-friendly trading solutions to clients worldwide. Established in 2001, we have built a reputation for transparency, reliability, and exceptional customer service.
Our commitment to empowering traders with cutting-edge technology and robust risk management tools has positioned us as a trusted partner in the financial industry. At easyMarkets, we believe in partnering with the best to achieve excellence, which is why we are proud to be an Official Online Trading Partner of Real Madrid. Just as Real Madrid exemplifies leadership, teamwork, and a winning mentality, we strive to embody these values in everything we do, making easyMarkets not just a place to work, but a place to grow and succeed.
