Previous Job
Previous
SQL Server ETL Developer – Senior
Ref No.: 18-20591
Location: Boston, Massachusetts
Job Details:
Title: SQL Server ETL Developer – Senior
Location: Boston MA 02108
Duration:  12 months
 
Database Architecture Re-Design and Development:
This project will involve restructuring the database into a relational structure, with views and lookups as needed.  Particular focus will be on improving efficiency and streamlining annual upload of case mix files.
 
Database Security and Minimal Access:
Ensuring the database limits access and complies with state, federal and guidelines, regulations and laws are essential.  This project will involve working closely with IT and IT to ensure the database is secure and access is limited to authorized parties only.  In addition, this will involve the creation of user-based access levels within.
 
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.
 
Warm Regards,
Shashi kumar
cid:image001.png@01D39900.54946F20
13454 Sunrise Valley Drive, Suite 120, Herndon, VA 20171
Direct: 201 497 1021 Fax: 703-935-0339
shashik@LanceSoft.com | www.LanceSoft.com
Contingent Workforce | Enterprise Solutions | Engineering Services