SUMMARY:

• 10 years of IT experience working in various fields like News/Media, Finance, R&D, Pharmaceuticals with expertise in Oracle Database Administration & AWS Administration
• Experience in migrating on premise oracle databases to AWS cloud Infrastructure including migrating oracle database to Aurora and Redshift.
• Experience working with AWS Infrastructure - EC2 Container Service, S3, Route 53, VPC, Identity and Access Manager (IAM), Elastic Beanstalk, Lambda, Cloud Front, Glacier, RDS, Dynamo DB, Aurora DB, ElastiCache, Redshift, Cloud Watch, Cloud Formation, Cloud Trail, Ops Works, Amazon Elastic Map Reduce(EMR).
• Excellent understanding of Oracle internals, Oracle architecture including Oracle High availability (RAC, Data Guard, Golden Gate), memory management, performance tuning, backup & recovery.
• Extensive experience working with different Oracle versions including 9i/10g/11g/12c. Performed database design, capacity planning, installation, configuration, upgrade, CPU/PSU patching and migrations
• Designed and Implemented Oracle Audit Vault & Database Firewall 12.1.1 to safeguard and provide a preventive and detective solution to block threats like SQL injection, Network poisoning, and host vulnerabilities.
• Experience working in multi-terabyte SAP/ERP systems, Performed upgrade and migration of a 40+ TB database in Solaris environment
• Hands-on experience in installation, configuration, troubleshooting Oracle Golden Gate (OGG) in homogenous and heterogeneous environments. Excellent understanding of different OGG topologies like Unidirectional, Bi-directional, P2P. Monitoring Golden Gate process like extract, replicat & manager using OEM
• Experience working with OGG Veridate for identifying, reporting and fixing data discrepancies between heterogeneous databases.
• Experience working with Oracle engineered systems like Exadata (X3-2, X4-2) and ODA (Oracle Database Appliance) worked on installation, patching, upgrade for X4, X5 series including software and firmware upgrades. Well versed with features like Smart Flash Cache, HCC (Hybrid Columnar Compression),Smart Scans, IORM
• Experience with Oracle Enterprise Manager (OEM) 10g/11i/12c/13c for maintaining and monitoring databases, automated many routine tasks like daily backups, alert notification for DB and ASM, database refresh, quarterly database patching
• Proficient in SQL & DB tuning, application and database performance tuning, experience working with AWR, ADDM, tuning advisor, 10046 trace levels.
• Experience working with BI tools like Jira, DOMO for project tracking, monthly/quarterly reporting
• Team player with excellent communication, documentation and troubleshooting skills.

TECHNICAL SKILLS:

Operating System: RHEL 4.x/5x/6x, OEL 5x/6x, Solaris SPARC 10x/11x AIX 6x/7x, Windows

RDBMS: Oracle 12c, 11g R2/R1, 10g R1&R2, 9i

Languages: SQL, PL/SQL, C, C++

High Availability Infrastructure: Real Applications Cluster (RAC)-10g/11g/12c, Data Guard 10g/11g,12c, ASM, ACFS, ODA X3-2/X4-2, X5, Exadata X3-2/X4-2, GoldenGate 11g/12c, Oracle Streams

Backup &Recovery: RMAN, expdp/impdp, Symantec NetBackup, EMC s Recover Point (CDP/CRR)

Performance Tuning: ADDM, AWR, STATSPACK, SQL Trace, SQL tuning advisor

Security & Auditing: Oracle Audit Vault & Database Firewall 12.1.1, Control Minder, Secret Server

Monitoring: OEM grid control (10x/11x/12c,13c), SQL Loader, Toad, DBArtisan, SQL Developer

Application Testing: Oracle RAT 11, Load Runner, Swing bench

Data Warehouse: OWB (Oracle Warehouse Builder 10.2/11.2)

Virtualization: VMware Workstation7x,8x, OVM

Web Tools: HTML, XML, IIS

PROFESSIONAL EXPERIENCE:

Confidential, Englewood Cliffs, NJ

Architect/Oracle DBA

Responsibilities:

• Design, Build and manage various OLTP and DW applications running on 10g/11g/12c, performed data migration from Oracle 10g and 11g to Oracle 12c including cross platform migration.
• Migrated various small, medium, large Oracle 12c databases from on-premises datacenter to AWS on EC2 instances and Amazon RDS, Used Amazon Storage Gateway, AWS-DMS, S3 for migrating application data
• Extensively used Amazon RDS for database provisioning, patching & monitoring, implemented Multi-AZ feature for high availability.
• Migrated many applications running on oracle 11g to Amazon Aurora using AWS Database Migration Service (DMS) and AWS Schema Conversion tool (AWS SCT) for converting schema objects like triggers, functions, indexes, constraints, tables
• Experience working with EC2, EBS, IAM, S3, ELB, RedShift, RDS, VPC, Route 53, Cloud Watch, Cloud Formation
• Worked on automating Oracle 12c Standalone and RAC builds via OEM PaaS (Platform as a Service), drastically reduced build time from days to hours
• Designed Database architecture for shared application, consolidated many small applications into shared environment for better performance and optimal hardware utilization.
• Responsible for planning, upgrading & migrating over 60 applications running on 2 and 3 Node RAC’s on physical servers to Single Instance on VM thus saving over 1 million in hardware costs.
• Resource and capacity planning for legacy application refreshes, ongoing and future projects including virtualization, worked closely with storage, server and network team for datacenter migration.
• Extensively used DMU for migrating various mission critical application from Western European character set (11g) to Unicode (12c). Worked with application developers to improve application code for better performance, testing and code deployments.
• Worked on ODA X4, X5 for various SAP, BI Applications. Performed installation, configuration, patching of Oracle 11g/12c database running on ODA’s also was responsible for upgrading Grid Infrastructure from 11g to 12c.
• Performed installation for Oracle 12c RAC (2 Node) on Linux OEL 6. Created CDB, PDB. Tested various Oracle 12c features like copying, renaming, moving oracle data files online, creating local user and common user, plug a PDB to another CDB, plug and unplug a database, making column invisible, extended data types.
• Performed regression and load testing using Oracle Real Application Testing (RAT) for SAP database for configuration change from single instance to Oracle RAC. Extensively used SQL Performance Analyzer and Database Replay to capture, analyze, replay production load to test environment to identify and remediate issues before production deployment.
• Upgraded SAP database from standalone non-ASM to RAC 3-node cluster with ACFS, migrated SAP database(s) from standalone to RAC 3-node cluster including conversion from non ASM to ASM file system
• Upgraded and migrated a 40TB database to 11.2.0.4 from 11.2.0.3 using RMAN duplicate and Recover point (CDP) in less than 16 hours.
• Responsible for implementing DR solution for Oracle SAP production database using EMC’s recover point (CDP/CRR), successfully tested Application and crash consistent recovery using CDP (Continuous Data Protection) and CRR (Continuous Remote Replication) options.
• Successfully reduced RMAN backup time for 40TB database from 42 hours to 18 hours using NetBackup’s deduplication option also was responsible for designing, implementing and automating incremental and cumulative RMAN backups for Oracle SAP database.
• Performed Oracle Grid and Oracle home cloning via OEM also automated database refresh using RMAN backup and RMAN duplicate from active database
• Performed installation and migration of SAP’s MaxDb ERP database(s).
• Worked on usual mail order type request like schema creation, grants, table and table partition, database object creation including Materialized Views refreshes
• Designed, implemented and managed Oracle Audit Vault & Database firewall 12.1.1 with standalone and resilient pair options, deployed Oracle Audit Vault Agent on over 80 databases running on Oracle 10g, 11g.
• Implemented password protection solution for Oracle database and OS (Linux, UNIX, and Windows) using CA - Control Minder. Performed password rotation at OS and Database level, created password policies as per SOX, PCI compliance for oracle database and OS related accounts.
• Designed Oracle Platform work order forms in ServiceNow, Prepared workflow from customer request to final delivery including any dependencies with other teams, created DB build SLA’s and Oracle database offerings and packages for customer to choose based on their requirements and budgets.
• Gather and analyze client requirements, create, manage, coordinate, and execute Database Platform Technology projects
• Perform value proposition and presentation to other IT teams including leaderships. Contribute to strategic thinking/planning on oracle based technology and related products.
• Advises project teams and stakeholders of industry trends for technical solutions and best practice
• Responsible for R&D on new oracle products, prepare SOP’s and documentation as per NBC standards, provide knowledge transfer to other team members.

Confidential

Oracle Database Administrator:

Responsibilities:

• Performed installation and configuration of OEL (Oracle Enterprise Linux) 6.3, disk Management including creating physical volumes, building file system (ext4), network configuration
• Designed and build Oracle 11g environments for Banner ODS/EDW database, also performed database upgrade and migration from Oracle 10g to Oracle 11g R2.
• Install and configured OWB (Oracle Warehouse Builder) 11.2 for Banner data warehouse.
• Deployment of Ellucian (Combination of Datatel and SunGard Higher Education) Banner products that included ODS (Operational Data Source),EDW(Enterprise Data Warehouse),RAP(Recruiting & Admissions Performance)
• Configured Web Server for administrative user interface running on OAS (oracle application server) which includes configuring data access descriptor(DAD), setup communication between application server and banner warehouse database
• Installed Cognos BI 10.1.1 on windows server 2008 which is used as a reporting tool for the banner,
• Performed import & deployment of ODS/EDW/RAP mappings on OWB

Confidential, New York

Oracle Database Administrator:

Responsibilities:

• Planning, analysis and implementation of Oracle database upgrade from 10.2.0.3 to 11.2.0.3 for DEV, Stage & Production environment.
• Performed OWB (Oracle Warehouse Builder) upgrade and migration from 10.2 on Solaris to 11.2 on Linux. Installed, configured and administered OWB (Oracle Warehouse Builder) on client and server.
• Performed cross platform migration of Oracle 10g database running on Solaris to Oracle 11gr2 on Linux using export/import datapump
• Responsible for designing RMAN backup strategies for Oracle warehouse database, created automation scripts for weekly full and daily archival backup including cold and hot backup.
• Performance tuning for data warehouse environment using ADDM, ASH, AWR, SQL tuning Advisor,Explain Plan, gather system/schema stats also reduced execution time for high load daily and weekly batch jobs
• Reduced execution of daily and weekly batch job by query optimization, significantly reduced data access time by creating indexes and partitions.
• Implemented database auditing on over 100 plus Oracle database. Created triggers for auditing DDL, DML changes.
• Created decommissioning/Migration plan for application running on 9i and 10g.Migrated & upgraded Oracle 9i & 10g database running on HP-UX to Oracle 11gR2 on Linux.
• Provided 24 X 7 on call support for ETL/Finance teams in India and USA also worked as tier2 supports for internal GE’s Service Center.

Confidential, NJ

Oracle Database Administrator

Responsibilities:

• Duties included all aspects of Oracle Database administration including oracle installation and upgrade Oracle databases from Oracle 9i to 10g, configuration of ASM, RAC, 11g (Test environment).
• Design, testing, implementation, maintenance of organization's relational databases running on Oracle 9i/10g across multiple platforms like Linux, AIX, Solaris, Windows
• Performed database upgrades from Oracle9i to Oracle10g including patching, data migration using exp/imp
• Developed SQL scripts and CRON Jobs for automating various DBA activities like DB alerts, purge logs.
• Implement backup and recovery procedures using RMAN for oracle databases and test regularly in conjunction with operations. Configuring scripts for Backups (Hot, Cold and incremental). Plan and schedule the online/offline backup
• Provided technical Support to development team to fine tune SQL and PL/SQL code using SQL execution Plan, SQL trace, ANALYSE DBMS STATS and evaluating and monitoring database to resolve performance issues including troubleshooting errors, recovering databases and failures as needed.
• Ensure maximum security at the database level using Users, Roles and Privileges
• Responsible for generating STATSPACK reports on weekly and daily basis
• Performed tuning involving Memory, Disk I/O, SQL and application tuning
• Migrated critical database from one server to other with minimal downtime using oracle Stream.
• Actively involved in group meeting, user interaction to get feedback from users and to meet business requirements
• Managing database objects like Tablespaces, Tables, Indexes, Views, and Synonyms, MVIEWS, DB LINKS, Regular Schema Refresh using Export/Import, database cloning and other day to day ticketing based requests, used OEM for daily maintenance activities

Aster Drugs Pharmaceutical’s Ltd

Jr. Database Administrator

Responsibilities:

• Administration of Oracle9i database including installation, creation, and monitoring database.
• Created database schema objects like table, synonyms, sequence, and index.
• User management, profiling, authentication providing required grants to users.
• Performed Hot Backups, Cold Backups and export/import utilities for schema based backups.
• Configured online and offline Database Backup using RMAN
• Performed several schema/object refreshes.
• Monitoring CPU, IO, and memory usages.