Post Job Free

Resume

Sign in

Oracle Data

Location:
Plano, TX
Salary:
$65
Posted:
April 01, 2015

Contact this candidate

Resume:

SREE INFOTECH LLC

AVINASH

Oracle Database Administrator

972-***-****

acozx8@r.postjobfree.com

SUMMARY:

• Over 7 Years of experience as Oracle Database Administrator. Oracle

Exadata,Oracle12c,11g RAC/10g RAC/9i/8i databases running on different environments

such as Sun Solaris, HP-UX, AIX, Red Hat Linux, and Windows.

• Proficient in Oracle Database Administration activities such as Upgrades, Migrations,

Patches, Cloning,Backup & Recovery, Performance Tuning, capacity planning, shell

scripting, and documentation.

• Extensive knowledge on database administration for Oracle 8i, 9i, 10g, 11g and 12c with

experience within very large scale database environment and mission critical OLTP and

OLAP systems.

• Experience in upgrading databases from 9i to 10g, 10g to 11g, 11g to 12c.

• Proficiency in Dataguard administration such as Failover, switchover, Rebuild.

• Good experience Conceptual, Logical and Physical database design .

• Experience in OLTP/DSS database systems, implementing and managingVery Large

Databases(VLDB).

• Hands On Experience in installing, configuring and managing Oracle 11g RAC, Oracle 10g

RAC

• Performance monitoring and tuning usingEXPLAIN PLAN, TKPROF, STATSPACK, SQL

TRACE,, AWR, ADDM.

• Experience in regular DBA activities such as Upgrades, Patches, TAR

support,Cloning,Backups and Recovery, Performance Monitoring and Tuning, Capacity

Planningand documentation.

• Migrated databases from Windows to Linux, Sun Solaris to AIX.

• Good experience on Oracle Support processes.

• Data transfer with Export, Import, Data Pump and SQL* Loader utilities.

• Database backup concepts and options such as user-managed backup, RMAN incremental

backups.

• Refresh/Cloning of Database and applications for development and testing purpose.

• Good experience with GoldenGate setup & replication.

• On call 24x7 Production Support Worked beyond regular hours.

• Dealing with database security and auditing.

• Excellent communication, interpersonal and strong analytical skills, Documentation &

Problem-solving skills with customer service oriented attitude. A very good team player, self-

motivated, dedicated in any work environment.

TECHNICAL SKILLS:

Operating HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2,5.3,6.1,7.1 Red Hat Linux

Systems 4.x, 5.x,6.x, MS Windows 98/2000/ME/NT/XP/Vista

Programming SQL, PL/SQL, Unix Shell Scripting, Perl, Java, .Net.

Languages

RDBMS Oracle Exadata, Oracle 12c, 11g RAC, 10g RAC, 9i, 8i

Software’s, DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware,

Applications and SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, DB

Tools Artisan, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR and

ADDM, SQL Developer, Golden Gate

Web Related and HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, MS Visio, Perl scripting

Other Tools

EDUCATION:

Bachelor of Technology, Jawaharlal Technological University

PROFESSIONAL EXPERIENCE:

AT&T, PLANO, TX.09/2014 - Present

Role: Sr.Oracle DBA

Responsibilities:

• 24x7 production database and applications support

• Installed and Configured Oracle 12c RAC for high availability.

• Database upgrade from 11gR2 to 12c.

• Migrated databases from Windows to Linux

• Taking Oracle HOT, COLD backups, RMAN incremental backups.

• Clone database from production to development and testing.

• Support and advise the development teams on database related issues.

• Installed and Configured GoldenGate.

• Trouble shooting and performance tuning golden gate replication.

• Assisted developers in creating Stored Procedures, Triggers, Functions, Packages.

• Responsible for memory and Application tuning of the databases using Oracle utilities like

OEM, SQL Trace, TK Prof, Explain Plan, AWR, ADDM.

• Partitioning of large tables for better performance and management.

• Designed and implemented crash recovery strategies, and Hot, Cold and Logical backup

plans.

• Involved in root cause analysis, problem solving, issue tracking and support in production.

• Written scripts for custom monitoring.

Environment: Oracle 12c, 11g RAC, 10g, SQL Server, Red Hat Linux, IBM AIX, Data Guard,

ASM, PL/SQL, RMAN, GoldenGate.

Citrix, Fort Lauderdale, FL 01/2013 –08/2014

Role: Sr. Oracle DBA

Responsibilities:

• 24x7 on-callproduction database support.

• Installation and Configurations of Oracle 12c, 11g

• Configured Oracle 11g RACand Standby Databases for high availability and disaster

recovery/reporting purpose.

• Installation, configuration, maintenance and tuning of Oracle 11g and 10g databases.

• Upgraded Oracle Database from 9i to 10g, 10g to 11g, 11g to 12c

• Migrated databases from Sun Solaris to IBM AIX, Windows to Linux.

• Consolidated databases to Exadata.

• Implemented both unidirectional replication as well as bi-directional replicate using Golden

Gate.

• Upgraded production databases from 10g to 11g without downtime using Golden Gate.

• Expertise in recovering the database. Performed complete and incomplete database recovery.

• Writing and modifying UNIX shell scripts, Perl scriptsto manage Oracle environments

• SQL tuning and Database performance tuningusing SQL Trace, TKPROF, Explain Plan,

AWR, ADDMand monitor the database performance on daily basis.

• Planning Backup/Recovery Strategy, Planning and scheduling Backups, taking Logical

Backups (with Export/Import Data pump utilities).

• RMAN Incremental backups

• Logical and Physical Database Design

• Capacity Planning and bench marking

• Partitioning of the tables for better performance and manageability

• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback

segments, Constraints, Database Access, Roles and Privileges.

• Performed policies on data confidentiality, integrity, availability, and auditability, Based on

Access Controls for Access to Data at the database level.

• Performed SQL and PL/SQL tuning, oracle contention and monitored production database

using automatic workload repository (AWR), automatic database diagnostic monitor

(ADDM) and automatic session history.

• Cloning databases from production to development and testing.

• Database Security User Management, Privileges, Roles, Auditing.

• Provided documentation for database design, analysis, modifications, creating schemas etc.

• Golden Gate installation and configuration.

• Replication using Golden Gate.

Environment: Oracle Exadata, Oracle 12c,Oracle 11g RAC, Oracle 10g RAC, RedHat Linux, IBM AIX,

Sun Solaris, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer,

SQL*Loader, ERWIN, Data pump, GoldenGate

Citi Bank, Dallas, TX 11/2011 – 12/2012

Role:Oracle DBA

Responsibilities:

• 24x7 on-callproduction database support

• Installation and Configurations of Oracle 11g, 10g.

• Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and disaster

recovery/reporting purpose.

• Implemented Data Guard for Disaster recovery.

• Worked on Data Modeling, Dimensional Data Modeling.

• Setup and configure Standby database for high availability by using Data Guard.

• Upgraded databases from Oracle 10g to oracle 11g

• Replication using Oracle Streams.

• Documented instructionsfor migrating & upgrading databases.

• Refreshed schemas from Production environment to Dev/Test environment using

expdp/impdp utilities.

• Wrote various shell scripts to automate tasks.

• Creating PL/SQL procedures for Extraction, Transformation and Loading of data

• Created schema (tables, Indexes, views, sequences, synonyms, packages).

• Setup database auditing, granted privileges to users through system/object roles.

• Implement and maintain database security.

• Created PL/SQL Procedures, Functions, Triggers.

• Taking Hot and cold backups.

• Modified Data Using Perl Scripting

• Creating and managing partitioned tables and indexes.

• Monitor and tune database performance usingExplain Plan, SQL*Trace, TKPROF, AWR,

ADDM

• Increasedperformance of sql queries by creating materialized views and by enabling query

re-write.

Environment: Oracle 11g RAC, Oracle 10g RAC, HP-UX, RedHat Linux, Sun Solaris, Windows, Shell

Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, ERWIN, Data Pump

Super Media, Dallas,TX 06/2010 – 10/2011

Role: Oracle DBA

Responsibilities:

• 24x7 on-callproduction database support

• Installation and Configurations of 9i, 10g databases.

• Installed Oracle 10g RAC, Standby Databases for high availability and disaster

recovery/reporting purpose.

• Organizing Oracle Database operations, installation, creation, configuration of Databases,

laying out database tables and database schema design, startup and shutdown of Databases.

• Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database

objects/schema, Enforce database accuracy and integrity.

• Creating users and roles for database and give the privileges.

• Performance monitoring and tuning using Automatic Workload Repository ( AWR) &

Automatic Database Diagnostic Monitoring (ADDM).

• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the

Master Data Management Architecture involving OLTP, ODS and OLAP

• Automated the Replication process using Materialized Views for reporting databases.

• Using the ADDM to analyze performance problem and with help of AWR reports for

individual SQL statements. Analyzing recent session activity with an ASH report.

• Responding immediately to any critical conditions, and proactively to any developing

conditions, including: locking, corruption, disk spaces andPerformance issues.

• Cloning of production database to the test environment using Recovery Manager ( RMAN).

• Created Standby databases for Disaster Recovery, using Data Guard.

• Load data using SQL*Loader

• Backup and Recovery

• Created database objects like tables, views, indexes, partitions.

• Develop, document and enforce database standards and procedures.

• Setting Oracle Streams for replication between two databases.

Environment: Oracle 10g RAC, Oracle 9i, Sun Solaris, RedHat Linux, IBM AIX, HP-UX, Windows,

Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, Data Pump

21st Century Insurance, Florida 01/2009 – 05/2010

Role: Oracle DBA

Responsibilities:

• 24x7 on-callproduction database support.

• Installation and Configurations of 9i, 10g databases.

• Installed Oracle 10g RAC, Standby Databases for high availability and disaster

recovery/reporting purpose.

• Performed backup and recovery activities.

• Daily database administration tasks including backup and recovery using RMAN,

Import/Export.

• Designed the database schema and created any necessary database objects.

• Applied patches, upgraded databases

• Worked on all phases of the project lifecycle including mapping data requirements, data

definitions and construction of logical data models.

• Performance Tuning of Applications/Databases using various Oracle tools like SQL Trace,

TKPROF, Explain Plan, AWR and ADDM.

• Tuned memory structures such as the database buffer cache, shared pool and library cache.

• Assist application developers to meet their day to day requirements related to performance.

Environment: Oracle 10g RAC, Oracle 9i, IBM AIX, Windows, RedHat Linux, Shell Scripts, ASM,

RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, Data Pump

Andhra Bank, Hyderabad 10/2007 – 11/2008

Role: Oracle DBA

Responsibilities:

• Responsible for maintenance of production.

• Created tables, views, materialized views

• Database administration tasks included performing regular Hot & Cold Backups, Job

Scheduling.

• Managing Database Structure, Storage Allocation, Table/Index segments

• Cloned databases from PRODUCTION to create TEST, DEVELOPMENT and UAT

• Configured and managed OEM to stabilized oracle database into healthy environment.

• Monitoring Growth of tables and undertaking necessary re-organization of database as and

when required.

• Trouble shooting performance issues using Explain Plan and TKPROF.

• Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA

• Maintenance & modification of Shell Scripts.

• Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function

Based Indexes and Loaded bulk data with SQL*Loader.

• Develop, document and enforce database standards and procedures.

• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and

monitoring their growth.

• Troubleshooting and fixing database listener issues.

Environment: Oracle 10g, Oracle 9i, Oracle 8i, RedHat Linux, Sun Solaris, Windows, Shell Scripts,

RMAN, OEM/Grid Control, SQL*Loader, Data Pump



Contact this candidate