Oracle Manager

VARUN VERMA New Jersey 662-***-**** ************@******.***

Around 8 years of IT experience working in various fields- News/Media, Finance, R&D, Pharmaceuticals with expertise in Oracle Database Administration, MySQL, MongoDB, AWS

2 years of experience in Architecture & Administration of AWS cloud platform.

1+ years’ experience working with open source RDBMS like MySQL,MariaDB & PostgreSQL

1+ years’ experience working with No SQL databases like MongoDB, Apache Cassandra

Experience in migrating on premise Oracle databases to AWS cloud Infrastructure including migrating Oracle databases 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, DynamoDB, Aurora DB,ElastiCache, Redshift, CloudWatch, CloudFormation, CloudTrail, OpsWorks, Amazon Elastic MapReduce(EMR).

Excellent understanding of Oracle internals, Oracle architecture including Oracle High availability (RAC, DataGuard, GoldenGate,ASM,ACFS), memory management, performance tuning, backup & recovery,cloning,refreshes

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 with Oracle, Performed upgrade and migration of over 80+ 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 task 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,7x Solaris SPARC 10x/11x AIX 6x/7x, Windows

Database Tools: Oracle 12c,11g,10g,9i,MySQL 4.1, 5.X,Maria DB 10x,MongoDB 3x,PostgreSQL 9x,10x

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

High Availability Infrastructure: Real Applications Cluster (RAC)-10g/11g/12c,DataGuard 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)

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

Monitoring: OEM grid control (10x/11x/12c,13c), Toad,SQL Developer,Monyog,Percona,MongoDB Compass

Cloud Infrastructure :AWS-EC2,S3,VPC, MongoDB-Atlas

PROFESSIONAL EXPERIENCE

NBC Universal Englewood Cliffs, New Jersey July 2013 – Present

Roles & Responsibilities Senior Database Architect

Design, Build and manage various OLTP and DW applications running on 10g/11g/12c including RAC & DataGurad(for HA), 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, 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

Worked on automating Oracle 12c Standalone and RAC builds via OEM PaaS (Platform as a Service), drastically reduced build time from days to hours.

Responsible for planning, upgrading, migrating over 90+ applications running on 2 and 3 Node RAC’s on physical servers to Single Instance on VM thus saving over 1.3 million in hardware & Support costs, consolidated many small applications into shared environment for better performance and optimal hardware utilization

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.

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

MySQL database administration including installation, configuration, replication(Master-Slave) on Linux environments

Used Monyog for instance & Servers monitoring,Automated MySQL installation using Ansible playbook

Worked on usual mail order type request like schema creation, grants, table and table partition, database object creation including Materialized Views refreshes .

Configure & maintain MongoDB instances including schema design, building MongoDb replica set & Sharded clusters, experience working with CRUD operations and tools like Compass, OPS Manager, Cloud Atlas,Percona

Designed, implemented and managed Oracle Audit Vault & Database firewall 12.1.1 with standalone and resilient pair

Implemented password protection solution for Oracle database and OS (Linux, UNIX, and Windows) using CA - Control Minder, created password policies as per SOX, PCI compliance for Oracle database and OS related service 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.

Perform value proposition and presentation to other IT teams including leaderships. Contribute to strategic

thinking/planning on Oracle & open source 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.

Concordia University Mequon, Wisconsin February 13 – July13

Roles & Responsibilities Oracle Database Administrator

Designed and build Oracle 11g environments for Banner ODS/EDW database, also performed database upgrade and migration from Oracle 10g to Oracle 11g R2. 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)

Install and configured OWB (Oracle Warehouse Builder) 11.2 for Banner data warehouse

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

General Electric (Global Research Center) Niskayuna,New York June 12-December 12

Roles & Responsibilities Oracle Database Administrator

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.

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.

Aster Drugs & Pharmaceutical’s Ltd, Chandigarh, India May 08-Aug 09

Roles & Responsibilities Jr. Database Administrator

Administration of Oracle9i database including installation, creation, and monitoring database. User management, profiling, authentication providing required grants to users.

Website development and management (autopartsprovider.us) at Texas A & M University Sep 10 - Dec 11

An e-commerce website designed for selling auto parts. Responsible for overall planning of website including web layer, Network, hardware, database

Education & Internships

Master of Science in Computer Science from Texas A & M University,May 2012

Bachelor of Technology in Electronics & Communication from Punjab Technical University, Punjab, INDIA, Aug 2008

Intern, Semiconductor Laboratory (SCL), Mohali, Punjab, Jul 2007-Dec 2007

Intern, Reliance Infocomm, Operation & Maintenances Department, Mohali, Punjab, Jun 2006-Aug 2006

Contact this candidate