Post Job Free

Resume

Sign in

sql dba

Location:
Gilbert, AZ, 85297
Posted:
April 11, 2023

Contact this candidate

Resume:

Robert L. Calgaro

• Home: 480-***-****/ CELL 480-***-****

• adwhla@r.postjobfree.com

Gilbert, AZ

PROFESSIONAL SUMMARY

Over 20 years of IT experience which includes technical leadership, project management, database administration, on call operation support, design, tuning, client interaction, testing and implementation of application software using, HP EVE SAN, MS SQL, WINDOWS and OpenVMS platforms.

Skills Summary:

SQL SERVER (2005, 2008 R2, 2012, 2014, 2016, 2017, 2019)

SQL Tools: Replication, Log Shipping

Systems: Windows 2000/2003/2008/2017

Networking: DNS, Active Directory, TCPIP

Business Skills: Solution Development, Client Interaction, Project Management, Database and Maintenance.

Infoarmor, - Scottsdale, AZ

March 2020 – June 2021

Working with SQL Administration, Monitoring, Database Backup, Recovery, Patches and Installs.

maintaining and managing MS SQL Server databases with 2016, 2017, 2019

Trouble shoot issues and Implement new databases

Move development into production and fresh development when requested.

Move Production to development after PII data has been scrubbed.

Monitors and tunes databases for optimal performance.

Wells Fargo, - Chandler, AZ

Aug 2018 till March 2020

Working with SQL Administration, Monitoring, Database Backup, Recovery and Installs.

maintaining and managing MS SQL Server databases with 2008 R2, 2014, 2016

Trouble shoot issues and Implement new databases

Performing integrations, migrations and quality checks that ensure a quality product is delivered from an operations/support perspective.

Move development into production and fresh development when requested.

Monitors and tunes databases for optimal performance.

Works with end users for database query design and support

IO Data Center -Scottsdale, AZ

(as of Dec 12 now known as Iron Mountain Data Center), July 2017- May 2018 - SQL DBA

Working with SQL Administration, Monitoring, Database Backup, Recovery and Installs.

maintaining and managing MS SQL Server databases with 2008 R2, 2014, 2016

Trouble shoot issues and Implement new databases

Performing integrations, migrations and quality checks that ensure a quality product is delivered from an operations/support perspective.

Support Replication and Bring new modules and sensor online.

Monitors and tunes databases for optimal performance.

Works with end users for database query design and support

Plain Green LLC, - Scottsdale, AZ

March 2017 - June 2017 - SQL DBA Consultant

Working with SQL Administration, Monitoring, Database Backup and Recovery.

maintaining and managing MS SQL Server databases with 2014, 2016

Trouble shoot issues and restore a stable environment

Performing SSIS file/catalog deployments.

Support Replication and bring Production which in the cloud into the company’s local domain.

Early Warning. - Scottsdale, AZ

Nov 2016 – March 2017 - Oracle/SQL Consultant

Working with Oracle Administration, Monitoring, Database Backup and Recovery.

maintaining and managing MS SQL Server databases with 2008 R2, 2014

Implementation and Administration of High Availability solutions with Oracle and SQL.

Intel Corp., Chandler, AZ

April 2010 to June 2016 - SQL/Oracle DBA

MSSQL

Experience in maintaining and managing MS SQL Server databases.

Troubleshoot day to day issues in high-volume/time critical production service environments.

Experience in leading Escalation Manager Role that facilitates the process of analyzing and resolving an incident.

Participated in support efforts between Enterprise IT Operations and other support teams.

Participated in the resolution of technical issues within the IT Team

Experience in Leading the effort of Event Management, Incident Management and Problem Management.

On call (Level 2) support for over 1000 databases across the sites

Experience in exceptional customer service to end users, Business Stakeholders and other members of IT.

Perform daily production support activities

Participated in team on-call rotations.

Perform patching and code deployments across all environments.

Experience in minor projects associated to the enhancement, upgrade/patching, or implementation of new or existing technology solutions.

Participates in support efforts between Enterprise IT Operations and other support teams.

Initiate change management requests and adhere to the IT CM process.

Performed source code/versioning management function adhering to technical management guidelines.

Experience in the resolution of technical issues within the IT Operations Team

Conduct performance tuning and troubleshooting.

Maintain a comprehensive monitoring and alerting process across all IT Operations platforms.

Strong analytical and troubleshooting skills

Excellent planning and organizational skills

Intel Corp., July 2000 to April 2010

VMS/Windows Infrastructure Engineer

Responsibilities:

As a member of the IS ATM Infrastructure Hub supporting VMS and Window systems in a world wide enterprise environment. Provides 24x365 supports for HW/SW installations in the ATM Infrastructure Hub. Delivers crisis management, problem troubleshooting, event post mortems, and data collection/reporting. Develops and documents BKMs for preventive maintenance, site personnel training, Hub internal processes, and Copy Exactly. Troubleshoots complex systems in a heterogeneous environment of VMS, and Windows systems. Identifies improvements for all of Intel's leading edge factory systems. Collaborates with engineering, manufacturing, and production control to leverage automation capabilities to solve complex manufacturing problems. Manages automation groups worldwide to define and maintain configuration standards. Utilizes and configures HP EVA SAN Storage for Windows servers. Notable projects include:

OPENVMS

•Upgraded Pathworks from 5.x to 7.3a. Pathworks is used mainly as a file server and testing applications that use windows with files from the VMS environment.

•Developed the BCP plan for the ATM IS infrastructure HUB, interfacing PBX to track site downtime and temporarily transfer customer calls to a different call center.

•Updated VMS at all of the ATM world sites (CR, PD, CD, CV, US and KM) to VMS 7.3-2 from 7.2-1. Configured firmware on HSG80s brocade switches to 3.1.3 and console firmware to 6.8-13.

•Managed the replacement of 2 VAX 4100s with 2 VAX 7000s, completing transitions from DSSI to SCSI.

•Championed efforts to move from SLS to Veritas as a backup solution for VMS with either NetApps files server or windows media server.

Windows 2003/2008/2012

•Lead projects, planning and executing activities to install many NLBS and MS clusters using shared drives from the SAN configured shares on the HP EVA for each database server.

•Directed the OSC SAN monitoring project for ACT SAN Islands. Modified brocade switches to send SNMP traps to the OSC for monitoring. Installed and configured the MS plug-ins for the SAN Admin servers that are monitoring the HSG80 controllers and disks.

•Oversaw the Norton Antivirus 7.51 and upgrade of IT monitoring package for 170 servers. Piloted the new NAV versions and the monitoring package upgrades on ACT development servers in collaboration with the OSC and customers to plan down time for ACT production servers. Established permissions on production servers and down loaded the NAV kits to each server.

•Coordinated physical layout of the SAN database and modified the layout from 18 to 9 logical drives with a hot spare. Tested and turned over disk drive configuration to application users.

•Added an OU to the ACT active directory structure and defined delegates that had permission to use this OU. This OU is used to add computers and users to a specific group on the network with is own default security. (GOPs)

•Appointed as a SAN administrator, managing 18 HP 5000/8000 EVA-SAN with over 500 Window 2000/2003 servers in different countries. Implemented and upgraded the IESS suite of tools on the SAN appliances that these EVAs are attached to.



Contact this candidate