Manage our 20-30 SQL DB's and maintain our MS SQL databases: MS SQL data backup, SQL scripting and tuning the SQL DB, Database replication as it relates to disaster recovery, MS SQL tuning and proactive management, Database security.
The SQL Database Database Developer / Architect is responsible for developing SQL code in various SDLC approaches, designing database system and management processes, and working with production systems in a hand on manner.
Provide database administration and system support for existing production database environments and help lead efforts to guide the team to the best practices of data usage, high availability, and business continuity.
The primary purpose of this role is to support first line risk management through development and implementation of data analytic tools and reporting to drive simplified and reliable execution of control and oversight activities.
In this role you will be doing SQL development/administration for the companies' various locations. You will be tasked with analyzing the database structures in all of the companies locations and make sure it is set up for future growth as well as a new Datawarehouse integration.
Demonstrated knowledge of alert creation and database monitoring policies (local and network) for network and agent implementations. Provide guidance, recommendations, best practices, etc. for DAM operations, stabilize and optimize DAM system performance, including rules and reports, assist with DAM tool upgrades.
Develops unit test and test scripts; performs unit, regression, conversion and parallel tests; develops system test data and performs system tests. With limited direction, coordinate and conduct system stress tests on software.
The successful candidate will be a highly knowledgeable and experienced SQL Developer and DBA, with solid communications skills and ability to multitask and prioritize. Previous experience working for a trading firm would be extremely beneficial in this role.