Occupation:Database Administrator |
Location:Carrollton, TX |
Education Level:Master |
Will Relocate:YES |
Description
Professional Summary Over 6 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g, 11g and 12c. Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills. Posses' excellent communication /documentation skills and strong aptitude to analyze and resolve problems. * Supported as Production and development DBA. Involved in Change/Release/Patch management and off-shore co-ordination, Product development, data center Migration, Upgrade and Integration. Administration including design, deploy, tune, trouble-shoot. Efficient to manage 50+DB. VLDB size in 5 TB. * Management of schemas, objects, USERS and PRIVILEGES 10g OEM Grid Monitoring. * Upgrade databases from 10g to 11g and 11g to 12c. Apply PSU and bug fix patch. Trouble-shoot upgrade process. * PATCHING: regular PSU patching, Bug Fixes, in Standalone and cluster environments for 10g/11g RDBMS. * Expertise in Database Space Management, experience in troubleshooting and performance tuning. * Excellent analytical and problem-solving skills, Sound judgment and use of initiative. * Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.) * Experience in using OEM, TOAD, Data Migrations using export/import. * Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM. * Database performance tuning using STATPACK, Explain Plan, AWR, ADDM, ASH. * Experience on working with data guard physical standby databases. * Created 12c multitenant container database using DBCA * Configured non-pluggable 12c database into pluggable container database. * Applied various patch sets released through critical patch updates. * Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER. * Manage Data Guard, Create Physical/logical standby. Detect archival gap. Fail-over, switchover. Open physical standby. Flashback of database. Configure 11g Active data guard. * Performed Backup/restore/recover using RMAN and user managed. Create backup/restore strategies. RMAN, UNIX script for backup. Logical backup of schema using expdp/impdp. Clone database. * PL/SQL objects creation. Create trigger/ function/ stored procedure/ packages. Manage cursor. Tune and trouble-shooting PL/SQL codes. Handle run-time errors. Write database Monitoring PL/SQL objects. * Performance, Tuning of databases using ADDM, AWR, explain plan, stats pack, TKPROF and dictionary views. Gather statistics, de-fragmentation of table, re-organize structure. Monitor memory, index, Schedule jobs, Partition pruning for big table. Top sql/session, bottle-neck issues. Tune init parameter. Full table scan and Index usage. * Loading data using Import/export/ sql loader. Purging /cleansing data. Used Data Pump. Estimate timing for imp/exp. Refresh schema. * Scripting - Shell, PL/SQL, SQL. Write script for Monitoring, maintenance. Audit and as per required. * Experience with mid-tier architectures, OEM, TOAD, Oracle grid-control. * Excellent Written and verbal Communication skills with a customer service oriented attitude. Knowledge on Oracle Support processes for technical requests with Metalink. Experienced with SRVCTL, CRSCTL, OCR and Voting Disk of 10g RAC. * Installing ASM environment and migrating database from NON-ASM to ASM. * Involved in process improvement, Oracle Server Installations / Upgrades/Patches, * Installed 11g Physical Data Guard in Maximum Performance Mode. Verify the Redo Generation, Redo Transfer and Redo Apply Services between the primary and standby database. Performed the Switchover, Switchback and Failure tests of the primary and physical standby and verified the successful catching up of standby with the primary DB. * Installation, setup and configuration of physical Standby Database using Active data Data Guard. * Recovering the database from Block corruption, Objects-drop and using TSPITR. * Setup DEV/TEST/UAT/QA environments from Production database using Snap mirror and RMAN. * Installed & Configured Oracle 11g Grid Control for monitoring over 200 Prod / Non Prod Hosts. * De-fragmentation/Reorganizing of database using Export/Import, Rebuild Index and move table. * Experience in migrating large databases up to three TB * Used Oracle streams * Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications. * Taking Periodic Backup of the databases and the software using RMAN. * Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption). * Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints. Environment: Sun Solaris 9.0/10.0, Oracle 10g/11gRAC, TOAD 9.0, sql developer 1.3, Informatica 8.6, Business objects 11.5, Database Tools/Utilities, Enterprise Manager, TKPROF, Explain plan, ERWIN 4.x, DBArtisan. Client: Lloyds Bank, UK Jan 2010 - Jan 2013 Role: Junior Oracle DBA Responsibilities: * Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database * Worked on the physical and logical designing of the database, which includes the distribution of data- files on different disks * Controlled and monitored user access to the database. Optimized the performance of the database. Tuned SGA data dictionary and set database parameters * Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability * Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes * Created primary database objects (tables, views, indexes) once application developers have designed an application * Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements * Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks * Allocated the separate rollback segments for the Batch processing jobs in order to speed up processing * Reorganized data files, identification and elimination of contention factors like I/O, buffers Environment: Oracle 10g and 9i, Sun Solaris, RHEL 5.3, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Erwin, STATSPACK
Accomplishments
Highlights:
Keywords
