SUMMARY:

• 10 years of total IT experience and worked as an Oracle Database Administrator on Linux and windows platforms, which includes Installation, Management, Administration, Backup and Recovery, Maintaining and Tuning of Oracle RDBMS.
• Experienced in supporting Oracle databases 9i/10g/11g in variety of different environments like HPUX, Sun Solaris, 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.
• Experience in configuring Data Guard - - Physical Standby and Logical Standby Databases.
• Exposure in upgrading OEM from 11g to 12c and upgrading the databases from 9i to 10g, 10g to 11g .
• Tracing out the SQL s in prod databases using tkprof and tuning them by making use of SQL profiles using OEM.
• Good experience Conceptual, Logical and Physical database design.
• Experience in OLTP/DSS database systems, implementing and managing Very Large Databases (VLDB).
• Solid knowledge on AWS (AMAZON WEB Services) and Sybase database.
• Hands On Experience in installing, configuring and managing Oracle 11g RAC, Oracle 10g RAC
• Performance monitoring and tuning using EXPLAIN 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 Planning and 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 Golden Gate 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:

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 4.x, 5.x,6.x, MS Windows 98/2000/ME/NT/XP/Vista

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

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

Software s, Applications and Tools: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Cluster ware, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, DB Artisan, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR and ADDM, SQL Developer, Golden Gate

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

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Oracle DBA/ Database Analyst

Responsibilities:

• Providing production support for 24X7 database availability for Oracle Database.
• Maintenance and monitoring of oracle 11g/10g database instances hosted on Linux and Sun platform.
• Oracle DBA activities such as configuring Grid events, Regular Backup’s, Replication, Tuning, and troubleshooting performance issues.
• Created check point table, did Data load using Expdp and Impdp for replication in Golden gate.
• Installed and Configured GOLDEN GATE Extracts/replicat for multiple databases.
• Configured and built heartbeat monitoring in Golden Gate.
• Configured error handling for restart, logging, production support and status reporting in Golden Gate.
• Implemented Oracle Data pump and stream instantiation, created single and multiple source environment: s, managed LCR s in Oracle Streams.
• Involved in support for 1TB 2 Node production RAC database with on-call pager.
• Simulate a copy of production databases into test databases for application upgrade testing.
• Support and advise the development teams on database related issues.
• Created database instances using appropriate INIT.ORA parameters for efficient database operations
• Assisted developers in tuning SQL statements in the applications.
• Space Management which includes table space creation, adding new data files
• Managed Table spaces, Rollback Segments, Redo Logs and other database object.
• Oracle installation, creation of database, which includes physical and logical design.
• Assisted developers in Creating stored procedures, Triggers, Functions, Cursors and Packages.
• Responsible for monitoring and resizing Oracle database objects (Table spaces, Tables, Indexes etc,).
• Responsible for memory and Application tuning of the databases using Oracle utilities like OEM,SQL Trace, TK Prof and Explain Plan,
• Partitioning of large tables for fine tuning performance.
• Designed and implemented crash recovery strategies, and Hot, Cold and Logical backup plans.
• Taking periodic Backup of the Database and the software using Recovery Manager and VERITAS.
• Perform Instance tuning using tools like Stats pack etc.
• Generated regular Stats-Pack reports for the performance tuning of the databases.
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.
• Experience with DBUA/Export and Import to migrate the database.
• Responsible for optimizing data access and performance by tuning indexes.
• Performed Replication of the Production database for setting up instances for the QA and Testing teams.
• Hands on experience in writing UNIX Shell Scripts.
• Involved in developing logical and physical modeling of the database using Erwin 7.4.3.1.
• Extensively worked on VM Ware for virtualization.
• Developed automated functions and processes for optimizing performance of the databases.
• Scheduling jobs through job scheduler and Oracle scheduler.
• Managed the existing databases by applying new required release modification to existing database structure and applied new Oracle patches as required.

Environment: Oracle 11g RAC, 10g, SQL Server, Red Hat Linux, IBM AIX, Data Guard, ASM, PL/SQL, RMAN, GoldenGate .

Confidential, Fort Lauderdale, FL

Sr. Oracle DBA

Responsibilities:

• 24x7 on-call production database support.
• Installation and Configurations of Oracle 11g, 10 g .
• Configured Oracle 11g RAC and 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 and exposure to 11g to 12c.
• Excellent Confidential putting standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• 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.
• Trouble shooting and performance tuning golden gate replications.
• Implemented necessary monitoring scripts for Golden gate in unix/perl scripting.
• Expertise in recovering the database. Performed complete and incomplete database recovery.
• Writing and modifying UNIX shell scripts , Perl scripts to manage Oracle environments
• SQL tuning and Database performance tuning using SQL Trace, TKPROF, Explain Plan, AWR , ADDM and monitor the database performance on daily basis.
• Involved in ETL Code review of interfaces mappings
• 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 Confidential 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 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, Golden Gate

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• 24x7 on-call production 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 instructions for 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, Confidential ransformation 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 using Explain Plan, SQL*Trace, TKPROF, AWR, ADDM
• Increased performance of sql queries by creating materialized views and by enabling query re-write.

Environment: oracle Exadata, 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

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• 24x7 on-call production 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 and Performance 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

Confidential, Florida

Oracle DBA

Responsibilities:

• 24x7 on-call production 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

Confidential

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