Oracle Data
Resume:
RazK
Chicago, IL - *****
**************@*****.***
Summary:
Around 8 years of experience as Oracle Database Administrator, providing 24x7 production support.
Knowledge using database administrative tools such as Oracle Enterprise Manager (OEM) Grid control and Cloud (12c), SRVCTL, CRSCTL, CVU, ASMCA, ASMCMD, SQL*PLUS and TOAD.
Contribution of important role as a team member to provide 24x7 on-call production database support.
Experience using HP-UX, AIX, SUN SOLARIS, RED HAT ENTERPRISE LINUX and WINDOWS environments.
Experience in GoldenGate and SHAREPLEX for migrating the databases.
Experienced in installing and configuring UNIDIRECTIONAL and Bidirectional replication using oracle GoldenGate 11.2
Experienced in identifying and resolving GoldenGate issues between source and target
Expertise in Oracle GoldenGate, GoldenGate Veridata installation, configuration, troubleshooting issues with GG.
Excellent experience in installation and configuration of Oracle 9i, 10g and 11g in UNIX/LINUX and Windows environment.
Provided Expertise on best practices & use/implementation of Oracle Retail Solutions
Good experience in SQL, PL/SQL, Shell Scripting, Parallelism, Partitioning, Data modeling, OLAP, Logical and Physical data model using ERWIN, RMAN Backup and Recovery procedures.
Involved in meetings with data architects, modelers, developers and Database Administrators.
Expertise in maintaining Database Security using security compliance auditing.
Creation and Management of schemas, objects, indexes and table partitions.
Experience using SQL*Loader, Export, Import, datapump, PL/SQL, SQL*Plus, SQL*Net, BMC-SQL, Server Manager.
Involved in meetings with data architects, modelers, developers and Database Administrators.
Expertise in maintaining Database Security using security compliance auditing.
Creation and Management of schemas, objects, indexes and table partitions.
Involved as a team member for Implementation and integration of Oracle Retail (ORMS)
Experience using SQL*Loader, Export, Import, datapump, PL/SQL, SQL*Plus, SQL*Net, BMC-SQL, Server Manager.
Experience on Data replication using Snapshot, Materialized views, import/export and Streams.
Installation, Configuration of Oracle Data guard for Physical and Logical mode.
Migrating and upgrading the databases to higher versions.
Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases.
Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup, IBM TSM & LEGATO Storage Manager
Extensive performance tuning experience, specializing in SQL Plan Management (SPM), Operating System Tuning, SQL Tuning, Database/Instance Tuning and application tuning.
Good knowledge of Oracle Client, ODBC/JDBC thick and thin drivers and interfaces with front-end technologies like .NET/java applications.
Provide value added services to the company through experience, Oracle’s best practices implementation, testing, and excellent written and verbal communication skills.
Technical Skills:
Operating System: Red hat Linux, UNIX, Solaris, HP-UX, AIX, Windows
Databases: Oracle 8i/9i/10g/11g/12c, RAC 10g/11g Ms Access, SQL 2005/2008/2012
Languages: SQL, PLSQL, Java, C, C++, XML, HTML, ASP.NET, C#, UNIX shell scripting.
Web Servers: Apache, Web logic
Tools and Utilities(ORACLE): Import/Export, Data pump, SQL * Loader, SQL Trace, OEM, Explain Plan, STATSPACK, AWR, ASH, ADDM, RMAN, FTP, TKPROF, Golden gate, Streams
Other Tools: ERWIN, DB Visualizer, Microsoft Visio, Use cases, SQL Developer, OEM, VM ware, Filezilla, putty, TOAD, Query Builder, VNC, WINSCP, Golden gate.
Work Experience:
Plexus Corporation - Neenah, WI Sep 2015 -Present
Sr. Oracle DBA
Job Responsibilities:
Installation and configuration of Oracle GoldenGate on SUN SOLARIS and setup table and schema level DDL replication.
Configuration, Monitoring and supporting GoldenGate for Replication of data from source to destination.
Identifying and resolving errors through log dump utility, GGSEVT
Experience in managing the GoldenGate performance by reducing lag between source and target
Performed unidirectional replication from source to target database using GOLDENGATE.
Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
Upgraded existing Oracle 8i to Oracle 10g to meet the environment requirements.
Upgraded existing Oracle 10g to Oracle 12c to meet the application requirements.
Supporting the databases and ensuring their performance, availability and security.
Tuned memory structures such as the database buffer cache, shared pool and library cache.
Performed Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same also performed corrupt block identification and fixing.
Performance Tuning of Applications/Databases using various Oracle tools like SQL Trace, TKPROF, Explain Plan, AWR and ADDM.
Assist application developers to meet their day to day requirements related to performance.
Environment:
Oracle 8i/10g/11gR2/12c, Windows 2008, Sun Solaris 10, Sun Solaris 11, Red Hat Enterprise Linux 5, ASM, RMAN, FTP, Data Guard, OEM11 &12C,GoldenGate, TOAD, PL/SQL, SQL*Loader, GGSEVT.
State Streets - Irvine, CA Aug 2014 –Aug 2015
Sr. Oracle DBA
Job Responsibilities:
Performing day-to-day maintenance of databases and monitors database statistics; ensures that sufficient back ups are taken by operations to recover from any situation.
Part of team responsible for pre and post GO LIVE on production support.
Resolving underlying GO LIVE performance issues.
Carries out capacity planning and monitoring for the databases to ensure that disk space is adequate.
Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
Installation of 12c OEM and customize it to our needs.
Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
Configure and Monitoring Golden gate for Replication of data from source to destination.
Configure Golden gate to replicate one direction, bi-directional and master-master replication between Oracle databases.
Evaluation of user needs and porting of data from mainframe to UNIX platform.
Involve in managing very large database with 30TB in size on a 8 node RAC cluster
Supporting the databases and ensuring their performance, availability and security.
Defining the standards and checklists, to maintain the health of the server.
RAC to RAC physical standby configuration of dataguard for Disaster recovery requirement.
Built physical standby using RMAN Active duplication method as well for Disaster recovery site.
Achieve load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.
Develop appropriate polices and plans relating to database backup, recovery, and disaster recovery using RMAN.
Improve the database performance by Using the Hints, Indexes, Explain Plan and TKPROF for effective retrieval and processing of queries.
Generate AWR reports for performance analysis and tuning opportunities.
Environment:
Oracle 10g/11gR2/12c RAC, Windows 2008, Sun Solaris 10, Unix, Mainframe, Red hat Enterprise Linux 5, ASM, RMAN, FTP, putty, Data guard, OEM11 &12c,Golden gate, TOAD, PL/SQL, SQL*Loader.
Cargill Inc - Hopkins, MN Feb 2013 – July 2014
Sr. Oracle DBA
Cargill is the privately held producer and marketer for agricultural products, industrial products and also provides financial services.
Job Responsibilities:
Involved in 24x7 supports for Production database and applications with on-call pager.
Installed, configured and maintained Oracle 11g R2 on Linux also upgraded from Oracle 10g to 11g.
Installed and created of 10g RAC and 9i databases for Testing, Development and Production.
Installed RAC on Oracle 10g and using OCFS2 feature of Oracle.
Supported upgrades from Oracle 9i to 10g, 10g to 11g; 11g R1 to 11g R2.
Performed migration from 9i to 10g from AIX to Linux.
Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
Performed Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
Involved in Dimensional Data Modeling, Relational Data Modeling, Dimension Tables, Conceptual, Logical and Physical Data Modeling using ER Studio, ERWIN and Power Designer.
Created tablespaces, sizing the system tablespace, allocating default tablespaces for users.
Created tables and indexes, sizing their extent, partitioning and so on.
Created users with restricted access, with default and temporary tablespaces.
Created roles and granting to users based on their group requirements.
Resolved SQL tuning issues and Tuning Considerations for Different Applications.
Monitored the table growth, database growth, current users, and system resource usage and so on.
Implemented Data guard, creating both Logical and Physical Standby databases.
Experienced in SQL*Loader, loading data from text files.
Experienced in writing shell scripts for automating various database related tasks as well as for backups and restoration.
Cloned databases using scripts as well as RMAN.
Installed setup and configured Data guard.
Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
Performed scheduling of Change Control-activities and scheduling jobs.
Tuned SQL queries using TKPROF, EXPLAIN PLAN, and SQL TRACE.
Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities.
Wrote UNIX Shell Scripts to schedule these activities.
Contacted Oracle metalink to resolve database issues and to raise SR’s.
Environment:
Oracle 11g/10g/9i, ASM, HP-UX, Red hat Enterprise Linux 4.2, OEM, Explain Plan, SQL, PL/SQL, Tkprof, ERWIN Power Designer, SQL*LOADER.
DST Systems Inc - Kansas city, MO July 2011 – Jan 2013
Sr. Oracle DBA
Job Responsibilities:
24x7 Production database administration support.
Installed and Configured Oracle 10g/11g Database on AIX, Sun Solaris and Linux based systems.
Installed, configured and administered Oracle 10g RAC/Oracle 11g RAC
Installed, configured and administered Automatic Storage Management (ASM)
Administered and managed Production, Test, and Stage and Development databases involving various types of applications. Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same also performed corrupt block identification and fixing.
Administered Data Warehousing environments and OLTP applications.
Highly involved in performance tuning based on type of applications (data warehousing and OLTP).
Monitored and maintained databases with sizes ranging from few hundreds of GB to TB’s.
Installed and configured Data guard using physical and logical standby for high availability and reporting purpose.
Worked on shell scripts to monitor statistics, backups, and DB checks.
Reviewed database environments, such as database settings, monitoring Oracle user processes.
Working knowledge in Oracle Grid control.
Maintained the grid control alerts, configuring the rules, notifications, setting up metric settings, blackouts, advisors (Segment Advisor, SQL Tuning Advisor, Memory Advisor, SQL Access Advisor), and administration and performance tuning of databases and servers.
Upgraded databases from 9i to 10g, 10g to 11g and 9i to 11g.
Partitioned large tables to get the better performance and manageability.
Performance tuning using AWR, ADDM, EXPLAINPLAN, TKPROF, STATSPACK.
Involved in Capacity Planning for databases based on the future business growth requirements.
Environment:
Oracle 11g RAC/ 10g RAC, Oracle 9i, Grid Control, TOAD, RMAN, RedHat Linux, Sun Solaris 10, AIX 5.3, DB2
BCBS - Chicago, IL Jan 2010 – June 2011
Oracle Database Administrator
Job Responsibilities:
Installed Setup and configured 10g/11g RAC on Redhat and AIX using Automatic Storage Management (ASM). Upgrading from Oracle 10g to Oracle 11g database.
Provided support for all assigned projects, which also includes database backup and recovery, performance tuning, capacity planning and monitoring
Security compliance on all supported databases following internal and corporate security guidelines.
Configured Oracle Data guard for Oracle Disaster Recovery.
Configured physical standby databases for ACTIVE DATA GUARD.
Updated Database, Schema refresh and objects comparison using ERWIN
Configured Oracle Grid and RMAN based on environments.
Tuned SGA by Library Cache, Dictionary Cache.
Tuned OS by reducing paging/swapping.
Tuned I/O which includes separation of data files and redo log files
Demonstrated experience in working on Root Cause Analysis for Oracle database issues
Implemented database security and audit, removing default passwords, configuring permissions for binaries and secure other executables.
Used Query commands and Activity logs to check for problems and activities done.
Defined and modified Barcode rules or labels for the Tape libraries to provide auto adding of new volumes.
Performed User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
Implemented Change Control process for the Production Databases as and when required.
Served as Oracle DBA in a 24x7 Production environment managing several Database instances
Decided time for Backup process to take and implementing schedules accordingly.
Monitored Network performance of all clients for better backup performance.
Restored Data for Users in the event of requirement or Systems crash.
Environment:
Oracle 10g/9i, HP-UX 11i, AIX 5.2, SQL Server 2005, J2EE, ERWIN, TSM
21st Century Insurance – FL May 2007 – Dec 2009
Oracle DBA
Job Responsibilities:
24x7 on-call production database support
Installed and Configured 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.
Assisted 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
Contact this candidate