| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Database Administrator / Architect / AnalystSpecializing in Microsoft SQL Server and associated technologies. Street Address SW Reese StreetArcadia, FL Street Address
PHONE NUMBER AVAILABLEEMAIL AVAILABLEEDUCATIONUniversity of MinnesotaBachelors Degree - Computer Science - 1990Bachelors Degree - Business/Economics - 1990EXPERIENCESenior Database Administrator Bridgetower Media7/2011 -3/2023 Administration Responsible for all aspects of MS SQL Server database server administration including installation, DB creation, DB object creation, profiling, troubleshooting. Design and Architecture Lead application architect and database designer for all customer-facing web applications based on .Net, ColdFusion, WordPress, SOLR, and more. Development Lead developer for all backend SQL Server data transfer systems as well as creation of data abstraction layers using hundreds of SQL Server stored procedures for use in Public Notice and Project Central web applications. Operations Responsible for all day-to-day SQL Server operations such as performance monitoring and enhancement, disaster recovery systems utilizing NetApp snapshot backups across multiple data centers, and tier 1 database service desk related issues.Database and Application Architect Polaris Industries 8/2008 -4/2011 Responsible for all aspects of the Oracle Data Warehouse including data import/export, programming, and data mining tools such as Sales Analyzer and Discoverer. Responsible for all import and export jobs to the Polaris CRM environment using Scribe Insight Server and other assorted tools. Completed Microsoft course 6234A - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services and subsequently designed and implemented an Analysis Services pilot project for PG&A sales reporting. Created a SQL Server data warehouse to hold traffic and usage data from the World Wide Web at Polaris.com. Used SSAS to create searchable data cubes for consumption by end-users via Excel and Sharepoint services.CORE COMPETENCIESMicrosoft SQL Server- Server Administration- Disaster Recovery- Indexing- Performance Monitoring- Security- ReplicationT-SQL- Stored Procedures- Functions- TriggersData ModelingDatabase ArchitectureETL- Remote DB- ODBC- API- FTP / SFTP- Flat FilesMicrosoft Office (Word, Excel, etc.)ANCILLARY TECHNOLOGIESOracleMySQLMicrosoft AccessAWSBlueConic CDPAPT FalconSharepointAPIERWinToadRedGateNetAppDNS AdministrationSQL Server Consultant Infocomm Information Resources 5/2007 -6/2008 Migrated all production SQL Server databases from SQL Server 7 to SQL Server 2005. Created jobs for production databases to automatically clean and archive. Designed and implemented database structures to maintain tradeshow records. (New market) Re-wrote manufacturer and dealer on-line reports to relate web traffic information to customers. Created jobs to automatically import and export customer information. SQL Server Consultant Bridgetower Media2/2007 -5/2007 Designed and implemented new data structures as needed by the Bridgetower development team. Audited, analyzed, and supported hundreds of database replication schemes across the enterprise. Maintained and supported all corporate SQL Server ETL functions. Designed, implemented, and supported new database maintenance plans on all production servers. Monitored, profiled, and improved performance of production servers. Routine backup and restores as requested by the Bridgetower development team. Administered SQL Server security in conjunction with active directory. SQL Server Consultant Montage Inc.12/2006 -2/2007 Created Data Transformation Services (DTS) packages to gather customer data. Re-wrote stored procedures for cleaning customer data. Redesigned warranty import procedures. Designed logging functions to help Montage IT staff troubleshoot future problems. Performance tests and load balancing on production servers to enhance performance. 1990 - 2006Upon graduation from college, my first job was a customer service representative for SPEED>S Corporation, an electronic tax filing organization. I quickly moved from that position to a Systems Integrator position. Two years later, I moved to Amcom Software, a voicemail, messaging, and call accounting software developer. I worked there two years installing and integrating systems, then I moved on to Premier One Consultants as a Systems Integrator. This is the position that allowed me to transition my career and utilize the database expertise that was the focus of my degree in college. After a year of systems integration, I was promoted to Project Manager and a year later to Senior Project Manager. As Senior Project Manager I took on the added responsibility of database design for the WorldTrak suite of Customer Relationship Management products. In 1998, I joined the Northwest Airlines Y2K program office and spearheaded a companywide program to certify and remediate all computer systems worldwide. After the year 2000, I spent four years as the Database Administrator/Architect for Infocomm Information Resources and then onto a host of consulting engagements including one for TFG Direct, a telemarketing firm that needed a database system to house marketing programs as well as record calls and responses. That database is still in use today. |
