Allan Wilson Email & Phone Number

Loveland, Co, Us

Continuing to support Pandora and SiriusXM for data infrastructure on-prem and in the cloud.Engineering for data platform deployments and administration.Mentoring for other engineers in this space.

• Deployment of multi-region CockroachDB in GCP on GKE and on-prem on Nomad leveraging Consul and Envoy.• Conducted several POCs on CockroachDB with synthetic workloads and assisting development teams.• Kafka administration of several clusters.• Leverage Ansible, Terraform, and GCP Load Balancers for Confluent Kafka in GCP.• Deployment of Confluent Kafka Multi-Region Cluster in GCP. Currently working on a migration plan to move from Apache Kafka.• Provided architecture design and tooling to migrate Pandora Media’s analytics and data science platforms to Google Cloud Platform (GCP).• Worked across SYSAD, NETOPS, SECOPS, Developers, Analytics, and Scientists to make sure the Cloud env met the needs for Pandora’s analytics and science platform.• Collaborated on network setup (VPCs, Interconnects) in GCP and routing of GCP API's over the interconnect to/from GCP.• Collaborated on technical roadmap development for Pandora's Data Platform• Led small team of Platform Engineers• Applied tuning to Dataproc clusters learned from on-prem experience for MR, Hive, Tez, and Spark via initialization scripts.• Created tooling in Python that leverages GCP and GSuite API’s• GCP cost optimization, quota mgmt, and budgets• Leveraged Terraform for GCP project creation and infrastructure.• Deployed and maintain Nexus Proxies in GCP• Migrated over 7PB of data from on-prem HDFS cluster to GCS Buckets.• Setup of shared Hive Metastore in GCP• Scaled production Hadoop cluster from 200 nodes to over 2700 nodes supporting a wide range of workloads such as Kafka Producers, direct log transfers to HDFS, MR, Spark workloads, Hive Queries (MR and Tez execution engines), and the integration of Presto DB.• Addressed scaling issues for YARN and HDFS as needed• Assisted users with performance issues in Hive• Automated deployment of Hadoop using Ansible playbooks• Migrated Hadoop cluster (~3.5PB of actual data, no replicas) to new Colo (on-prem)

Atlanta, Ga, Us

3-Month Contract at Dell SecureWorks through DISYS.- Installation and upgrade of Cloudera Hadoop (CDH) and Cloudera Manager (CM)--HDFS--MapReduce--HBase- Capacity Planning- Cluster Expansions- Performance analysis, profiling, and reporting.- MySQL upgrades and administration for Hadoop Platform- Write and maintain Chef Cookbooks- Maintain Crowbar Barclamps

DBGT AS - Risk Domain- Oracle Engineering for the RPL ODS- Physical database design- Performance tuning, benchmarking, profiling- Oracle RAC 11gR2 on Oracle Exadata- Troubleshooting- ConsultationPreviously at Deutsche BankDBGT AS - Data Domain- Hadoop Platform engineering- HBase validation in lab- Oracle performance tuning and trouble shooting for Data Warehouses and Operational Data Storeswithin the bank.

San Jose, California, Us

Focused on bench-marking, validating, documenting, and spreading the word about NetApp storage solutions for Databases and HPC Solutions.

San Jose, Ca, Us

Worked on the creation of Cisco Validated Designs (CVD) for Oracle E-Business on baremetal FlexPod. Designed and implemented the entire environment for the Oracle E-Business FlexPod environment which consisted of Cisco UCS Servers, Cisco Nexus switches, NetApp Storage, Cisco Load Balancing for the Apps Tier, and Oracle 11gR2 RAC with Oracle R12.1 E-Business Suite.

Raleigh, North Carolina, Us

Sr. Oracle DBA for the Collection Engine team at Itron.--Assist with performance scale-out of the application in Oracle single instance and RAC--Administer SCALE performance environments (Oracle 10gR2 single instance and RAC)--Maintain Database Update scripts for the OpenWay Collection Engine product--PL/SQL coding--Support customers with performance issues and problems with the maintainence jobs.--Maintain data dictionary for Collection Engine Schema--Assist developers with design, SQL, and PL/SQL coding

San Jose, California, Us

Oracle DB Performance Engineer.Tested Oracle single-instance and Oracle RAC performance with NetApp storage using various protocols (NFS, iSCSI, FC).Worked with Engineers to improve DATA Ontap. Worked with DATA Ontap 8 Cluster Mode to improve performance with Oracle.

Worked with Baytree Consulting to setup a new Oracle EBS env at Motricity for our Bell Mobility customer in Canada.Converted an Oracle 11.5.10 env to Oracle 10g RAC and implemented Parallel Concurrent Processing.Patched and cloned Oracle 11i environments as needed.Collected and analyzed stats from a 6-node 10g RAC cluster that now serves as the DB backend for Cingular's MEDIA Mall and Internet purchasing of applications and ring tones.Made SQL tuning recommendations and implemented hash partitioning to reduce Global Cache waits due to concurrent inserts/updates of tables in the DB.Added 6th RAC Node to the Cingular Oracle RAC Cluster.Installed Oracle Grid Control and configured to monitor the RAC Clusters.Installed and Configured Grid Control plug-in for Oracle Applications.Created scripts for Oracle DB backups.Implemented DB changes as needed for Cingular 3.0.Worked several cutover windows to move Cingular to our new Fuel Platform.Assisted the Back Office team with ETL performance problems.

Morrisville, Nc, Us

Estimated and provide justifications for annual budget for the DBA group.Negotiated software license and support costs.Specified and purchased new hardware for development, test, and production Data warehouse and E-Business envs.Performed OS Administration as needed (create logical volumes, create file systems, install packages/patches, etc)Architected new Oracle 11i production environment using Oracle RAC 10g and using a different storage technology from LSI Engenio (IBM DS4800) to improve performance and increase up time.Performed the upgrade of Oracle Applications 11.5.8 to 11.5.10.2 in production.Produced clones of Oracle Apps production for development and test environments.Deployed a new 11.5.10 Application Server in the DMZ to be used by Technical Service Partners, End Users, and Suppliers.Deployed a new Application Server dedicated for Oracle Configurator in production.Migrated Oracle Applications production DB to a larger Sun Server.Applied numerous patches to all envs for Oracle Applications.Setup new printers for Oracle Applications.DB Performance monitoring and tuning.Wrote database backup scripts utilizing the NetApp snapshot functionality.Gathered information for SOX auditors.Currently working on designing and deploying a new infrastructure for Oracle Applications.Hardware selection for Servers and SAN.SQL Server DB administration for internally developed applications. Production environment was a 2-Node MS Windows cluster. SQL 2000 and SQL2005 was used.Assisted with Cognos administration (Decision Stream, Cognos Report Net).

Cary, Nc, Us

Development DBAWorked with Sterling Software on improving and stabilizing performance of their Gentran Information Server.Implemented Data Mirror's Transformation Server for transactional replication from Oracle to a remote SQL Server DBWrote Perl script to monitor data replication.Performed logical and physical data modeling using ER StudioPerformed data migration from SQL Server to OracleWrote complex SQL statements and tuned them for performance.Wrote PL/SQL stored procedures, packages, functions, and triggers.Troubleshot problems with applications getting errors accessing the database. DB change controlMaintained a 1 TB data warehouse that stores train car wheel detector events.Automated replication of IRF data from Mainframe DB/2 to Oracle Implemented Oracle production DBs in Veritas ClusterImplemented Oracle RMAN backupsUpgraded DBs from 9i and 10gOracle Applications DBAInstalled an Oracle Applications 11.5.2Upgraded Oracle Applications 11.5.2 to 11.5.3 also applied many one-off patches and family packs.Performed cloning for testing.Maintained Oracle Applications 11i in a production environment.Resolved order import problems with Oracle's Order Import batch interface.Implemented Oracle Enterprise Manager for DB Monitoring. Also used Oracle's Statspack for performance trending.Performed database maintenance such as table reorganizations, index rebuilds, keeping statistics current, and addition/deletion of range partitions.Wrote shell and Perl scripts to automate most DB maintenance tasks. MS SQL Server DBAMaintained a single production database that houses data for a Shortline Railroad car movement/inventory system.Developed backup/recovery plan for Production SQL Server database.Implemented SQL Server maintenance plans.Maintained development SQL Server databases, performed data refreshes, user management, client installs, etc.

Worked on-site at the Information Systems HQ for the U.S. Postal Service under contract from Oracle Support Services to recommend, test, bundle (re-package), and deploy Oracle software across their entire enterprise.Assisted with problems dealing with the Oracle Forms and Reports server products for the U.S. Postal Services Assisted with developing new Oracle backup plans using RMAN and Veritas NetBackup.Worked with the U.S. Postal Service's development and application deployment groups to either upgrade or patch Oracle software to ensure Y2K compliance.; Oracle & MS SQL Server DBA Consultant

On-site at Dow AgroSciencesAdministered Oracle 7.1, 7.3.4 Oracle databases on OpenVMS and Windows NT 4.0 servers. Installed, upgraded, administered Oracle 8.0.5 databases on Windows NT 4.0 and Solaris 2.5.; Performed Oracle user administration using roles for all developer and end-user accounts.Tuned the Oracle databases on OpenVMS, Windows NT 4.0, and Solaris to increase performance. Tuning was achieved through the use of explain plans for SQL statements, SQL Tracing and TKPROF utility, BEGIN and END Stat scripts supplied by Oracle, and using the dynamic V$ views.Implemented and maintained Oracle database backups using ArcServ on the Windows NT 4.0 platform.Implemented BMC Patrol to monitor the Oracle databases, customized alert parameters, and setup notification via emails for critical problems.Installs and upgrades of Oracle Application Server (OAS). Administered and applied changes to OAS.On-call for Oracle problems.On-Site at New Court FinancialUpgraded SQL Server 6.0 to 6.5.Performance tuned their SQL Server 6.5 database server.Designed and implemented a hot standby SQL Server database by applying transaction log dumps to the standby database on an hourly basis. Wrote Transact SQL procedures using remote procedure calls to have the standby database apply the transaction log dumps from disk over a shared network drive.

Los Angeles, Us

Installed and upgraded Oracle databases on Windows NT 4.0, HP UX, and IBM AIX platforms. Worked with Oracle 7.3 databases.Implemented backups using BMC SQLBackup (Oracle exports straight to a tape device to avoid the AIX file size limitation)Wrote and maintained capacity management reports.Assisted in testing backup and recovery procedures in an Oracle Parallel Server environment.Wrote COBOL programs to extract data from VSAM data sets to be loaded in their data warehouse.Tuned SQL queries for the data warehouse team.Wrote summary table loads in PL/SQL for the data warehouse team.On-call for Oracle problems.USA Group, Fishers IN

Supported Sybase Rel. 10 and 11 databases.Migrated development and production applications from Sybase Rel. 10 to Rel. 11.Wrote and maintained capacity management reports for Sybase.Participated in data modeling meetings of new applications. Diagrams were maintained in Erwin. Schemas were sometimes generated using this tool.Supported IDMS Rel. 10.13 and Rel. 12.01 databases on MVS.Assisted in the upgrade of all enterprise applications from IDMS Rel. 10.13 to Rel. 12.01.Implemented and maintained approx 150 development and test databases for their Eagle II project.Supplied JCL and utilities to developers to preserve their test database data across database changes.Helped monitor and tune the IDMS central versions.Designed and maintain Data Structure Diagrams (DSD's or Bachmans) depicting the structure of the IDMS database record layouts, storage methods, indices, and their database areas.Ran database reorganizations to change how the data was stored and to expand existing database areas.Participated in performance reviews of new COBOL programs that would access the IDMS database.On-call support for both IDMS and Sybase database systems.

Us

Ran nightly batch cycles on an IBM mainframe running MVS, batch schedules were controlled using CONTROL-M from 4th Dimension Software.Notified programmer on-call when batch jobs abended.Performed print room operations.Performed tape librarian functions.Performed weekly backups and system IPL.

Bs, Computer Technology

Education record