DataWarehouse / Database Management Professional
IT Professional and Leader with in-depth experience in the planning, designing, development, configuration and maintenance of the Database Management System. Recognized as a top performer with the ability to work under highly stressed circumstances while maintaining exceptional quality of work.
Knowledgeable and well-versedwith a wide range of Database Management applications including implementation according to organizational requirements. Strong in Problem Solving and Performance Tuning. Less talk and more work is my motto.
Ensures the Database System meets the security and performance standards according to Hewlett Packard standards, client expectations and compliance with SOX governance.
Seeking a full time position.
Databases: Oracle, MSSql, MySQL, Big Data, MongoDB
Operating Systems: Oracle, Windows, Linux, HP-UX, SAN, 3par
Programming/Scripting: plsql, Objective-C, unix shell scripting, html, xml, java, perl
Tools : OEM, Toad,Microstrategy, ERWIN, MS Project, Cognos, Crystal Reports, Tidal, Informatica
Cloud : AWS, Azure (Conceptual Knowledge)
Other : Exadata, Rac, Goldengate, Dataguard, Streams, Caching/Memory Mgmt in Oracle/Sql Server, devOps (Conceptual ), e-commerce (Wordpress, Woocommerce)
Speaker/Presenter by invitation, for Independent Oracle Users Group 2013
Navigated the design and development of the Database Management System upgrade for Oracle ERP 10gR2 non-RAC to 11gR2 RAC.
Acknowledged by management for a smooth, well-managed Database Management System upgrade.
Recognized as a Top Performer and advanced within the organization. 2009
Speaker/Presenter by invitation for Qualcomm at Oracle Open World, Linux RAC9i. 2004
Conceived, designed and launched the first mobile app “dbaBuddy” for dba’s and managers.
Piloted $5M ‘hands-on’ project, Oracle DBA, Full Development Life/ Cycle, to manage over a Terabyte (4 TB total), APS (Advanced Planning and Scheduling, JDE DP, PDP, PS, SNO) databases.
Short Term Contract Position :Santander Dec2018 2018 – Dec 31, 2018
Oracle 11g and 12g hardening guide, assessing security risks, compliance and remediation scripts using bash and sql. This project is scheduled to end Dec 31, 2018
Short Term Contract Position : IBM Watson Sep 2018–Nov 2018
Lead Exadata DBA
Primarily worked as a Lead Oracle Exadata DBA on 18g for a 300 TB Data Warehouse Project. Worked closely with Networking team in reviewing cabling docs and translating those to requirements for the OEDA. Set up TDE, Auditing, and Auto DOP, exawatcher for a Dev environment. Worked closely with the Data Architects in Design discussions. Worked closely with ETL developers helping them with loading XML files.
Emory Healthcare, Atlanta, GA. Jun 2015 – Sep 2018
Lead Datawarehouse DBA
Worked with the Data Stewards in ensuring all changes to how Data was stored and modified was reviewed, approved and documented. Involved in Oracle 12c implementation and sql server 2012 upgrade projects. SME for all performance tuning needs. GoldenGate 12c Installation and Oracle Golden Gate Veridata Installation and configuration. Configured golden Gate to replicate uni-directionally 20+ TB database for remote hosting. Obey files for Conflict Detection Resolution and Exception Handling. Incorporated Golden Gate Transorformations to refresh a test environment. Setup the JAGENT to monitor Golden Gate replication. Configured Oracle Golden Gate in OEM 13c Cloud Control. Sql Server Clustering and HA training, Always ON, log shipping and testing. Some MongoDB experience for a remedy application. Migrated over 50 sql server databases from older versions to version12.Sql Server monitoring and notifications using Idera.
HewlettPackard, San Diego, CA. 2007 – 2014
Lead ERP Database Administrator
OLTP/Datawarehouse DBA for Oracle HRMS Backend. Completed the ‘Functional, Solution and Technical Design’ document, the RAC Test Strategy and AWR baselines.Initiated then led a thorough ‘failover testing’ covering all failure points.
Lead the conversion of ASM storage from EMC/SAN to 3PAR. Created and Support sqlServer databases. Introduction to DTS, TSQL packages.
Identified and solved performance issues arising from a software upgrade or inadequate sql/sqr within the San Diego County HRMS (PeopleSoft) ERP Databases.
Sole DBA Management System Lead for upgrade from 9i to 10gr2 and from 10gr2 to 11gr2.
Implemented unique backup and refresh strategies resulting in meeting public sector testing.
Created prototype for mobile app as key member of the Innovation Council presented to clients.
Qualcomm, San Diego, CA. 2003-2007
Lead Database Administrator, Corp-IT & QIS,
Key contributor to the success of Oracle RAC project on Solaris / Linux including Load Runner as tool to benchmark and measure performance of RAC databases.
Provided High Availability Solutions such as Data Guard to external customers with extensive and detailed MOPs including drafting SOWs and SLAs.
Key contributor in the ERP Oracle Apps implementation and OID evaluations.
Defined then implemented a DB Audit and Security Policy as Key Tester of Sox Controls then applied across the organization.
Initiated a series of Process Improvements to migration and refresh processes resulting in improved efficiency and increased effectiveness for time sensitive cloning test environments.
Database Administrator/Entrepreneur/Architect Roles 1989-2003
Lead Oracle DBA (OLTP and Datawarehouse) Consultant
Leader and expert advisor in database design, configuration, architecture, capacity planning, offsite retention strategy, development techniques, setting Dev/Test environments, performance tuning, mentorship, scheduling system maintenance and outages.
Hands On training Oracle Exadata, Hadoop Operations, MapReduce, Pig, Hive, Impala, Mahout, Data Scientist.
C/IOS, University of California, Extension, San Diego
Marquette University, Milwaukee, WI
MS, Computer Science, concentrationRelational / Distributed Database
University of Colorado, Colorado Springs
Tech Hobbies/Passion : Founder/Project Manager of www.BigBanglesTheory.com. Worked with teams in USA and other parts of the world to get an e-commerce site bootstrapped.
Better Life Technologies, La Jolla, CA. 2012-2016
Conceived, designed and launched the first Business/Productivity app for Database Administrators, database managers and project managers. Utilized a thorough understanding of IOS/Android Development process using Agile Methodology. Speaker IOUG Collaborate-13. Manage and direct the work of a team of 10 offshore Developers.
Implemented Amazon Web Services via partnership with Amazon using Cloud Technology to host the services. Mysql database.
Praised as ‘…Innovative and futuristic…’ by clients and technical followers of the “dbaBuddy”.
Managed the development and launch of the app Picplate, 2Meditate in iTunes.
Budgeting and Financial Planning
Uma Lakshman page two