Senior Database Developer

Robert Half Technology is looking for a Senior Database Developer. This Senior Database Developer is a direct hire, FTE (Full Time Employment) position with one of our client companies. For immediate and confidential consideration on this Permanent / Direct hire IT opportunity, please email [email protected]

What you get to do every day:
-Architecting solutions and developing new components, enhancements, and maintenance of various
applications that integrate with Geneva portfolio accounting system.
-Designing, developing and implementing data warehouse solutions to generate daily NAV reporting
-Work with highly configurable and flexible systems allow different extract rsls to be executed to feed the data into data warehouse.
-Design database schema including tables, views, stored procedures, functions, etc in the MS SQL Server database to hold extracted data
-Design and create .NET web services that call RSLs and write to CSV files
-Design and create SSIS packages to consume the CSV files and onboard the data in the data warehouse
-Design custom Geneva reports that not only extract data from Geneva but also from data warehouse for specific information stored outside the Geneva
-Assist in providing seamless experience to the Geneva users to run reports directly out of Geneva
-Assist on Geneva 18.1 upgrade from Geneva 15.2, work with professional services to ensure best practice hardware infrastructure, upgrade plans, installation, testing of multiple environments including development, UAT, production and disaster recovery.
-Work extensively with support, and development teams to resolve issues in multiple versions of Geneva.
-Oversee execution and stability of critical daily technology processes including internal performance calculations, application integrations with data warehouse and the exchange of data with business' administrator and third parties
-Drive the development and maintenance of data governance model and data management tools including the development of an integrity report framework focused on isolating data inconsistencies
-Design efficient schema and database models to support growing technology stack, investment modeling and an increasing number of application and third party points of integration
-Provide guidance and oversight for technology implementations including working with internal constituents as well as external resources and vendors to drive the project to successful completion
-Provide direction to the development efforts by third party consultancies and vendors including design and code reviews
-Working knowledge of industry best in class business intelligence tools (i.e. Power BI)
-Development, debugging and performance tuning of TSQL and ETL processes
-Effectively communicate project and development status to team lead

Requirements

Requirements:
-Qualified candidates must possess a Computer Science or Technical degree with 8+ years of applicable technical experience
-Financial Services industry experience is required
-3+ years of experience working with Geneva is required
-Experience in data warehouse development and architecture for financial services institutions required
-Experience creating process documentation and eliciting requirements from ends users required
-Experience maintaining, upgrading and report developing within Geneva
-Experience administrating, maintaining, upgrading, and management of the production/UAT/dev Geneva core, App Server, Workflow Manager, and World Investor components
-Experience managing Active/Active SAGA servers
-Must be well-versed in development of Geneva RSL, RDL, SSIS for reporting, data extracts and data loading
-Experience leveraging current technology such as Geneva DLLs for integration instead of SOAP API
-Ability to architect and develop custom reports, extracts and feeds to and from Geneva.
-Experience working with SS C?s team to get solutions to critical issues related to Geneva architecture.
-Candidate should have strong experience developing, maintaining, and integrating with data warehouses for financial intuitions
-Candidate must be well versed in TSQL, ETL and query performance tuning
-Candidate must possess strong technical, organizational, communication (both oral and written) and analytical skills
-Candidate must have basic knowledge of financial instruments and rudimentary understanding of valuation inputs or techniques
-Detail-oriented, responsible, and proactive
-Deadline-oriented to meet time-sensitive regulatory and contractual requirements
-Adept at problem solving
-Candidate must be self-motivated and willing to work in a team environment
-Candidate must possess project management skills in order prioritize and focus when various work streams are occurring concurrently

As a technology staffing firm, we can't think of a more fitting mantra. We're extreme believers in technology and the incredible things it can do. But we know that behind every smart piece of software, every powerful processor, and every brilliant line of code is an even more brilliant person.

Leader among IT staffing agencies

The intersection of technology and people — it's where we live. Backed by more than 65 years of experience, Robert Half Technology is a leader among IT staffing agencies. Whether you're looking to hire experienced technology talent or find the best technology jobs, we are your IT expert to call.

We understand not only the art of matching people, but also the science of technology. We use a proprietary matching tool that helps our staffing professionals connect just the right person to just the right job. And our network of industry connections and strategic partners remains unmatched.

Apply for this job now or contact our branch office at 888-490-4429 to learn more about this position.

All applicants applying for U.S. job openings must be authorized to work in the United States. All applicants applying for Canadian job openings must be authorized to work in Canada.