Occupation:Database Administrator |
Location:Los Angeles, CA |
Education Level:Bachelor |
Will Relocate:YES |
Description
Professional Summary: * Over 7 years of professional experience as an Oracle Database Administrator encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, RAC, Data Guard, Grid and Enterprise Manager. Expert knowledge of Oracle Database 12c/ 11g/ 10g /9i / 8i including installation, administration, migration, backup/recovery and troubleshooting. * CERTIFIED in ORACLE and ITIL. * Expert knowledge of implementing, administering and troubleshooting Oracle RAC. * Skilled in designing and implementing complete life cycle client servers and database applications with various development tools. * In depth knowledge of RMAN, Data Domain, Grid Control and Oracle Enterprise Manager. * Experience in developing and successfully implementing backup and disaster recovery plans. * Installation and administration of Oracle on OEL, RHEL, Windows, HP-Unix, IBM-AIX and Sun Solaris in OLTP and OLAP environment. * Provide day-to-day, hands-on technical support of Oracle based production, pre-production and development systems running on various platforms. * Executed the scripts and provided to my development team. * User account maintenance, log file maintenance and database backup/copying. * Creating new users and granting privileges. * Proficient in setting up the network connections (i.e. setting up Listener and TCP/IP Connections). * Having good experience using oracle utilities such as DBCA, DBUA, ASMCA and NETCA. * Experience in Installation, Configuration and Maintenance of Oracle 12c/11g/10g RAC with ASM and single instance database. * Upgrading databases from 11g to 12c versions. * Configured and replicated databases using Oracle Golden Gate. * Good knowledge on Golden Gate Unidirectional and bidirectional replication. * Involved in construction of Disaster Recovery (DR) for all the production databases. * Performed Database refresh from production to QA, development databases and testing environments. * Responsible for setup and implementation of two and three node RAC on 11g. * Adding a new node to existing cluster for minimizing the downtime, maximizing availability and also achieved load balancing by minimizing the interconnect traffic. * Migrated single Instance database to RAC Environment and NON-ASM databases to ASM using RMAN. * Created and monitored database objects like Tables, Indexes, Views, Users and DB links. * Performed Migration and Upgrade of databases to 11g and 10g. * Extensive experience in Oracle Upgrades, Critical Patch Updates (CPU), Patch Set Updates (PSU) and other oracle patches. * Configured, managed Physical and Active Data guard in 11g. * Solid experience in database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies. * Backup, Recovery and Cloning of databases using RMAN also profound in using the new oracle 11g features in these utilities. * Installation and configuration of RMAN with and without Recovery Catalog. * Extensive experience with Backup and Restore methodologies using Native and third party tools (LITE SPEED, NetBackup, and Red Gate) to/from Disk or Tape. * Experience in implementing many types of High availability solutions such as Clustering, Database Mirroring, Log Shipping, and Replication. * Have good knowledge and experience in designing database schemas per business requirements. * Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing at different levels, and analyzing security problems. * Implemented data transfer using Transportable Table Spaces, Data Pumps and Export/Import utilities. * Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF. * Experience on Data Replication using Snapshot, Materialized views, import/export. * Implementation of Flashback Technology. * Proficient in writing PL/SQL Procedures, Functions, Triggers and UNIX Shell Scripting. * Data transferring and refreshing with export/import utilities, Data Pump utility. * Good understanding of database block corruption. * Experience in troubleshooting and resolving problems during the regular maintenance of Oracle database. * 24/7 Production Support and performance tuning of production instances in Oracle 9i/10g/11g on Sun Solaris, Linux, UNIX and Windows platforms. * Provide expertise in the following areas: Database performance tuning, capacity planning, maintenance patching and new version installation, Client installs and Toad. * Possesses excellent analytical, problem-solving and learning skills as well as a keen interest in the emerging technologies. * Good written and verbal communication skills, self-motivated team player and good analytical thinking. * Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment. It is a universal bank with operations in retail wholesale and investment banking as well as wealth management mortgage lending and credit cards. It has operations in over 50 countries and territories and has around 48 million customers. Barclays was the most powerful transnational corporation in terms of ownership and thus corporate control over global financial stability and market competition. Responsibilities * 24 7 production Support for production systems * Installing and configuring CRS on all cluster nodes with ASM Configuring public private virtual IP addresses for the servers shared storage for Voting disk and OCR on raw volumes * Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances. * Installation and Maintenance of Oracle 9i 10g 11g on IBM-AIX LINUX and Windows platforms. Upgrade Oracle 10g 9i on Sun Solaris AIX HP-UX Redhat4 to 11g. * Initiated 10g new feature implementations such as Automatic Storage Management RAC Flashback features DBMS Scheduler ASSM and ASMM to improve performance and manageability. Implemented the Oracle 10g Physical Data Guard in Maximum performance mode for production system in case of disaster recovery maintained primary and standby databases. Applied Patches on RAC Standalone Standby databases based on the requirements. * Evaluated mix of backup and recovery methods based on organizational needs. Implemented tested and documented various backup/recovery scenarios for knowledge base. Wrote scripts for Backup of databases maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery. * Database Refreshing / Replication from production to testing using Exp/Imp. Performed Table Partitioning created Index Organized tables and Locally Managed Tablespaces. * Monitored and provided weekly reports on the server's memory disk and CPU I/O using HP tools and UNIX command-line utilities. * Planned and configured disk layout mount points and capacity requirements for servers. * Provided maintenance of user accounts privileges profiles and roles. * Upgrading the software from 10.2.0.1.0 to 10.2.0.3.0 and 11.1.0.1 to 11.1.0.6. * Generating the necessary convert and transport scripts required for cross platform migration from Sun Solaris to HP-UX Using RMAN CONVERT DATABASE migrated the database into ASM enabled 2 node RAC Monitoring space wait events locks and long operations running on the database * Monitoring the session waits for the database performance and resolving the performance issues. * Monitoring the database for growth and added space to the table spaces as per demand. * Generating AWR/stats pack reports on regular basis to identify the database performance at peak load. * Tuning the SQL statement by analyzing the explain plan and ADDM reports * Design and implemented capture apply propagation process in oracle streams. Resolved various issues related to oracle streams and stabilized the streams. * Supported activities that involved studying troubleshooting and resolving the issues as per the severity.
Accomplishments
Highlights:
Keywords
