Data Oracle

VADIM A. NELSON

**** * ****** ******, ****** CO *0112 ph. 303-***-**** *****.******@**.***

PROFILE

An experienced senior database administrator for relational databases such as Oracle, Postgres, Mysql, SqlServer and BIG DATA technologies for Vertica and Redshift. Expert knowledge of configuration, implementation, development and tuning Enterprise databases.

•25+ years of information technologies experience

•5+ years of Vertica technology administration and development

•20+ years of Oracle experience in both production and development roles

•6+ years of MySql administration and development

•2 years of AWS REDSHIFT and S3

•Experience using share storage technologies to reduce recovery time of any database to the matter of seconds instead of days.

•Implemented DR solutions

SKILLS

•Oracle 7 through 11g, Oracle RAC, Vertica, Mysql Enterprise, Postgres, Mango, Redshift, OEM 11g, S3, rman, SQLSERVER, SQL Developer, Toad, SolarWinds, VSQL

•Linux, Sun Solaris, NETAPP, SAN, NAS

•PL/SQL, C/C++, ProC, Java, Shell scripting, Perl

PROFESSIONAL EXPERIENCE

Senior Database Administrator

Aug 2008 –Aug 2015

Level 3 Communications

•Developed 200TB Vertica cluster that handles 500 concurrent users, 300gb + daily loads and sub-second end-user query response time.

•Implemented a Vertica data warehouse for Call detail records that is used by Mediation, Disputes, fraud detection and law enforcement.

•Managed daily operations of a Data Store in Oracle 11g RAC that is used by an entire company.

•Used Amazon AWS services to store archived data from production systems and reduce operational costs

•Managed 30+ other databases in Oracle,Vertica, Mysql, and Postgres by providing backups, DR and development support

•Utilized NETAPP and PURESTORE snapshot technology to maintain multiple environments and minimizing storage footprint by factor of 10x. In addition leveraged this technology to allow nearly instantaneous recovery and replication.

Oracle Developer and Administrator

Jul 2002–Aug 2008

Direct Tech Inc.

•Performed Oracle 8i, 9i and 10G installation, sql tuning, database backup and recovery, upgrades, optimization, resource planning, data modeling and enforcement of DB standards.

•Supported multiple teams with Database change management and PL/SQL development

•Developed ETL processes

• Provided production support for data warehouses for over 25 external clients including Home Depot, HSN, Hickory Farms, Neiman Marcus, Pet Edge, Fredericks of Hollywood, Anthropology

•Maintained data models using Erwin, supporting multiple development environments, performing upgrades, and packaging releases.

•Supported ETL processes utilizing PL/SQL, SQLLDR, SQL SERVER 2000/2005 TSQL programming, perl and Unix shell scripts. Provide support in Solaris, Windows, HPUX, Linux

Senior Oracle DBA

Jun 2001–Jan 2002

REASON INC

•Maintained 12 databases in Windows NT/2000 environment

•Performed daily backups using Backup Exec, and database tuning

•Maintained data dictionary and data models for various projects

•Developing custom code in PL/SQL

Database Consultant

Oct 1999– Jun 2001

TOOLCASE INC

•Completed data conversion into Oracle projects

•Developed custom ETL code in TSQL and Data Junction

•Regular tasks included performance tuning, troubleshooting, code and design recommendations.

Database Consultant

USWest/Qwest

Nov 1997-Sep 1999

•Developed database standards used by development teams in Oracle

•Performed capacity planning and performance tuning

•constructed CGI scripts using Perl, C/C++, and ProC

•Developed a generic C++/OCI class library that simplified access to Oracle databases

Database Consultant

Nov 1995-Oct 1997

Price Waterhouse

•Developed database standards and naming conventions

•Maintained data models and data dictionaries in Designer 2000

•Developed a automated reporting system for the managers

Senior Systems Analyst

Oct 1993-Nov 1995

BANC ONE Mortgage

•Developed new business processes

•Completed workflow implementation for the Collections department

•Developed, implemented, and supported Management Reporting System that tallied all activities performed on the system by customer support representatives

Programmer Analyst

May 1989 - Oct 1993

Everett I. Brown Architects

•Developed a graphical software package that simulates effects of bombs on different buildings

•Developed file versioning software to handle checking/checkout of various architectural files.

•Developed GUI interface for editing graphical information on a VAX/VMS server

Army Technician

Jun 1985-Oct 1987

•US Army 327 Battalion Ft Harrison

•Maintained M1 and Bradley fighting vehicles

•Repaired electronic equipment and power generators

EDUCATION SUMMARY US ARMY/USAR Electronics technician and an armored vehicles mechanic

Purdue University BS in Computer Science Dec. 1990. Minor in EE.

Indiana University MBA classes at Indiana University

Oracle University Certified DBA

Contact this candidate