Teacher | Database Administrator

• Oct 1984 - Present

• Manages IFES’ corporate SQL Servers (versions 2000-2014) on both physical and virtual (VMware) environments;• Assists in the management of IFES’ corporate datacenter infrastructure, that includes EMC VNX Storage, HP Storage and servers and VMWare ESX virtualization;• Teaches technical, undergraduate and graduate classes on Database Management, Data Modeling, Object Oriented Programming, Computer Architecture, Operating Systems, and Algorithms / Data Structures classes, which are part of the Electrotechnical and Electrical Engineering curriculums;• Mentors Electric Engineering undergraduate students on the development of Arduino, Windows desktop, cloud-based and mobile applications;• Develops operating research (OR) solutions for efficient placement of resources, such as electric vehicle charging stations, utilizing metaheuristics, linear/integer programming and C#. Show less

Teacher | Database and Network Administrator | IT Manager | Software Developer

• Oct 1984 - Mar 2003

Database Administrator• Managed corporate SQL Servers. Responsibilities included hardware and operating system installation, SQL Server installation and configuration, performance monitoring and tuning, proactive management, security configuration, backup automation and replication.• Reviewed and redesigned a variety of SQL Server corporate databases, increasing their reliability and performance. Enhancements included elimination of redundancies, replication, denormalization, RAID configuration, data replication, query optimization and physical relocation of database files. IT Manager• Managed IFES’ IT department, from 1999 to 2002. • Reengineered and expanded IFES’ computing infrastructure.• Specified, contracted and supervised the external development of an ERP Academic Information System.• Designed and implemented IFES’ corporate Intranet.• Managed the migration of IFES’ corporate Win32 applications to web-based applications.• Introduced remote management and support technologies.Teacher• Assisted in the development of IFES’ first Computing Technical course.• Taught Database Administration, data modeling and computer programming technical courses.Software developer• Developed T-SQL scripts for a variety of Information Systems.• Trained developers on T-SQL programming best practices.• Participated in the analysis and development of different information systems, including academic, inventory, help-desk, human resources, and library information systems.• Developed a variety of client-server applications, utilizing Delphi, Access, VBA and SQL Server.IT Infrastructure Administrator• Managed IFES Windows Server based LAN and WAN network. Responsibilities included: Hardware installation and configuration, Operating System installation, RAID Configuration, Backup and Restore execution, 3COM Routers configuration, MS Exchange administration, creation of corporate IT policies, DNS, RRAS, VPN, WINS and DHCP management and configuration. Show less

SQL Server Consultant

• Oct 2012 - Jun 2016

• Installed, configured and managed cloud-based SQL Servers hosted at Softlayer.com; • Troubleshot performance issues at OS, SQL Server and T-SQL code levels; • Optimized dynamic T-SQL and Stored procedures having performance issues. • Installed, configured and managed cloud-based SQL Servers hosted at Softlayer.com; • Troubleshot performance issues at OS, SQL Server and T-SQL code levels; • Optimized dynamic T-SQL and Stored procedures having performance issues.

Senior Database Administrator

• Apr 2008 - Apr 2012

• Managed high-end clustered SQL 2005/2008 servers that supported Asure software Workforce Management SaaS multi-tenant application, accessed by more 200,000 users from more than 3,000 client companies and performing more than 200,000 SQL transactions per minute. • Managed clustered SQL 2005/2008 servers that supported Asure Software SaaS multi-tenant resource scheduling application, comprised of more than 1,200 user databases and about 300 client companies. • Planned and implemented the upgrade/migration of development, production and QA SQL 2005 servers to version 2008, in a variety of configurations of hardware and software that includes MS clustering, EMC fiber SAN and DELL SCSI and iSCSI storage. • Managed, installed, expanded and configured servers, storage and backup hardware. • Designed and implemented server and database disaster-recovery strategies for all database servers. Also developed SQL Server utilities to support these strategies. • Designed and implemented an automated multi-stage database backup strategy for all database servers. • Fully automated SQL databases maintenance. • Developed basic SSIS and DTS packages. • Developed a complete database scripting and ETL tool, in Transact-SQL language. • Managed all corporate database metadata changes, utilizing Red-Gate SQL Compare and CA Erwin data modeler. • Developed and optimized T-SQL stored procedures, triggers and user-defined functions used in mission critical applications, which were required to be highly efficient and scalable. • Created, standardized and documented database administration procedures, including disaster recovery and contingency plans. Show less

SQL Server and IBM DB/2 DBA - Database Administrator

• Oct 2006 - Jan 2008

• Managed a complex and diversified SQL 2000/2005 environment comprised of 100+ SQL Servers, geographically dispersed across Harley-Davidson’s facilities, in six States. • Automated H-D SQL Server backups to IBM´s Tivoli Store Manager servers, providing a standardized approach for backing databases throughout the organization.• Optimized a variety of high-end dedicated SQL Servers serving H-D public web and dealer sites, PeopleSoft, real-time monitoring, and others. • Moved the majority of H-D development and QA SQL Servers to run on the HP-Polyserve Matrix virtualization environment, in order to provide High-Availability, and instance virtualization. • Developed a fully automated restore and disaster-recovery application, utilizing SQL Server and IBM TSM technology in QA data-refreshing operations and DR simulations.• Migrated H-D’s SQL Servers, which supported their public websites, from a third party Datacenter to H-D’s Datacenter. Developed and documented procedures to backup, compress and restore databases that were used to migrate hundreds of databases.• Consolidated a large number of older departmental and corporate SQL 2000 Servers into fewer and more powerful SQL Servers, utilizing HP-Polyserve Matrix Server. • Supported heterogeneous replication to and from SQL Server and IBM AS/400 systems, utilizing a combination of IBM´s DataMirror and SQL Server replication technologies. • Established guidelines and best practices for efficient, reliable and maintainable SQL coding.• Trained SQL developers on coding for better performance, error handling and ease of maintenance. • Managed, at basic level, IBM DB/2 database servers and databases.• Developed data migration utilities to convert databases from MS SQL Server to IBM DB/2.• Responsible for supporting and implementing SQL Server 2005 database and technologies on many businesses critical projects, including datacenter consolidation, H-D´s Museum ticket sales, disaster recovery and others. Show less

SQL DBA

• 2006 - 2008

SQL Server Administrator

• Jan 2004 - Oct 2006

• Managed high-end clustered SQL 2005 servers that supported iEmployee’s Workforce Management SaaS multi-tenant application, accessed by more 200,000 users from more than 3,000 client companies and performing more than 200,000 SQL transactions per minute. • Dramatically reduced iEmployee’s web site timeouts related to poor SQL Server performance, during peak utilization periods (7500+ concurrent users and 200,000+ transactions per minute). • Designed and implemented server and database disaster-recovery strategies for iEmployee database servers. Also developed SQL Server utilities to support these strategies. • Designed and implemented an automated multi-stage database backup strategy for all database servers. • Fully automated SQL databases maintenance. • Designed and implemented a high availability and failover strategy for all non-clustered production SQL Servers, utilizing Microsoft Log-Shipping technology. • Established transactional replication of main databases to reporting databases, for utilization by SQL Server • Managed all corporate database metadata changes, utilizing Red-Gate SQL Compare and CA Erwin data modeler. • Created T-SQL coding corporate standards and trained developers in best practices regarding T-SQL coding and optimization. Also helped developers on daily T-SQL programming activities. • Developed and optimized T-SQL stored procedures, triggers and user-defined functions used in mission critical applications, which were required to be highly efficient and scalable. • Created, standardized and documented database administration procedures, including disaster recovery and contingency plans. • Assisted the IT department in establishing policies to increase security of web and database servers. • Assisted in the administration of company’s Internet Web farm comprised of Windows 2003 Advanced Servers utilizing Microsoft Application Center 2000 and NLB (Network Load Balancing). Show less

INFORMATION TECHNOLOGY CONSULTANT

• 1996 - 2003

- Provided SQL Server, Delphi and Windows NT consulting for Microsoft Partners and major Brazilian corporations. - Designed and implemented SQL Server installations from ground zero. - Provided emergency support in recovering Terabyte class SQL Server SAP databases. - Secured SQL Servers for different corporations including Brazilian government financial organizations. - Provided SQL Server and Windows NT Microsoft Official Curriculum (MOC) Training for various corporations that includes Xerox corp. - Trained developers and database administrators on T-SQL programming, query optimization and SQL Server -Delphi integration. - Represented TVI, a well-known Brazilian Microsoft Partner, at 98 MGS (Microsoft Global Summit) in New Orleans, which gathered Microsoft Engineers from all over the world. - Managed TVI’s technical support and development departments. - Designed Alternativo’s College technological undergraduate computing course. Show less