Create T-SQL queries to map Hadoop business activity to documenting customer activity and functionality between Cross Channel Customer Interactions (C3i) and the MAAC database to Snowflake Data Lake.Utilizing Cognition Pro for Hadoop, Squirrel SQL Client, and Box applications to code in HiveQL to maintain big data.Inquire Kafka Topic database on validating C3i Business Activity.Operate Control-M to check Daily Monitor of Data Processing jobs and logs for C3i and MAAC batch tasks events.

Administrate multi-mortgage systems operations for accuracy and performance. Develop procedure specifications and validate program accuracy by preparing unit test plans/scenarios and evaluating results against plans.Plan work unit packages which include source code, documentation, unit test data/plans, debugging, and evaluating test results against expected results.Implement resource guide, instruct, and monitor team members in coding techniques, technical and user procedures, and established standards.Expertise in SSIS, SSRS, T-SQL, PL/SQL, PowerShell, DOS script, and API scripts on SQL Server 2018 and 2019 Oracle, and VM/Oracle Cloud projects.Automation, DR Plan, coordinating SQL Agent job schedule cross-platform.Evolve new and existing programs that reflected changes in systems performance.

Developed a capacity planner database to increase efficiency on reporting by 30% on evaluation metrics.Transformed LLD & HLD requirements documentation of CPU, memory, and disk requirements. Designed technical evaluation for Splunk (30 servers), Hadoop, and MapReduce expansion projects. Coordinated management through the research of server performance improvement and planning.

Administrate and manage multiple VM database instances on a private cloud environment. Utilize performance tuning, optimization, and maintenance for the client's database and SQL Server 2005, 2008, 2012, 2014Monitor database server operations using Spotlight, logs, and Windows Management tools.

Head reconstruction of SQL Server 2008-2014 for relocation to a new facility.Implement DR plan before financial database failure that results in a full recovery of a database. Direct optimization initiative to use performance tuning and page life expectancy (PLE) for all productionservers.Perform system maintenance regimen to scrub database of outdated configurations and code.Strengthen development procedures, triggers, SSIS, Index, and ad hoc T-SQL for SQL support. Monitor server using Fog Light and Power Designer for data architecture.

Led development of migration of SQL Server and other databases to new platform and database.Utilized Power Designer for Data Modeling and Data Architect for standardization and documentation.Designed end to end conceptual and logical data models of databases and tables.Created SQL Server 2005, 2008, 2012, SSIS and ETL package for production systems migration (Agile/ Scrum).Identify and construct complex SSIS, T-SQL, PL-SQL, and stored procedures.Evaluate AWS network and storage platform for cost and feasibility.Developed data warehouse design in Sybase Power Designer for data architecture.