Oracle Database Dba

Ajay Kumar Chinta

E-Mail: ad5qu4@r.postjobfree.com

Mobile: 469-***-****

EXPERIENCE SUMMARY:

Solutions-oriented Oracle DBA with a proven track record of designing, configuring, supporting, and troubleshooting database management solutions demonstrated through 11+ years of experience and education in oracle database products. Aim to be placed in a challenging organization that gives me scope, update my knowledge and skills in accordance with the latest trends and be a part of team that dynamically works towards growth of organization.

Professional Experience:

A competitive professional having a total of 11+ years of experience in Oracle DBA & Apps DBA.

Experience on Oracle Applications 11i, R12 Installations and Oracle databases 9i, 10g and 11g.

Experience on up gradation of oracle database 10g to 11g.

Excellent in Administration and Troubleshooting skills of Oracle Applications ERP systems.

Experience on Applications Patching and Database Patching

Experience on Applications Cloning and Database Cloning using Cold, Hot and RMAN

Experience in Sys Admin Activities like creating users and assigning responsibilities including Security Maintenance.

Experience with RMAN, and standard backup and recovery procedures.

Excellent experience in production support, installation, configuration, upgrades,

Migrations, patches, performance tuning, backup, and recovery, cloning, space

Management, database security, auditing.

Expertise in development, testing and implementation of Backup and Recovery Strategy Using RMAN, Data pump and Export/Import utilities.

Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump, Hot and Cold backups.

Proficiency in standby database (Data guard) installation, configuration, maintenance, and administration for disaster recovery.

Expertise includes Oracle Databases (11g RAC/10g RAC/9i/8i), on UNIX (HP-UX, Sun Solaris, IBMAIX)/LINUX and Windows environments.

Extensive knowledge on database administration of Oracle 10g, 11g, 12c with experience on very large-scale database environment and mission critical large OLTP and OLAP systems.

Hands on experience in Installing, Migrating, Upgrading, Patching and Maintaining different oracle versions on HP-UX, UNIX, AIX, Linux and windows Platforms.

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

Proficient in PL/SQL, SQL, and UNIX Scripting

Good experience in SQL, PL/SQL, Shell Scripting, Perl Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.

Knowledge of MongoDB database concepts such as locking, transactions, indexes, sharing, replication.

Strong knowledge in Amazon Web Services in areas of Storage(S3), Compute (EC2, Container Services), Databases (RDS, Dynamo DB) & Networking (VPC, Route 53).

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

Golden Gate installation, configuration, troubleshooting GG issues.

Knowledge of maintenance of PostgreSQL databases.

Golden Gate DDL Replication and oracle Streams and Golden Gate for Site-to-Site Replication.

Installation and Administration of Oracle products such as Demantra, Oracle Application server, Demantra and non-Oracle products such as Kintana (ITG), Informatica, Outer Bay and Clear Orbit

Oracle Advance Supply Chain Planning (SCP/ASCP) and Oracle Demantra

Change Management in Production and non-Production instances through ITG Kintana applications.

Performs database re-orgs as required to assist performance and ensure maximum uptime of the database.

Administers all database objects, including tables, indexes, views, sequences, packages, and procedures and creating new instances when required.

Technical Skills:

RDBMS

Oracle 8i,9i, 10g, 11g and 12c

ERP Administration

Oracle Applications 11i, R12

Oracle Tools and Utilities

SQL* Loader, Putty, RMAN, OEM, OAM, Exp/imp, AD utilities, FND utilities

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH

Operating System

Linux 32 bit/64 bit, AIX, HP Linux, Sun Solaris and Windows XP, Windows2000

Programming Languages

SQL*Plus, PL/SQL, Shell Scripting, Microsoft Office, HTML, XML

Ticketing Tools

Remedy, Espresso, Central station, Jira

Third Party applications

Demantra, HP Kintana Applications (ITG for deploying scripts, forms, reports, objects), Source tree, Bitbucket

TECHNICAL STRENGTHS & CERTIFICATIONS:

Name of the Institution

Certificate

Discipline

Oracle Corporation

Oracle Certified Associate

Oracle Database 11g Administrator

Oracle Corporation

Oracle Certified Professional

Oracle Database 11g Administrator

Amazon

AWS Certified Solutions Architect – Associate

AWS Certified Solutions Architect

Project#1:

Client : Worldwide Express, Dallas, TX

Duration : Feb 2018 to till date.

Role : DBA Consultant

Responsibilities:

24x7 Production database and applications support.

Partitioning tables by determining the suitable methodology to improve performance and manageability.

Performed Database refreshes from Production to Development.

Refreshed schemas from Production environment to Dev/Test environment using exp/imp and expdp/impdp utilities.

Creating and maintaining users, granting, and maintaining the privileges, roles.

Involved in administration of over 50 Oracle 11g/10g/12c instances.

Handling monthly maintenance activities for oracle productions.

Handling all day-to-day activities including tuning of SQL/PLSQL, performance tuning, database auditing and managing user groups,

Database security, OS space monitoring, network issues, locking, database issues, etc.

Sizing the SGA, sizing the db. Buffers, shared SQL area, log buffer based on the requirements.

Applied CPU & PSU patches to ASM Grid Home and Database.

Coordinated with Oracle support for SR to resolve Oracle bugs and ORA-600 errors.

Documented all Oracle database installations and database operations.

Created Procedure to track backup tables and drop backup tables based on LAST_DDL time stamp.

Used analyze table, analyze indexes to tune queries and increase performance.

Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.

Created User accounts, Roles and granting required access permissions and privileges .

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).

Partitioning and re-organization of tables and indexes.

Code Migration and deployment activities

Installed OHS servers and BI Publisher on servers & Expertise working with BI XML Publisher

Worked on OEM 13.4 upgrade.

Installed OEM 13C, registering databases, creating OEM users, deploying agents, monitoring databases, registered Databases in OEM Administering Oracle Database 10g, 11g and 12c using Enterprise Manager.

Worked on AWS Database Migration Services for migrating data from Oracle to RDS & migrated data from oracle to PostgreSQL (data lake).

Proficient in AWS services like RDS, EC2, S3, Autoscaling Groups (ASG) RDS, IAM, CloudFormation, CloudWatch, CloudFront, CloudTrail.

Assisting the team with performance tuning for ETL and database processes

SQL knowledge and performance tuning of SQL. Master of relational database concepts and implementation

Environment: Oracle RDBMS 11gR2, OEM 13c, Oracle Apex, BI Publisher, RAC 11g, AWS (EC2, S3, RDS, Cloud Watch, CloudFormation, AWS Auto Scaling), GIT, SQL, Jira, AWS CLI, Unix/Linux, Shell scripting, Jenkins,

Project#2:

Client : Apple, Cupertino, CA

Duration : Mar 2014 to Jan 2018

Role : DBA Consultant

Responsibilities:

Monitoring and maintenance of Production databases.

Table partitioning, Monthly Tablespace partition and Purge old data regularly.

Monitoring growth of the databases to take proactive action. Managing Tablespaces, Temporary Tablespace, Tables, Indexes etc...

Handling the customer issues through Incident tickets.

Creation of tablespaces, adding datafiles to tablespace.

Database cloning and renaming the databases using control file.

Creating and maintaining users, granting, and maintaining the privileges, roles.

Handling monthly maintenance activities for oracle productions.

Killing hung sessions on all databases which are causing locking.

Proficient in performance tuning using Explain Plan, TKPROF.

Partitioning tables by determining the suitable methodology to improve performance and manageability.

Performed Database refreshes from Production to Development.

Refreshed schemas from Production environment to Dev/Test environment using exp/imp and expdp/impdp utilities.

Locks, long running sessions, scheduling jobs and alerting based on the metrics.

Apply RDBMS patches using OPatch.

Analysis of database performance reports e.g. AWR and ASH reports.

Database object tuning like partitioning tables, tuning indexes.

Oracle table partition(s) orchestration i.e. splitting partitions, merging partitioning, purging partitions, defrag partitions etc.

Find top SQL queries consuming more CPU and memory and provide action plan for the changes.

Tuning queries and recommending changes to improve performance.

Analyze application performance and identify issues. Perform issue RCA

Provide potential solutions to performance issues Explain advantage and disadvantages of solutions to performance issues.

Analyzing growth of Tables and creating partitions and maintaining them.

Applications covered in SCI like SAT, Demantra, CTB, GPT, Octopus etc.

Database administration includes proactive monitoring, troubleshooting & performance tuning.

Participate in DBA on-call rotation as part of 24*7 support during the freeze period.

Responsibilities as Oracle Apps DBA: :

Responsible for Cloning the Oracle Applications using Rapid Clone according to the client require.

Handling changes requests like code migrations& patching activities.

Creating and maintaining users, granting, and maintaining the privileges, roles and managing the resources with profiles.

Responsible for downloading the required AD patches and for Pre-Patch analysis.

Oracle EBS User administration and Concurrent Programs/Managers administration

Responsible for Cloning the Oracle Applications using Rapid Clone according to the client require.

Environnent : Oracle RDBMS 12C/11gR1/11gR2, Oracle eBiz Applications 11.5.10.2/R12.2, AIX, OEM, Demantra, ESSBASE applications.

Project#2:

Client : Meritor, Chennai, Ind

Duration : Dec 2011 to Feb 2014

Role : DBA Consultant

Responsibilities:

Working on 24/5 &weekend on-call support

Handling the customer issues through Incident tickets.

Handling monthly maintenance activities for oracle ERP productions.

Handling change requests like code migrations& patching activities.

Creating and maintaining users, granting and maintaining the privileges, roles and managing the resources with profiles.

Monitored and diagnosed database performance through monitoring of alert files, trace files and log files of different services.

Cloning of Oracle Application Database.

Administered and Troubleshooting of Oracle applications Server issues.

Responsible for downloading the required patches and for Pre-Patch analysis.

Patching Oracle EBS Application systems and ad utilities and PSU patch analysis

Application and database User, concurrent, form and Session tracing.

Responsible for Cloning the Oracle Applications using Rapid Clone according to the client require.

Administrating software and tools in line with the client’s requirements

Developing and maintaining an up to date knowledge of practice area specific Oracle products and services

Oracle EBS User administration and Concurrent Programs/Managers administration

Standby Database creation and maintenance and DR configurations.

Setting up, configuring Oracle Streams between the two databases (Schema level)

Datacenter and Storage migration from EVA to EDS/HP

Proven experience in data modeling, data management, data warehousing, data transformation, metadata, and reference data

Change control administration for Environments with HP ITG Tool

Participated in DR DRILL activity during Datacenter migration.

Configured the DMZ for restricted access on standard apache for I supplier portal for 4 productions

Configuration of Kintana ITG workflows for new environments.

Installed the Demantra application on Wintel (2008 server) box and configured with the production schema.

Configured third party tools like (Clear orbit, Matrix listeners, oracle configurator) which are integrated with e-Biz instances.

Migrated distributed HP-Outer Bay application and resolved all printer issues.

Handling create & maintaining users, granting and maintaining the privileges, roles and managing the resources with profiles.

Monitored and diagnosed database performance through monitoring of alert files, trace files and log files of different services.

Environment: Oracle database 9i/10g/11g, EBS 10.7/11.5.10.2, MS-SQL Server (2008, 2012), RHEL 5/HP UNIX/ORACLE SORARIS 8/9/10, outer bay (HP), Kintana ITG (HP), Clear Orbit (TAKE Supply Chain), Informatics for loads, web portal for reporting, Kintana applications, OTM, ASCP, DEMANTRA, VCP.

Contact this candidate