| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatePage 1 of 2Candidate's Name
Data Warehouse/DatabaseAdministratorEMAIL AVAILABLE PHONE NUMBER AVAILABLELinkedIn Profile Sparta, GAPROFILEClient-centric and analytical professionalpossessing 20+ years of experience.Proven track record of improving systemsecurity by recognizing and neutralizingvulnerabilities. Proficient in testingdatabases, programs and systems whilecorrecting errors. Skilled in evaluating,testing, implementing and modifyingcomputer databases. Knowledgeable instreamlining database performanceissues, database capacity and databasescalability.AREAS OF EXPERTISEDatabase AdministrationBackup & Data RecoveryData & System SecurityInstallations & ConfigurationDatabase Access ManagementCapacity PlanningSystem TroubleshootingTechnical QueriesSystem Updates & MonitoringEDUCATIONHigh School DiplomaMiddleton High SchoolMiddleton, WITECHNICAL SKILLSMicrosoft SQL Server, SAP AdaptiveServer Enterprise, MySQL, Sybase IQ- TransactSQL - Database Design - Querytuning & Index OptimizationProficient with Linux, UNIX, Windowsand Mac OSAdobe ColdFusion - DeveloperVMware SystemsPROFESSIONAL EXPERIENCEManaging Partner 07/2006 to 06/2021Trac III Systems, Mount Horeb, WIDesigned, developed and deployed the current National Motor Fuel Diversion and Import Registry System, i.e., fueltrac.us (from scratch). Rewrote the entire system in numerous languages using multiple databases and application platforms. Enabled tax adjustments on motor fuel travelling interstate through this system. This system presently records over one billion gallons of fuel annually and collects over $250M in motor fuel tax annually.Deployed a Sybase IQ data warehouse solution to streamline subscription churn analysis and client targeting for St. Petersburg Times.Implemented the Sybase Industry Warehouse Studio (Data Warehouse for Media) in addition to the Circulation Pro software solution catering to AST in Framingham, MA.Database Specialist 08/2004 to 07/2006Global Card Services Inc., Downers Grove, ILUndertook extensive data analysis for clients' information and storage systems. Developed as well as implemented digital conversion programs to meet clients requirements. Generated and submitted data collection reports to the concerned departments.Fortified the folio viewer application used in hotels, cruise lines and rental car industries by building a substantial Sybase IQ multiplex data warehouse. The system encompassed two components; first the OLTP system to collect credit card transactions and second was the data warehouse that retrieved transactions swiftly and prepared them for display. Web Developer 09/2002 to 08/2004Distributor Resource Management Inc., Carrollton, TX Leveraged languages and numerous tools to develop appealing and intuitive websites. Oversaw website updates. Orchestrated tests and schedules for efficient workflow. Backed up files for recovery and data retrieval. Identified and troubleshot diverse issues through customer feedback and testing. Evaluated and ensured that the code meets industry standards and has compatibility with different browsers and devices. Defined and fulfilled user demands by assessing and interpreting technical needs.Built a web interface that facilitated the submission of food service rebates. These rebates would then be distributed to the desktop clients via a SOAP XML interface.Page 2 of 2PROFESSIONAL EXPERIENCE, CONTINUEDSystem Consultant 06/2001 to 08/2002Sybase Software, Dublin, CAUnderstood client needs and business objectives. Offered strategic consultations on deploying technology to attain goals. Governed IT tasks and liaised with technical team members. Developed IT systems and networks while selecting the correct functionality and architecture. Promoted new technology to optimize operations. Recognized and resolved technical issues. Upgraded existing systems and recommended cutting-edge improvements.Assisted new clients in integrating Sybase IQ into current infrastructure. offered suggestions based on data modelling and indexing. Supported clients with the extraction, transformation and loading. Aided DBAs in their learning journey with Sybase Data Warehousing solutions and provided guidance on enhancing performance.Managed some of the largest data warehouses in the country at the time, each comprising over one billion rows of data. Learned almost everything about the extraction transformation and loading (ETL) process through numerous operating systems and RDBMS.Database Administrator 09/1997 to 06/2001AccuData Integrated Marketing, Cypress Lake, FLMonitored system performance and recognized technical issues. Responded promptly to user-reported errors. Safeguarded the database against unauthorized access and equivalent vulnerabilities. Backed up databases and for recovery in the event of memory loss. Tracked and reported on parameters pertaining to performance and usage. Recommended improvements for database security. Coordinated with IT project managers and database programmers.Collaborated with development team to build one of the first online mailing list count and order system (getlists.com). Listed DNB, Polk Consumer and several others. The system was initially developed in MS SQL Server, but delivered lower output than expected, for a web-based system. We tackled this issue efficiently and implemented Sybase IQ in under a week. |
