Database Administrator

Responsible for managing and optimizing database environments, supporting data projects, automating tasks, maintaining documentation, and providing Level 2 support for data platforms and analytics tools like Databricks, PowerBI, and Tableau.

• Responsible for administration, monitoring, performance tuning and maintaining all our Database environments both on-prem and Azure SQL
• Monitor all scheduled jobs for data applications and works with development teams to resolve issues
• Monitor database backups and restores for all database environments from DEV to PROD
• Document and maintain an Administration manual and runbooks
• Identify opportunities for process improvement and automation to enhance data operations efficiency
• Support data-related projects, including data migration, integration, and system upgrades
• Manage permissions for database servers, application databases, and data & analytics applications
• Manage passwords for system administration in a password manager
• Provide on-boarding and off-boarding support for Financial Accounting, Tax, and Data platforms such as Investran, Databricks, Alteryx and Visualization tools (PowerBI / Tableau)
• Assist in change control, version control, and deployments for all data and analytics applications
• Provide Level 2 support for all data and analytics applications
• Provide automation of tasks and alerting through PowerShell or other scripting languages available

Qualifications 

• Bachelor’s degree in Computer Science, information systems, or equivalent working experience in information technology
• 2+ years of Financial Services experience
• Proficient in SQL Server Administration with at least 5 years experience as a DBA, with extensive experience working with the Microsoft stack on a cloud environment
• Knowledge of Cloud Data Platforms such as Databricks and supporting ETL operations
• Familiarity with BI / Reporting tools such as PowerBI, Tableau and SSRS
• Contribute towards all reviews of SQL and NOSQL scripts, tables, Views, stored procedures, extended functions in python etc. on the data platform
• Strong attention to detail with the ability to be proactive, solve problems, think ahead, and multi-task on a daily basis
• Excellent written & oral communication skills
• Ability to identify areas for improvement and present and implement viable solutions
• Strong comfort and experience liaising with internal and external contacts
• Investran experience a plus
• Familiarity with Alteryx a plus
• Azure DevOps and Terraform a plus