Robert 'Scot' Caraway Email & Phone Number

Charlotte, Nc, Us

Operational DBA on the Teradata platform.

Charlotte, Nc, Us

• Managed DB2 databases for internal client 'Bank of America Direct' client as well as trading applications. • Synced contingency database to production using HADR in DB2. • Worked with both the single node and multi node DPF environments • Created K Shell scripts to automate common tasks such as daily health checks, backups, grooms, DBMS restarts, host backups and statistics. • Built and concurrently managed 23 different Netezza servers for various reporting and risk management trading applications. • Lead DBA on project for appliance relocation. This allowed the bank to save millions of dollars as it sold the center and shrunk its data center foot print. • Refresh large data sets within the bank infrastructure as required by the different application managers. • Performed SQL tuning of slow running queries. • Acted as operating system administrator (OS) for RHEL 5 and 6 in support of Netezza appliance (11 years) • OS security hardening • Software installation and removal • OS upgrading • Manage individual production databases which exceed 20 tb in size. • Created a scheduled process to periodically take incremental backups of production and apply them to the DR server once shipped. • Implemented LDAP on all servers to simplify password management and force passwords to conform to company mandated format. • Performed server hardware assessment to validate hardware as well as determine how hardware is being used. • Performed security patching of Netezza servers on a 60-day cycle. • Created server configuration documents to help database team remediate security vulnerabilities. • Provided guidance to development teams on best database object creation practices. • Provided instruction to new DBA members for onboarding in Netezza. • Decommissioned two Netezza servers as to remove and scrub all bank data and programs before being removed from the datacenter.

Armonk, New York, Ny, Us

• Worked as Point of Contact on World Wide DBA team for upgrading CRM/Siebel system to a new release. • Created K Shell scripts to automate common tasks such as daily health checks, backups, reorgs, statistics and rebinds as well as deployment tasks such as migrating data to a Unicode format. • Restored databases to a specific version and point in time to recover data and build test environments. • Performed SQL tuning for slow running queries. • Assisted with the development and testing of CRM Audit database. • Managed defects during the various phases of testing new CRM releases. • Responsible for physical design and implementation of numerous reporting databases. • Performed maintenance on multiple databases to ensure that backups were being managed and that database performance remained consistent. • Tuned databases for optimal performance and minimal disk usage for systems as large as 300 GB in size. • Set up and monitored DPropR replication for copying changed data in both single and bi-directional environments on DB2 V7 and V8. • Responsible for setup, maintenance, hardware and security of department AIX servers for use as a test environment and code storage. • Performed quarterly security audits on customer databases to insure compliance with corporate security guidelines. • Maintained both online transaction processing (OLTP) and decision support system (DSS or batch) databases. • Built, serviced, and customized personal computers for internal customers.