Anderson Simas Email & Phone Number

London, On, Ca

London, Ontario, Canada

London, Ontario, Canada

- Enterprise data modeling- Implement Data Integration between Azure SQL and Redshift using ADF- Implement Data warehouse on Snowflake

Stratford, On

I was the physical DBA for the corporation.- Managing access- Installing, upgrading, and maintaining databases- Designing the database's physical modelAchievements:- Implement the SQL Geo Cluster, the deployment using Powershell.

London, Ontario, Canada

 Develop and manage client-required changes and improvements to the MS SQL database environment. Build database schemes, tables, procedures, and manage user permissions. Plan, perform, and document software upgrades for the SQL Server environment. Perform SQL Server performance tuning and define backup and restore routines. Implement and configure high availability solutions using MS Failover Cluster SQL Server and Always On Failover Cluster. Implement and configure MS… Show more  Develop and manage client-required changes and improvements to the MS SQL database environment. Build database schemes, tables, procedures, and manage user permissions. Plan, perform, and document software upgrades for the SQL Server environment. Perform SQL Server performance tuning and define backup and restore routines. Implement and configure high availability solutions using MS Failover Cluster SQL Server and Always On Failover Cluster. Implement and configure MS SQL components, including Reporting Services, Integration Services, and Analysis Services. Oversee database replication technologies such as Mirroring, Log Shipping, and Replication. Create shell scripts for task automation and improve operational efficiency. Ensure the proper functioning of storage, backup, and archiving recovery procedures. Manage MS SQL with Policy and Audit Management for compliance and security purposes. Handle systems operations, including Windows Servers (2008 and up), AIX, HPUX, CentOS, and SSAS, SSRS, SSIS administration.Technical Environment: Utilize tools such as MS SQL Management Studio, MS SQL Profile, and MS SQL Analysis and Integration Services. Monitor performance using MS Performance Monitor, Visual, and Office tools. Work with TSQL, ODBC, and ADO for database operations. Manage systems operations on Windows Servers (2008 and up) and administer SSAS, SSRS, SSIS.Achievements:Provided a wide range of SQL Server administration services, including implementation, optimization, migration, and consolidation.Designed and implemented SQL Server high availability solutions to ensure uninterrupted operations.Managed database replication technologies such as Mirroring, Log Shipping, and Replication.Created shell scripts for task automation, improving operational efficiency.Ensured the proper functioning of storage, backup, and archiving recovery procedures in compliance with policy and audit management for MS SQL. Show less

Londres E Região, Canadá

 Database Administrator SQL Server SQL Server performance tuning. Backup and restore routines definition. Server Installs (Microsoft Hyper-V, VMware ESXi) Administration MS Exchange Office 365 Infrastructure Network Implementation and Management Helpdesk Support  Technical Support for Small & Medium Enterprises  Excellent technical knowledge in Network (Switches, Firewall, Router, VPN) & PC and server hardware Implementation and maintenance of… Show more  Database Administrator SQL Server SQL Server performance tuning. Backup and restore routines definition. Server Installs (Microsoft Hyper-V, VMware ESXi) Administration MS Exchange Office 365 Infrastructure Network Implementation and Management Helpdesk Support  Technical Support for Small & Medium Enterprises  Excellent technical knowledge in Network (Switches, Firewall, Router, VPN) & PC and server hardware Implementation and maintenance of VMware ESXi Perform analysis, diagnosis and resolutionTechnical Environment:  MS SQL Management Studio MS SQL Profile MS Performance Monitor Active Directory Manager VSphere Client DNS, DHCP, GPO Active Directory Replication Achievements:Provided a range of IT support, administration, implementation, optimization, migration and consolidation for variety customers. Supporting all IT helpdesk demand of services to customers from various market sectors. Show less

São Paulo, Brazil

Level 3 Database Support Services. Developing and managing the client required changes and improvements Coordination between onsite and offshore team Planning, Performing and Documenting Software upgrades SQL Server performance tuning Backup and restore routines definition High availability implementation and configuration with MS Failover Cluster SQL Server and Always On Failover Cluster. MS SQL implementation and configuration: Reporting Services… Show more Level 3 Database Support Services. Developing and managing the client required changes and improvements Coordination between onsite and offshore team Planning, Performing and Documenting Software upgrades SQL Server performance tuning Backup and restore routines definition High availability implementation and configuration with MS Failover Cluster SQL Server and Always On Failover Cluster. MS SQL implementation and configuration: Reporting Services, Integration Services and Analysis Services. Mirroring, Log Shipping and Replication MS SQL with Policy and Audit Management Maintenance plan, job creation with SQL Agent MS SQL migration and upgrade MS SQL Data Export/Data Import Implementation and Administration of MS Active Director Administration MS Exchange .NET development Report writing environment using SQL Server Data Tools Systems Operations: Windows Servers (2003 to 2012), AIX, HPUX, CentOSAchievements:Sphere IT Solutions is a well-known database focused consulting company in Brazil where I have worked for 5 years. Working for Sphere IT, I had to deal and solve critical database issues. Issues that companies are unable to solve, or even provide support for their team. I have worked to solve problems into our client’s databases. I also provided a range of SQL Server administration, implementation, optimization, migration and consolidation expert services to contract customers from various market sectors: General Electric, Honda Motor Company, Louis Dreyfus Commodities, Bomi Group, Votorantim Group, Abbott Laboratories, Aché Laboratories, Becton Dickinson and Company, Cyrela Brazil Realty, MAC Construtora, Luigi Bertolli, Hospital GRAACC and Hospital Santa Casa de São Paulo, among others.Designed and implemented SQL Server high availability solutions at main market players: Polishop.com.br, Louis Dreyfus Commodities, Honda Motor Company, Bradesco Bank, General Electric Company, ABBOTT, and Aché Lab. Show less

São Paulo, Brazil

Technical Environment: Active Directory Administration Lotus Notes 7.5 configuration and support Lotus Notes 7.5, Active Directory, Windows Server 2003.Achievements:Help desk Support and responded to requests for technical assistance in person, via phone, electronically. Diagnosed and resolved technical hardware and software issues and redirect problems to correct resource. Identified and escalated situations requiring urgent attention, also tracked and routed… Show more Technical Environment: Active Directory Administration Lotus Notes 7.5 configuration and support Lotus Notes 7.5, Active Directory, Windows Server 2003.Achievements:Help desk Support and responded to requests for technical assistance in person, via phone, electronically. Diagnosed and resolved technical hardware and software issues and redirect problems to correct resource. Identified and escalated situations requiring urgent attention, also tracked and routed problems and requests and document resolutions. Kept current with system information, changes and updates. Show less

São Paulo, Brazil

Technical Environment: Active Directory Administration Lotus Notes 7.5 configuration and support Lotus Notes 7.5, Active Directory, Windows Server 2003.Achievements:Help desk Support and responded to requests for technical assistance in person, via phone, electronically. Diagnosed and resolved technical hardware and software issues and redirect problems to correct resource. Identified and escalated situations requiring urgent attention, also tracked and routed… Show more Technical Environment: Active Directory Administration Lotus Notes 7.5 configuration and support Lotus Notes 7.5, Active Directory, Windows Server 2003.Achievements:Help desk Support and responded to requests for technical assistance in person, via phone, electronically. Diagnosed and resolved technical hardware and software issues and redirect problems to correct resource. Identified and escalated situations requiring urgent attention, also tracked and routed problems and requests and document resolutions. Kept current with system information, changes and updates. Show less

Management Information System

Apprentice High School, Computer Technician