Experience

PG&E, LLC

• United States
• Civil Engineering
• 1 - 100 Employee

• Oracle Database Administrator Team Lead

  • Mar 2020 - Present

• Sr. Oracle Database Administrator

  • Jun 2016 - Feb 2020



Bank of the West

• United States
• Banking
• 700 & Above Employee

• Sr. Oracle DBA/Co-ordinator

  • Jun 2015 - May 2016

  • Co-ordinator role – Ensuring Incident Management- tickets are below threshold and responding within the SLA. • Responsible for stabilizing the environment and keep it healthy and up and running and meeting the SLA. • Escalation point of contact for several source systems and articulating issues and triaging. • Responsible for support, monitoring, proactive problem recognition and resolution of database issues. • Undergone DB Maestro/EMC snap sync training • Conducting sizing & capacity planning for Oracle databases. • Implementation plan review and suggesting changes per standard/process • Applied PSU patches, upgraded OPatch. • Converted single database instances into oracle RAC for high availability. • Group Admin of OEM ( Oracle Enterprise Manager) for whole group. • Performance diagnosis, CPU usage, Top,NMON, NETSAT, iostat, SAR • Using ignite other than OEM for extensive performance diagonis and metrics • Applied security patches, proactive monitoring of databases and applications. • Perform SQL tuning and assist developers with coding PL/SQL. • Monitor and tune Oracle database for optimum performance. • Oracle Realms – Federal, HR – to secure sensitive data. • Involved in informatica upgrade project and completed successfully. • Worked as a fire fighter and resolved long time pending performance issues. • Materialized views perfomance and refreshing them. • Management of schemas, objects partitioning the tables & indexes. • User management. • Perform other regular DBA activities including space management and performance monitoring. • Responsible for deploying the code in the production and have been taking care of most of the releases. • Limiting the user management and sensitive data access via – Oracle Advanced security tools – Oracle Database Vault – Data Masking. • Effective troubleshooting of Performance tuning problems in Oracle database. • Continuous monitoring of database performance during peak and non-peak loads using AWR. Show less



NetApp

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Support Manager - Operations/DBA Lead

  • Jan 2010 - Jun 2015

  o Responsible for managing NetApp's data warehouse operations/day to day activities. o Responsible for defining the IT strategy/enforcing constructive process o Streamlined the operational process o Involved in managing cost, time, quality, scope for the multiple concurrent data warehouse projects o Responsible for maintaining SOX compliance breach free environment o Conducting sizing & capacity planning for Oracle databases and management of schemas, objects partitioning the tables & indexes o Develop POC on new technologies & work with other architect teams to implement solutions. o Evaluating Oracle Patches, testing patches o Responsible for setting and managing user accounts, granting required privileges to users. o Prepared home grown scripts and also did reverse engineering for monitoring databases. Show less



Knowledge Solutions, LLC

• IT Services and IT Consulting
• 1 - 100 Employee

• DBA

  • 2009 - 2010

  o Identify application bottlenecks. o Monitor and tune Oracle database for optimum performance. o Optimize database statistics collection o Modified existing database queries to use cost base optimization for Oracle 10g. o Using Axibase other than OEM for extensive performance diagnosis and metrics o Used RMAN for backup and recovery. Performed backup validations using RMAN. o Defining and Implementation of backup and recovery strategies o Identify application bottlenecks. o Monitor and tune Oracle database for optimum performance. o Optimize database statistics collection o Modified existing database queries to use cost base optimization for Oracle 10g. o Using Axibase other than OEM for extensive performance diagnosis and metrics o Used RMAN for backup and recovery. Performed backup validations using RMAN. o Defining and Implementation of backup and recovery strategies



SiriusXM

• United States
• Entertainment Providers
• 700 & Above Employee

• DBA

  • 2008 - 2009

  o Migration of Database and applying patches whenever required o Designing appropriate Backup / Recovery Policies for databases. o Ensuring proper online and offline backup. Periodical reading and checking of backups taken. o Capacity Planning & Benchmarking using analysis from STATSPACK reports o 24 X 7 on call–support for both production and development databases with on-call pager. o Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc. o Work with Unix Administrator to allocate disk space, create volume groups and mount points for database o Maintenance of standby database. o Oracle Patch management on production servers. Show less