•Perform and support database maintenance and system health checks•Support Business Continuity and Contingency processes and tests•Work directly with internal and external product providers and end user clients to conduct quality implementations, product deployments, and project deployments•Define User Acceptance tests to ensure the product meets the project goals•Identify the root causes on issues and clearly articulate the cause, the scope of the risk, and ways to mitigate the risk moving forward.•Understand and articulate the impact and interaction of other tools on the options available to our customers.•Maintains Microsoft SQL databases, including all client-facing environments, database backup, support of databases across internal and end-user application.•Analyzing existing database applications for performance tuning, alerting & monitoring, working with application developers to integrate efforts with relational databases, participate in team or company projects as required

Build Pentaho Data Integration with spoon filesMigrate ETL process to Pentaho Schedule ETL Jobs and Transformations using pentaho and pythonMigrate data from EDW to AWS s3 buckets using AWS GlueCreate BTEQ scripts to ingest flat files into EDWCreate database objects, such as tables, and maintain the database build scriptTunes SQL queries for performance and scalabilityTroubleshoot complex problems and provide support for the ETL process.Assist in migrating data into Azure databrick Build views to provide data to reporting tools(powerBI, tableau, splunk)Create database user accounts and grant appropriate privileges to those accountsCreate alarms base off patterns/behaviors identified in the data Use topic modeling to create labels and reduce amount of reviews need for email labelsCreate dashboards in PowerBI to identify changes in alarms Use time series forecasting to predict expected workload of advisers throughout the year Predict if a transaction is fraud base off independent variables identified using a logistic regression model