We provide IT Staff Augmentation Services!

Senior Database Technical Lead Resume

4.00/5 (Submit Your Rating)

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

We'd love your feedback!