*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* *[email protected] <[email protected]>* -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.
