R



R.J. TroudtN7817 County Road WHFond du lac, WI 54937920.226.1405 Cell920.923.4078 HomeRJ@Primary Areas of SQL ExpertiseMicrosoft SQL Server management 7.0-2016, systems analysis, design, development, programming, performance monitoring, hardware utilization and high availability clustering, availability groups. PowerShell, SSAS, SSIS, SSRS, TSQL.Experience:Senior SQL Database Administer Mgr.– VPAssociated Bank Corp., Milwaukee, WI 08/2011 - 04/2019Architect solutions to manage proprietary analytic application.Design, develop and implement frameworks to support process & workflow automation, data models, data marts & DW. Metadata, Availability, SLA, Job execution, security tracking (SQL & NTFS) schema change & notification.Automation & integration of enterprise applications leveraging multiple enterprise schedulers – (Control-M, Informatica Power Center & SQL Agent)Automation of Excel based reportsETL development from multiple data sources & types (SQL server, Oracle, PostgreSQL, Mainframe DB2)Performance management, SQL server & hardware/infrastructure. Supporting tables of large size 2+ billion rows and multiple databases of 5+ TBMigration of SQL environments to SSD storage (Pure) for HA, DR, Non-ProdProject Management – From inception or assignmentDesign collaboration – supporting agile & continuous integration development with Business Analysts, DBA Team, Developer Team and Enterprise business partners. Change & Design principles supporting db design, modeling, normalization & relationalSupport of day to day operations & disaster recovery operations in multiple data centers.Areas of interest:Cloud transition & transformation – AzureBIML automationMS StackProfessional Association for SQL ServerSenior SQL Database Administrator - AVPM&I Bank, West Allis, WI 07/2005 – 08/2011Manage SQL Clusters 2000-2008 R2, Web Farm and application servers for Risk Administration MIS group. Manage DBA workload.Responsible for disaster recovery planning for SQL Servers. Responsible for information security auditing & reporting. Design & develop Integration services / SSIS automations / ETL from multiple source data systems. Mainframe, Netezza, Oracle, Progress and SQL server.Data warehouse design and validation mechanism. Integration of multiple source systems into unified reporting structure for multiple business lines at M&I Corporation.Project management.Continuous improvement by monitoring long-running SQL queries to cut execution time, ease database load and improve scalability.Trained developers and junior DBA's on SQL best practices, query design proc execution plans.Hardware conversions & software version upgrades.Implemented Quest software suite.Systems Administrator – ConsultantTEK Systems, Appleton, WI January 2005 – May 2005Perform various activities AD, deployment, SQL server AdminNetwork Systems DeveloperWells Manufacturing Corp., Fond du lac, WI January 1994 – May 2004SQL Server 2000, Data Warehousing, DTS, Microsoft IIS, Visual , SQL Report Server, Crystal Reports, Terminal Server, Office.Windows 2000 Domain AdministratorEmail administration Firewall, VPN, Routing, DNS, DHCP, TCP/IP work security.Architect SQL Databases for business applications and create web interfaces for data access and manipulation. Create data marts for Analysis and reporting services.Analyze, design, develop, and implement business process applications.Set-up, create, and administer enterprise reporting systems using SQL Report Server and Crystal reports.Create and develop corporate intranet. HTML, ASP & Integrate third party middleware.Evaluate and recommend software based on internal customer requests.Create group policies for Active Directory user administration and software distribution.Distribution & maintenance of Antivirus (Sophos) to 350 nodes and servers in LAN/WAN.Set-up, maintenance of Windows 2000 servers, SQL servers and Network Appliance Filers. Backup of Storage Area Networking and servers with Network Appliance Snap-Image and Veritas software.Content scanning of all email documents based on policy requests from management.Quality Assurance TechMetal Tech Industries, Longmont, CO October 1991-September 1994Inspection of fabricated sheet metal parts to blue print specifications.Q.A. InspectorMuza Metal Products, Oshkosh, WI November 1983-July 1988EducationMicrosoft product training.University of Colorado Denver, CO August 1988 - May 1991Regis College, Denver, CO September 1981 – May 1983Ripon High School, Ripon, WI June 1981Professional AssociationsPASS Professional Association for SQL ServerReferences available upon request ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download