Senior Database Technical Lead Resume
San Diego, CA
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