SUMMARY:

• An astute Oracle professional, self - motivated with around 6+ years IT experience as an Oracle DBA (versions 12c/11g/10g/9i) in Oracle products, both production and development environments spanning several industries: production, health care, financial services, and high tech.
• Installation, upgrade, maintenance, administration of multi-terabyte standalone and RAC on multiple platforms like IBM-AIX, Sun-Solaris, UNIX, Linux, Windows.
• Hands on experience in test, development databases, production support and day-to-day activity to ensure zero alert thresholds is met 24x7.
• Extensive knowledge and experience on Data Warehouse using ETL tools like Informatica.
• Experience with installation of Grid Infrastructure for ASM, RAC. Very good understanding of GpnP (Grid Plug n Play).
• Administered Oracle clusterware and resources on 11g and 12c using CRSCTL/SRVCTL.
• Migrated OS file system storage to ASM with minimal downtime and administered ASM disk groups and instance.
• Server side and Client-side fault tolerance achieved by configuring SERVICES and TAF (Transparent Application Failover).
• Proactively monitored and diagnosed symptoms using OEM (Enterprise Manager) to significantly increase the probability of success of production db and application.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities ESTAT/BSTAT, STATPACK, End-user tuning and troubleshooting using various tools like EXPLAIN PLAN, AUTOTRACE, SQL TRACE, TKPROF, AWR, ADDM, ASH, v$ performance views.
• Knowledge of Shareplex for Materialized Views, Good experience with Data Modeling to translate logical data elements into the physical database design.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) /Network Attached Storage (NAS)
• Experience with Toad Data Modeler using Erwin.
• Build complex entity relationship models - both logical and physical database design.
• Experience in resolving complex restore and recovery issues using RMAN.
• Experience in working on Remedy (Incident management / Change management) BMC Patrol.
• Experience working with Application development team in Release and Deployment Management processes.
• Experience in UNIX Shell Scripting for automating the DBA tasks like User maintenance, Performance Monitoring of CPU, Disk and Memory usage, and File system monitoring.
• Good Experience in Hot/Cold Backups, and Cloning of Databases.
• Knowledge of Business Continuity Volume(BCV) for database backups and refresh
• Extensive knowledge on database backup/recovery strategy (RMAN), Import/Export & Datapump, Capacity Planning, Replication (Streams) standby databases, Oracle configuration management, Dataguard, database cloning, refresh and patch management and Oracle Exadata Database Machine.
• Experience in Database Security and Auditing.
• Extensive knowledge in Korn shell and Perl scripting.

TECHNICAL SKILLS:

• Databases: Oracle 12c, 11g, 10g, 9i, 8i, 8.x, 7.x, 6.0 MS SQL Server 2005 and 2008
• Languages: C, C++, Java and J2EE
• Application server: Oracle 9iAS Release 2, Websphere MQ, Web logic, iPlanet
• Tools and Utilities: OEM 2.2, Forms6i, Reports6i, SQL*Loader, Oracle Workflow, Oracle PL/SQL, Designer 6i, Developer/2000, Discoverer 3.1(Administration & User) Visual Basic 5.0
• ERP Applications & Tools: Oracle Applications - 11i, 11.0.3, 12.0.6, 12.1.1
• ETL Tools: Informatica (Power Mart & Power Center)
• Decision Support Tools: Business Objects, Brio, Web Intelligence and Apache
• Web Technologies: Weblogic, IBM Websphere MQ
• Fusion Middleware: IDM, OIM, OAM, SOA, OBIEE and SSO
• Replication: Golden Gate, Streams and Oracle Advanced Replication
• Hardware: Sun Fire V880, Sun Ultra Enterprise 3500, Sun Ultra Enterprise 250/450, Acer Altros19000 DDE Org Supermax RISC Plus IBM, Dell 6600, Compaq Proliants, Compaq DL580, IBM Netfinity
• Operating Systems: Sun SPARC Solaris 2.x, Linux Red Hat Advanced server, HP-UNIX, IBM AIX Unix Windows 2000 advanced server, Windows XP, Windows 2003 and Windows 2008

PROFESSIONAL EXPERIENCE:

Confidential, O’Fallon, MO

Sr. Oracle DBA

Responsibilities

• Install, Setup and Configure Oracle Clusterware and database software.
• Performed upgrades to Oracle 11g from earlier versions of Oracle.
• Successfully upgraded databases to version 11.2.0.4 and applied latest PSU patches.
• Performed rolling Grid Infrastructure upgrade from 11.2.0.4 to 12.1.0.2
• Implement and enforce database security to meet PCI requirements.
• Plan and implement backup, recovery solution using RMAN.
• Plan and develop contingency solutions for supported databases.
• Perform ASM Installation, Migration & Configuration as per the requirements.
• Migration of Non-ASM standalone database to One Node RAC.
• Migration of Databases to Oracle Exadata machines using datapump import.
• Creation and setup of physical standby databases and oracle active Dataguard on exadata machines.
• Support for logical standby database.
• Manage RAC environment for Day to Day Database administrator, performance tuning.
• Securing stored data using oracle transparent data encryption by installing TDE wallet and creating encrypted tablespaces and storing sensitive data in encrypted tablespaces.
• Successfully performed Disaster recovery exercises for highest availability using DataGuard broker (DGMGRL).
• Performed database rolling upgrades and PSU patching.
• Provide the support for day to day database maintenance activities; planning & scheduling the changes.
• Enforce and maintain database audit and security standards for PCI standards.
• Assist and implement data model design changes in databases as per application projects and business requirements.
• Develop and implement high availability, scalability and disaster recovery solutions dataguard, replication, streaming & golden gate as per the application's business needs to meet the required SLAs.

Environment: Oracle 12c/11g 3-node RAC, IBM AIX, CRSCTL, SRVCTL, RMAN, ASM, Stats Pack, Physical Standby db, Data Guard Broker, OEM Grid Control, Data pump, SQL Developer/TOAD, SQL* Plus, Putty, SSH

Confidential, Jersey City, NJ

Role: Oracle DBA

Responsibilities

• Managed database on 11g R2 RAC.
• Wrote PLSQL jobs and scheduled via oracle scheduler to run daily.
• Excellent knowledge of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities
• Performed converting single node instance to RAC and Adding instance to the existing RAC
• Administered GI resources like ASM, SCAN Listener, node listener, OCR, Vote files using CRSCTL and SRVCTL utility.
• Successfully added nodes to the existing RAC cluster by extending GI and Oracle binaries.
• Troubleshooted Node eviction (split brain syndrome) issue due to flooded interconnect traffic.
• High availability and load balancing achieved with Services which was fully integrated with 11g/12c Grid Infrastructure.
• Perform Database monitoring, Tuning RAC.
• Client-side fault tolerance achieved by configuring TAF (Transparent Application Failover) in RAC as well as Data Guard env.
• Upgraded more than 15 db from 10.2.0.1 to 11.2.0.1 and then 11.2.0.1 to 11.2.0.2 including patchset updates using opatch.
• Wrote procedures/packages to load data using new SQL features like copy.
• Effective use of tuning packs like ADDM, AWR, ASH, Tuning Advisors to troubleshoot resource-intensive SQL, enqueues, locks.
• 50% improved Performance of fetching LOB data by creating partitions. Data footprint reduced by purging older partitions to lowered operational cost.
• Data migration using Data Pump export/import to bring historical data from application so to analyze the growth of db over a period.

Environment: Oracle 12c/11g 3-node RAC, OEL 5.8, IBM AIX, Grid Infrastructure, CRSCTL, SRVCTL, RMAN, ASM, Physical Standby db, Data Guard Broker, Flashback, OEM Grid Control, Data pump, TOAD, SQL* Plus, Putty, SSH

Confidential, Fort Lauderdale, FL 

Oracle DBA/SQL Server DBA

Responsibilities

• Installation, up gradation and Maintenances of Oracle Databases on Linux & Windows platforms.
• Used Shell Scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Proactively monitored the database and database access, and maintained the database security.
• Extensively worked under UNIX environment to provide DBA support.
• Installed, managed and administrated the MS SQL Server 2012/08R2/05 Production and Non-Production Servers.
• Worked on Client/Server tools like SQL Server Management studio (2008), SQL Server Enterprise Manager (2008) and Query Analyzer to Administer SQL Server.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Perform production system problem analysis and recommend corrective measures in a timely manner.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
• Perform database monitoring, capacity planning and performance tuning.
• Scripted jobs to refresh tables/schemas and databases as well.
• Generating AWR reports to deal with performance issue.
• Written scripts to monitor tablespaces, file systems.

Environment: Oracle 11g, 10g, MS SQL Server 2012/2008R2/2005, Query Analyser, Windows Server 2008, RHEL Advanced Server/Enterprise 2.1/3.0, OEM(Grid-Control), RMAN, AWR, ADDM, PL/SQL, SQL Developer, WinSCP.

Confidential, Holland, MI

Jr. Oracle DBA

Responsibilities

• Installation, configuration and maintenance of Oracle 10g/11g databases.
• Installation, configuration and maintenance of 11.2.0.3 Oracle Data Guard as a high availability solution.
• Installing and configuring physical standby database using RMAN duplicate from active database on RHEL 6.3.
• Possess strong RHEL and Solaris skills.
• Applying one off patches using OPATCH utility.
• Creating and managing application schemas with appropriate table spaces and Indexes.
• Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package
• Manage users, privileges and profiles, schemas using Oracle Grid Manager, Oracle Enterprise Manager (OEM) and SQL.
• Refreshing application schemas using data pump export/import
• Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Used RMAN to cloned and duplicated databases.
• Migrated databases from Windows to Linux using transportable tablespaces.
• Oracle 10g & 11g RAC, ASM, Data Guard (Physical, Logical standby), Enterprise Manager (EM) Grid Control, RMAN, Installation, Upgrades, Migrations, Performance Tuning Recent Experience.
• Creating and managing application schemas with appropriate table spaces and Indexes,
• Create public and private database links.

Environment: Oracle 11g/10g, SUSE 9.x, HP-UX, OEM grid control, TOAD, Data Pump, RMAN, AWR, ASM

Confidential,

Technical Analyst

Responsibilities

• Involved in gathering requirement, Analysis, Design.
• Created database objects including tables, views, synonyms, sequences, constraints, indexes.
• Created Pl/SQL Stored Procedures, Functions, Packages, Triggers, Cursors.
• Prepared migration documents & other documentations. Monitored db performance via STATSPACK.
• Participated in design reviews for upcoming application enhancements.
• Performed data extracts/loads in the testing environment using SQL*Loader.
• Assisted developers to troubleshoot SQL and PL/SQL code and increase the efficiency of execution.
• Created daily, weekly, and monthly DBA checklists for each environment.
• Documented database/server configuration for production, test, and development databases.
• Setup Crontab jobs to automate the routine tasks.

Environment: Oracle 9i, SQL*Plus, Pl/SQL, TOAD, SQL*Loader, SQL*PLUS, UNIX, VSS, OEM, Stats pack, QC