Database Engineer
This role is responsible for the implementation, support, and administration activities required to maintain the operational integrity of our databases and ETL processes. Responsibilities include designing and developing ETL solutions using Microsoft’s SQL Server Integration Services (SSIS) and BridgeGate ETL for interfacing between the source application and the Reporting Data Warehouse. Additional responsibilities include unit testing and validation, problem assessment and resolution, current ETL process enhancement, and documentation for existing and new ETL packages including workflow mapping. In addition, the Database/ETL Engineer  works with the DBA Group and the Development Teams to assist in the continuous review of the Transactional database and Data Warehouse database schemas including data types, business key selections, referential integrity, etc. for consistency and standardization. Additionally, as a Database/ETL Engineer you will be assigned to participate on project teams providing Microsoft SQL Server expertise as required to deliver on the project objectives.Responsibilities:Along with other key personnel, ensure the overall data integrity and conformity of the information gathered; manage data quality tasks through the ETL processesWork with DBA Group, Development Teams, and Business Analyst to identify and understand source data systems, as well as provide input for enhancements for standardization and consistency across the Enterprise (Transactional systems, Data Warehouse, etc.)Map Import/Export Files to source system data; map source data to data warehouse modelsDevelop and test extraction, transformation, and load (ETL) processesDevelop and maintain ETL scripts and workflows, SQL queries, VB/C++ script components, schedules, etc. using SVN for version controlDefine and capture metadata and rules associated with ETL processesDevelop processes to identify and analyze data quality issues and recommendations to resolveDocument, including diagrams, the architecture and components of the Reporting data warehouseModify existing ETL processes to improve performance and adapt to changing requirementsUse SQL Server query techniques and available tools, against the transaction system and the reporting data warehouse, to identify and analyze data quality issuesPerform daily review of production data processes to ensure successful completionReview databases to ensure operating at optimal performance levelsReview and report disk utilization as required input to capacity planning effortsProvide expertise in the review and correction of data integrity and / or reporting issuesPerform performance tuning of queries and stored procedures.Review, understand, and provide feedback on functional requirements from a database perspectiveSupport QA, Developers, Support and others allowing them to complete their assignments.Implement as required database structures as defined by the Senior / Lead database engineerImplement as required log shipping, database mirroring, SQL replication, backup and restore processes as defined by the Senior / Lead database engineerMonitor the health of all SQL servers with regards to log shipping, database mirroring, SQL replication, backups and restores (full, differential, and transaction logs), SQL agent job status, disk space, transaction log space, open transactions, etc.Develop, test, and debug new functionality, and maintain/enhance existing functionality in using SQL, stored procedures and API’sIdentifies and implements process improvement leading to cost reduction and operational stability.Will ensure documentation is updated and current for all release cycles.
Title: Database Engineer
Salary: None
Description: This role is responsible for the implementation, support, and administration activities required to maintain the operational integrity of our databases and ETL processes. Responsibilities include designing and developing ETL solutions using Microsoft’s SQL Server Integration Services (SSIS) and BridgeGate ETL for interfacing between the source application and the Reporting Data Warehouse. Additional responsibilities include unit testing and validation, problem assessment and resolution, current ETL process enhancement, and documentation for existing and new ETL packages including workflow mapping. In addition, the Database/ETL Engineer  works with the DBA Group and the Development Teams to assist in the continuous review of the Transactional database and Data Warehouse database schemas including data types, business key selections, referential integrity, etc. for consistency and standardization. Additionally, as a Database/ETL Engineer you will be assigned to participate on project teams providing Microsoft SQL Server expertise as required to deliver on the project objectives.Responsibilities:Along with other key personnel, ensure the overall data integrity and conformity of the information gathered; manage data quality tasks through the ETL processesWork with DBA Group, Development Teams, and Business Analyst to identify and understand source data systems, as well as provide input for enhancements for standardization and consistency across the Enterprise (Transactional systems, Data Warehouse, etc.)Map Import/Export Files to source system data; map source data to data warehouse modelsDevelop and test extraction, transformation, and load (ETL) processesDevelop and maintain ETL scripts and workflows, SQL queries, VB/C++ script components, schedules, etc. using SVN for version controlDefine and capture metadata and rules associated with ETL processesDevelop processes to identify and analyze data quality issues and recommendations to resolveDocument, including diagrams, the architecture and components of the Reporting data warehouseModify existing ETL processes to improve performance and adapt to changing requirementsUse SQL Server query techniques and available tools, against the transaction system and the reporting data warehouse, to identify and analyze data quality issuesPerform daily review of production data processes to ensure successful completionReview databases to ensure operating at optimal performance levelsReview and report disk utilization as required input to capacity planning effortsProvide expertise in the review and correction of data integrity and / or reporting issuesPerform performance tuning of queries and stored procedures.Review, understand, and provide feedback on functional requirements from a database perspectiveSupport QA, Developers, Support and others allowing them to complete their assignments.Implement as required database structures as defined by the Senior / Lead database engineerImplement as required log shipping, database mirroring, SQL replication, backup and restore processes as defined by the Senior / Lead database engineerMonitor the health of all SQL servers with regards to log shipping, database mirroring, SQL replication, backups and restores (full, differential, and transaction logs), SQL agent job status, disk space, transaction log space, open transactions, etc.Develop, test, and debug new functionality, and maintain/enhance existing functionality in using SQL, stored procedures and API’sIdentifies and implements process improvement leading to cost reduction and operational stability.Will ensure documentation is updated and current for all release cycles.
Requirements: Mid-Senior level experience, Bachelor's Degree education
Fraudulent: No