*Hi, * Please find the requirement below , If you find yourself comfortable with the requirement please reply back with your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number *631-230-0251 x 5256 <(631)%20230-0251>*
*Please share the profile at vis...@edoorsinc.com <vis...@edoorsinc.com>* *Sql Server Reporting Developer/ DBA* *Woodcliff Lake, NJ* *8+ month/ Contract* *Phone and In Person* *Must be USC, GC, EAD- GC or TN* *Responsibilities:* As part of the Reporting Team, candidate will gather, coordinate and be responsible for providing technical reporting capabilities in support of the global risk applications. Responsible to liaise with functional users and team members to gather business requirements, analyze reports to ensure business goals are achieved and quality is maintained, liaise with other group members and ITS teams to evaluate enhancements. Candidate will also document issues and defects, liaise with the Reporting Project Manager and other reporting team members to keep all concerned parties informed. *Main responsibility is the cleanup and upgrade of 2 database servers* · Generate large data extractions, and analysis based on a SQL back-end data store. Design new reports/data transformation/flows and maintain existing report portfolio. Utilize SQL scripting and SSIS. · Understand, interpret and challenge requirement specifications · Address complex issues by thoroughly understanding the business and its functions · Troubleshoot complex issues as well as provide ongoing support to production: Create, manage and troubleshoot SQL Server Agent Jobs. Manage Logins and Security in SQL Server · Automate existing ongoing reports via SQL server and SSIS while continuously looking for efficiencies. · Provide development estimates and participate in project planning. Learn and prototype new technologies, and recommend their use in future reporting solutions · Maintain detailed commentary in all SQL scripts and diligently report all activity (requirements gathering, development time and implementation) in the Project Activity Application · Document issues and defects, while liaising with the reporting manager, development teams, and business leads to keep all concerned parties informed · Can ask logical questions to ascertain requirements /needs. Communicate with teams the technical implications, including extractions of data, processing of data, and the delivery of reports. · Liaise with application end users and team members to define report requirements, participate in group projects and support the business process help desk teams. Collaborate with team business leads and IT development teams to understand application and database structure changes and enhancements. Participate in business design sessions · Participate in the Deployment and Implementation of Projects *Skills:* · *5-7 years of overall business experience with at least four years of reporting development and SQL development and SSIS*, preferably within a professional services firm · *Strong database administration experience on SQL Server 2008 R2 IS REQUIRED* · Experience in SSIS working in Azure environment; specifically upgrading packages from Project Deployment SQL 2012 to Package Deployment SQL 2016 preferable · Demonstrated technical experience with designing, building, installing, configuring and supporting the RDBMS Microsoft SQL Server · Strong experience in SQL development (T-SQL) including working with complex data structures and indexes · Database management knowledge focusing on Microsoft SQL server technology, including writing SQL stored procedures, cursors, dynamic SQL and performance tuning · Ability to reverse engineer existing ETL processes · Strong understanding of database structures, theories, principles, and practices along with the capacity to stay abreast of current technologies and technological trends · Familiarity with SQL Server Credentials and Proxy accounts as they relate to the SQL Server Agent · Advanced knowledge of Microsoft Access & Excel including but not limited to macros, pivot tables, power query and power pivot. Proficient in all other Microsoft Office applications · Strong backup and restore experience · Particularly adept at conveying complex technical information in an understandable manner to all levels · Ability to act quickly on issues and requests associated with business needs · Ability to work in a fast paced team environment and self-manage, work well under pressure meeting tight deadlines and possess excellent interpersonal skills to work well with employees at all levels. · Working knowledge of application implementation and support procedures · Ability to handle multiple tasks and support special project needs simultaneously · Solid experience with requirements gathering · Strong written and oral communication skills · Ability to determine appropriate escalation path · SQL Server 2005, 2008, 2008 R2, 2012 · BIDS SSIS, SQL Server Data Tools · Visual Studio 2010, 2013 Education: BS/BA or MS degree from an accredited college/university or equivalent work ex -- You received this message because you are subscribed to the Google Groups "R-help-archive" group. To unsubscribe from this group and stop receiving emails from it, send an email to r-help-archive+unsubscr...@googlegroups.com. To post to this group, send email to r-help-archive@googlegroups.com. Visit this group at https://groups.google.com/group/r-help-archive. For more options, visit https://groups.google.com/d/optout.
