Database Administrator II - MSSQL

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