Our client a leading financial services firm operating in the Wealth Management and Institutional Management space in St. Louis,MO, seeks a Senior SQL Server DBA to support both development and production environments.
The successful candidate will work with the IT team in the development of enterprise-class data solutions. This position will implement our efforts around "best fit data architecture using one or more database technologies including Transactional DB, MPP databases, massive distributed non structured databases, both in terms of engineering the backend solutions and providing operational support.
5+ years' of SQL Server Database Administration and data stores.
Must be able to perform both physical and logical database design.
The candidate must be capable of understanding data strategy on enterprise level but implement on project level
Ability to develop DDL and DML scripts for SQL server databases
Must possess a strong understanding of database backup and recovery and security techniques.
The candidate will be required to as well as work with a third party data synchronization solution
Experience with SQL, SQL tuning, optimization and data extraction and modification
Strong organization and interpersonal skills. Ability to deal with and balance multiple priorities
Knowledge of Oracle is an added advantage
Experience in a large development project experienceRESPONSIBILITIES
Coordinate with Data architects to determine requirements.
Analyze, design, create and implement more complex databases including access methods, device allocations, validation checks, organization and security.
Implement complex physical data models, data dictionaries and schemas.
Liaisons with database software vendors and external technical support on issues such as software upgrades, problems and potential solutions.
Review systems under development and related documentation.
Coordinate activities of the project team and assist in monitoring project schedules.
Investigate source systems to locate and understand existing data.
Create documents and coordinate script deployment with Data Operations.
Coordinate and ensure appropriate reviews per processes defined in Research IT.
Assist in developing data migration strategies.
(DBA over 2 year(s) OR DATABASE ADMINISTRATOR over 2 year(s) ) AND(SQL SERVER over 2 year(s) ) AND (BROKERAGE COMPANIES )
Velocity Technology Resources