PROFESSIONAL SUMMARY:

• 17+ years of total IT experience as a Sr. Oracle DBA (7.x to 12.1.x), Oracle Golden Gate (10.2 to 12.1), Mongo DBA (2.2.6 to 3.4.2), AWS Cloud, Amazon Redshift, S3, EC2, RDS, Oracle RAC DBA (10g to 12c), Oracle Enterprise Manager 11g/12c, Oracle Veridata (12.1), Oracle Application DBA (11.0.3 to 11.5.10.2), Datawarehouse Administrative Console (DAC), Informatica ETL, Business Analytics Warehouse (BAW) Administration, Unix/Linux Shell Scripting, OBIEE, Pro*C, PL/SQL
• Provided round the clock support to 2600+ databases having 660+ production (150+ Apps Databases) and rest development, and test databases.
• Work closely with different team like product development, program management, Operations and deployment, Storage, Networking, Infrastructure.
• Able to manage multiple tasks effectively and forecast/plan different database activities.
• Meeting /Bridge call with client, third party client, management, third party vendors, Network team, Unix administration team and communication with Oracle Support.
• Worked as a SME - Oracle DBA i.e. first point of contact for all Oracle database queries/ issues in 5 different projects.
• Expertise in Installation, upgrades, maintenance, backup & recovery, performance tuning, refresh, cloning, troubleshooting of Oracle application and Oracle core databases
• Experience in Oracle Database monitoring, Cloning and administration using OEM, Toad, manual scripts, cronjob /email alerts etc.
• Experience in Backup & Recovery (Full, Partial, Until Time/SCN etc) using Data Pump, Hot, Cold, Logical and RMAN.
• Experience in Performance Monitoring and Tuning of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisers.
• Experience in Installation, Configuration and Maintenance of Oracle Standby/Data Guard (Physical, Logical, Snapshot and Active Data guard)
• Experience in managing Database Structure, Database Upgrades (Manual and using DBUA), Replication and Data Extraction
• Experience in Pro*C, SQL and PL/SQL programming and debugging skills - Triggers, Stored Procedures etc.
• Experience in implementing and administering Oracle GoldenGate using various methods such as bi-directional, uni-directional, Cascading in Linux and Sun Solaris environments. It includes usages of Veridata, Log Dump utility, Golden gate Director and Monitor. The Configuration methods have been deliberate and decided based on customer’s planned architecture and aspiration
• Experience of Oracle Golden Gate including Installation, Configuration of Extract, Replication, Manager, trails, parameters. Troubleshooting and fixing issues of LAG, Mapping, performance etc
• Experience in Installation, Configuration and supporting of Golden Gate Veridata, Golden gate Director and Golden Gate Monitor.
• Experience in AWS Cloud, Amazon S3, EC2, Redshift including building/configuration of Cluster, VPC, Parameter group family, snapshot, recovery, security group, IAM, Cloudwatch, SNS, WLM, Multi-region Network setup, Database Migration, Encryption, SQL Worksheet/J etc.
• Amazon Redshift cluster and table level restore into multi-region.
• Experience in Installing, Configuring and Supporting MongoDB for OLTP applications including High availability and performance tuning to improve read/write latency, with and without Journal with embaded/ data model.
• Experience in MongoDB HA Shraded cluster, replication, Security, User/ Roles, CRUD operations/ commands, Aggregation, Indexing, Monitoring with profile, utilities, Perforamce tuning.
• Worked on Mongo DB replication, security, High Availability, and Sharding.
• Worked on Mongo DB backup / recovery using MMS, LVM Snapshot, Copying, mongoexport/ mongoimport and Mongodump/ mongorestore.
• Over 8 years of experience in Project Management / Principal consultant / DBA Manager/ Team Lead. Managed team of 14 DBAs for client Motorola being employee of CSC.
• People management and motivation to complete the work providing 24/7 database support meeting with Service Level Aggrements with client.
• Working knowledge of PostgreSQL (9.6.2), MarkLogic-8, Amazon RDS, Cassandra DBA (2.0.2 to 3.10), Hadoop Administration (2.4.0), Oracle Exadata (12c) and Oracle Warehouse Builder (OWB) Administrator
• Domain knowledge of Retail (Retek, now subsidiary of Oracle), Government, Telecom, Transportation, Civil Engg. and Banking applications

TECHNICAL SKILLS:

Database: Oracle Core 7.x/8.x/9.x/10g/11g/12c, Oracle RAC 10gR2/ 11gR1/ 11gR2 / 12c, MongoDB 2.2.6 to 3.4.2, Cassandra 2.0.3 to 3.10, BAW

Languages/Tools: Unix Shell Script, SQL*Plus, PL/SQL, Pro*C, Fortran, C, C++, AD Utilities, OEM, dbconsole, Tivoli, Oracle RAC, Java, JDBC, RMAN, AWR, ADDM, ASM, ACFS, Statspack, Tkprof, Netbackup, Dataguard (Pysical, Logical, Snapshot), Server Manager, SQL*Loader, OUI, dbca, Logical/ Cold/ Hot backup, Data Pump, SQL*Net/Net 8, Rapidwiz, Kintana, Retek RMS 9.x, GGSCI, Oracle Golden Gate Director, Veridata, Toad, OWB, Informatica ETL, Informatica Power Centre, Datawarehouse Administrative Console, BI Application 7.9.6.3, Business Analytics Warehouse (BAW), Adadmin, adconfig, Oracle Apps /Core DB patching

Operating System: Windows Server 2003/2008, Windows 2000/98/95/NT/Vista/XP, MS-DOS, UNIX AIX, Sun Solaris, SCO Open server, HP-UX, Linux Radhat

Domain Knowledge: Banking, Finance, Retail, Travel, Government, Civil Engineering, Cloud Computing

PROFESSIONAL EXPERIENCE:

Confidential, Madison WI

Sr Oracle DBA

Responsibilities:

• Logical, physical, RMAN Backup/ recovery, scheduling and monitoring.
• Database infrastructure support (Space/storage utilization, IP, DNS, Firewall, Regulatory / Non-Regulatory )
• 24/7 oncall support on weekly rotation basis.
• Database Migration from Oracle datawharehouse to Amazon Redshift.
• Database hardware migration from Physical to Virtual environment . from HP-Ux to Linux environment using RMAN and Golden gate replication.
• Single Node / RAC support (service, listener, srvctl instance level, service, listener ) using ASM
• Database upgrade 10.x / 11.2.0.3 to 11.2.0.4 / 12.1 to continue Oracle Support,
• Oracle quarterly CPU and Java Patching.
• Service level charge back module implementation
• Active Data guard setup, Application database support, Linux/ Unix scripting
• Database Cloning using RMAN Duplicate and OEM
• Golden gate replication setup/ monitoring / error fixing at Object, schema and database level with selected data replication.
• Creation/ Maintenance of Oracle Wallet.

Confidential

Senior Oracle DBA

Responsibilities:

• Oracle Datawarehouse DBA support to 4 datawarehouses having maximum size as 13.6 TB
• Meeting SLA (Service Level Aggrement) to resolve any sort of database issue(s) based on business priority.
• Clonning production data into Devp, QA, Stage, Test, datawarehouses.
• Automate common maintenance, installation Jobs.
• Streaming Unix commands, Shell scripts.
• Backup using RMAN, Hotbackup, Logical Backup, Cold Backup
• Managing Cron job and DBMS jobs to schedule jobs keeping workload balance.
• Day to day problem solving for application users and debugging for databases

Confidential, Sunnywale, CA

Sr Consultant / Oracle DBA

Responsibilities:

• Production database support of 18 databases with 4 node RAC, 4 data warehouse, and rest development, QA databases.
• Installation, configuration and support of Oracle golden gate
• Cloning production database into development/ databases
• Installation, configuration and support of OBIEE 11.1.3 & 11.1.1.5 on Linux Red hat 4 and Windows platform.
• Installation, configuration and support of OWB (Oracle Warehouse Builder) ver 11.2.0.1 on 11.2.0.2 oracle database.
• Up gradation of OWB from 11.2.0.1 to 11.2.0.2
• Up gradation of Oracle database from 10.2.0.3 to 11.2.0.2 on linux platform, standalone on windows
• Shell scripting for loading loss data on periodic basis
• RMAN configuration on upgraded database 11.2.0.2
• Data conversion of Wachovia bank into Well Forgo bank’s format. (Dry Run, Dress Rehearsal and Prod Run)
• Deployment of database packages / patches into bank server (Ally bank, Citi Bank, Confidential ) as per planned/scheduled timeframe.
• Problem handling of OBIEE and OWB on Linux/ windows platform.
• Communicating with oracle support with SR for Oracle Golden Gate runtime issues.
• Requirement gathering for automatic data request in development program using client’s tool Anthill.

Confidential

Deputy General Manager (Process Management & Systems)

Responsibilities:

• Taking initiatives to plan & implement paperless work in all offices of company.
• Creating centralized monitoring system to manage all projects of company in India and overseas
• Creating in-house Payroll product using Oracle Database 11gR2
• Day to day activities of IT support and maintenance.
• Creating & implementing backup/ restoration policies of company records/ activities.
• Maintaining E-Mail server and Web server
• Working experience in Primavera ver-7.x on Oracle database.
• Giving presentation to officials in concerned ministry after filling up tender application.
• Worked to prepare annual and quarterly reports with work completed and planned further.

Confidential, Salt Lake City, UT

Offshore DBA Lead /Senior DBA / Principal Consultant

Responsibilities:

• Offshore DBA Lead of Oracle Database support.
• Supporting migration of previous SAM application data of Credit card transactions
• Synchronized the Credit card data of Confidential into GE Money with defined securities andaccess level.
• Supported 4 data warehouses and worked in performance tuning improvement
• Prepared and implemented plan for new joiner in our team and at client side.
• Demonstrating technical leadership and oversee development, design, UI and technology integrationefforts of team.
• Designing for security, reliability, scalability
• Implementation of best standard and practices

Confidential, Chicago, IL

Lead DBA / Principal Consultant (G50)

Responsibilities:

• Responsible to deliver at the agreed time frame as per signed SLA with client.
• Identifying the required resources for the project in pipeline and coordinate with the resource manager and other support groups for the same
• Leading technical requirements gathering sessions and writing technical requirements documents.
• Managing the technical delivery of integrations and custom extensions.
• Responsible for providing hands on expert level assistance to developers and DBAs for technical issues
• Identifying problems, initiate and implement corrective and preventive actions
• Setting goals for software product including intermediate software work products and track it.
• Identifying problems initiate and implement corrective and preventive actions.
• Initiating Concession requests for in process / process end deliverables, which fail to meet the agreed criteria vis-à-vis quality system requirements.
• Creating Project Risks Plan, Disaster recovery Plan and Project Plan.

Confidential, Schamburg, IL

Sr. Oracle DBA / Deputy Consultant

Responsibilities:

• Installing /Configuring Oracle 11.x.x Application / Database on single node/ multi nodes on Solaris and Radhat Linux OS using rapidwiz
• Installation and Administration of Oracle 9.x/ 10g Database on Unix platform using single node, Multi nodes (RAC) using OCFS (Oracle Cluster File System) and RAW devices.
• Applied Individual, Merged Patches (c, d, g, j and u drivers) in multiple testing / development and production environment having multiple application tiers and shared APPL TOP in Oracle Apps
• Upgrade Applied Family and Maintenance pack
• Installing and registering new products released from maintenance pack (Adsplice) in Oracle Apps
• Oracle PL/SQL coding and SQL procedural programming
• Debugging the stored procedures, function, packages, snapshot
• Analyzed applied patches and new requirements in existing Oracle Application environment (adphrept.sql, adpchlst.sql)
• Oracle application and Database (11.5.5 to 11.5.10.2) using Rapid install and Adaimgr and using TUMS script, Oracle Upgrade assistant excel sheet, Release note, pre/ post upgrade categories and customization of existing functionalities.
• Refreshed application and Database from production to testing/ development environment
• Monitoring SQL /Oracle Database and application using SDM tickets (remedy user), Tivoli, OEM, dbconsole (emctl, emca), OAM, DBA/ V$ views of SYS schema, FND/ AD tables/views of Apps schema
• Perform Oracle Database operations using Kintana
• Oracle Database Performance tuning, SQL tuning, trouble shooting and bug fixing
• Managing Oracle Application servers (Web, Form, Apache, Report and discoverer server)
• Managing Standard, Internal and Concurrent managers, concurrent requests/ Concurrent programs
• Oracle Database ASM installation, configuration, Disk group Mirroring, Dynamic Rebalancing and Monitoring long running operations.
• Non-CFS backup, Online/offline user-managed backup
• RAC instance recovery using EM and recovery of OCR/ Voting disk
• Managing Oracle pfile/ spfile parameters to use automated process
• Administration of OCR, Voting File
• Tuning Oracle 10g RAC Nodes/Instances for load balancing, I/O, optimal resource utilization
• Automatic shared memory management and analyzing /optimum use of dynamic SGA parameters (large pool, Java pool, Shared pool, Buffer cache) in Oracle databases
• File copying and transferring to Local, Remote server, ASM to Non-ASM (OCFS) and vice versa in 10g RAC
• Maintain Oracle application using AD utilities (Adadmin, Adpatch, Admgrch, Adctrl, Adident etc)
• Oracle Database Fine tuning, Backup application and Database using RMAN and netbackup (Archive log and full backup) and monitoring Oracle 10g Database Data Pump utilities

Confidential

Lead Oracle DBA

Responsibilities:

• Database backup (RMAN backup, Net backup, Hot /Cold and Logical Backup)
• Performing and monitoring Database backup using RMAN.
• Database cloning and refresh using RMAN recovery
• Experience in Database recovery (Control file, Data file, Init file)
• Configuring and Monitoring Database using Tivoli, Dataguard and OEM
• Using Database tools SQL * Loader, Oracle Universal Installer (OUI), Database Configuration Assistant (dbca), Import and Export
• Customization of Unix shell scripts, Batch programs, Reports, Printers.
• Problem solving and troubleshooting using SDM tickets (Remedy user)
• Auditing in User process, Background process and statements.
• Data warehousing analysis, creating and maintaining Materialized views, Partitioning
• Customization /Maintenance of Init parameters as per application use / Database requirement
• Tuning SGA parameters dynamically as per Database use / temporarily during problem solving / performance testing
• Supporting production /development and testing databases on 24/7 basis.
• Verifying Database structure, data storage, disk input/output and future forecasting
• Creating and maintaining triggers, stored procedures
• Monitoring and analyzing databases using V$ and DBA views of SYS schema
• Creating help for SQL*Plus user using Database scripts and configuring glogin
• Database performance tuning using Statspack report, Utlbstat and Utlestat report
• SQL tuning using Explain plan and Tkprof utility.
• Experience of monitoring Index uses, rebuilding techniques, row chaining and row migration
• Performed Data Migrations from flat file/excel sheet into Database using SQL* Loader and PL/SQL scripts
• Provided in-house to client/ team members.
• Maintenance/ Customization of tablespaces, tables, indexes and storage parameters affecting performance of database.
• Database design/ Modification having requirement analysis with client and considering the present and future scenario.
• To ensure all the instances are up whenever required and verify the uptime/downtime
• Managing Backup & Recovery methodologies and Networking /OS level issues
• Managing cron jobs on OS level to schedule jobs/Unix shell scripts at pre-defined time/interval
• Evaluatecurrent/anticipatedcapacityrequirements and prepared / executed appropriate Database monitoring and upgrade plans

Confidential

Oracle DBA

Responsibilities:

• DBA support to online banking transaction processing
• Migrating development Database to production
• Worked closely with the development staff on all issues related to the Oracle database.
• Performance tuning of Oracle 9i production databases in development databases after copying the database/ schema statistics
• Managed rollback segments and undo tablespaces
• Analyzed tables/ indexes and moved into another tablespaces
• Used SQL* Loader to load data from flat files
• Database backup (Hot /Cold and Logical Backup)
• Recovery of Database Control files, Data files, Init files
• Creation of Database env for Integration, Core, Quality Analysis, Migration and Final Testing.
• Maintenance of users, roles, groups as per user category
• Auditing in User process, Background process and statements.
• Creating and maintaining materialized views, table/ index partitioning
• Monitoring and analyzing databases using V$ and DBA views of SYS schema
• SQL hints/tuning using Explain plan and Tkprof utility.
• Experience in Installation and configuration of Oracle Streams.
• Monitoring and analyzing optimal use of different types of indexes (bitmap, functional)
• Daily documentation / report maintenance with status of user pending issues
• Maintenance/ Customization of tablespaces, tables, indexes and storage parameters affecting performance of database.

Confidential

Oracle DBA

Responsibilities:

• Responsible for the day-to-day effective technical performance of the existing physical databases, including taking necessary actions to improve performance and initiate recovery activities when system failure occurs.
• Installation of Oracle 8.1.7, 8.3.0 Oracle databases on Sun Solaris
• DBA support of existing development databases of Retek product RMS-9.0
• Managing Database users and security administration
• Creating public and private data links
• Database performance tuning of Retek RMS 9.x databases
• Change of Database structure as per developers/users requirements, suggestion and to achieve the best performance
• Verifying Database structure, data storage, disk input/output and future forecasting
• Creating and maintaining triggers, stored procedures
• Monitoring and analyzing databases using V$ and DBA views of SYS schema
• SQL hints/tuning using Explain plan and Tkprof utility.

Confidential

Oracle DBA

Responsibilities:

• Database tuning considering optimal utilization of Init parameters as per existing OS
• SQL tuning using hints, explain plan and tkprof
• Modifying the application without changing the functionality
• Used SQL*Loader to load data and take the future forecast
• Creating and managing table and index partitions (Row, hash and List partitions)
• Creating materialized views and monitoring/testing performance as per changing init parameters, Database structure and application codes

Confidential

Oracle DBA

Responsibilities:

• Database support of GEMMS product of GE-Plastics
• Creating and managing shared procedures and triggers
• Performance tuning and troubleshooting
• Working with developers to do the root clause analysis for problem related to database
• Unix shell scripting and using DBMS jobs scheduling
• Taking logical backup of schema, objects and database

Confidential

Oracle DBA

Responsibilities:

• Database end support and Helpdesk support at client site
• Installing Oracle databases 6.x to 8.x in difference flavors of Unix platforms
• Configuring kernel parameters of Unix to achieve maximum SGA memory
• Analyzing codes of forms 4.5 and pro*c
• Upgrading Database and product
• Modification of Database structure and reports as per user request
• Reporting the errors, root clause analysis and documentation
• Providing to client for managing day-to-day DBA activities
• Supporting 24*7 at month end, quarter end and year end Database activities
• Monitoring Database structure and performance using V$ and DBA views of Sys schema
• Using SQL* Loader to load data from text files after setting control files parameters