PROFESSIONAL SUMMARY:

• Over 11 years of experience as an Oracle Database Administrator/Architect and 5 years in MS - SQL Database.
• Installation, configuration administration, and performance tuning of Oracle Clusterware 12C/11G on ASM/ACFS. Upgrading/migration, patching of Oracle 12c/11g Grid, ASM Configuration, Setup, Performance tuning.
• Experience in Installation and Maintenance of Database and its Tools of various RDBMS versions of Oracle 11g/12c RAC and Standalone environmentsin OLTP/PLAP environments for High Availability and Disaster Recovery and managed databases (VLDB) of over 8TB in OLTP environments.
• Managed Oracle/SQL Server databases on Amazon AWS, database migrations to AWS using GoldenGate. Migrated Databases to Amazon RDS and EC2 instances.
• Expertise in Upgrading Oracle Development and Production databases and ensure that any new product usage or release upgrade takes place with minimal impact and Configuring the network environment to enable clients to connect to the database (ODBC and JDBC).
• Experience in database CPU/PSU and SECURITY patches to the database in RAC and Standalone Dev and Production environments
• Setup and Installation, configuration of OEM Cloud Control 12c/13C. Upgraded OEM Cloud Control from 12C to 13C, applying patches, deploying agents, deploying templates, incident management and developed database monitoring/health check alert scripts for database for HighPerformance, Capacity Planning.
• Extensive experience in Database Backups using RMAN (Full/Incremental) and traditional hot/cold backups
• Experience in Database Recovery using conventional hot & cold backups, RMAN and Block Media recovery, Flashback technologies to ensure Business Continuity. RMAN Cloning of databases using Duplicate and Active Duplicate.
• Experience in Database/Schema Data Migrations using RMAN, DATAPUMP, DB LINKS, TTS, Redgate between the databases. Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
• Installation and Configuration of Oracle DataGuard databases, Physical and Logical, Active DataGuard setup, DG Broker, Failover and Switchover configuration.
• Experience in Capacity Planning, Storage Reviews required to create and maintain both RAC and Standalone databases for development, testing and production usage.
• Installation, Upgrade, Configuration, maintenance and performance tuning of Oracle GoldenGate 11g/12C for Uni-Directional, Bi-Directional and Consolidation topologies.
• Configuration of Oracle Advanced Security by implementing Oracle TDE for 11g/12C databases and Database Redaction for Databases with PCI,PII, HIPPA data. Implemented User and Database security through user profiles, database auditing, Database Hardening through MSB scripts.
• Implemented Oracle Advanced Compression for tables, Data pump exports, RMAN backups to improve query performance and reduce storage costs.
• Experience in Carrying out database application performance tuning and testing using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, ASH and ADDM.
• Good knowledge of Architecture and Physical Database Design.
• Experience in SQL, UNIX scripting.
• Experience is DB level OS Administration in Unix/Linux and Windows Server Administration, Storage experience with EMC SAN storages, NFS.
• Experience in MSSQL Server Database 2008/2012/2014 , Administration, Installation, Support and Performance Tuning using Management Studio.
• MSSQL Server Backup and Recovery Scenarios of the Database/Schema.
• Experience in SQL Server DB Mirroring, Log Shipping, Replication, Data Migration.
• Proficient in SQL Tools such as Data Governance/Compression/Partitioning for SQL Server.
• Experience working in Waterfall/Agile environments.
• Excellent/Proven problem-solving skills with Result oriented, Self-motivated, Team Player and Ability to work independently.

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, SQL*PLUS, C, Java, Shell Scripting

Database: Oracle 12c, 11g RAC/10g RAC/9i

Operating System: UNIX, Solaris, AIX, HP: Unix, Linux, Windows 2005/2003/XP/2000/NT

Tools: Golden Gate, SQL*PLUS, SQL Developer, TOAD, SQL Navigator, PUTTY, OEM, RMAN, SQL* LOADER, Imp/Exp and Data pump, Humming Bird Connectivity, Cygwin-X

Other Technologies: ODBC, Crystal Reports, MS Office, Erwin, Database Design.

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

Oracle DBA

Responsibilities:

• Provided 24x7 support for Production, Development, and Test databases.
• Production database administration and support.
• Installed and configured Oracle GoldenGate with high availability for Replication.
• Troubleshooting Golden Gate Replication issues.
• Worked on Patching GoldenGate Homes, Migrating GoldenGate to hub servers.
• Supported databases on Exadata.
• Migrated several database from Oracle 11G to 12c pluggable database on Exadata.
• Implementation of High Availability solutions with Oracle 11g/12c RAC Standby Database.
• Refresh/Cloning of Database and applications for development and testing purpose
• Configured and maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Supported Oracle databases with Edition Based Redefinition (EBR), Transparent Data Encryption (TDE), Database Vault, Oracle Virtual Directory (OVD).
• Worked on Production releases to support database and GoldenGate activities.
• Worked on Performance Tuning of Databases, Oracle instances, SQL’s using tools AWR, ASH and applying baselines using tuning advisory.
• Monitoring oracle databases using OEM 13c cloud control and creating Metric Extensions to monitor GoldenGate processes and reports.
• Worked on writing shell scripts to Monitor GoldenGate, Database reports.
• Worked with database Functions, Procedure, triggers, synonyms, views, sequences and profiles.
• Created users, roles and granted privileges according to the business requirements.
• Works with management, peers and vendors to design and implement hardware/software configurations.
• Provided support for Production, Development, and test Databases.

Environment: Oracle 11g, 12c multitenant, RAC, Exadata, GoldenGate, SQL, PL/SQL, EXPDP/IMPDP, OEM13c, TOAD, RMAN, Sun Solaris, Red Hat Linux, Windows, Data guard, Autosys, BMC Remedy

Confidential, Moline, IL

Oracle DBA

Responsibilities:

• Provided 24x7 support for Production, Development, and Test databases.
• Production database administration and support.
• Supported databases on Exadata databases.
• Migrated several databases to Exadata machine.
• Installed and configured Oracle Golden Gate for Replication.
• Troubleshooting Golden Gate Replication issues
• Installation, Configuration and Administration of 11g /12c RAC on Exadata.
• Implementation of High Availability solutions with Oracle 11g RAC Standby Database.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Configured and maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked on Performance Tuning of Databases, Oracle instances, SQL’s using tools AWR, ASH, SQL Trace and Explain plan.
• Implemented backup and recovery procedures.
• Monitoring oracle databases using OEM 13c cloud control
• Installed and Configure OEM 13c, Configure grid control agents and Troubleshooting connectivity with Agents.
• Created different process documents for day to day DBA activities and make sure Databases are Audit compliance.
• Worked with database Functions, Procedure, triggers, synonyms, views, sequences and profiles.
• Created users, roles and granted privileges according to the business requirements.
• Works with management, peers and vendors to design and implement hardware/software configurations.
• Provided support for Production, Development, and test Databases.

Environment: Oracle 9i,10g,11g, 12c RAC,SQL, PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM12c, TOAD 12, RMAN, Sun Solaris, Red Hat Linux, Windows, Data guard, Sun clusters, Oracle Database Appliance, Patrol.

Confidential, Groton, CT

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support for both OLTP and OLAP (EDWD) databases.
• Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Standby Database (Active Data Guard), Replication.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Migration of all Oracle 9i/10g databases/clients to 11g.
• Migrated NON ASM databases to ASM databases.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export)
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Oracle data cloning between oracle 10g and 11g databases using Golden Gate.
• Written Shell scripts to monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Partitioning of large tables for better performance and manageability.
• Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
• Logical & Physical Database Design
• Capacity Planning and Benchmarking
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR and ADDM.
• Applying Quarterly patches and Version change patch bundles.
• Created users, roles and granted privileges according to the business requirements.
• Worked with Application Teams to resolve issues in data warehouse databases.

Environment: Oracle 9i/10g RAC/11g RAC, SQL, PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, RMAN, HP-UX, IBM-AIX, Sun Solaris, Red Hat Linux, Windows, Data guard, ERWIN

Confidential

Oracle DBA

Responsibilities:

• Provided 24x7 support for Production, Development, and test databases.
• Involved in Design and implementation of oracle 10g Data Guard both physical/logical standby databases for high availability and disaster recovery.
• Implemented Oracle streams for replication and configured tablespaces for streams administration at database and table level.
• Upgrade and Migration of Database’s from 10.2.0.4 to 11.1.0.6 and applying patches whenever required.
• Monitored Production Database Using O.E.M and Toad DBA Monitor tools.
• Recovering the database from any kind of crash with the minimum data loss.
• Database Recovery (both complete and incomplete) from different types of failure.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Responsible for maintaining Every Day Backups and also to maintain ASM and Disk Space.
• Performed Database Point in Time Recovery and Table Space Point in Time Recovery with the use of Transportable Table space.
• Applying patches quarterly (PSU, CPU, ONE-OFF) for security and to fix the bugs.
• Responsible for supporting the Oracle databases and ensuring their Performance, Availability and Security.
• Planning the size of the Database, Creation of Database and location of initial data files, redo log files and multiplexing them, editing database initialization parameter file whenever required.
• Implementation and release of Database changes as submitted by the development team.
• Create Production Support databases for testing every Week for developers using Data pump Impdp from Production Backups.
• Maintaining all database objects including Schemas, Tables, Indexes, Triggers, Sequences, Primary and Foreign keys, Views, and all Constraints.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, ADDM, AWR, EXPLAINPLAN, SQLTRACE and TKPROF.
• Maintaining Erwin for all the new database changes Implemented during each release.
• Responsible for the Database Builds on Test, Development databases and Monitor Production database during builds.
• Worked with cross-functional team of marketing team, engineers, and production planners to understand business process and develop functional specifications.
• Written Shell scripts to Monitor activates like availability of Database & Listeners, Space utilization, Gathering statistic for the cost base optimizer, Index rebuilding .
• Good exposure to oracle technologies like AWR, ASM, Flashback and Data Pump Import/Export.
• Worked on External tables for Loading Flat files into Database and also created flat files of existing tables for loading into different environment.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, Toad 9.0, RMAN, DBCA, ErwinLinux, Windows.