MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQl Server DBA

Location New York, United States
Posted 17-January-2019
Description

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

Role:

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.

Responsibilities:

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

Required Skills:

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

We look forward to reviewing your profile.

Thank you,

Talent Team @ SIAL TP

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url