SUMMARY

• Over 10 years of experience in Oracle Databases as Administrator in Enterprise level Database Administration, Management and Operations which includes MySQL, Oracle, PostgreSql, NoSQL DB(Mongo DB, Cassandra, Couchbase) Administration on 24x7 critical production and about 500Gb to 30 TB sizes. Management and Operations.
• Extensive experience in Installing, Designing and Managing Oracle 12C, ExaData, 11g RAC/10g RAC/9i/8i Databases on Windows, UNIX (HP - UX, IBM AIX, Sun Solaris),
• Installed/configured Oracle 11g/10g Real Application Clusters (RAC).
• Upgraded databases from Oracle 8i, 9i to 10g and Oracle 10g to 11g and 11g to 12C.
• Experience in a 24*7 Production Database support role.
• Extensive experience in Backup & Recovery (Hot, Cold, Logical and RMAN Incremental Backups)
• Expert in Performance Monitoring and Tuning of Oracle Databases on Unix/Linux platform using database tuning, SQL TRACE, TKPROF, Explain Plan, STATSPACK, AWR and ADDM.
• Experience in Table, Index Partitions for increased performance and for better storage management. Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability.
• SQL/T-SQL, Triggers, And Stored Procedure: Wrote SQL, T-SQL, Stored-Procedures and triggers. Assisted SQL developers to optimize SQL queries, Stored Procedures and Triggers
• Have worked on Backup and Recovery on Oracle, MySQL, PostgreSQL databases. I have experience in setting up automated scripts to run the backup.
• Done Benchmarking using various tools for Oracle, MySQL, and Postgres. (orion, Hammerora, swingbench, mysql slap, sysbench)
• Excellent experience in database cross-platform migration
• Expert in Installation, Configuration and Maintenance of Oracle Standby (Active Data Guard).
• Monitoring databases and setting alerts using Oracle Enterprise Manager/Grid Control
• Experience in database cloning/refresh, tuning, patch
• Experience in Writing Shell scripts.
• Experience in Capacity Planning & Benchmarking
• Excellent SQL and PL/SQL programming and debugging skills - Cursors, Functions, Stored Procedures, Packages and Triggers etc.
• Experience with Data Modeling, Logical and Physical database design.
• Excellent experience in managing Very Large Databases (VLDB).
• Experience in replication using Materialized Views, Oracle Streams and Golden Gate.
• Expertise in maintaining Database Security using auditing.
• Expertise in loading data from flat files using external tables, SQL*Loader.
• Proven ability to adapt to demanding schedules and changing priorities.
• Able to work independently and collaboratively in Team environment.

TECHNICAL SKILLS

Database: Oracle 12c, ExaData, 11g RAC, Oracle 10g RAC, Oracle 9i, Oracle 8i, Oracle 7.3, MySQL, SQL Server 2008

Operating System: Sun Solaris 8, 9, 10, HP-UX 10.x, 11.x, AIX 5.1, 5.2, 5.3, 6.1 Red Hat Linux 4.x, 5.x, 6.x,Windows 95/98/ME/NT/2003/XP

Languages/Tools: Unix Shell Script, SQL*Plus, PL/SQL, C, C++, OEM/Grid Control/Cloud, Golden Gate, dB console, RMAN, AWR, ASM, ADDM, STATSPACK, SQLTRACE, EXPLAIN PLAN, TKPROF, Data Guard, SQL*Loader, OUI.

Ticketing Tools: Bridge Clarify, LEO, Citrix-Xen APP(DWNG),RDI,DB Symphony, DB Unity, GTO Supportal

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Oracle Database Administrator

Responsibilities:

• Expertise in Database Space Management, Memory Tuning and Application Tuning, Expertise in troubleshooting and performance tuning. Having experience in Oracle Golden Gate 10.x, 11.x installation, Configuration, upgradation and administration.
• Expert in configuring cluster environments: Oracle 10g/11g RAC on Linux/Unix with TAF and Load Balancing, VCS (VERITAS Cluster Server).
• Designed and implemented Oracle Dataguard Physical and logical standby databases for disaster recovery. Administered Oracle 11g/10g Data Guard and troubleshooter client replication issues causing log latency
• Setup Oracle Enterprise Manager(OEM) & Grid Control for database monitoring/performance and Diagnostics.
• Installation, Configuration and Support of Oracle High Availability Solutions such as Standby Database with and without Data Guard Broker setup, Advanced Replication with Single and Multi-master setup and Oracle Streams Replication.
• Deployment Team: Assess and validate Scripts, Working with Developers and Sys Admins.
• Wallet creation and Transparent Data Encryption Under 11g, 12c
• Installation and maintenance of Oracle 12c/11g/10g on Linux OS, Window OS .
• Monitored database (RAC and STANDBY) and SQL performance, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Worked on application and database security (data access, passwords resets and users account managment, network, etc).
• Worked with different utilities like dataguard broker (DGMGRL), SRVCTL, CRSCTL and CLUVFY.
• Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches.
• Build Disaster Recovery sites using Oracle Data Guard.
• Experience in configuring, building and managing Oracle Redstack on multi-node RAC environment.
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Regularly involved with planning and scheduling Backups and Database Recovery.
• Automated many common tasks using different technologies like Autosys Jobs, crontab including: archive old records, purge jobs, proactive monitoring and verification of such processes.
• Configuration and Management of Data Guard 10g/11g on RHEL, OEL and Sun-Solaris
• Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) on 10g/11g
• Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicate issues.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.

Environment: Oracle 9i,10g,11g, OEM 10g/11g/12c, RMAN, Data guard, Sun Solaris 5.9, 5.10, AIX 6.1, RHEL 3.x/4.x,/6.x, RAC, ASM, Sql Developer, Autosys, SQL Server 2005, Netbackup, Virtual Change, ResolveIT, Microsoft Office, FDR backups.

Confidential, Sunnyvale, CA

Oracle Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Using SRDF Technology for maintaining of one node RAC on Most of the Linux Systems
• Using TSM for backup and archives push(both Disk and Direct)
• Upgrade RAC Databases from 11.2.0.3 to 11.2.0.4
• Applied various versions of PSU Patches (recent were - 11.2.0.3.5 and 11.2.0.3.8 ) on the RAC Cluster.
• Professional exposure to and use of Oracle 12c / 11g Automatic Storage Management (ASM) storage option deployed to support Oracle RAC and standalone databases
• Professional exposure to and use of Oracle 12c / 11g RMAN backup/recovery technology integrated to centralized backup solutions such as Veritas Netbackup, IBM Tivoli.
• Database CLONING from either PRODUCTION to Test or QA environment using RMAN utility, and also doing SCHEMA REFRESH using DATA PUMP Utility.
• Professional exposure to and use of enterprise level database Disaster Recovery solution using Oracle Dataguard 12c / 11g for Oracle RAC databases
• Expert in troubleshoot and fixing issue for different customers who log in Service Request. ORA Errors like ORA-600, ORA-7445, ORA-700 (internal error), ORA 24247 Access control list denied by server. ORA 28374: typed master key not found, 28365 DURING A BROKER SWITCHOVER WHEN USING A WALLET, 0RA-29024 Certificate Validation Failure, ORA-01031: insufficient privileges, ORA-01017
• Experience to Oracle enterprise monitoring technologies leveraging Oracle Enterprise Manager (OEM) 11g, 12c, TOAD
• Installation of 12c RAC 2 NODE WITH EXTENDED CLUSTER, HUB NODE and LEAD NODE. Also managing FLEX CLUSTER and FLEX ASM.
• 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 (ASH).
• USED PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and AUTOSYS scheduler)
• Handling databases sizes range from 500GB to 2 TB.
• Running RDA Tool (Remote Diagnostic Assistant) for checking prerequisites as a part of pre-upgrade check on the server.
• Recommending the ASG Team for the sufficient size of the oracle home, swap-space and kernel parameter settings specific to the platform, as a pre-upgrade task.
• Oracle RAC Dataguard Switchover and Switchback with Broker configuration.
• Oracle RAC Dataguard upgrade from 11.2.0.3 to 11.2.0.4 with physical standby in place.
• RMAN resync implemented on the standalone and RAC Environments.
• RMAN Duplicate for Cloning of the standalone to the RAC cluster.

Environment: Oracle 12c, ExaData, Oracle 11g Database, Red hat Linux AS4, 12c OEM, 11g Golden-Gate, ASM, RAC Cluster

Confidential, Seattle, WA

Oracle Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Installation, Configuration and Maintenance of Oracle 11g RAC/10g RAC, Standby database (Service Guard) for High Availability and Disaster Recovery
• Database upgrades from Oracle 11.2.0.1 to 11.2.0.4, 10g to 11g.
• Database migrations from windows to Linux
• Worked with Confidential on migrating SAN/NAS storage.
• Set up, configured and maintained oracle data guard(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication materialized views.
• Cloning databases using scripts as well as RMAN & Created duplicate databases using RMAN duplicate.
• Configured 10gR2/11gR2 12cR2 RAC with ASM on AIX/ RHEL servers and GPFS/Oracle cluster files systems and also configured workload management (both server side and client side Load Balancing).
• Implemented the MAA (Maximum Availability Architecture) having 11g Physical Standby Data Guard for 2 Node RAC System.
• Implemented the Oracle 10.2.0.4 Physical Data Guard in Maximum Performance Mode for re hosting of data center using Data Guard.
• Implementing GOLDEN GATE(Bidirectional) for replication, real time analysis, migration, upgrade without down time.
• Designed and developed logical and physical data models using CASE tools such as ERWin and Oracle Designer 10g and using manual methods as well.
• Setup backup and recovery procedures using RMAN and Net backup. Used hot backups and cold backups, incremental and full backups. Performed database cloning to setup test and development databases.
• Used Flashback technology to recover (Point-in-Time-Recovery) accidentally dropped or modified database objects.
• Perform other regular DBA activities including space management and performance monitoring.
• Worked on TSPITR using RMAN.
• Installed and configured bi-directional Golden Gate for High data availability and Operational reporting.
• Troubleshooting the issues on Oracle Data Integrator establishment and replication setup.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Performance Tuning use of SQL diagnostic (ADDM, SQL Adviser) and Oracle utilities like AWR.
• Worked with Oracle support on different types of ORA-600 errors.

Environment: Oracle 12c, ExaData, 11g RAC/10g RAC, Sun Solaris, Red Hat Linux, Windows, OEM (Grid Control), RMAN, ASM, Golden Gate, SQL*Loader, Oracle Data guard, Streams, TOAD

Confidential

Oracle Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Installation, Configuration and Maintenance of Oracle 10g RAC/11g RAC, Standby database (Service Guard) for High Availability and Disaster Recovery
• Upgraded of 10g Cluster to 11gR2 Grid Infrastructure along with 10g DB to 11gR2 db.
• Implementation of High Availability Architecture by Installing Oracle Cluster as part of Real Application Clusters (RAC) along with ASM and DB home.
• Implemented Oracle Duplication from Active DB very new feature of 11gR2 to build Physical Standby Database.
• Migration of Oracle 10g database from Linux to Oracle 10g RAC on HP-UX.
• Worked on Oracle exadata clusters, cell servers (exadata storage)
• Worked under ITIL frame work where in SLAs of 99.99% availability of production database is defined.
• Re-org of fragmented tables, indexes and partitioning also helps in achieving optimal performance. Apart from above methods I also worked on compression of old partitions for optimal performance of the queries run on old partitions.
• Supported data warehouse database on 8 node 11gR2 RAC database which runs on 14 exadata Storage Cells the very latest storage technology in the world of data warehousing. The projected size of database which is around 22 TB.
• Supported 5 way multi master replication using widely accepted and latest technology named Oracle Golden Gate and upgraded Oracle Golden Gate from version 10.4.0.12 to 10.4.0.90.
• Thorough testing and documentation is done before implementing any change.
• Upgraded databases from Oracle 8i, 9i to 10g and Oracle 10g to 11g
• Migrated Databases from Linux to HP-UX, Windows to LINUX
• Oracle RMAN configuration for backups to disk and tape. Implemented Backup & Recovery strategies and performed Disaster & Recovery drills
• Backup & Recovery (Hot, Cold, Logical and RMAN Incremental Backups)
• Planning and implementing Backup and Recovery procedures, scheduling daily backups and performed periodic recovery tests
• Database Design (Conceptual Design, Logical Database Design, Physical Database Design)
• Capacity Planning & Benchmarking
• Data Loading using SQL*Loader, External Tables. Writing PL/SQL procedures for Extraction Transformation and Loading (ETL) data.

Environment: Oracle 11g RAC/10g RAC/9i, Sun Solaris, HP-UX, Red Hat Linux, Windows, OEM, RMAN, ASM, SQL*Loader, Oracle Data guard, Streams, Golden Gate, TOAD

Confidential

SQL & ORACLE Database Administrator

Responsibilities:

• 24x7 Production database and applications support
• Managing multiple production, development, test databases
• Managed and Administrated the SQL Server 2008r2/2008/2005 and 2000 production and Non-production servers.
• Involved in the migration of SQL Server 2000 databases to SQL Server 2005.
• Authenticated logins and validated permissions.
• Evaluated data storage considerations to store databases and transaction logs.
• Maintained Expression (CTE), Data Partitioning, Snapshot Isolation.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Created Database Maintenance Plans for the performance of SQL Server, which covers Database Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure data optimization using EXPLAIN PLAN.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Developed automated backup and DBCC scripts for databases and transaction logs. Maintaining the database consistency with DBCC utility at regular intervals.
• Worked on log shipping for synchronization of database. Managed SQL Server using PowerShell.
• Writing stored procedures, triggers, and functions and maintained coding standards. Involved in database Normalization, logical and physical data modeling.
• Administering Oracle 9i, 10g, 11g databases
• Upgrade database from 9i to 10g, 9i & 10g databases to 11g
• Cloned/Refreshed databases from production database to test and development
• Creating Database objects like (Tables, Indexes, Views, Synonyms, Database Links, Materialized Views, PL/SQL Functions, Procedures, Packages, and Triggers etc.)
• Performing Hot Backup, Cold Backup, RMAN Incremental Backups, Maintaining High database availability for supporting non-stop Business Operations
• Implement and Maintain Database Security. Creating / Altering / Dropping Users as and when
• UNIX Shell scripting for the automation of backups, cloning/refresh, monitoring file system utilizations, status of various oracle and UNIX processes etc.
• Performance Monitoring and Tuning of Oracle Databases on Unix/Linux platform using database tuning, SQL TRACE, TKPROF, Explain Plan, STATSPACK, AWR and ADDM
• Partitioned large tables for better performance and manageability
• Writing PL/SQL procedures for Extraction Transformation and Loading of data
• Setup monitoring OEM/Grid Control

Environment: Oracle 11g RAC/10g RAC/9i/8i, HP-UX, IBM AIX, Red Hat Linux, Windows, OEM (Grid Control), RMAN, ASM, MS SQL Server 2008r/2008/2005, Windows Server 2008 advanced server NT.