*Please send the resume to [email protected] <[email protected]>*
*Dear Partner, * *Scadea Solutions Inc. is a highly recognized provider of professional IT Consulting services in the US.* *Here is our open requirement which can be filled immediately. Kindly respond to this requirement with your consultant resume, contact and current location info to speed up the interview process.* *Position: SQL Server Developer* * Location: Boston MA Duration: 6-12 months Responsibilities: • Review the current database architecture, re-design & develop the new database to improve the efficiency, usability and streamline data import and export processes. • Develop advanced T-SQL code for implementing application business logic using stored procedures, views, and functions. • Document specific requirements for data integration, including file format, fields, etc. • Develop ETL processes for the import and export of data between the DPH internal systems using SQL Server Integration Services (SSIS) and advanced T-SQL to include stored procedures, user-defined functions, views, etc. • Design, develop, revise and maintain a wide variety of custom SSRS reports to support our business. • Assist in the Creation and Analysis of optimized stored procedures for data pulls for reports/exports. • Develop data warehouse objects and processes for the purpose of supporting business intelligence, including ETL, fact/dimension tables, and cubes. • Research, analyze, document, and maintain internal Applications and Database architectures. • Assist with RICE (Reports, Integrations, Conversions, and Enhancements) through the use of current tools. • Provide technical assistance and information to technical and non-technical users. • Analyze, design, implement and maintain the businesses critical systems, maintaining at all times the proper data security standards set forth by the organization. Experience and Skills: • Experience with SQL Server databases and their native utilities (Query Analyzer, Analytical Workbench, Etc.) • Advanced SQL query-writing skills, Linux/Unix scripting, and automated job scheduling. • Experience in ETL Development using standard tools like SSIS, SSAS, or other open source ETL tools. • Knowledge of file and file transmission protocols (SFTP, Web Services, etc.). • Strong knowledge of networking protocols and ODBC, JDBC connectivity as it relates to user based connectivity. • Knowledge of applications security including authentication and role based access control within the DB. • Robust data modeling and database design experience. • Strong adherence to source control, version management, or configuration management practices. • Experienced in providing ongoing maintenance and support of IT systems and User communities. • Capable of working independently or as part of a large team. • Experience in maintaining the confidentiality of sensitive information. • SQL Development – ability to write, review and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints). • Expert level knowledge of T-SQL, sqlcmd, bcp, sqldiag, tablediff and other programing and diagnostics experience. • Understanding of Data encryption, TDE, and key management - Intermediate level knowledge/experience. • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. • Strong knowledge of Database server administration and in virtual environments. • Strong understanding of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively. • Knowledge of database native tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, and system specs). • Working knowledge Database Error and Exception Handling. • Knowledge of Base SAS programming and migration of SAS procs to SQL is a Plus. • Qualifications: • 8+ years of Database development experience with Microsoft SQL-Server in OLTP/OLAP environments using T-SQL, SSIS, SSRS and SSAS. • 8 Years of experience in implementing complex ETL processes. • 5+ years of experience in database architecture and administration, SQL tuning, expdp/impdp, SQL loader, Erwin/Data modeler, OEM and ADDM/AWR generation. • Advanced understanding of data warehouse and ETL concepts. • Bachelor’s degree or equivalent work experience is required. • Strong adherence to source control, version management, or configuration management practices. • Exceptional analytical and problem-solving skills. • Ability to communicate effectively both verbally and in writing. • Capable of working independently and as part of a team. * Thanks & regards *Matt* *Scadea Solutions Inc.* Email: [email protected] | Ph: 7908.636.2727 Ext. 2232 Gtalk :- recruiterkhan.it URL: www.scadea.net -- You received this message because you are subscribed to "rtc-linux". Membership options at http://groups.google.com/group/rtc-linux . Please read http://groups.google.com/group/rtc-linux/web/checklist before submitting a driver. --- You received this message because you are subscribed to the Google Groups "rtc-linux" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
