Hi , Please let me know if you have anyone for this role.
Client: Big Telecom company Title: *SQL Server/ETL Developer* Location: *Boston, MA* Duration: *6 months* to start (likely long term extensions) *F2F interview required.* Visa: EAD/GC/USC The consultant shall work closely with client IT Leadership and will be responsible for the proper maintenance, documentation, support, and enhancements to the current application environments. Strong verbal, analytical, and written communication skills are required. The consultant will be responsible for gathering, analyzing, documenting and maintaining all data requirements related to the business applications, interfaces, and reporting environments. This documentation shall include all logical and physical data models, all required Gap analysis, all source to target specifications & all business logic or rules required to translate the business functional and technical requirements. The Analyst shall be assigned to daily operations, as well as to ongoing projects, with a focus of meeting the business objectives of quality, on time, and on budget goals. The consultant shall expertly utilize standard SQL Server tools and possibly other third party and data modeling tools to develop and implementing highly efficient, scalable, and automated ETL processes. The consultant is responsible for ensuring high availability of all related business applications through the strict adherence to all client processes, ensuring proper Confidentiality of data, Security, Quality Assurance, Change Management, and Release Management practices. This position reports directly to Applications Manager and the designated IT Program Manager. Key Responsibilities: - Research, analyze, document, and maintain internal Applications and Database architectures - Assist with RICE (Reports, Integrations, Conversions, and Enhancements) through the use of current tools. - Develop work plans, schedules, and manage to target deadlines on short term and long term initiatives - Provide tier-3 support, which may include problem definition, solution design, business continuity, backup and restore requirements resolve complex system issues and incidents escalated from lower support tiers. - Provide SQL development and coding (TSQL) for internal projects and teach/mentor other team members. 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 ETL Solutions - Knowledge of file and file transmission protocols (SFTP, Web Services, XML, Flat File) - 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 - Strong Data Modeling and Database Design experience - Strong adherence to source control, version management, or Configuration management practices - Ability to communicate effectively both verbally and in writing (Clearly and Succinctly) - 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 ) - T-SQL, sqlcmd, bcp, sqldiag, tablediff and other programing and diagnostics - Expert level knowledge/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 knowledge 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, system sprocs) - Working knowledge Database Error and Exception Handling. - Knowledge of J2EE/Web/Application server and troubleshooting application/server logs. *Please send me below information to submit your resume to client.* Full Name: Current location: Contact number: Email: Skype ID: DOB(MM/DD) SSN( Last 4 Digit): Face to face: Legal visa: Willing to relocate (Yes/No): Availability: *--------* *Thanks,* *Bhanu Pratap Singh* *Source InfoTech Inc.* W: *609-917-3310*| F: 732-909-2282| Email: *bh...@sourceinfotech.com* <bh...@sourceinfotech.com> | Website: *www.sourceinfotech.com* <http://www.sourceinfotech.com/> | -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at https://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
