*Locals Only* *Title: Database Developer* *Duration: 6+ Months (Contract)* *Territory: Minnesota*
*Hours: 40 hours per week, typically 8:30 to 5:0*0. *TOP SKILLS/TECHNOLOGIES:* 1. 8 to 10 years Creating and optimizing database queries, indexes, stored procedures, triggers, and reports; 2. 8 to 10 years Database planning and design, set-up, maintenance, performance tuning, and partitioning; 3. 8 to 10 years Designing complex physical and logical data models; *Specific Skills:* · Risk Management operates a complex Monte Carlo simulation application that performs billions of operations on millions of records daily to forecast financial impacts on the company. · The results are relied upon each morning by the business prior to the opening of the US financial markets that supports decisions to cover exposures in our financial products. · Risk Management has a need for an experienced, seasoned data architect/database developer to design and develop high quality database solutions. · Ideal candidate will have significant experience in database design and development using Microsoft SQL Server. · Due to the market- and time-sensitive nature of the application and its criticality to the business, the senior data architect/database developer professional must have 10+ years’ experience in database design and development, preferably in the financial services industry. *Specific Skill or Knowledge Required, Job Responsibilities:* • SQL Server 2008+, SQL Server Management Studio and other data management tools • Database development: Work with application developers to deliver data through the design of stored procedures, functions, and views • Design complex physical and logical data models • Create database queries, indexes and stored procedures, some with high levels of complexity • Performance Tuning: Review monitoring tools and query execution plans to maintain or increase query efficiency. Also perform root cause analysis on query performance issues and other database issues • Writing and creating data load scripts and stored procedures; ensuring that data is loaded in a timely manner • Working with application developers in the design, tuning, and indexing of tables • Extensive experience with SSRS, SSIS, and T-SQL • Must demonstrate experience managing the set up and upgrades of complex databases, including interfacing with source control in order to generate creation, upgrade, and maintenance scripts • Extensive experience creating and optimizing database queries, indexes, stored procedures, triggers, and reports • Extensive experience with database planning and design, set-up, maintenance, performance tuning, and partitioning *The candidate must also be:* • Self-directed, self-motivated and able to take a concept-to-implementation with a high degree of robustness • Great written and oral communicator, and collaborator that performs well in a team-oriented environment • Able to make progress in a fast paced, ever changing environment that is driven by market conditions that constantly cause the team to evaluate the models, data, and platforms meant to forecast conditions accurately. *Preferred qualifications: * Masters or PhD in Computer Science, Math or related field *General Description* · Contribute to software development activities by developing, documenting, testing, modifying and maintaining new and existing software applications. · Apply standard techniques, procedures, and criteria to the development life cycle. · Bring application(s) and technology expertise to the specification and design development process. · Provide technical expertise on assigned applications, to include interfaces and interrelationships with other applications and systems. · Receive technical guidance and day-to-day direction from Software Engineers and Senior Software Engineers. · Code, test and troubleshoot existing programs utilizing the appropriate hardware, database, and programming technology. · Analyze end user data and business needs to format final product and assure user-orientation. · Test and develop programming modifications. · Utilize applications expertise to participate in the design process as needed, then write new program code based on defined specifications. · Document programming problems and resolutions for future reference. · Maintain and modify programs; make approved changes by amending flow charts, develop detailed programming logic, and coding changes. · Write and maintain programming documentation, as well as operations and user guides (as required). - Effectively unit test all code and programs prior to releasing them to the quality assurance (QA) team. · Resolve all unit test issues in a timely manner. · Collaborate with the QA team to identify test cases and create/mine test data to enable a thorough test of all development deliverables. · Respond to all inquiries and issues in a timely manner as the developed code/program moves through the testing process and ultimately into production. · Provide implementation/production support as required. · Analyze performance of programs and take action to correct deficiencies based on consultation with end users, Business Analysts and senior development team members. · Provide input to prolong application life or recommend replacement. Confer with senior development team members to gain understanding of needed changes or modifications of existing programs. · Assist in resolution of questions of program intent, data input, output requirements, and inclusion of internal checks and controls. · Evaluate and thoroughly understand complex interrelationships between assigned applications and systems, such as whether a contemplated change in one application would impact or cause unwanted results in a related part of that application or other applications/systems. · Proactively provide subject matter expertise regarding assigned application(s) to other members of the technology and business teams to assure understanding of interrelationships and dependencies. · Support the installation planning for application program requirements. · Support the end-user and technical operations staff as required. · Assist senior development staff with the integration of technology within and across the capability domains. · Act as a resource to junior development staff regarding technology, methodologies and standards. · Proactively share knowledge and collaborate with development team members, Business Analysts and Technology Operations to assure quick and effective responses to customer needs (internal and/or external). · For Senior and Executive Levels: Strategically plan and prioritize software/solution releases within planned release schedules based on enterprise business strategy, business and technology need, and impact while assuring appropriate scope, size and impact of releases to end users. · Effectively plan all design, development and testing work to assure the pre-determined release schedule is met. *For Senior and Executive Levels*: Provide strategic direction and operational leadership to a team of highly technical employees. Develop and maintain an organization of high performing people through effective hiring, coaching and rigorous performance/talent management processes. *Regards,* *Chathurya* *Talent Acquisition Specialist* *RaysTech Solutions* *901-286-8743* */ **901-254-7016* *chathu...@raystechsolutions.com <chathu...@raystechsolutions.com>* -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.
