Tom Crider Email & Phone Number

- Managed up to 13 IT professionals as Tech Lead in support of US Army property book system.- Oversaw, planned and implemented Oracle quarterly patches on Oracle Solaris Super Cluster to include Solaris OS, Solaris ZFS appliances, Infiniband, Exadata, Oracle database and Java.- Remotely managed team members as well as supporting production and development environments for Oracle databases, Solaris ZFS appliances, Oracle Exadata machines and Oracle Solaris ZFS appliances.- Led project planning for upgrading databases from 10G to 11.2.0.3 while migrating from Solaris 10 to Solaris 11 on Oracle Super Cluster and Exadata engineered systems. - Installed and configured Enterprise Manager 11g, Cloud Control 12c and 13c.- Installed and configured Oracle 11g and 12c databases running on remote ZFS appliances as well as Exadata machines.- Configured Oracle Advanced Security options to include TDE (transparent data encryption), AES-256 encryption and MD5 checksum for network connections.- Created and managed physical standby databases using Data Guard maintaining an average of 4 minutes of lag across 1,700 mile data path.- Wrote Bash shell scripts to monitor file systems, databases, standby and Enterprise Manager systems in order to alert remote DBA for potential issues.- Created Bash shell script to monitor memory usage on six Tomcat 6 zones, restarting the Tomcat service when memory limits are reached, but ensuring at least 3 zones are up at all times. - Secured OS, Oracle database, Tomcat and Apache environments in accordance with DOD STIG standards, auditing and security compliance requirements.

- Serving as the S6, staff signal officer, providing guidance and implementation of all signal related equipment in support of Battalion operations.- Successfully planned and implemented communications technology to include satellite, HF Motorola radios and management of remote Wi-Fi networks in support of Baton Rouge area flooding in August 2016.- Managed up to 48 personnel in training as well as disaster response environments.Officer in charge (OIC) of Division level IT help desk operations serving a user base of over 2,000 personnel. - Managed teams of personnel with varying technical backgrounds to include Cisco Network Administrators, Windows desktop support, STT (satellite transportable terminal) technicians, JNN (Joint Network Node) LAN/WAN technicians and Windows Server administrators for applications including Microsoft Exchange and Microsoft Share Point.- Received over 680 hours of training on management and usage of advanced technology communications equipment to include Cisco routers/switches, Security+, Network+, telephony switches, satellite, VOIP and network management.- Graduated 4th out of 78 officers in Signal Officer Basic Course, which included Security+, CCNA, Network+ and other technology training.- Maintained accountability of over $30 million dollars in technology equipment.

Austin, Tx, Us

- Installed, managed and tuned Oracle 10g and 11g databases. Installed and configured MySQL versions 5.1 and 5.5.- Tuned report queries and application queries providing performance gains up to 150 times faster than previous runs. Tuned application SQL decreasing production CPU usage by 50%.- Implemented multiple levels of monitoring ensuring notifications allow for proactive responses to issues and problems.- Managed all databases remotely via secure shell connections.- Tuned SGA increasing performance to include 99% buffer hit ratios and 95% library cache hit ratio.- Created standby database architecture working around the fact that standard edition Oracle does not allow for standby and Data Guard configurations. - Wrote shell scripts to automate the monthly FTP data deposits with Iron Mountain.- Oversaw the backup and restoration process for MySQL databases, including replicating data from production to development databases.- Created processes for promoting Oracle and MySQL code from development to QA to UAT and then to production.- Created disaster recovery documentation from scratch.

Dallas, Tx, Us

- Remotely managed up to 15 production, standby, development and QA databases located in multiple data centers across the United States. Monitored databases 24/7 for issues and problems which could impact end customer experience.- Tuned report queries and application queries providing up performance gains up to 130 times faster than previous runs. Tuned application SQL decreasing production CPU usage by 50%.- Created a monitoring application using stored procedures, Perl and Shell scripts to monitor database activity, space usage, stand-by database and operating system level issues.- Upgraded 7 development and QA databases as well as production environment to 9.2.0.8 from 9.2.0.4 and to 10gR2 from 9.2.0.8. Completed upgrades from 10.2.0.4 to 11.2.0.1. All upgrades were completed with minimal down time and no major post upgrade issues.- Oversaw all aspects of daily operations of 24/7 Oracle database in support of international Wi-Fi connectivity for largest provider of Wi-Fi worldwide.- Implemented new flash process decreasing restore times for development databases from 12 hours to less than an hour.- Installed and configured Oracle Enterprise Manager 10g and Grid Control- Designed and implemented multiple RAC environments up to 5 nodes per cluster and on both 10g and 11g CRS.- Oversaw and planned the migrations from 9i on Solaris to 11.2.0.3 on Red Hat staying within planned maintenance windows. Planned and executed the migration of production databases to new data centers.- Received multiple employee recognition awards to include 3 quarterly and Employee of the Year award while serving as Senior Oracle DBA.- Continued on as contractor and advisor for 8 months to ensure system stability and availability after moving to new employment opportunity.

- Managed 20 databases up to 350GB in size, to include 3 Oracle 9i RAC instances running on Sun E-10K servers and implementation of 10g RAC for Oracle Financials.- Installed and supported Oracle databases from version 8.1.7 to 10g on various platforms, including Solaris, Linux and Windows 2000.- Implemented and configured Oracle Cluster File System (OCFS) and Oracle Cluster Ready Services (OCRS) and Automatic Storage Management (ASM) for 10g RAC on Solaris, Linux and Windows operating systems.- Configured services and listeners in support of client-side and server-side fault-tolerance and load balancing.- Migrated database files from UFS to ASM in support of upgrades to Oracle 10g.- Tuned RAC database specific wait and enqueue events reducing OLTP application response time and speeding up processing of nightly batch.- Designed and implemented Oracle replication technology allowing cross database data replication and reporting.- Tested and verified the integrity of database backups on a regular basis. Recovered Oracle databases using RMAN to accommodate developer requests and testing.

Austin, Tx, Us

- Installed and implemented Oracle 9i with Oracle Data Guard configuration. Upgraded 8.1.6 databases to 9i.- Configured RMAN backups to run off of standby databases removing the backup load from running on production systems.- Tuned Oracle SQL cutting query times from over 1 hour to under 25 seconds.- Configured Oracle Enterprise Manager to allow management of Oracle 9i databases and real-time monitoring of database and performance. - Installed and configured Red Hat Advanced Server 2.1 in support of production Oracle databases and Java 1.4x application servers. - Configured and maintained production and corporate backups using Syncsort Backup Exec.- Recovered over 300GB of data from corrupted Red Hat installation, preventing nearly 2 weeks of downtime.- Wrote Perl scripts reducing Apache log filtering from 8 hours to 10 minutes.

Managed production data center operations. Negotiated data center services provided by Inflow and other service providers providing up to 50% savings allowing better use of funds. - Implemented and configured Big Brother monitoring application to track and trend system utilization and SLA response times. - Migrated production databases from Oracle 8.1.6 to 8.1.7.3. - Managed all aspects of production databases, to include performance tuning, SQL tuning, backup and recovery, writing PL/SQL procedures. - Used trending data to ensure capacity and performance based upon planned sales goals and signed contracts. Ensured quick response to hardware problems or application response time issues. - Created disaster recovery plan based upon customer SLA’s and recovery guidelines. - Designed production change control procedures requiring documentation of changes made to production environment, including disaster recovery and back-out procedures for all changes applied to the production environment. - Installed and administered Windows 2000, 2000 Professional Server, Windows XP, Microsoft Exchange 5.5, Red Hat Linux 7.x and Solaris 2.x.- Compiled, installed, and configured Bind 9.2, Sendmail 8.12.5, Apache 1.3.26, Mod-SSL 2.8.9, OpenSSL 0.9e, Apache Tomcat Jakarta 4.0.1 as well as other Unix based applications required to support data center operations. Installed and administered Oracle 8.1.x and 9. - Redesigned corporate network implementing a firewall hardware solution moving all internal PC’s to private non-routable IP’s. Configured and administered Cisco 1600, 1700, and 2500 series routers, as well as Cisco 2950 series switches.

- Installed and supported Oracle databases from version 7.3.3 to 9i on various platforms, including Solaris 2.x, Digital Unix 4.0x, AIX 4.3.3, Linux, Windows NT 4.0, and Windows 2000. - Managed up to 15 databases to include 6 production databases and 9 test/QA databases. - Redesigned the physical data model of a 300GB production database increasing overall performance by 20 – 30 percent, taking into account an application running a mixture of OLTP and OLAP queries, long-term manageability, and an extensive growth of 20,000 end users per month. - Created views and materialized views decreasing user induced load on the system, fulfilling reporting requirements, and at the same time decreasing the time required to run the reports by as much as 300%. - Tuned production and development databases consisting of approximately 12 TB’s of raw data, using a combination of OS level tuning tools and database level tuning scripts and applications. - Wrote scripts to automate database administration. - Defined and implemented effective automated backup and recovery strategies for 6 production databases using RMAN, Oracle export, and hot backups as appropriate. - Tested and verified the integrity of database backups on a regular basis. Recovered Oracle databases to include disaster recovery, block corruption, production and development database replication, and point in time production recovery due to user error. - Installed, configured, and administered various flavors of Unix in support of a quickly growing E-commerce business to business environment.