Database Administrator II - MSSQL

Job Description

The Apex Group was established in Bermuda in 2003 and is now one of the worlds largest fund administration and middle office solutions providers. Our business is unique in its ability to reach globally, service locally and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide.Your career with us should reflect your energy and passion. Thats why, at Apex Group, we will do more than simply empower you. We will work to supercharge your unique skills and experience. Take the lead and well give you the support you need to be at the top of your game. And we offer you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities. For our business, for clients, and for you Responsibilities Installation, administration and maintenance of multiple SQL Server instances. Setup environments for use within the end to end software delivery lifecycle. Define, design & implement control procedures. Backup monitoring and continuous review of the backup strategy. Troubleshoot and resolve issues quickly. Performance monitoring and tuning. Query tuning (Index maintenance and management, housekeeping, memory, CPU, Disk I/O etc.) Planning and execution of Service Pack upgrades. Work alongside project teams (analysts, developers, testers and implementation managers) during software release and patching. Adhere to change management procedures. Working closely with other team members. Complete structured and systematic testing. Track and report on regular tasks executed to ensure system availability maintaining a continuous improvement roadmap. Pro-actively identify productivity opportunities. Ensure correct procedures are adhered to as tasks are being progressed. Experience in a Windows based 24/7 environment including 1st/2nd line support. Involved in the design and build of new systems, including high-availability and disaster recovery solutions. Skills Required Min. 8+ years of Exp in Microsoft SQL Server 2016, 2019, Azure SQL. A bachelors degree in computer science or a related discipline Extensive knowledge of SQL and SQL server tools Experience in Database Performance, Development and Maintenance In-depth understanding of database security, backup and recovery, and performance monitoring requirements Familiarity with relational and dimensional data modelling Extensive knowledge in database design, implementation, and conversion Knowledge of PowerShell and Unix shell scripting Experience with SSAS, SSIS, and SSRS A solid mathematics and statistical skills Outstanding writing and verbal communication abilities Meticulous attention to detail MCSE/MCSA certificates preferred Working knowledge of Linux and Windows Server infrastructures Extensive knowledge of database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB) Prior experience with cloud services (AWS, Microsoft Azure) Excellent time management and decision making skills. Excellent communication skills in both English written and verbal. Background in the financial Industry preferable DisclaimerUnsolicited CVs sent to Apex (Talent Acquisition Team or Hiring Managers) by recruitment agencies will not be accepted for this position. Apex operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.