| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Power BI Developer Miami, FL Project Manager Information Technology Boynton Beach, FL Pharmacy Technician III Microsoft Office, word, excel, and power Hollywood, FL Power Bi Data Analyst Hialeah, FL Information Security Software Development Boca Raton, FL Internal Audit Information Technology Fort Lauderdale, FL Administrative Assistant Power Bi Davie, FL |
|
Click here or scroll down to respond to this candidateCandidate's Name
SQL DBA and Developer, Microsoft Certified IT Professional with over 15 years of experience in applied technical information technology. Proven track record in developing and managing data, system maintenance, troubleshooting, infrastructure planning and integrating advanced technology to support operational strategies. Acts as functional liaison for technical teams and business units, while precisely translating complex data into easily understood terms, resulting in action items for prompt execution. Offers a wide breadth of diverse perspectives, lending to innovations and unique solutions in continuously improving technical business processes and facilitating repeated success.Core Competencies: Database Administration (Backups, Security, Performance Tuning, Query Design, Database Replication), DTS/SSIS, SSRS, Power BI, experience supporting SQL Server 2008/2012/2014/2016/2017/2019/AzurePROFESSIONAL EXPERIENCE(10/2022 Present) Vitas, Mira Mar, FLSQL DBAMonitoring, Maintenance, Security and Deployments of SQL, Azure, Sybase and PeopleSoft SolutionsEmphases on security and encryption and proper use of PII guidelines for health care dataAdministrate security on servers including SSRS and Power BI, supporting 19 statesInvolved in creation and implementation of DataversePassword Vault keeper and update passwords and Azure secrets deploymentsVMware and Linux BackupsAzure Fundamentals Certified with Azure Architect focus(2/2019 10/2022) Health First, Melbourne, FLSQL DeveloperCreates and maintains ETL processesLarge volume data transfers to reporting servers, vendor sftp sites and for data endpoint useEmphases on security and encryption and proper use of PII guidelines for health care dataUse of SSIS, SSRS, Power BI on SQL 2019 /Azure and Informatica (Oracle)Creates and amends all technical documentation using version control IvantiScrum Master Certified(6/2016 4/2018) Comprehensive Health Services, Cape Canaveral, FLSenior Database Administrator (DBA)Performs and coordinates DBA activities on multiple SQL Servers 2000 through 2017Monitors performance, capacity, service levels, and error logs, on approx. 100 serversCreates, monitors, and manages databases and jobs, SQL agent tasks, and packages SQL Profiler, SolarWinds, Idera, Fog LightCreates and maintains backup, restore, and other maintenance plansTake appropriate steps to ensure that:oService packs on databases and applications are testedoUsers access data concurrently, in a form that suits their needsoProvision for data security and recovery controlFull life cycle implementation and support of applicationsAlwaysOn (Availability Groups and Windows Failover Clusters), VM, AWS and Azure Cloud environmentsCreates and amends all technical documentation using version control TFSEnsures requirements of business users are clearly defined and documented, software, code changes and documentation are updated using version control software Visual Source Safe, research and testing has been done on all new applications.Creates immediate, administration and deployments of, SQL Reporting Services, SSIS and SSAS, BI Stack. Also, maintenance and administration of SharePoint 2016Communicates regularly with technical, applications, and operational staff, to ensure database integrity and securityFacilitates Sarbanes-Oxley compliance, SOC II and TSA auditsDocuments Business Requirements, Request for Proposal, Tech Specs, architecture, and data flow including current vs best practices, ROI analysis, Unit tests, and user documentation(11/2015 12/2015) GE Healthcare Division, RemoteDBA/SQL App SupportOnboard customers to a new medical applicationAssist with software upgrade tasksTroubleshoot ETL interfaces to Oracle(07/2015 10/2015) Gibraltar Private Bank and Trust, Tampa, FLDBA/SQL App SupportProduction and Development support security project for Microsoft and Jack Henry productsProvided guidance to users and client groups, application developers, system administrators on storage management, architecture and risk managementInstalled and upgraded servers to 2012 or 2014Performed complex server-class database activities across various platforms/environments (AS400)(07/2013 10/2014) Price Waterhouse Coopers, Tampa, FLDBA/SQL App SupportProduction and Development Tax App Support, SQL 2014Large scale environments, part of several teams within the Tax departmentTroubleshooting issues on SharePoint application sites with emphasis on administrationSSRS, SSIS, ASP.NET, data structure, query analysis, query tuning, data cleanup(07/2013 10/2014) Cofiroute, Anaheim Hills, CASQL DBA/DeveloperProduction and Development DBAAlways on, two nodes production server with a reporting server using heavy Microsoft Replication and SSRSBuilt interfaces with local tolling systems and Department of Motor Vehicles, PowerShell(04/2009 11/2011) Panasonic, Lake Forest, CASQL DBA/DeveloperProduction and Development DBAGlobal support of production approx. 20 SQL server and hundreds of databasesSSRS support of approx. 3000 reports and subscriptionsDeployment of web apps, SQL and Oracle changes in development serversSharePoint, Project server, and Team Foundation server support(01/2009 03/2009) Wolters Kluwer, Santa Ana, CASQL DBA/DeveloperImplementation of new tax software productDevelopment teams worked 24 hours making changes and checking them inManaged database changes and create alter scripts to update schema changes and data changes through testing and onto productionReviewed and tested developers scripts for performanceSQL 2005, DB Pro, Visual Studio Team Suite(09/2009 01/2009) First American, Santa Ana, CASQL DBA/DeveloperRetirement of legacy system; facilitated transformation of existing data into SQL 2008 EnterpriseLarge scale data mapping documentation and development of SSIS package for conversion of dataInstallation and configuration of boxTested continuity between legacy and new applicationManaged quality assurance user testing within the .Net applicationCommunicated with legal department users and accountingCode testing and optimization before dropping into production(06/2009 08/2009) DMS Marketing, Mission Viejo, CASQL DBA/DeveloperImplementation of SQL 2008Designed database and table structures, including normalizationBuilt SSIS packages for the transformation of existing and new dataSSRS ReportingDetailed SSIS documentation provided to data department(02/2004 08/2008) Carl Karcher Enterprises/ Carl's Jr, Anaheim, CASQL DBA/DeveloperFull lifecycle implementation and support of SSAFinancials and Warehouse Management for accounting and multiple distribution centersSupport and development for Hardee's equipment division: Great Plains DBA/SQL 2000/2005Enterprise administration including backups, security, performance tuning, managing DTS/SSIS jobLoftware barcoding, Starship and Maximum Data using a secure environmentSupported SRC demographics and integration to Google Earth mapping softwareResearched field service software integration with Coca-Cola call center and business processesCreated SOX compliance plan across all of IT and accountingBusiness requirements documentation for Carl's Jr Distribution CenterDeveloped .Net Company and Franchise Sales Analysis ToolSQL Report Reporting Services SSRS and SSISSupported and troubleshooting of post implementation objectsConverted/combined Crystal Reports to SSRS Reports, using stored procedures/managed securityUsed Visual Studio and Visual Source Safe for software and documentation version control(2002 2003) Disney/The Disney Stores, Glendale, CASQL Programmer/AnalystProject Tomorrowland: Accounting data conversion AS400 to SAP for International and US storesConversion included inbound and outbound interface with internal customers and outside vendorDesigned MS Access database with SQL 2005 backend for GL reconciliation, and MS Access database for fixed asset conversionExtensive testing within SAPWorked with currency conversion, international taxes, credit card transactions and structuring and automation of budget/forecasting uploadsCompleted tech specs, data flow charts using Visio, user instruction manuals documentation(2002 2003) Disney/ABC Television and Radio, Burbank, CASQL Programmer/AnalystProject Tomorrowland: Accounting data conversion to SAP for 11 stations across the country all using different accounting applications: AS400, JDS, Enterprise, Columbine AV, Mas 90, Great Plains, Access, Open TraverseSQL and stored procedures using MS Access Project 2002 and setting up network connectionsAccounting support to users post implementation(2000 2001) Nissan North America Inc., Compton, CAProgrammer/AnalystDesigned custom applications to automate monthly/annual analysis reports for Parts Product Development Department and Assurance Products, using Oracle, SQL, Focus, VB, SAP, AS400Designed data models and appliedDesigned Core Return Call CenterAudited and validated information, and restructure current Access databasesEDUCATION AND CERTIFICATIONSOrange Coast College 1994-1996Cal State Fullerton -Visual Basic Series - 2004Microsoft Certified MCTSMicrosoft Certified MCITP: DBA - SQL 2005, 2012Microsoft Certificate - Administering a Microsoft SQL Server 2000 DatabaseNew Horizons Learning Certificate - Custom Microsoft SQL Server Reporting Services 2005SSA Global/ Infor Certificate of Warehouse ManagementSRC Certificate - DemographicsNow.com |
