SUMMARY:
Over 7 Years experience as Oracle Database Administrator. Oracle 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 with experience within very large scale database environment and mission critical OLTP and OLAP systems. Excellent experience in migrating the Databases. Have experience on decommissionadatabase. Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management, and monitoring Experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB). Hands On Experience in installing, configuring and managing Oracle 11g R2 RAC, Oracle 10g RAC Experienced at using Oracle Enterprise Manager/Grid Control (OEM/GRID CONTROL) Performance monitoring and tuning with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 TRACE, AWR, ADDM. Successfully implemented physical Standby database using Oracle Data Guard feature for High availability configuration. Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation. Experience in Flash-Back Recovery, Data Pump, AWR, ASM, ASH and ADDM, Recycle Bin and Grid Monitoring. Migrated databases from Windows to Linux, Sun Solaris to AIX Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Knowledge on Oracle Support processes for technical requests through Meta link. Planning and scheduling for the backup of database information using UNIX shell script and Crontab jobs. Experienced in using Oracle\'s Transportable Table space (TTS) feature allows users to quickly move a user Table space across Oracle databases. Strong knowledge and experience of managing Oracle8i, 9i,10g and 11g RAC environments using the OEM Grid Control tools. Have extensive experience in performance and tuning of OLTP and Datawarehouse applications. Data transferring with Export, Import, Data Pump and SQL* Loader utilities. Experience in using packages like DBMS_JOBS, DBMS_SCHEDULER to schedule tasks and used DBMS_STATS to gather the statistics. 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 backup, incremental and cumulative backup. Skilled in database upgrades 8i to 9i, 9i to 10g R2 and 10g to 11g. Refresh/Cloning of Database and applications for development and testing purpose. On call 24x7 Production Support Worked beyond regular hours. Dealing with database security and auditing. Have extensive knowledge Oracle Application Server Administration (weblogic) Having good experience on Exadata 2.0 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. Knows perl scripting Worked As a DBA for Web Application Projects Knows Web logic environment Knowledge on Sybase working on the comprehensive set of database management software technologies that provide the crucial foundation for the Unwired Enterprise and enable you to manage and mobilize information from data centers to the point of action. TECHNICAL SKILLS:
Operating Systems:
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, PostgreSQL, Unix Shell Scripting.
RDBMS:
Oracle 8i/9i/10g RAC/11g RAC
Software’s, Applications and Tools:
DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, 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, EMC Storage, Metalink, MS Visio, Perl scripting
EDUCATION:
Bachelor of Engineering
Experience:
Confidential,Irving, TX December 2010 - Till Date
Sr. 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. Installation, configuration, maintenance and tuning of Oracle 11g and 10g databases. Upgraded Oracle Database from 9i to 10g, 10g to 11g. Applied CPU patches Migration of the database from Sun Solaris to IBM AIX, Windows to Linux. Expertise in recovering the database. Performed complete and incomplete database recovery. Configured and maintained Grid Control Repository and Deployed OMS Agents on different database servers. Automated the nightly RMAN backups Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes. PL/SQL Programming. Developed PL/SQL scripts for Extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases. Using the 11g Grid control, OEM for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc. Experience in taking backups with RMAN in both Catalog/ No catalog modes. SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and 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. Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same. 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. Experience in PostgreSQL Cloning databases using scripts as well as RMAN. Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication. Did Perl scripting for functional data Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables. Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc. Enabled the audit on all the dev/test databases, analyzed and reported the audit records about the suspicious activity in the database. Created a new debt recovery infrastructure with Oracle Exalogic. Elastic Cloud and Oracle Exadata Database Machine that will help us gain greater business agility, enhance forecasting, reduce the down time of our debt collection process, improve recovery rates and reduce costs Known’s website reporting design Strong Knowledge on writing Sql/DBA queries Monitoring the database storage and day-to-day activities. Have knowledge on RF Mobility and done website reports Table partitioning for better performance. Oracle Application Server Administration (weblogic) Worked on exadata environment Have good knowledge on Google Mapping ability to tie in graphical reports Knows Web logic environment and maintained database for web logic design projects Knowledge on Sybase working on the comprehensive set of database management software technologies Golden Gate installation and configuration. Replication using Golden Gate. Performed all aspects of database administration including installs, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader. Perform on Sybase IQ Database Design Environment: 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
Confidential,FL October 2009 – November 2010
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 Setup and configure Standby database for high availability by using Data Guard. Migrated & upgraded databases from Oracle 10g to oracle 11g Installed and implemented Golden gate to replicate data between databases. Replication using Oracle Streams. Documented instructions for migrating & upgrading databases. Refreshed schemas from Production environment to Dev/Test environment using exp/imp and expdp/impdp utilities. Wrote various shell scripts to automate tasks. Creating PL/SQL procedures for Extraction, Transformation and Loading of data Worked on PostgreSQL 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 db link for inserting large tables directly without taking export. Online index rebuilds 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 STATSPACK, AWR, ADDM Increased performance of sql queries by creating materialized views and by enabling query re-write. Perform decommissionof adatabase operation 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
Confidential,Pittsburgh, PA June 2008 – October 2009
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) 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,Dallas, TX October 2007 – May 2008
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,Hyderabad June 2005 – September 2007
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. Worked in a 24/7 supporting environment with ON-CALL rotation Environment: Oracle 10g, Oracle 9i, Oracle 8i, RedHat Linux, Sun Solaris, Windows, Shell Scripts, RMAN, OEM/Grid Control, SQL*Loader, Data Pump
Privacy Policy
