Oracle Data
Resume:
SREE INFOTECH LLC
AVINASH
Oracle Database Administrator
*****@************.***
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