PROFESSIONAL SUMMARY

• 8+ years of experience in Database administration on Unix operating systems, handling Terabyte Databases and have worked on Oracle 12C, 11g, 10g, 9i, 8i Software Development and Design.
• Expertise in both Core Database Administration, Oracle Applications DBA (Oracle 11i & R12), PL/SQL Development.
• Expertise in Real Application Cluster, Dataguard, ASM.
• Expertise in design and implementation of Disaster Recovery Solutions with Active Data guard, Oracle Fail Safe and replication using SRDF.
• Expertise in various database administration activities such as instance management, schema management, Security management, database migration, Performance Tuning in areas of Applications, Backup implementation, Recovery and Oracle Installation & Configuration, PL/SQL programming.
• Worked in 24/7 production Support as a Level 2 and Level 3 Database Administrator on Key Financial and multi - Terabyte Databases
• Expertise in handling and resolving Severity 1/ Severity 2 issues on Production environments
• Worked on Enterprise Backup and Recovery solutions Legato Networker.
• Hands on experience in Migrations of databases from various versions of oracle Databases.
• Well versed in Backup and Recovery using RMAN, hot backups, database Cloning, Logical Backups using Import/Export using Data Pump.
• Evaluating patches on requirement basis, applying bundled patches, CPU Patches on clustered, non-clustered and disaster Recovery environments.
• Good working Knowledge on Oracle Grid Control/Enterprise Manager tools.
• In-depth knowledge in analyzing performance tools of Oracle like Automatic Workload Repository (AWR), ADDM
• Performance tuning, Oracle Wait Event analysis and troubleshooting and isolating problems which are caused with Oracle waits.
• Identifying database hung Issues, Hot-Block issue identification, tracing oracle sessions degrading performance and fine tuning queries usage of Oracle utilities like TKPROF.
• Working closely with application teams for better application design/tuning, partitioning large tables, IOT’s, Indexes ( B-Tree, Reverse Key, Bit Map)
• Knowledge in usage of Oracle internal tools for debugging like Oradebug, OSWatcher, System State dumps, process state dumps. Root Cause Analysis for Issues of Oracle RDBMS, following up with Oracle TARs and getting technical solutions for BUGs and applying them. Handled Oracle several Internal Errors ORA-600 and ORA-7445
• Well versed with Oracle tools like TOAD, PL/SQL Developer, GRID control, knowledge in planning and Implementing physical and logical structures of a very small database to very large databases/warehouses.
• Very fluent in creation of Instances, Table spaces, IOT tables/ Partitioned tables/ Indexes, External Tables, Materialized Views, Bitmap Indexes, SQL*Loader, SQL Copy, PLSQL packages, objects, roles etc
• Client Connectivity tools like ODBC and JDBC. Experience in handling 3rd party vendors.
• Exposure to capacity planning for a database and hardware sizing.
• Exposure to writing Unix Shell scripts. Written shell scripts for automating routine DBA day to day activities and Dataguard environment verification scripts which will help in smooth switchover and failover process.
• Maintain MS SQL server versions 2008 R2 and 2012 . Involved in cross platform database migrations
• Good Exposure in Critical applications like financial, telecom, automobile domain projects, aircraft maintenance, manufacturing.
• Experience in software development life cycle and software development methodologies MSF, Oracle Apps.
• Strong background in relational database systems, internet application development/ implementation using many (Object) relational databases and object oriented technologies.

TECHNICAL EXPERTISE

Operating Systems: Sun Solaris, IBM AIX, HP-UX, SQL Server 2008, Windows-2003/NT/xp, RHEL, OEL

Databases: Oracle DBA 12C, 11g,10g, 9i, Oracle 11i(11.5.10), Oracle R12(12.1.3)

Disaster Recover Solutions: Oracle Data guard, High Availability Suite, SRDF, Snapshot database, Active data guard

Languages: PL/SQL, Java, Exposure to HTML

Utilities: Visual Source Safe, SOS (Source on remote site), TFS (Team Foundation Server) SQL Navigator, PL/SQL Developer, TOAD, Oracle GRID-OEM, Semantic-pc Anywhere, VMware, oracle virtualbox

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. IT Engineer (Core DBA, Apps DBA)

Responsibilities:

• Oracle Core DBA & Applications DBA:
• 24/7 level 2/ Level 3 Production Database support for Critical Key financial Systems, ERP Resolving Severity 1/ Severity 2 issues in production which can be of cluster issues, Performance related issues and explaining end users in simple terms
• Developed PL/SQL code to capture encryption and scrambling table/data activities by scheduling an automated jobs. Partitioned large tables to enhance faster querying
• Encrypting database exports and RMAN backups, Oracle SQL*Net network traffic
• Setup SSL based authentication for network data
• Identify and encrypt critical application tables or individual columns using TDE based
• Managing ASM, RAC, Data guard, VCS Clusters, worked on 9i, 10g,11g on Sun Solaris/OEL Installations, upgrades and patching of Oracle Databases, Cloning, Refresh of Databases
• Tuning queries effecting database performance, identifying indexes, partition of objects as part of tuning.
• Database Upgrade from Oracle 10g to 11g non-rac to rac.
• Managed Terra Byte Databases, Table space / Data file management
• Created LVM, creating Quotas and backups on linux and solaris machines. Change request and Trouble Ticket Management
• Root cause analysis for database failures and Oracle Internal Errors caused and create SR/TAR follow ups with Oracle
• Building the different RAC node configurations, Building the Physical Standby database (Data guard) on Oracle 10g, 11g Environment
• Performance management using AWR, ADDM, Stats pack reports, database maintenance and tuning instances
• Configuration of Active Data guard, Snapshot database
• Cloning OEBS (Oracle Enterprise business suite) in RAC Environment.
• Experience in Oracle OEM 12c implementation and operations in an enterprise scale
• Configuration of different environments under grid infrastructure
• Implementation of Active Datagurad(ADG) in OEBS environment(R12, 11g Release2)
• Administration, maintenance, and tuning of concurrent managers, monitor operations, schedule Concurrent requests.
• Using AD utilities like adadmin, adpatch, admrgpch, adctrl, adsplice etc. to maintain applications by compiling Apps schema, maintain application object menu, maintaining snapshots of the application using adadmin and adpatch utilities for application of patches.
• Diagnosing the performance bottlenecks of the database using the diagnostics pack.

Environment: Oracle 11g RAC, Oracle 10g RAC, Oracle 11i Apps, Oracle R12, Data Guard,, Grid Control, Netbackup

Confidential, Columbus, OH

Oracle DBA (Core DBA)

Responsibilities:

• Managed ASM, RAC, Data guard, Oracle Fail Safe Databases on 9i, 10g,11g on RedHat Linux, Sun Solaris and Windows
• Installations, upgrades and patching of Oracle Databases, cloning, refresh of databases
• Database Upgrade from Oracle 9i to Oracle10g,11g
• Managed tera byte databases, table space / data file management
• Reorganizing of Objects, resolved backup and recovery issues.
• Resolve Change Ticket and Trouble Ticket Management raised by the customers for all instances
• Automating DBA Tasks to simply management using PL/SQL, Shell Scripts
• Building the 6-node to 10 RAC node on Oracle10g, 11g and Linux environment
• Configure Physical Standby database (Data guard) on Oracle 10g, 11g environment
• Participating in Software Peer Review Process and database design.
• Cloning OEBS(Oracle Enterprise business suite) in RAC Environment, AS(10g) in cluster environment
• Configuration of different environments under grid type of infrastructure
• Patch Application in Dev, UAT, pre-Prod and production.
• Upgrading 11i to R12 and database from 10g to 11g R1/R2
• Configured SSO/OID(Single sign on with AD Integration), discoverer integration, PCP Configuration
• Administration, maintenance, and tuning of concurrent managers, monitor operations, schedule Concurrent requests.
• Trouble shooting performance related Issues in PROD, UAT and STAGING instances.
• Applying patches set updates, critical patch updates every quarter, research and install new products.
• Installation and configuration of Single or multi node APPS Middle Architecture with Load Balancing.
• Performed numerous application and database tuning assignments on Oracle Applications
• Managing and monitoring the use of disk space, memory, and connections on SQL server.
• Monitor all the production, UAT and developments boxes for any errors in the logs and fix them as needed.

Environment: Oracle 11g RAC, Oracle 10g RAC, Oracle 11i Apps, Oracle R12, Data Guard, SRDF, Grid Control, Legato Networker

Confidential, Auburn Hills, MI

Software Engineer

Responsibilities:

• 24/7 Production Support
• Installation/upgrade/patching of Oracle RDBMS, Oracle Application Server
• Installation/upgrade of Operating System, Hardware/Software RAID Configuration
• High Availability and disaster recovery solutions using Real Application Clusters, oracle dataguard, Sun HA suite
• Database migrations from Oracle 9i to 10g, 11g
• cloning/refresh of UAT and staging environments
• Performance tuning, backup, restore and recovery of databases
• Configuration and maintenance of Active Data guard and Snapshot database.
• Integrating backups with Enterprise backup solutions hardware sizing and capacity planning
• Automating DBA tasks like health checks, backups and scheduling cronjobs.
• Troubleshoot RMAN remote database connectivity issues and database net connectivity issues.
• 3rd party vendor follow ups for resolving technical issues.
• Implemented timely maintenance scripts like Transact-SQL, re-org, table fragmentation, analyzing statistics and troubleshooting errors reported.
• Managed security by defining roles and rights. Scanned the data pages, Indexes and checked the storage space used by each table.
• Monitored the growth of data volume and log space usage.

Environment: Oracle 9i - RAC, Oracle 10g, OFS

Confidential

Lead Team Member- DBA Software Engineer

Responsibilities:

• Database administration, preparing different environments and design.
• Customizing/Implementing the core modules like master entry, transactions, user management
• Database migration, installations, upgrades and developing the database objects
• Involved in requirements gathering for system hardware/data migration, validated their various users functional requirements.
• Setting up of Backup and Recovery for databases and testing Backups periodically
• Health Check and proactive monitoring and performance Tuning of Databases Confidential Client Location
• Setting up of development Environment and refreshing Development Site with Production data
• Automat day-to-day routine database admin work with PL/SQL, Shell scripts and scheduling jobs
• Patching of oracle RDBMS and oracle application servers
• As a lead team member, performed requirements analysis and database design from time to time as the client requirement changes, keeping the referential integrity and database performance in consideration.
• Developed special stored procedures for some of the critical operations such as Generating Globally Unique Identifier (GUID’s) by Using Java Stored Procedures in Oracle.
• Involved in Requirements gathering for System Hardware/Data Migration, Validated their various users functional requirements
• Linux, Solaris system installation, configuration, monitoring and troubleshooting.
• Creating partitions, including DNS, DHCP, Samba Server, Mail Server and Client configuration.
• Experience in creating LVM, creating Quotas and backups on Unix machines
• Designed Special Packages Those are used to handle Record sets returned by Oracle stored procedure, These packages creates Ref Cursor Type objects those Cursors Return different types of Record sets depending on the requirement
• By using above method client has adopted this database with very minor/without changes of code in Business Layer/ User Interface Layer

Environment: Oracle 9i, SqlServer 7.0, Java, Toad, Windows 2003 server

Confidential

Trainee Software Engineer

Responsibilities:

• Installation of RHEL 3/4 on i386 Machine.
• Installing Oracle 9i server binaries on RHEL 3/4.
• Applying upgrade patch, maintenance and interim (opatch etc) patches on all the databases.
• Refreshing Dev and test instances with data from Production on a regular basis.
• Create schemas, assign roles and privileges.
• Checking the Continuity of Archive Log Sequence.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab. LINUX Administration
• Solaris system installation, configuration, monitoring and troubleshooting.
• Manage setup, maintain groups and user accounts.
• Creating partitions, configuring mail Server and client configuration.
• Experience in creating LVM, creating Quotas and backups Windows Administration
• Implementing, administering active directories services (ADS) and group policies.
• Configuration of distributed file systems, delegating administrative controls, disk quotas and software deployment.
• Creation of domain users, profiles, groups and organizational units.
• Enabling and configuring SAMBA servers on Unix machines
• Installing, configuring, updating of DNS and DHCP servers.
• Configuration of IIS for websites and FTP sites.
• System performance tuning and troubleshooting any reported problems.

Environment: Oracle 9i, 8i, SqlServer 7.0, Java, Windows 2003 server