{"id":3709,"date":"2009-04-01T21:23:12","date_gmt":"2009-04-02T01:23:12","guid":{"rendered":"http:\/\/www.asianinny.com\/?p=3709"},"modified":"2009-04-01T21:23:12","modified_gmt":"2009-04-02T01:23:12","slug":"database-developer-2","status":"publish","type":"post","link":"http:\/\/www.asianinny.com\/?p=3709","title":{"rendered":"Database Developer"},"content":{"rendered":"\n\n\n\n\n\n\n
Company:<\/strong><\/td>\nMoody’s Investors Service<\/span> <\/td>\n<\/tr>\n
Job Category:<\/strong><\/td>\nIT\/Software Development<\/span> <\/td>\n<\/tr>\n
Job Title:<\/strong><\/td>\nDatabase Developer<\/span> <\/td>\n<\/tr>\n
Location:<\/strong><\/td>\nNew York, NY 10007<\/span><\/td>\n<\/tr>\n
URL:<\/strong><\/td>\n http:\/\/www.moodys.com<\/a><\/span> <\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Job Description<\/strong><\/p>\n

Moody’s is an essential component of the global capital markets, providing credit ratings, research, tools and analysis that contribute to transparent and integrated financial markets. Moody’s Corporation (NYSE: MCO) is the parent company of Moody’s Investors Service, which provides credit ratings and research covering debt instruments and securities and Moody’s Analytics, encompassing the growing array of Moody’s non-ratings businesses including Moody’s KMV, a provider of quantitative credit analysis tools, Moody’s Economy.com, which provides economic research and data services, and Moody’s Wall Street Analytics, a provider of software for structured finance analytics. The corporation, which reported revenue of $2.3 billion in 2007, employs approximately 3,600 people worldwide and maintains a presence in 29 countries. Further information is available at www.moodys.com<\/a><\/p>\n

Responsibilities<\/strong><\/p>\n

This associate will provide expert database design, development, administration and implementation skills using primarily the Microsoft SQL Server 2005 toolset to manage the needs of the Asset Finance Group’s RMBS and Servicer Quality Teams.<\/p>\n

DUTIES AND RESPONSIBILITIES:<\/p>\n

General
\n– Develop, maintain databases, procedures, ad hoc queries, reports, tools
\n– Write SQL queries, stored procedures, and DTS\/SSIS packages to scrub, cleanse, modify data –
\n– Optimize and tune SQL statements and databases
\n– Troubleshoot and resolve database issues
\n– Perform database management tasks including database infrastructure design, automation of data loads, performance tuning, SQL programming, data manipulation, massage and cleansing.
\n– Support internal clients by creating data-driven applications and ad hoc queries.
\n– Define, test, and execute data validation routines
\n– Perform application program enhancements, troubleshooting and bug fixes as required.<\/p>\n

Specific<\/p>\n

Support Deal Monitoring Database Querying and Report Generation – Primary
\n– Provide RMBS analysts with data extracts and reports from the Trustee, loan-level database
\n– Either develop an internal OLAP system or implement a third-party OLAP solution for loan-level data<\/p>\n

Servicer Quality Data Processing – Backup
\n– Receive raw data from Servicers and turn-around (extract, map, clean, load) within 3 person-days
\n– Iterate with analysts to troubleshoot and correct errant data from Servicers
\n– Develop integrated Servicer database and associated advanced servicer reportage
\n– Automate all components, reports, etc of the Servicer data process that can be automated
\n– Use JIRA and other project management tools to calculate, manage and improve Servicer process throughput<\/p>\n

Other<\/strong>
\n– Handle ad hoc requests from SQ Team, RMBS analysts and QR&A personnel while staying on schedule with Servicer Data processing and reporting
\n– Other database projects as required<\/p>\n

Qualifications<\/strong><\/p>\n

QUALIFICATIONS:
\nB.S. in Computer Science, Mathematics, or Engineering
\n5+ years experience working as a database developer using SQL Server
\nClear understanding of the logical and physical database design and data normalization concepts
\nExpertise in creation and management of databases, tables, views, and stored procedures
\nExpertise with scripting tools: perl preferred.
\nExpertise with OLAP technologies, .Net programming, XML
\nExpertise using data modeling tools, e.g., ER-Studio, Erwin, etc.
\nExperience with Sybase ASE and IBM DB2 databases a plus
\nExperience with Moody’s legacy systems (specifically sfg, ratings, and ems databases and PDS) a big plus
\nKnowledge of Mortgage Backed Securities a big plus
\nSome statistics background and \/or training a plus
\nProven troubleshooting and problem resolution skills
\nExcellent problem solving skills with the ability to analyze complex tasks and propose viable solutions for both strategic and tactical development initiatives
\nAbility to work well in individual, team and high pressure situations
\nVery good oral and written communications skills<\/p>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Company: Moody’s Investors Service Job Category: IT\/Software Development Job Title: Database Developer Location: New York, NY 10007 URL: http:\/\/www.moodys.com Job Description Moody’s is an essential component of the global capital markets, providing credit ratings, research, tools and analysis that contribute to transparent and integrated financial markets. Moody’s Corporation (NYSE: MCO) is the parent company of […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[278,174,277,279],"class_list":["post-3709","post","type-post","status-publish","format-standard","hentry","category-looking-for-work-search-our-premium-job-database","tag-database-developer","tag-it","tag-moodys","tag-software-development"],"_links":{"self":[{"href":"http:\/\/www.asianinny.com\/index.php?rest_route=\/wp\/v2\/posts\/3709","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.asianinny.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.asianinny.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.asianinny.com\/index.php?rest_route=\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/www.asianinny.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3709"}],"version-history":[{"count":2,"href":"http:\/\/www.asianinny.com\/index.php?rest_route=\/wp\/v2\/posts\/3709\/revisions"}],"predecessor-version":[{"id":3711,"href":"http:\/\/www.asianinny.com\/index.php?rest_route=\/wp\/v2\/posts\/3709\/revisions\/3711"}],"wp:attachment":[{"href":"http:\/\/www.asianinny.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.asianinny.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3709"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.asianinny.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}