Our client in Springfield Ma is seeking a Senior Database Engineer/Architect for a contract role.
Consultants must be able to work on our W2.
No corp-to-corp submissions accepted for this role.
Top skills required for the Senior Database Engineer/Architect
- Sr level team leader, 10+ years in SQL Server based application design and development
- Database table schema design and implementation
- Performance tuning, “where systems bog down”
- Familiarity with investment management portfolio and market data
- 7-10+ years working with MS SQL Server
Senior Database Engineer/Architect Overview
Investment Management middle office Database Developer/Architect has a combination of experience in technical, investment, and people skills working in a fast paced, innovative, and collaborative environment. Both emotional intelligence and the ability to solve complex problems and communicate effectively are key to success. Ideally, candidate will have a strong background in Data Engineering and development skills to solve a variety of market risk analytic business issues. Robust experience in cloud platforms is a plus. Position is for a team lead/developer to support a key transformation effort involving the processing of data to be used by quantitative business analysts. Efforts includes analysis, design, development, testing, migration to production, and documentation.
Responsibilities
- Model / Design new database solutions to new problems including application support, scalability, redundancy, and recovery
- Ensure database support for front end user application to maintain and enhance complex data tasks
- Understand and enhance complex database models
- Create and maintain complex SQL procedures, triggers, and TVFs.
- In-depth knowledge of referential integrity constraints and indexing
- Analyzing different user requirements and coming up with specifications for the various database applications
- Follow and enhance in-house coding standards
- Troubleshoot/bug-fix SQL including performance optimization
- Database administration
- Profile server resource usage and optimize as necessary
- Assist in Compliance efforts to include, reporting, auditing, and implementation
- Use database code repositories for change (GIT) management
Requirements
- 10+ years in SQL Server based application design and development
- Database table schema design and implementation
- Familiarity with investment management portfolio and market data
- Ability to function well in a fast-paced, dynamic environment with competing priorities
- Ability to build strong working relationships across the organization
- Strong communications, both written and verbal, in leading teams and coordinating with peers and other disciplines on driving projects/issues to closure.
- Commitment to organizational excellence and constant awareness to seek opportunities to improve processes/quality of deliverables.
- Strong and effective team player in working with various disciplines and peer groups
- 10+ years of solid relational database experience