SUMMARY

• A Senior Oracle DBA with over 25 years of development and IT experience, including 7+ years in Vertica, 12 years in Oracle, 11 years in PostGres and a background
• Primary DBA for PostgresSQL supporting over 300 database clusters.
• Expertise in enterprise DB and PostgresSQL installation, configuration, streaming replication, partitioning, cascading replication, FailOver Manager, hot standby, oracle connectivity/replication and EDB/Postgres programming.
• Main DBA for Vertica data warehouse (Versions 5.x through 8.x) Main DBA for Vertica data warehouse (Versions 5.x through 8.x)
• Expertise in Vertica Tuning, resource and pool management, MergeOut/MoveOut and Tuple Mover analysis, setting job priorities, balancing physical segments, ROS/WOS load performance considerations, projections, node dependencies and analyzing projections for optimal performance.
• Vertica query tuning and isolation via profile, explain plans, Vertica Management Console and system Data Collector table queries.
• Creating 30 DBA alerts for key Vertica performance metrics, deleted vectors, space growth, partition growth, resource allocations and overall performance.
• Practical knowledge of Vertica node recovery during multi - node disk failures with Ksafe=1
• Knowledge of analytical functions and optimization utilizing Event-Windowing, Sessionization, Pattern Matching, Hadoop, and machine learning evaluation functions.
• Data conversion from various sources to Oracle via snapshots/Materialized Views, replication tools and Oracle Streams.
• Implementation of Oracle-based architecture for high-rate OLTP transaction and low retrieval response time.
• Expertise in Golden Gate replication and File Connector to Vertica
• Worked with Cloud and on-premise solutions for data appliances and databases. (AWS and Google cloud)
• Installation and operation of warehouse appliances such as GreenPlum and Vertica: achieving max write speed up to 40 Mbytes per second with 3 nodes during POC.
• Expertise in Database migration from MySQL to Postgres and Oracle and from Oracle and MS-SQL to Postgres.
• Oracle 10g/11g/12c RAC configuration, implementation and performance tuning
• Physical and Logical Standby configuration and implementation ( Solaris and Windows platforms)
• Configuration and implementation of Oracle 10g Grid control
• Expertise in Oracle 9i/10g/11g Security VPD (Virtual Private Database) and Fine-Grain Control
• Implementation of XDB-based schemas, XDB transformation queries and configuration utilizing oracle XDB package utilities.
• Expertise in PL/SQL programming on various Oracle versions and platforms
• Professional installation/configuration of 10g/11g version 2, OCFS/2 and ASM.
• Expertise in Advanced Oracle Multi-Site Replication.
• Database benchmark measurement with Bench-Factory and i-player.
• Proficient in data modeling utilizing various tools such as ER Studio, SQL Navigator, Erwin and implementing logical to physical transformation.
• DBA: Installation, Oracle Enterprise server system upgrades/patches, Backup/Recovery methods utilizing RMAN, hot and physical backups, configuration, performance tuning, DBMS job scheduling, troubleshooting, profile/user management and security.
• Expertise in utilizing Oracle Pipes, stored procedures, triggers, SQL*NET, SQLLOAD, DBMS package tools, SQLPLUS and Oracle Enterprise Manager.
• Design and implementation of packages and efficient stored procedures, especially for financial-type applications requiring security.
• Proficiency in developing Pro-C objects, dynamic SQL, JDBC and PL/SQL.
• Device Driver development and network code development for diskless workstations on UNIX-based platforms such as AIX 3.2. Development of UNIX applications using IPC, shared memory, sockets, pipes, mapped files,
• UNIX environment: Shared memory, aliases, threads and queues.
• Graphics application development in 'C' via GL.
• Creating Workflow process, utilizing object oriented tools and services, especially with InConcert.
• Working knowledge in Neural Network and Fuzzy Logic.
• Multimedia experience, especially in speech and pattern recognition.
• Technical leadership skills in developing data models, process flows, system architecture, state and data entity diagrams from abstract ideas.
• Experience in HTML JAVA scripts, ODBC/JDBC and JAVA applet development.
• Servlet technology utilizing Apache and tomcat.
• Working knowledge of APEX (Oracle Application Express)
• Expertise in developing structured programs utilizing TCP/UDP Socket interface, especial use of parallel methods to take advantage of parallel architecture and concurrency.

TECHNICAL SKILLS

Operating Systems: Flavors of UNIX including Linux(RedHat/CentOS), Sun Solaris, AIX 5L, Berkley/Free BSD and System V.

Platforms: Dell Intel, SUN Workstations, RS/6000, HP9000, SGI, SPARC, and latest laptops.

Clustered Storage: Network Appliance 3170 and XIV, ZFS (with SSDs)

Warehouse Appliances: Vertica, Greenplum

Databases: PostgresSQL/EDB 11.x, Oracle 12c/11g certification, 10g, 9i, (RAC, GoldenGate, DataGuard and replication). SQLserver 2005, MySQL

Distributed Databases: Citus, some experience with Radis and Cassandra

Cloud Implementation: AWS and Google

Languages: ProC, PL/SQL, SQLPLUS, Structured C and C++, Java, JDK, UNIX shells bsh, ksh, AWK, Perl, Python, PHP, Intel-based assembly language programming x86-based

Data Communications: Kafka, TCP/UDP Socket RPC

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Senior Database Technical Lead

Responsibilities:

• Migrated two major games data from Oracle to Postgres Based databases in record time
• Complete DBA and development tasks with Postgres versions 9 through 11, including installation, streaming replication, tuning, partitioning and monitoring.
• Implemented infrastructure and logistics to move/replicate large data sets from various sources to Vertica.
• Converted all data from MS-SQL to Postgres based databases for 22 database clusters
• Maintained all our company databases and primary DBA for Vertica 8.x.

Environment: Vertica 8.1 with 6 nodes

Confidential, San Diego, CA

Senior Database Administrator

Responsibilities:

• Install and upgrades of Vertica 6-node appliance and POC of various data feeds to vertica.
• DB installation and maintenance of 9i/10g/11g RAC and non-RAC production instances including a 3 TB data warehouse.
• Data Warehouse ETL tool configuration and management.
• Database migration from MySQL to Postgres Based Enterprise DB (EDB) and Oracle 11g.
• Zero downtime of storage migration utilizing Oracle 11g, utilizing ASM rebalancing.
• Oracle GoldenGate Replication in heterogeneous platform environment.
• Evaluated Clustered storage XIV and NetApp performance/functionality/reliability with benchmark measurements, load test and Linux/cluster built-in tools.
• Creation of Enterprise DB instances, standbys, configuration, partitioning and replication to/from oracle.
• Creation of various RMAN backups and real time monitoring and alerts via Grid Control.
• Automation of storage snaps/clones for database backups, standbys, roll-forward and point-in-time restores.
• Established a high transaction rate solution with Vertica warehouse, implemented migration/replication of Oracle warehouse schemas to Vertica.
• Performed benchmark Vertica measurements for analytics team.

Environment: Oracle 9i/10g/11g on Linux (170 instances including 125 RAC)

Confidential, San Diego

Senior Database Administrator

Responsibilities:

• Upgrade of various Oracle platform to 9i and 10g.
• Define and configuration of SQL-server with admin roles, data sources, connectivity, monitoring and evaluating Key Performance Indicators.
• Data Modeling and reverse engineering of existing database architectures utilizing standard process and modeling tools from Erwin and Embarcadero for various County of San Diego projects.
• Designed and developed various functionalities for Probation Department
• Implementation of RAC on Solaris with EMC Powerpath
• Implementation of Oracle Security Vital Private Database for San Diego County Sealing project
• Implementation of Alert system utilizing Oracle Mail.
• Creating logical and physical standby database with 10g Dataguard
• Implementation of latest Oracle security patches
• Performed many DBA tasks including database recovery due to disk failures or system outages.
• Oracle Steams set-up, trouble-shooting and tuning.
• Automated hot backups, cold backups with RMAN and hot backup Unix scripts.
• Performance tuning of various Oracle implementations including large databases.
• Responsible for 20 instances and backup DBA for another 15 instances.

Environment: Oracle 10g on Solaris and Windows

Confidential

Senior Database Administrator

Responsibilities:

• Solo Senior Database Administrator, responsible for Design and Implementation of Oracle Parallel servers, Data Modeling, XML interface to Publishers and EndUsers.
• Implemented advanced multi-site replication for all production databases.
• Performed regular system Upgrades and applied latest patch sets to all Oracle Enterprise servers, piloted all changes in a controlled environment prior to deployment.
• Created alerts and monitor utilities in order to troubleshoot database detractors or pinning performance issues utilizing Oracle trace, tkprof, explain plan, spreport and stacktrace.
• Created backup strategy via RMAN, recovery manager repository, hot and physical backups and data pump of selected schemas objects for fast data recovery.
• Designed a hot standby instance to take over in case of CPU or instance failure.
• Architected and modeled database logical and physical layer for book Editor’s ERP/CRM applications.
• Designed/developed and implemented agents to transfer objects/files for Confidential content repository via Oracle package and proC/C++ application.
• Measured and planned resources HW/SW to implement an optimal heterogeneous database solution that included multiple instances and CPUs in a clustered environment, utilizing 10G RAC and materialized views.
• Consulted end-users, developers and other system analysts/architects regarding the application performance issues, software development, capacity and throughput, in order to maintain a highly scalable, supportable and efficient infrastructure.
• Implementation of SOX guidelines and plan development

Environment: Oracle 10g on Intel x86.

Confidential

Senior Analyst/Project Lead

Responsibilities:

• Designed and implemented a data mart schema from a Data warehouse containing bank and holding company information.
• Designed an online reporting system utilizing data mart objects.
• Handled design and implementation of a nightly update process for many portal applications.

Environment: Oracle 8i with SGI and HP