Data Oracle

Amit Kumar Singh

Mob:-678-***-****

Sunnyvale - CA

********@*****.***

Professional Summary

Oracle Certified professional having 14+ years of combined DBA (Cloud, Support and Lead DBA) & Techno-functional experience of Oracle Applications

10+ yrs. Oracle core & Apps DBA experience - Oracle E-Business Suite (EBS R11i,R12.1.x,R12.2.x), Oracle Database 8i,9i,10g,11g,12c including installation, configuration, administration, patching, cloning, upgrading, SQL & performance tuning, security, backup, recovery, HA and DR etc.

4+ yrs. Fusion Middleware DBA experience of Oracle WebLogic (11.1.1.6.x, 11.1.7.x), OBIEE 12c, Informatica 10, DAC, OEM etc.

2+ yrs. Oracle Cloud experience (OCI/OCI classic & AWS).

5+ years Technical Developer experience using Oracle SQL, PL/SQL and python, including Application & Database Architecture Design

10+ Yrs. RAC experience of installation, Maintenance on multimode cluster

6+ Yrs. Golden Gate experience of installation, maintenance and monitoring on bi-directional .

AWS configuration and administration.

Support Oracle 9i, 10g, 11g, 12c Database and RAC Database Administration of Production & UAT/Dev databases on Solaris, Linux and AIX env.

Good knowledge in Administration and Implementation of High Availability solutions with Oracle 10g/11g/12c RAC, ASM, Physical Standby Databases (Data Guard)

Managed container and pluggable databases cloned 12c database performed incremental backups using recovery manager.

Experience on version control system like GIT & SVN

Handling and managing IaaS and PaaS, DBaaS production and development environments.

Data migration from on-premise to Oracle Public Cloud. Handling Oracle Public Cloud databases and alone DBA managing Cloud and on-premise environment.

Managed Bare Metal Cloud Database Services, Oracle Database Cloud Services, RAC, In-Memory and Active Data Guard Options, Oracle Pluggable Database, PDB Hot Cloning and Refreshes, Availability Domains, Hybrid Public/Private Cloud, Oracle Database Backup Service, Oracle Database Vault, Oracle Real Application Security

Various Database upgrade from 9i to 10g,10g to 11g including 5 TB databases with cross platform migration.

Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM Grid Control and manual scripts.

Proficient in installation of CRS and 10g/11g/12c RDBMS in multimode node cluster and standalone server.

Installing, configuring and maintaining MYSQL and Maria databases.

Developed shell scripts for Oracle DB, session, process, deadlock, file system monitoring, free space in the tablespaces, free space in ASM disk groups and free disk space in archive log destination for production databases.

Performed DB/CRS/Grid patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.

Implemented High availability using Golden Gate Replication

Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.

Certifications:

Oracle 9i certified professional

Oracle 11g certified professional

Education: Bachelor’s in Engineering NIT Allahabad INDIA, (2004)

Projects profile:

1.Client: Linkedin Oct 2019– till date

Role: Senior Oracle Consultant

Sunnyvale CA

Employer: Flexton

Roles and Responsibilities:

Implemented High availability using Golden Gate multi master Replication

Manage a comprehensive and ongoing release management and planning program

Schedule and manage all performance tuning and troubleshooting efforts

Review, recommend and monitor the source code/versioning management function adhering to technical management guidelines

Utilize standard tools and methodology to develop system and support performance metrics

Deploy patch on system via version control system like GIT

Perform crisis management during high-severity operational incidents

Ensure system integrity, efficiency and performance through management of core system resources (CPU/Memory/IO Performance)

Following the problem management, change management and service management processes

Evaluate and manage existing software and licensing configurations, systems and the design, implementation and management of new/improved systems

Strong working knowledge of server hardware and OS technologies including Linux, and Solaris

Managing goldengate multimaster replication.

Python scripting to create MP

Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.

Performed DB/CRS/Grid patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.

Troubleshooting of Performance and Tuning problems in Oracle database

Setup of High Availability of the database using RAC, Standby, Data guard

Cross plateform database migration from solaris to linux server.

Environment:

Oracle12c,GoldenGate18c,Unix,shell,python,sql/plsql,ossh,github,RMAN,Dataguard,ASH,AWR,ADDM,oswatcher,SqlT,grid Rac12c,shell scripting,rb,ossh,i2cssh

2.Client: Riverbed Technologies Dec 2018 – Oct-2019

Role: Lead Oracle DBA

Sunnyvale CA

Employer: IIT Jobs

Roles and Responsibilities:

ScaleUp/Scale Down the OCI services. EE- Extreme performance - High Performance, EE based on business requirement.

Computing Power (Resource Allocation) Configuration

Metering Frequency Analysis and Selection

Storage Management from OCI classic. Monitoring and Capacity Planning

RAC Clustering Configuration

Installing, configuring the goldengate on many environments.

Upgraded the goldengate from 11g to 12c

Configure alerts in golden gate from cron & OEM.

Troubleshooting of GG abstract/replication issues.

Oracle Cloud Instance Creation. SSH Key Configuration and Deployment. Enabling Secure, Network Access

PDbs database refresh activity from OCI classic console. Deploying Linked Clone Databases from Snapshots

Backups to Oracle Storage Cloud Service Containers

CloudDB Monitoring (CPU And Memory utilization from PSM page).

Database/OAC (Oracle Analytic Cloud) Patching using OCI PSM tool.

Adding compressed tables, frequently used columns to In-Memory to get better performance.

Handling and managing IaaS and PaaS, DBaaS production and development environments.

Enhanced data access performance through partitioning, replicating objects and building indexes. – I monitored as well as troubleshoot database performance on memory utilization, slow running query, and from alerts logs. I resolved locks and wait events, load balancing and other performance derogation events that results from users, system, network and or job scheduling events.

Extensive experience in working with OBIEE Answers, Delivers, and Intelligent Dashboards

Experience in using Data Warehouse Administration Console (DAC 10.1.3.4) for scheduling and executing Incremental ETL loads.

Experience in Administering WebLogic 10.3.5 for OBIEE11g.

Involved in Unit Testing of Reports. Involved in Performance tuning of queries.

Coordinated the OBIEE .rpd and Web Catalog objects migration from QA to Production environment.

Performance Tuning of Dashboards/Reports/DB and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.

Data migration from on-premise to Oracle Public Cloud. Handling Oracle Public Cloud databases and alone DBA managing Cloud and on-premise environment.

Environment:

OCI, oracle-dbcs-cli Utility, dbaascli Utility, raccli Utility, dbpatchmdg Utility, In-

memory, Oracle 12c, 11g R2 RAC, Solaris,RHEL 7, Data Guard,Grid, OEM,

ASM,ASH, RMAN, AWR, Toad, Golden Gate, PL/SQL, Shell scripting,

3.Client: AT&T services Inc June 2013 – Dec 2018

Role: Lead Oracle DBA

Atlanta GA

Employer : Tech Mahindra Americas

Roles and Responsibilities:

Planning/Implementation/troubleshooting OracleRAC, DR, Standby HA database.

Managing more than 400 production/test/dev business critical databases of AT&T hosted across US datacenter. Production database size range from 500G to 8 TB.

Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.

Managing Oracle 10g/11g RAC (3-6 Nodes) database in production and development environment

Managing and troubleshooting Golden Gate databases replication issues.

Closely work with Dev and testing team to fix the performance issue.

Up gradation of database from 10g to 11gR2

Extensively use O/S commands, Oracle system tables TKPROF, AWR, ADDM reports and other 10 & 11i features to identify and fix performance/locking issues.

Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning

Installation of RAC on 4 node, 6 node cluster and standalone server.

UNIX Shell scripting and SQL scripting

Worked on OEM and Grid control for regular database maintenance

Setup of High Availability of the database using RAC, Standby, Data guard.

Raising SR with ORACLE for any issue.

Environment:

Oracle 12c, 11g R2 RAC, Solaris,RHEL 7, Data Guard,Grid, OEM, ASM, ASH, RMAN,

AWR, Toad, Golden Gate, PL/SQL, Shell scripting, AWS, EC2, EBS, S3, Route 53,

Cassandra, mysql/maria db.

4.Client: IBM (ABN AMRO) Dec 2011 – Nov 2012

Role: Senior Oracle DBA

Noida (INDIA)

Roles and Responsibilities:

Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.

Performed Logical backup using and full/partial export/import and Data Pump.

Core DBA Activities Patching, Upgrades, Database Refresh

Work with the change management team to schedule production changes

Working on backup strategy for production and UAT database

Refresh Production database with development to perform periodic testing using RMAN

Primary DBA for production, development and testing databases. Install and configuring Oracle database 9i, 10g, Linux. Implemented 10g flashback database features. Extensively worked on SQL Tuning using AWR, ADDM, ASH and tuning advisor in Oracle 10g

Oracle Application Server and Oracle WebLogic, installation, configuration, related utilities and tools

Resolve production tickets and work on root cause for permanent fix.

UNIX Shell scripting and SQL scripting

Grid control administration which include OMA installation, Upgradation, Patch applied and configure the agent, database, host, listener to the grid server

Monitoring Jobs running on different servers and working on issues related

Administering and Monitoring Apex jobs and Cron jobs

Worked on OEM and Grid control for regular database maintenance

Performance monitoring, Alert Log monitoring and backup monitoring

Environment:

Oracle 11g R2,10G, RAC, Solaris, RHEL 5, Data Guard,Grid, OEM, ASM, ASH, RMAN,

AWR, Toad, Golden Gate, PL/SQL, Shell scripting,,MySQL db,expdp,impdp,RMAN

5.Client: Oracle Corporation Nov2010 – Nov 2011

Role: Senior Oracle DBA

Bangalore (INDIA)

Roles and Responsibilities:

Creation of database on RAC and standalone server.

Performance tuning and identifying possible areas of improvement in test setup.

Installation of RAC on 2 node,3 node cluster and standalone server.

Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance Bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM

Performed DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.

Analyzing the netstat for any load on the network.

Perform root cause analysis on failures. Resolve performance tuning related issues and queries.

DBA activities such as configuring Grid events, Regular Backup's, Replication, Tuning, and troubleshooting performance issues.

Perform backup and recovery testing.

Migration of database from 9.2.0.6 to 10.2.0.3

UNIX Shell scripting and SQL scripting

Monitoring Jobs running on different servers and working on issues related

Worked on OEM and Grid control for regular database maintenance

Maintaining Physical Data-Guard Environment. Switchovers drills to secondary datacenters. Standby Refresh/Creation Using RMAN

Checking for errors in alert log and trace file

Environment:

Oracle 11g R2,10G, RAC, Solaris,Exadata,RHEL 5, Data Guard,Grid, OEM, ASM, ASH,

RMAN, AWR, Toad, Golden Gate, PL/SQL, Shell scripting,,MYsql db,expdp,impdp

6.Client: HSBC UK Sep 2008 – Nov 2010

Role: Oracle DBA

Pune (INDIA)

Roles and Responsibilities:

Installation of RAC on 2 node, 3 node cluster and standalone server and create db.

Performing V6.5 Netbackup testing for master and client netbackup server by doing lot of backup and recovery scenario on various flavor of Unix .i.e Solaris, Linux & AIX.

Perform backup and recovery testing.

Administering and Monitoring Control-M jobs and Cron jobs

Migration of database from 9.2.0.6 to 10.2.0.3

UNIX Shell scripting and SQL scripting

Creating users and database links, snap shots on production and development servers.

Grid control administration which include OMA installation, Up gradation, Patch applied and configure the agent, database, host,listener to the grid serve

Working with security team to move all oracle accounts into the PAR system.

Administering and Monitoring Control-M jobs and Cron jobs

Worked on OEM and Grid control for regular database maintenance

Used EXPORT/IMPORT to do table level and full database defragmentation

Work within the production support team and maintain operational consistency and efficiency

Environment:

Oracle 11g R2,10G, RAC, Solaris,RHEL 5, Data Guard,Grid, OEM,, RMAN Toad, Control

M, PL/SQL, Shell scripting,,MYsql,expdp,impdp .

Contact this candidate