SUMMARY:

• Over 8 years of experience of Oracle Database Administrator including 9i/10g/11g/12c databases.
• Managed Databases on RHEL, OEL, CentOS, AIX, HPUX, Solaris and Windows.
• Proficient in Administering 10g, 11g and 12c Oracle Instances.
• Hands on experience in database administration and production support.
• Extensive work in database installation, configuration and upgrades.
• Proficient in Oracle quarterly patches.
• Worked on tuning SQL and instance for faster response time.
• Setup Disaster Recovery sites using Data Guard
• Written shell scripting to automate procedures and jobs.
• Excellent Experience as Production DBA with 24/7 supports.
• Expertise in Developing Recovery Manager (RMAN) scripts for database backup
• Build 2 - node and 4-node RAC clusters
• Extensive expertise in export import and data pump.
• Database Migration to Amazon Web Services (AWS).
• Managed ASM instances
• Upgrade databases
• Worked on Data Center Migration.
• Expertise in silent database installs
• Clone databases using RMAN restore/recovery methods and RMAN duplicated database methods
• Experience in tuning Different components and identifying bottle necks in performance of databases
• Hands on Experience in Performance tuning and optimization
• Analyze database performance using ASH, AWR and ADDM reports
• Creating and Managing Users, Roles and Privileges with required security implementations
• Expert in encryption for databases using Wallet Manager
• Database replication using snapshot, materialized views and advance replication methods
• Written shell scripts
• Setup replication using oracle GoldenGate.
• Managed databases on Exadata.
• Managed SQL Server 2008 and SQL Server 2012 instances.

TECHNICAL SKILLS:

• RAC
• ASM
• Data Guard
• ASH
• Scripting
• GoldenGate
• Performance Tuning
• AWS
• RMAN
• Patching
• AWR
• Security
• Exadata
• Instance / SQL Tuning
• OEM
• TOAD
• Exadata
• ADDM
• RHEL / AIX
• SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Provided Operations support of 10g, 11g and 12c Databases.
• Coordinated the migration of oracle instances to AWS.
• Setup the disaster recovery site using Oracle Data Guard.
• Managed databases on Exadata.
• Apply Oracle Quarterly patches.
• Setup instances on Amazon Web Services.
• Worked on Instance Tuning.
• Worked on SQL Tuning.
• Used Data Pump to refresh schemas.
• Performed backup, restore, recovery using RMAN.
• Cloned Databases using RMAN Duplicate.
• Setup alerts, threshold and jobs using 13c Cloud Control.
• Oracle 11g with Physical Stand by Data Guard.
• Written shell scripts.
• Managing users, profiles, roles and table space according to the requirement.
• Worked on Tablespace Management
• Analyzed ASH/AWR and ADDM reports and guided application team.
• Build 4-node 12c RAC Clusters.
• Migrated Oracle database from file system to ASM.
• Provided on-call support
• Worked with onsite and offshore teams.
• Setup GoldenGate replication.
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Used external tables and SQL*Loader to import data from flat files.
• Created Documents for DBA processes and Procedures.
• Refresh database and schemas using export/imports and data pump.

Confidential, St. Louis, MO

Oracle DBA

Responsibilities:

• Oracle 12c, Windows OS, Physical/Standby setup
• Create databases for new customers
• RMAN backup/recovery, Data pump export/import, off-site Disaster recovery servers
• Erwin Data modeling, Visual Studio source code management
• Routine Schema management, SQL tuning
• Windows Task scheduler, jobs/Alerts reporting
• Created Documents for DBA processes and Procedures.
• Refresh database and schemas using export/imports and data pump.
• Clone databases using RMAN duplicate database.
• Performed RMAN restore and recoveries.
• Managed databases on SQL Server.
• Installed SQL Server 2005 and 2008.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Performed Import and Export using Oracle Data pump utilities
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Used external tables and SQL*Loader to import data from flat files.
• Monitored database space requirements and adjusted for future needs.
• Worked on project to move from standalone servers to RAC
• Build physical Standby Data Guard.
• Practiced DR by performing switchover and failover using data broker.

Confidential, Hoffman Estates, IL

Oracle Jr. DBA

Responsibilities:

• Moved spreadsheets to Microsoft Access
• Moved Access to SQL Server
• Installed SQL Servers
• Apply patches.
• Deployment Microsoft office.
• Troubleshoot Database networking issues.
• Written and Fixed SQLs.
• Followed documentation.
• Worked with Developers with running any SQLs.
• Provided support to offshore DBAs
• Provided desktop support.
• Installed oracle client.
• Troubleshoot database networking issues.
• Applied patches on Windows.
• Applied CPU patches.