SUMMARY:

• Over 9+ years of IT Experience as an Oracle Database Administrator of real time challenging projects with system analysis, design including monitoring and maintenance. I have good exposure to all stages of designing and implementation of database and ability to understand Functional Requirements and Design Documents. I have worked in the domain of Aviation, Leasing\Loaning, Insurance, Healthcare and Real Estate.
• Database administration, development, production support, installation, configuration, upgrades, patches, backup and recovery, database security, auditing and storage management
• Installation and configuration of Oracle 8i, 9i, 10g, 11g, 12c databases in Solaris, Linux and Windows environment
• Expertise on performing cold, hot, full and incremental backups
• Designed and implemented centralized backups and recovery strategies using recovery manager (RMAN)
• Experience with Flashback and RMAN recovery techniques
• Planned and implemented Oracle 10g, 11g, 12c Standby Databases (Data Guard) for High Availability and Disaster Recovery (DR)
• Patching the databases with CPU/PSU on quarterly cycles or ad - hoc needs
• Installed and configured Oracle 12c Cloud Control and deployed agents on managed targets
• Configured RAC database instances with two to four nodes
• Experience in using and creating SQL, PL/SQL stored procedures, functions, indexes, materialized views, partitioned tables, packages and triggers
• Created and refreshed Oracle databases for development, test and stage environments
• Performance Tuning experience in identifying poor SQL statements using Explain Plan, Statspack, TKPROF, SQL Trace, OEM Cloud/Grid Monitoring, AWR, ADDM, SQL tuning advisor
• Leveraging the Oracle Support for Service Requests
• Experience in managing large OLTP and Data warehousing databases
• Creating shell scripts and dbms scheduler jobs for monitoring purpose
• Generating reports using BI Publisher for various monitoring and management reporting tasks
• Involved in Data odelling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases
• Excellent communication skills, strong analytical & logical abilities, problem solving skills and quick learning
• Attended Mongo DB Sessions.
• Also have created Databases on AWS cloud.

TECHNICAL SKILLS:

Databases: Oracle 7i, 8i, 9i, 10g, 11g, 12c, SQL Server 2005, 2008, 2016, Inventory, Informix, DB2, Mainframe, Sybase, Mongo DB

Operating Systems: Red Hat Linux, HP-UX, AIX, Sun Solaris and Windows.

Languages: SQL, PL/SQL developer, C, Shell Scripting, Python.

Utilities: RMAN, Oracle 10g Grid Control, Data Guard, SQL*Loader, EXP, IMP, Datapump, SQL developer

Tools: TKPROF, TOAD, EXPLAIN PLAN, AWR, STATSPACK, ASH, AUTO Trace, Toad, Pl/Sql, OEM 12c, Developer, ERWIN, appworx, putty.

Middleware tools: Weblogic, Tibco

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Oracle DBA

Responsibilities:

• Setup standby database using dataguard for 11g databases
• Primary support for 2 new applications and worked on all 3 phases of project dev, qa and prod with organizational impacts
• Install, configure and support Oracle databases for Business Systems environments
• Monitor database space and capacity, estimate sizing and growth requirements
• Plans, implements and maintain Oracle database backups via RMAN and maintains Backup and Recovery procedures
• Database refreshes, archiving and partitioning
• Migration of sql 2008 to Oracle 11g database.
• Work with vendors and application support teams to gather information, determine and implement resolutions

Confidential, Warren, NJ

Oracle DBA

• Maintain over 45 non prod databases
• Supporting QA environment for testing at the enterprise level
• Preparing databases for monthly enterprise level releases
• Refreshing QA databases with Production load for realtime testing
• Work with Developers and Business Analysts to understand the requirements and work on database structural changes
• Applying database JIRA tickets for db level changes
• Taking part in various projects for testing
• Setup and troubleshoot shareplex in environments
• Worked on converting File system to ASM
• Create materialized views, remote synonym or views for tables sync-up
• Worked on supporting highly critical Datagrid project
• Using flashback to rollback the changes based on business requirements

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

• Worked on DR testing
• Troubleshooting performance related issues for applications
• Implementing OEM 12c for the existing production and development databases
• Coordinating with Data Center and application teams
• Worked on VLDB

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

• Worked on Database Consolidation project.
• Upgraded databases to 11gR2
• Migrating databases to new servers
• Dataguard setup using RMAN duplicate
• Worked on SNAPCLONE feature of Oracle
• Implementing OEM 12c for the existing databases for the use of new features
• Configured and maintained RAC 3 node
• Worked on Databases of 3-4TB size

Confidential, Minneapolis, MN

Database Administrator/ Access Management Analyst

Responsibilities:

• Provisioning user access on various database platforms tun 10g, 11g, SQL Server 2005 and 2008, Teradata, Informix, DB2, Sybase, Mongo for over 1500 databases
• Worked on Red Hat Linux, HP-UX, IBM-AIX, Sun Solaris operating systems
• Solving problem tickets for database access issues
• Work on daily requests for user creation, modification or deletion
• Review and modify procedural documents
• Work on Unix shell script for automation of processes
• Attending to user related issues.
• Work on project activities including process improvements.