SUMMARY:

• More than ten years’ experience in full cycle software development in various roles Technical Manager, DBA, Architect and Consultant.
• Knowledgeable in various technical environments including web technology, middle - ware, database technologies, technical architecture, planning /analysis,
• Over ten-year experience in Oracle (8i,9i,10g,11g, and 12c) database administration (Development and Production).
• Experienced in setting up OEM repository (13c - Cloud Control), monitoring databases using OEM tools. Backup and recovery using RMAN and OS.
• Experience with E/R, relational, dimensional modeling, star, snowflake and DE-normalization techniques.
• Strong skills in solution architecture, design and analysis (SSAD/OOAD), leadership, team building and mentoring skills
• Worked in various industry sectors: Human Resources, Utility, Banking, Finance, Automotive, Retail, Distribution, and Trade Show.
• Mentor, Architect, Team Lead, Product Specialist at major HR company
• Team lead and DBA Asset Reconciliation System for telecoms/banking client
• DBA and development lead Project information system for automotive client
• Site Lead, DBA and Project/Program Manager for trade show client - time keeping, accounting
• Architect, DBA, Project Manager for Utility client

TECHNICAL SKILLS:

Hardware: SUN, IBM, HP, AWS, Cloud

Operating System: UNIX (SOLARIS/AIX/HP-UX), Windows, Linux

Databases: ORACLE10g/11g/12c RAC, SQLSERVER, SSIS, SSRS, MySQL, PostgreSQL

Tools: Oracle Enterprise Manager; Oracle Tuning Pack, TOAD, Veritas, SharePlex

Languages: C, JAVA, Shell scripts, PERL, PRO*C, PLSQL, Python

GUI utilities/CASE: IEW, ERWIN, SYSTEMS ARCHITECT

Project utilities: MS office, MS Project, PMI templates, VISIO

Configuration/Change Management: CLEARCASE, Source-safe, Peregrine Exposure to various Web architectures J2EE, Microsoft DNA, component based architectures & IDE

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles

Database Architect/Administrator

Responsibilities:

• Migrating Oracle, MySQL databases to AWS (Amazon Cloud) - Worked in EC2/S3/RDS/IAM
• Improving the performance of DW processes - ETL in Oracle (PL/SQL), SQL Sever
• Recreating physical/Logical/Conceptual models for the Data warehouse (star schema/Dimensional modeling)
• Develop, implement, and maintain data cubes, loading data, dimensions, calculating data and aggregation techniques
• Process improvement of Database administration though rationalization and automation
• ASM storage management, Oracle Database administration, tuning, troubleshooting (10,11,12c) including active dataguard, RAC
• Troubleshooting, optimizing, tuning complex queries for Data warehouse
• Exposure to MongoDB, SSRS, SSIS, PostgreSQL, MySQL- development and data warehouse environments
• Prioritizing trouble tickets, business requirements, operational issues
• Storage migration of ASM Disks - Implementing New storage solution on production
• Mentoring analysts, database administrators
• Collaborate with Business and Development teams on data and architectural issues.

Confidential, West lake Village, CA

Consultant DBA

Responsibilities:

• Consulting at e harmony as a consultant DBA - Ticket resolution, tuning, installation, upgrades
• Application Monitoring and database troubleshooting using Toad, SQL Developer, TRCA, TKPROF, STATSPACK, ASH reports, AWR reports
• In house consultant DBA responsible for - Oracle installation and Upgrades (11g and 12c), monitoring, tuning and troubleshooting client databases (8i,10g,11g, 12c). Oracle on AWS, EC2, Exadata, ODA including active dataguard, RAC
• Troubleshooting GoldenGate in production environment
• Storage migration of ASM Disks- resolving Disk corruption
• Tuning and Redesigning data warehousing ( ETL) processes - SharePlex/Oracle Stored Procedures( PL/SQL)
• Migrating Oracle, MySQL databases to AWS (Amazon RDS)

Confidential, Camarillo, CA

Technology Consultant/Lead

Responsibilities:

• Migration from 8i to 9i, and 9i to 10g, 10g RAC,11g RAC, ASM, Installing11g RAC, GRID Control, Veritas cluster on Sun SOLARIS 2.9
• Team Lead for a team of up to 6 DBAs
• Reduced the time for upgrades (eLabor Application) from 40+hours to 4 Hours
• Oracle Install on 2 Node, 6 Node and 8 node RAC clusters
• Design and development of scripts to migrate data from one data center to another (25000+ schema)
• Real Application Testing (RAT)
• OEM installation, configuration, monitoring,
• DR set up using Golden Gate and Oracle data guard
• Mentor the DBAs in the Team
• Project planning at technical and executive levels. Project/plan resource requirements for DBA Group, mentor/ guide team members and developers
• Manage/administer database support activities in a production, staging and QA environment and support up to 300 Oracle and SQL server databases, allocate and coordinate tasks across product teams, production resource
• Application Hosting environment with two data centers (coast to coast) with 2 million users using the application
• Interfacing with product support and development teams on database performance and new production features. Developing strategies to reduce data redundancy, efficient interfaces with multiple applications
• Install, upgrade, tuning and maintenance of various oracle 8i/9i/10g/11g (RAC and non RAC) databases
• Working with Application developers to troubleshoot application, SQLs
• Troubleshooting and Solution Development for variety of issues crossing many technologies (DB/WEB/.NET/JAVA)
• Improved application upgrade performance (Application upgrade from 40 hours to less than 4 hours, data load from 4 hours to ten minutes)
• Designed and Developed scripts to collect Oracle statistics and to track the database performance over time. Trending usage, growth, performance of various parts of the application (capacity planning and forecast)
• Demonstrated experience working with and tuning complex SQLs. Troubleshooting and tuning of application SQLs using TKPROF, STATSPACK, AWR, ASH, Explain Plan, SQL Trace, ANALYZE, HINTS, etc.

Confidential, Torrance, CA

DBA

Responsibilities:

• Migrating from Oracle 8i to 9i
• Troubleshooting data warehouse (ETL) scripts for customer Data warehouse (Informatica mappings) and redesigning them for improved performance (using STATSPACK)
• Implementing Oracle features such as Partitioning, Advanced Queues, Locally managed tablespaces, Undo tablespaces.