What are the responsibilities and job description for the Sr. Analyst, Database Administrator position at PanAgora?
Company Overview
Founded in 1989, PanAgora (Greek for across marketplace) Asset Management is a premier provider of investment solutions spanning most major asset classes and risk ranges. We seek to provide investment solutions using sophisticated quantitative techniques that incorporate fundamental insights and vast amounts of market information. While PanAgora's investment strategies are highly systematic in nature, the processes deployed within these strategies are built and overseen by talented professionals with significant and diverse investment experience. Innovative research plays a central role in our investment philosophy and process, and is an essential component of our firm's ability to deliver attractive investment solutions. Investment teams are organized into an Equity Strategies group and a Multi Asset Strategies group. Most investment team members are engaged in original research using fundamental intuition, market intelligence, modern finance and scientific methods.
We are committed to providing clients with reliable investment processes, consistent performance, transparency, and access to our investment resources. Our client base is comprised of institutional investors across the globe, including public & private retirement funds, sovereign wealth funds, endowments & foundations, and sub-advisory mandates.
Summary
Reporting to the Database Team Manager, this individual will be a contributor providing database, server, and application support, leveraging Microsoft Windows, SQL Server, VMware, MS Azure, and industry storage technologies. The primary focus would be to provide SQL Server database support and monitoring, as well as system administrator functions involving VMware, SQL Sentry and other Microsoft technologies.
Primary Duties and Responsibilities
- Work directly with application Developers to provide SQL administration support.
- Assist investment groups with new database creation and initial data loads.
- Support, troubleshoot, and apply SQL permissions across prod / stage / dev environments.
- Tune customized SQL maintenance plans across all production SQL servers.
- Performance tuning using SQL DMVs, SQL Sentry, execution plans
- Create scripts to automate administrative tasks such as post monthly OS patching systems checkup process using but not limited to PowerShell, Windows Task Scheduler, and others.
- SQL data security, capacity planning, database tables indexing and query tuning.
- SQL Server table portioning, SQL Server replication, Data virtualization using Polybase technology.
- Use third party tools to snap production databases to low region environments.
- Installation and configuration of additional SQL Windows environments utilizing VMware.
- Basic administrative tasks for Active Directory to support Microsoft SQL Server.
- Maintain and optimize resources utilization of VMware virtual machines.
- Availability to monitor, respond and resolve afterhours requests for MSSQL support.
Essential Skills, Education and Experience :
Desired Skills :
