OBJECTIVE

A direct hire, long term, local position with a company that will utilize over 20 years of experience with enterprise database and data warehouse administration, architecture, design, development, tuning, documentation, organization, project management, reporting, security, data mining, software testing, automation, and analysis.

SUMMARY:

Expertise in all versions of Oracle, MySQL, SQL Server, Vertica, PostgreSQL, Hadoop, MongoDB, and Unix/Linux systems administration. Proven problem solver/preventer in relational database systems, both OLTP and DSS. Advanced skills in data modeling, data mining, big data, automation, machine learning, MDM, ETL, Excel programming, financial/insurance systems, project management, systems analysis, software architecture, ILM, ERP, data architecture and system architecture. Extensive expertise in database and AI based systems like neural networks, intelligent agents, etc..

TECHNICAL SKILLS:

Programming Languages: C, C++, All SQL versions, Java, Matlab, Python, ASP.NET, VB, UNIX scripting, and others.

Hardware Systems: IBM PC/XT/AT, AWS Cloud, Sun, Prime, DEC Alpha, HP, TI, Dell, NCR, Cloud (AWS) and others.

Operating Systems: Solaris, AIX, Linux (any), HP - UX, Windows NT/XP/Vista/7/8/10.

Database/Knowledge Base Systems: Oracle 8i/9i/10g/11g/12c, MySQL 4/5.x, SQL Server 2000/05/08/12 , Teradata, MongoDB, PostgreSQL, Teradata, DB2, PostgreSQL, Cassandra, Greenplum, Vertica, Netezza, Redshift, Hadoop (MapR, Hive, Pig), Amazon RDS/Aurora, and others.

Data Warehouse/Data mining Tools: Informatica, Discoverant, Tableau, Brio, Talend, Hyperion, Cognos, Microstrategy, Business Objects (BOBJ), Oracle Analytics(ETL, ERP, CRM, OBIEE), DataStage, SAS, SSIS, SSAS, SSRS, Parallel Data Warehouse, Excel, Star Schema, Snowflake, OLAP Cubes, Aggregate Navigation, Scala, Spark, Multi-Dimensional, Elastic Search and others.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Analyzed test data files for loading into MySQL database, provided guidance for Amazon Cloud service offerings, including RDS, Hive, and Redshift (installed and tested all 3 products). Installed and setup MySQL 5.5 database for demonstration, Installed and setup Talend ETL tool, Developed Java job to reformat and load test datafile into MySQL table, Created and debugged proof of concept for ETL process.
• As a datawarehouse architect, performance tuned SQL scripts and Informatica 9.5 mappings and workflows, Improved run times, for many critical BI processes and ETL workflows, provided guidance for data warehouse design and tuning methods, Used partitioning, data caching, and parallel processing to improve process performance, Supported problem solving and ETL processes for Hawq/Hadoop database system, Supported DW migration from Greenplum DB to Hawq/Hadoop system.
• Created data models using Toad for implementing in MySQL 5.6, Installed MySQL and created 4 node Percona/Galera replication cluster, Installed and setup ScanBase for load balancing on the cluster, Demonstrated the cluster operations and ScanBase. Installed and evaluated Amazon Redshift in their private AWS cloud.
• As a datawarehouse/system architect, designed and implemented database schemas in MySQL, Vertica, and Mongo DB, Created and administered 12 development databases, Created data dictionaries and data models, using Lucidchart and Excel, Supported, administered, and tuned MySQL and Vertica databases on AWS Ubuntu, Created databases for CRM and retail transaction support, Provided DBA support and leadership for development team.
• Solved problems in MySQL 5.5 Databases, Stored Procedures, Backup, and data migration, Instituted Transaction Control into all production Stored Procedures, Created data dictionaries and data models, using Toad and MS Visio, Supported, Administered, and Tuned MySQL databases on Linux (RHEL), Created databases for Financial Transaction Support, Led Team in Agile/SCRUM project management methods,
• Executed Proof of Concept for DB2 backup, restore, and suitability for Data Domain file systems usage, Performed analysis and verification of best practices in DB2 9.6/7, Oracle 10/11g, and SQL Server 2005/2008 databases, Setup and configured Oracle 11g, EMCTL, RMAN, and Data Warehouse. Solved many problems in many different database systems. Led project, established requirements, use cases, and identified candidate products/vendors for new Enterprise ILM Archiving project, Utilized Toad for DB2, Sharepoint, Lynx, and Putty
• Setup RMAN backup system of NASA production and development databases in Oracle 10g and 11g., Tuned SQL queries and solved problems in MySQL and PL/SQL., Setup and used Zoho Application Manager for monitoring Linux based computers and Oracle databases. Utilized Toad for DBA operations, data modeling and ETL processes. Upgraded databases from 10g to 11g. Mentored clients in RDBMS, RMAN, SharePoint, Advanced Queuing, MDM, Tableau, database security, and Data Guard concepts and usage. Led project to installed Oracle 11g and load the database on a new Linux machine for production.
• Tuned, solved problems, debugged SQL, Java, and PL/SQL programs in Oracle 10/11g databases for financial applications. Used Talend for ETL jobs and data migration. Documented Talend operations and usage. Administered SQL Server 2005/8 for security and agent job scheduling. Used Toad for administering Oracle 10/11g databases to support tax applications. Used and administered Perforce system for document control. Utilized Mongo DB, PostgreSQL, Hadoop, HIVE, HBAS. MapR, and NoSQL for ETL testing.
• As a datawarehouse architect, tuned, solved problems, and made performance improvements for data warehouses in SQL Server, and IBM DB2. Provided recommendations for best practices and configurations for top performance, scalability, enterprise database monitoring, and MDM. Optimized indexes and buffer pools in DB2 to support ETL and BI reporting. Optimized parallel processes and memory use in SQL Server 2008 for an enterprise data warehouse, using SSIS, SSAS, SSRS, Parallel Data Warehouse, Informatica, Tableau, and Business Objects.
• As a datawarehouse architect, tuned and solved problems in Oracle 10g databases and many SQL statements for a datawarehouse project. Supported Discoverant applications and automated conversion and migration operations with Korn shell scripts on Solaris 10. Designed, tested and benchmarked the production database system. Fully documented project database administration and designs for the system. Started enterprise MDM project. Performed all DBA functions using Toad and SQLPlus for DSS type databases.
• Solved problems and documented databases in SQL Server 2008. Tuned and supported worker’s compensation insurance applications and databases using Toad. Automated processes to enhance data quality. Performed index optimization and worked on MDM project. Performed all DBA functions using Toad and SQLPlus for OLTP and DSS type databases.
• As an information security analyst, I monitored access and network logs for intrusions, made plans and implemented encryption and obfustication in files and databases. I made reports on security events and prevented over 60 intrusion attempts. Evaluated SIEM tool vendors and product offerings.

Confidential, Westlake Village, CA

Senior Database Architect

Responsibilities:

• Solved many problems in SQL Server 2005/2008 for high transaction load OLTP systems and large scale DSS database systems.
• Made changes that achieved system stability and significant performance gains.
• Developed and supported Oracle (8i, 9i, 10g, and 11g) databases for security, RAC tuning, database creation, backup, recovery, and data migration.
• Trained in Netezza database systems and administered 3 large systems in user setup, backup, tuning, migration, and access.
• Supported Sharepoint and tuned databases and queries in MySQL systems

Confidential, Sherman Oaks, CA

Senior DBA, Data Warehouse Architect, Senior Analyst

Responsibilities:

• Administered Oracle 10g/11g (CRM, OBIEE), MySQL 5.1, and SQL Server 2005/8 for financial analysis, reporting and BI using Microstrategy 9 and SSIS/SSAS/SSRS/Excel including Streams Replication, indexing and partitioning.
• Converted DataCom database to SQL Server 2008.
• Led projects for data warehouses and CRM analysis using Business Objects, Agile methods, SQL Server, SSIS, and Subversion for version control
• Designed MDM development for multi-department company using Cognos.
• Performed upgrade of Oracle database (2.5T) 10g to11g on Solaris 10.
• Designed and implemented 3 Universes on Business Objects v10 and 11, and Tableau for reporting.
• Administered Windows XP Pro and Red Hat Linux (Fedora 10).
• Evaluated Corda, PostgreSQL, and Teradata v.12.0 for functionality.

Confidential, Los Angeles, CA

Senior Data Warehouse Architect

Responsibilities:

• Analyzed the existing systems and requirements for a new data warehouse project.
• Designed and created the databases and universes using the Star Schema method, developed data models and ETL methods using Business Objects v10 (BOBJ) and DI.
• Solved problems in SQL Server data warehouses involving the SSIS, data, and views.
• Supported and provided guidance for Oracle 10g DBA.
• On Linux, AIX, Windows XP and Oracle 10g.

Confidential

Senior Database Administrator, Developer

Responsibilities:

• Documented production systems in UML using Visio.
• Load tested applications with Curl and SQL.
• Converted 4 C programs (~2500 lines) to Matlab for implementation of SIFT based image recognition system.
• Supported debugging and PostgreSQL database design.
• All on Linux, Apple OS 10, VM Fusion (Windows XP) and Vista.

Confidential, Philadelphia, PA & Austin, TX

Senior Database Consultant

Responsibilities:

• Provided consulting and analysis of high concurrency database configurations including RAC and replication methods.
• Developed trigger-based multi-master replication, and Streams Replication (with Advanced Queuing) systems.
• All on Solaris 10 with Oracle 10g.
• Installed, configured and patched Oracle on 4 Sun Sparc 2000 class systems for replication.
• Utilized Excel, TOAD, PL/SQL, and UNIX scripting.
• Provided support and guidance for Oracle database upgrades (from 9i to 10g), 10g grid control, import and export, tuning, database design and setup.
• Developed Java wrapper to eliminate database passwords from UNIX shell scripts to enhance security.

Confidential, Torrance, CA

Senior Database Consultant

Responsibilities:

• Setup benchmarking systems for Oracle 9.2 on Solaris with PL/SQL and shell scripts.
• Administered Oracle data warehouses with Toad, Enterprise manager, SQLPlus, and Informatica.
• Did troubleshooting, capacity planning using Excel, and performance tuning of ETL processes, SQL queries and data warehouses.
• Developed methods for user monitoring and data security.
• Upgraded Oracle databases from 9.2.0.2 to 9.2.0.8 and planned upgrades to 10g.
• Supported data analysis and reporting with Microstrategy and Hyperion/Brio in financial systems.

Confidential, Agoura Hills, CA

Consultant, Senior Database Administrator, UNIX systems administrator

Responsibilities:

• Setup and configured OS and Oracle 10g RAC on Red Hat Linux.
• Programmed packages and stored procedures in Oracle 9i PL/SQL and UNIX scripts for installment plan fulfillment.
• Tuned and provided algorithmic support for database operations in Oracle 9i OID and LDAP.
• Optimized queries and loading systems for data warehousing and business intelligence.
• Provided support and planning for replication of Oracle 10g OID systems.
• Setup and maintained Oracle 10g RMAN backup systems and database synchronization methods.