SUMMARY

• Over 10 years of experience in System Analysis, Design, Development and Administration on Oracle 9i/10g/11g/12c/18c/19c Database.
• Upgraded the Databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.3 to 12.1.0.0 and applied patches according to the client requirement.
• Around 3 years of experience in MS SQL SERVER 2012/2008R 2/2008//2005/2000 Database
• Administration and Development in Windows environment.
• Around 2 years of experience in PostgreSQL 9.4 Database Administration
• Good experience in setting up and administration of SQL Server, PostgreSQL and Oracle databases
• Worked on DB2 z/OS/AWS/kafka/mango environment.
• Awell - organized, goal-oriented, highly motivatedandeffective team leader/member with excellent analytical, troubleshooting, and problem-solving Skills.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in Installation, Configuration, up gradation and Maintenance of Oracle Databases.
• Installed, Upgraded and Maintained Oracle RDBMS on Linux, UNIX & Windows platforms.
• ACHIEVED High Availability, Scalability and Performance by determining the Cluster architecture choosing the best MPP RAC servers and hardware configuring the raw devices for Oracle RAC.
• Installed and Monitored Oracle 11g/10 g RAC software and experienced on Performance Tuning on RAC.
• Implemented advanced features of Oracle 11g/10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Experience in Performance tuning, Application tuning and Query Optimization using Oracle supported tools such as EXPLAIN PLAN, TKPROF, AUTOTRACE, etc.
• Hands on experience with tools like SQL*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM), and TOAD.
• Hands on Experience in Space Management, Capacity Planning.
• Creating Users, Roles and Profiles, Privilege management with role-based security.
• Backup of database Logical and Physical (hot and cold) using Backup script procedures and also using RMAN.
• More than 10 years experiences and solid hands-on experiences in installation, configuration, performance tuning and troubleshooting Oracle GoldenGate in Oracle to Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and Sybase/MySQL to Oracle).
• Firsthand experiences in setting up Oracle GoldenGate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions. Extensive skills in upgrading OGG 11gR2 to 12c, configuring OGG in RAC high available environment.
• Primary technical resources to upgrade Oracle GoldenGate from 11g to 12c in Exadata machine environment. Design GoldenGate HA solutions by using Oracle 11.2.0.4 Clusterware functionality.
• Deep understanding Oracle GoldenGate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicate. Developed home-cooked OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM (Oracle Enterprise Manager) 12c.
• Experience in Auditing and Capacity Planning, Configuring & Managing Hot Standby Databases (Data Guard).
• Ability to work under extremely tight deadlines and can maintain focus on objectives and processes and troubleshooting, implementation and development skills.
• 24x7 production database support.
• Keep abreast of current and emerging technologies to maintain skills levels necessary to provide quality service to customers.
• Effectively handle multiple tasks simultaneously and have ability to acquire and apply knowledge rapidly.
• Co-ordination with Oracle Corporation for technical support, new products and releases, technical discussion/support.
• Experience in using tools likeSQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance, Idera Diagnostic Manager
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c,13c
• Amazon Web Services;As a passionate advocate of AWS within Gracenote, I migrated my department from a physical data center environment to AWS. I also designed, built, and deployed a multitude application utilizing almost all of the AWS stack (Including EC2, R53, S3, RDS, DynamoDB, SQS, IAM, and EMR), focusing on high-availability, fault tolerance, and auto-scaling.

TECHNICAL SKILLS

Operating Systems: Oracle Enterprise Linux 3/4/5, Red hat Linux 2.1/3.0/4.0/5.0 , Sun Solaris 5.6/5.9/10, UNIX IBM AIX, HP-UX, Windows NT/2000/2003/XP/Vista/7.

Languages: SQL, PL/SQL, C, Bash & Korn Scripting, PERL Scripting.

Tools: /Utilities: SQL, Import/Export, Import/Export data-pump, RMAN, SQL*LOADER, AWR, STATSPACK, iSQL*PLUS, TOAD, ERWIN, Procedure-Builder, SQL*PLUS, Enterprise Manager Grid Control and Database Control, Knowledge of Oracle Internet Application Server, DBCA, OUI, Working, Knowledge of Data Guard.

DBMS Tech: Oracle 9i, 10g, 11gRAC,12c,19c,12c/13c OEM

Forms Server: Fusion Middleware 10g/11g12c Weblogic.

CLOUD Tech: AWS \ RDS \ EC2

Microsoft tools: Microsoft Office and Excel 2016/2010/2007/2003/2000

PROFESSIONAL EXPERIENCE

Confidential, Winston Salem, NC

Sr. Oracle database administrator

Responsibilities:

• Partitioning of the tables for better performance and manageability.
• Design implemented a solution which manage the Identity lifecycle of almost all applications with the enterprise, without directly controlling the identity store within the application.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Coordinating with business analysts on collecting requirements.
• Worked on Grid control Oracle Enterprise Manager 13c (OEM)
• Installation, Upgradation, Configuration and Troubleshooting GoldenGate 12c software.
• Configured GoldenGate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.
• Install, configure and support uni-directional Oracle-to-Oracle replicated environments utilizing Golden Gate for reporting.
• Using the GolgenGate Process to be masking the sensitive data for reporting.
• Masking the Critical Sensitive data using Oracle Masking process and implement the fully automation of masking process using EMCLI tool.
• Applying the PSU patch every quarterly for every Prod and Lower environment in the database and Yearly on Cluster using Rolling Fashion.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Creating the 12c multitenant cluster database for new application and provide the end to end support to configure the application to connect 12c database.
• Administer all WebLogic servers, domains, clusters in all environments: Production and non-Production
• Integrated Oracle Access Manager 11g, OID 10g/11g on WebLogic 11g with OHS 11g web server
• Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.
• Installed and configured Golden Gate JAgent to work with OEM GoldenGate Plugin.
• Performed Schema level and Table level data refreshes from Production to Development environments using Datapump EXPDP/IMPDP.
• Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.
• Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Setup of Standby database for faster disaster recovery and Data Guard setup for high availability.
• Taking periodic Backup of the database and the software using RMAN.
• Handling Database storage, Reading Alert. Log and User trace Files and Diagnosing the Problem, Scheduling jobs through Oracle job Scheduler.
• Planning and implementing DR & high availability solutions using Oracle 11g /12c Standby Database using Dataguard.
• Installing agent 12c on the server, scheduling Backups through OEM12c & Commvault backups.
• Configured Data Guard Broker and used for switchover and stopping and Starting Media recovery process.
• Implemented Fast Start Fail Over (FSFO) using Data Guard Broker in Production Environment.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Implemented Data Guard with maximum availability and performance configurations for production databases.
• Performance tuning of oracle databases using Sql Access Advisor, Sql Performance Analyzer, sql Tuning Advisor.
• Upgraded oracle 10g databases to oracle 11g R1 (11.1.0.6, 11.1.0.7) and 11g R2 (11.2.0.2).
• Degrade oracle RAC databases from 11g to 12c.
• Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.
• Worked on AWS Oracle databases for App migration.
• Worked on AWS Database Migration Services for migrating data from Oracle to RDS.
• Hands on experience in Implementing DataGuard High Availability Environment on RDS Oracle Databases.
• Worked on Configuring and installation of DataGuard Broker on AWS Servers.
• Supported Main DBA functions in RDS and documenting in confluence page.
• Worked on Developing a Lambda Function script for copying Audit files to S3 buckets.
• Developed a shell script for Audit enable/disable on RDS Oracle Tables in multiple databases.
• Published RDS capabilities and limitations documentation into confluence page.
• Worked on FGA for new RDS Oracle databases and created IAM policies to the users.
• Worked on Audit test by truncating the tables in the Oracle database and validated results.
• Supporting High Availability Environment and monitoring those databases for performance tuning.
• Worked on Implementing Disaster Recovery strategies for RDS Oracle databases and documented into confluence page.
• Hands on experience in Amazon Web Services (AWS) provisioning and good knowledge of AWS services like EC2, S3, Elastic Beanstalk, ELB (Load Balancers), RDS, VPC, Direct Connect, Route53, Cloud Watch, Cloud Formation, IAM, SNS etc.
• Configured and installed, involved using AWS services such as EC2, Data Pipeline, S3, RDS and EMR. Architecting new DBA solutions in AWS.
• Provide domain expertise of open-source and commercial relational DBMS products and services (Oracle 11g/12c, SQL Server, PostgreSQL, AWS RDS, AWS EC2 ) and NoSQL databases (e.g. MongoDB, Cassandra) databases.
• Defined AWS Security Groups, which acted as virtual firewalls that controlled the traffic, allowed reaching one or more AWS EC2 instances.
• Installed the application on AWS EC2 instances and configured the storage on S3 buckets.
• Worked on migrating Oracle databases to AWS RDS using utility AWS Database Migration Service (DMS).
• Worked on multiple databases available in AWS RDS such as Aurora, Oracle, MSSQL, MySQL, Cassandra, and PostgreSQL.
• Worked on converting schema from one DB engine to AWS RDS using AWS Schema Conversion Tool (SCT).
• Hands on experience in encrypting data using AWS Key Management Service (KMS).
• Worked on integrating KMS to AWS CloudTrail to monitor logs used by keys for compliance Databases.
• Worked on installing and configuring Active DataGuard (ADG) for AWS instances.
• Performed DBA activities using ADG in AWS are rolling upgrades and first patching on standby using physical standby.
• Worked on taking incremental backups on ADG and load balancing, service management across the replicated databases.
• Implemented and maintained the monitoring and alerting of production and corporate servers such as EC2 and storage such as S3 buckets using AWS Cloud Watch.
• Creating S3 buckets and managing policies for S3 buckets and Utilized S3 bucket and backup on AWS.
• Created an AWS RDS Aurora DB cluster and connected to the database through an Amazon RDS Aurora DB Instance using the Amazon RDS Console.
• Configured an AWS Virtual Private Cloud (VPC) and Database Subnet Group for isolation of resources within the Amazon RDS Aurora DB cluster.
• Hands on experience in Amazon RDS Aurora performance tuning.
• Developed scripts to proactively monitor and databases and alter the DBA on events such as running out of extents, disk space and actively involved in shell scripting for various CORN jobs to be run.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Involved in 24x7 support for 40TB, 3 Node productions RAC database with on-call pager.
• Expertise in OAG/OEG 11.1x-install, configure API policies, upgrade, administration, DMZ, Proxy setup.
• Expert in Vertex (v 7, 9) configuration, administration and integration with EBusiness Suite
• Working with the Oracle Support Mechanisms; My Oracle Support (Metalink), Raising Service Requests.

Environment: Oracle 10g, SQL SERVER, Oracle RAC on Linux, Toad, RMAN, SQL*Plus, SQLPL/SQL, SQL*LOADER, Oracle OEM, Import/Export.

Confidential, Torrance, CA

Sr. Oracle Admin

Responsibilities:

• Develops, documents, and rolls out standard process for implementing database and system patch upgrades and new Oracle 12c database environment build.
• Defines, refines, and standardizes database performance and tuning practices.
• Refines and manages baseline configurations for the MSRB database environment.
• Understanding of Agile/Continuous Integration Development practices; especially with Team City and Octopus Deploy.
• Good understanding of the organization’s goals and objectives.
• Migrated using Datapump Export/Import for small databases and non-critical databases and used DataGuard to Migrate huge and critical databases with 99% uptime.
• Managing database on 12c RAC and 11g R2 RAC
• Install, Configure and Administer Oracle products - Database (12c, 19c), RAC (10c,12c, 19c), Weblogic(11i,12c), SOA Suite, OBIEE, ODI, OAG, Discoverer
• Installation, configuration upgradation of BI/ODI, including bug fix patches.
• Support worldwide CRP/UAT for upgrade projects of ODI/OBIEE. experienceSSIS/ODI (Oracle Data Integrator) experience (developing, enhancing, tuning, and supporting ETL/ELT and data integration solutions using tools from Oracle
• Automates routine database functions to ensure accuracy and minimize costs.
• Establishes and practices a consistent database backup and recovery practice that complies with the MSRB backup and retention policies and business continuity practices.
• Performs migration of corporate database systems from Windows to Linux.
• Performs migration of corporate databases from Oracle 11g to Oracle 12c.
• Develops and follows upgrades procedures to ensure consistency within all MSRB databases.
• Conducts performance testing and reports on impact of Oracle 12c upgrade on MSRB applications.
• Enhances the MSRB data replication processes to reduce the amount of time between replication using Oracle golden gate 12c.
• Provides 24x7 operational support of corporate production databases on a rotating schedule.
• Performs routine production database and application maintenance tasks on a rotating basis.
• Monitors all production database activity for operational improvements to include, but not limited to CPU, Disk and Memory utilization, space utilization, replication and consistency of sites, long running queries/data loads, query access plans, security infractions and overall performance of databases Develops and implements corrective measures for database issues/problems found during monitoring.
• Provides database technical support for Technology and Application Delivery projects to include, but not limited to analysis of database design and schema, database environment provisioning, security assessments, database build executions, database application performance testing/tuning and supporting project deployments. Leads and manages all database aspects of the assigned technology delivery project.
• Provides database technical support in maintaining and building the database non-production environments, including database refreshes, database patch management, database space management, database performance tuning and migration/upgrade of the non-production database environments to Linux/Oracle 12c.
• Acts as subject matter expert for all database systems; provides level 2 and 3 technical support for complex database issues. Provides technical input to software developers and end users in the areas of database capabilities, performance and best practices.
• Provides training and guidance to peers and Database Administrators.
• Recommends, creates, and follows all relevant policies and procedures to operate a controlled production environment.
• Leads and manages database administration activities as assigned by the Lead Database Administrator.
• Performs other duties as assigned.
• Implemented 100TB of Backup system for Exadata databases machine and Exalogic Elastic cloud computing servers & VDI environment involving Oracle ZFS 7420 storage systems and HP Data protector 6.11.
• Patched 11g Grid Infrastructure & RAC databases on Exadata Database Machines.
• Patched Oracle Exadata Machine 11g R2 Grid Infrastructure and RAC databases. Involved in Exadata switch patching and cell storage.
• Configured Oracle Grid monitoring system for Exadata database machine & Exalogic on separate network.
• Implemented Oracle Virtual Machine virtualization 2 node cluster on HP Blade G470c servers for different needs.
• Implemented Database Listeners on infiniband network from Exadata Machine to Exalogic Machine.
• Worked on Scan listeners for 11g grid infrastructure.
• Administering Cell Storage servers for Exadata Database Machines.
• Extensively Administered Oracle Apps r12, 11.5.10 e-business applications on RAC.
• Upgraded Oracle APPLICATION 11.5.9 to 11.5.10.
• Patched, Cloned and administered Oracle Apps 11i with ad utilities (ADADMIN, ADPATCH, ADCTRL, and ADMERGE).
• Solved issues related to Concurrent Manager on oracle apps 11i.
• Provided installation, configuration support of Oracle RAC9i, 10g, 11g RAC databases from building server to installing databases.
• Involved in upgrading Oracle9i to Oracle10g database
• Configure workflow notifications, printers, and form servlets in Oracle financial applications.
• Cloned 2-tier, 3-tier eBusiness suite application from production to test environment.
• Involved heavily in different kind of cloning requirements. Restoring databases in same cluster system and different cluster system to another database.
• Worked extensively on HP data protector and managed system wide backups. Configured backup polices for oracle databases and system wide backups.
• Involved in patching 10g ASM instances and CPU patching for RAC instances and single instances.
• Performed 10.2.0.3 Oracle RAC Cluster ware upgrade to 10.2.0.4. Upgraded 10.2.0.2. databases to 10.2.0.4

Environment: RedHat 4/5/6/7/8, Sun Solaris 5.9/10, HP-UX, Windows NT/2000/2003/XP/Vista/7. Oracle 11g/10g/9i, TOAD, AHP PPM, Foglight, Quest Stat, OBIEE 11.1.1.6, Vertex, 11g/12c/13c OEM grid control, RAC.

Confidential

Oracle DBA/ Linux Administrator

Responsibilities:

• Upgrading Oracle Golden gate 11.1.1.0 to 11.2.1.0.1
• Installing Oracle Golden Gate for EBS Reporting Databases
• Oracle and SQL server Database Capture using Oracle Golden Gate 11g
• Data Extract, Conversion and Load using Golden Gate
• Configuring Extract Parameters for Golden Gate EXTORA, RMTHOST, RMTTRAIL
• Configuring Replicate Parameters ASSUMETARGETDEF, REPOR, DISCARDFILE
• Creating GLOBALS for Golden Gate and Adding database checking points.
• Migrated the data from old storage to a new EMC INVISTA Storage to minimize downtime and provide High Availability.
• Migrated data on different Oracle versions of 9i and 10g, 11g and on different operating systems of AIX/Sun Solaris/Linux.
• Migrated data from File System/Non - ASM to ASM storage.
• Migrated data from ASM disks to ASM disks by using Rebalancing techniques.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 5
• Production databases and few development databases.
• Recovered data files from block corruption using RMAN.
• Reduced production outages by implementing best practices of patch management, purge/archival, code
• Optimization and applied rolling patches such as PSU and CPU on RAC after testing on DEV, QA and Staging.
• Taking backup of databases using RMAN.
• Used tools like export/import and data pump export/import.
• Created a physical standby for Disaster Recovery (DATA GUARD).
• Experienced writing UNIX scripts and troubleshooting issues.
• Upgraded Real Application Cluster (RAC) from Oracle 9i to Oracle 10g on HP-UX.
• Used tools like TOAD, SSH.
• Involved in Database Tuning for the performance of databases.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as TKProf, STATSPACK, Explain plan and SQL*Trace.
• Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between two oracle servers.

Environment: Oracle 9i/10g/11g, Oracle RAC/ASM on AIX/Sun Solaris/Linux/WIN, Oracle Golden Gate 11g (11.2.1.0 and 11.1.1.), Toad, SSH, RMAN, SQL*Plus, SQL, Import/Export.