Youll be working on-site at our client (a premier Investment Management Firm) location in New York City One year + contract (potential to go for multiple - years)
Candidates local to the NYC area will be given preference
We are seeking candidates that will Leverage outstanding knowledge of RDBMS solutions, object oriented programming, database networking technology, and database management, tuning, configuration, and troubleshooting to optimize management of client data warehouse. You will be part of a Team, performing MS SQL Database architecture development and collaborating with BI and analytics developers to recommend/apply best practices and standards for optimal performance of analytical tools (e.g., Tableau, SAS, VBA) and processes.
Develop automated processes and develop resource-efficient database packages to support the firms growing analytics capabilities, including evaluating new and existing technologies and processes for capacity, performance and scalability.Monitor system performance, develop recommendations, and advocate for buy-in of proposed solutions to improve performance and reliability of RDBMS and underlying operating systems.Serve as administrator to manage user accounts, maintain system documentation, manage the installation of firm-wide software, allocating storage space, among others.Manage database backups by recommending and implementing appropriate strategies, and periodically test backups to ensure database recoverability.Provide guidance and support to analytic colleagues to resolve hardware and/or software issues and/or failures on an on-call basis.Represent the firm as needed to manage the client data transfer process
Must have a Minimum of 10+ years a Database administrator.Must have previous experience working in a the financial industry (preferably at a Investment Management or large Financial firm technology department).Minimum of 7+ years experience working as a SQL Server DBA handling versions 2008 R22016.Must have experience handling Large DBs of 30tb or better.Must have Recent experience performing as a Functional & Application DBA.Extensive experience of designing schemas for OLTP & OLAP databasesAdvanced knowledge of data integration and workflow applications (e.g., SQL Server Integration Services, Oracle Data Integrator, Informatica Power Center)Advanced knowledge of database reporting and analytical tools (e.g., SQL Server Reporting Services or Analysis Services)Excellent SQL development and tuning skills to generate complex queriesStrong scripting skills for development of automated process (e.g., PowerShell, Python)Experience with infrastructure components including operating system, storage, network, hardware, virtual machines