Oracle Data
Resume:
***.******@*****.***
PROFESSIONAL SUMMARY
Oracle DBA: 17 years of total experience which includes RMAN / RAC / Data Guard / Golden Gate /Performance Optimization / Backup and Recovery/Oracle Enterprise Manager and other Oracle related administration
Postgre SQL DBA: 4 years of experience as Postrge database admin
(Postgres / pgadmin).
Postgre Responsibility:-
Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
Responsible for all backup, recovery, and upgrading of all of the PostgreSQL database
Performing schema management, database sizing, maintaining privileges.
Ability to proactively identify, troubleshoot and resolve live database systems issues.
Deploy Blue Medora’s plugin in OEM to monitor Postgress databases
Installing and Configuring PostgreSQL from source or packages on Linux machines.
Experience designing database structures, indexes, views, partitioning.
Implementing backup and recovery (Logical and Online).
Performing schema management, database sizing, maintaining privileges.
Data migration while upgrading database versions.
Removing the Index bloat concurrently to improve the performance.
Scheduled maintenance activities to vacuum, analyze to improve the query response time.
Maintaining custom vacuum strategies at table and db level.
Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
Data migration while upgrading database versions.
Extensive experience with Warm Standby and Hot Standby (PostgreSQL 9.x and greater).
Oracle Responsibility:-
Proficient in installation and configuration of Oracle 19C/12C,11g, 10g, 9i on HP-UX, IBM-AIX, WINDOWS, REDHAT-LINUX.
Migrated on premises oracle database to aws rds via native Tool & DMS
Created Golden gate hub on EC2 to support replication between on premise db and RDS
Created optional group to enable OEM monitoring for RDS
Modified parameter group as per application requirements
Enabled monitoring via Oracle Enterprise Manager (OEM) 12c/13c including Management Agent setup, Oracle Management Console configuration,Dashboard setup and monitoring
Experience in incident rules administration, reporting through OEM, target metrics administration, monitoring template administration,Experience with OEM 13c System Configuration Baseline Implementation.
Expertise in installing, configuring and maintaining Oracle 11g RAC (Real Applications Clusters) with ASM & OCFS2 file systems on RHEL, AIX, and HP-UX.
Installed and Configured Oracle Golden Gate for replications and troubleshooting its issues.
Upgraded oracle databases from 9i to 10g and 10g to 11g using both manual method and DBUA.
Performed RMAN backups (Full, Incremental and Cumulative) and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard.
Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC
Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with NetBackup.
Applied Patch Set Updates to 10g and 11g oracle databases.
Strong experience in database performance tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables.
Good knowledge in implementing Oracle Flashback technology for faster recovery of tables/database.
Management of Schemas, Objects & Partitioning the tables & indexes
Expertise in maintaining and reinforcing standards for change management, database security plan and auditing.
Well experienced in working with various project, application and infrastructure teams, in large enterprise projects.
Cloud AWS / In house cloud: 2 years of AWS cloud and in-house cloud experience (oracle as a service)
TECHNICAL SKILLS
Operating System Linux, HP-Ux, AIX
Databases Oracle 9i/10g/11g/12c/19c, PostgreSQL
Oracle Utilities RMAN, EXP/IMP, Data pump, CRON, OEM Grid Control 12C/13C,Sql Developer, Toad, Oracle Streams. Golden gate
Shell script Unix Shell Scripting
Tools OEM12C/13C, SQL*Plus, SQLT, EC2, S3, IAM. Devops Tools, Ansible, Chef.
PROFESSIONAL EXPERIENCE
Wipro Ltd, Citi Bank, Irving, Texas Aug-27-2016
Database Consultant
Description:
Citi, the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Citi provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management.
Working as Oracle DBA at Citi bank client location, job duties includes installation, configuration of Oracle 11g/12c/19c, Real application cluster, golden gate setup, performance optimization, backup and recovery using RMAN, expdp/impdp utilities and other day to day activities to support Oracle databases applications.
Other databases support like: postgres
Wipro Ltd, Client: Citi Bank, Singapore Nov 2013 – Aug 2016
Responsibilities:
Daily activities includes Monitoring and rectifying alerts, Database build, upgrade, tuning, Implementing change request (CR), Database refresh request from development team, schema creation that includes user creation, permissions, table space quota.
Working in shifts 24*7 and in team environment.
Working on RAC environment
Cloning of database using Hot or Cold Backup’s and RMAN Backup.
Upgrade the Oracle Database from 9.2.0.x to 10.2.0.x,11.2.0.X
Implementation of quarterly security patch of Oracle.
Collecting performance statistics using Stats pack/AWR (Automatic workload Repository)
Managing Tivoli Generated Incident Tickets for production database.
Developed backup & restore strategies for Hot and Cold backups.
Analyzing and Rectifying Production Databases backup failures.
Creating new users and grants them required privileges and roles.
Creation of new Tablespace and adding and resizing the Data files.
Working on RAC, RMAN, ASM, DATAGUARD, Golden gate and applying patches on these technologies into the project
Database Sizing, Tablespace Management and Rollback Segments Management, Security Administration.
Implemented Oracle Golden gate for replication between Oracle database tables.
Wipro Ltd, NUS, Singapore, Asia Apr 2013-Nov 2013
Team Lead
Description:
The National University of Singapore (Abbreviation: NUS) is an autonomous university in Singapore. Founded in 1905, it is the oldest institute of higher learning (IHL) in Singapore, as well as the largest university in the country in terms of student enrolment and curriculum offered. NUS are a research-intensive, comprehensive university with an entrepreneurial dimension.
Responsibilities:
Daily activities includes Monitoring and rectifying alerts, Database build, upgrade, tuning, Implementing change request (CR), Database refresh request from development team, schema creation that includes user creation, permissions, table space quota.
Handling the customer escalations, Managing the Rota and applying the process guideline as per the client requirement
Database creation (using scripts and DBCA), applying Patch sets and CPU patches
Cloning of database using Hot or Cold Backup’s and RMAN Backup.
Upgrade the Oracle Database from 9.2.0.x to 10.2.0.x,11.2.0.X
Implemented oracle replication via oracle stream
Collecting performance statistics using Stats pack/AWR (Automatic workload Repository)
Environment: Oracle 11gR2, Linux, oracle stream, RMAN, Data pump, OEM 12c Grid Control
Wipro Ltd, Credit Suisse, Singapore, Asia Dec 2012 – Mar 2013
Role: Team Lead
Description:
Credit Suisse Group is a Swiss multinational financial services holding company, headquartered in Zürich, that operates the Credit Suisse Bank and other financial services investments. The company is organized as a stock corporation with four divisions: Investment Banking, Private Banking, Asset Management, and a Shared Services Group that provides marketing and support to the other three divisions.
Responsibilities:
Responsible for provisioning the database as per bank standard for oracle,Sybase and sql server during transition,Handling the customer escalations, Managing the Rota and applying the process guideline as per the client requirement, preparing the transition docs like SMTD,SOP etc.
Environment: Oracle 11gR2, Linux, oracle stream, RMAN, Data pump, OEM 12c Grid Control, sql server, Sybase
Wipro Ltd, CITI Bank, Noida, India May 2010 – Dec 2012
Team Lead
Responsibilities:
Daily activities includes Monitoring and rectifying alerts, Database build, upgrade, tuning, Implementing change request (CR), Database refresh request from development team, schema creation that includes user creation, permissions, table space quota.
Handling the customer escalations, Managing the Rota and applying the process guideline as per the client requirement
Database creation (using scripts and DBCA), applying Patch sets and CPU patches
Working in shifts 24*7 and in team environment (17 DBA).
Working on RAC environment
Cloning of database using Hot or Cold Backup’s and RMAN Backup.
Upgrade the Oracle Database from 9.2.0.x to 10.2.0.x,11.2.0.X
Implementation of quarterly security patch of Oracle.
Collecting performance statistics using Stats pack/AWR (Automatic workload Repository)
Managing Tivoli Generated Incident Tickets for production database.
Developed backup & restore strategies for Hot and Cold backups.
Analyzing and Rectifying Production Databases backup failures.
Creating new users and grants them required privileges and roles.
Creation of new Tablespace and adding and resizing the Data files.
Working on RAC, RMAN, ASM, DATAGUARD and applying patches on these technologies into the project
Database Sizing, Tablespace Management and Rollback Segments Management, Security Administration
Configured Database monitoring tool Fog light a product of Quest technologies, Patrol, Symphony on bulk of databases.
Team Size : 17
OS : Sun Solaris version 5.8/5.9, HP-UX, AIX
Databases : Oracle 9i, Oracle 10g, Oracle 11g
Environment: Oracle 11gR2, Linux, Aix, Solaris oracle stream, RMAN, Data pump, OEM 12c Grid
HCL LTD, Deautche Bank, Noida, India Apr 2007 – May 2010
Associate Consultant
Description:
Deutsche Bank is a German global banking and financial services company with its headquarters in the Deutsche Bank Twin Towers in Frankfurt. It has more than 100,000 employees in over 70 countries, and has a large presence in Europe, the Americas, Asia-Pacific and the emerging markets.
The bank offers financial products and services for corporate and institutional clients along with private and business clients. Deutsche Bank’s core business is investment banking, which represents 50% of equity, 75% of leverage assets and 50% of profits. Services include sales, trading, research and origination of debt and equity; mergers and acquisitions (M&A), risk management products, such as derivatives, corporate finance, wealth management, retail banking, fund management, and transaction banking.
Responsibilities:
Daily activities includes Monitoring and rectifying alerts, Database build, upgrade, tuning, Implementing change request (CR), Database refresh request from development team, Stand by database sync, schema creation that includes user creation, permissions, table space quota.
Cloning of database using Hot or Cold Backup’s and RMAN Backup.
Upgrade the Oracle Database from 9.2.0.x to 10.2.0.x,11.1.0.X
Implementation of quarterly security patch of Oracle.
Managing Tivoli Generated Incident Tickets for production database.
Analyzing and Rectifying Production Databases backup failures.
Creating new users and grants them required privileges and roles.
Creation of new Tablespace and adding and resizing the Data files.
Configured Database monitoring tool Fog light, a product of Quest technologies, on bulk of databases.
Monitoring Database using Stats pack Snapshots of Different Levels.
Restoration of Backups from TSM Server-Active/Inactive Backups
Team Size : 25
OS : Sun Solaris version 5.8/5.9, HP-UX,
Databases : Oracle 9i, Oracle 10g, Oracle 11g
Environment: Oracle 9i/10g/11gR1, Linux, AIX, Shell Scripting, RMAN, Data pump
Endevour system, AT&T, Pune, India May 2006 – APR 2007
ORACLE DBA
Description:
AT&T Inc. is an American multinational telecommunications conglomerate, headquartered at Whitacre Tower in downtown Dallas, Texas. AT&T is the world's largest telecommunications company. AT&T is the second largest provider of mobile telephone services and the largest provider of fixed telephone services in the United States
Responsibilities:
Providing 24x 7 supports to end users using remote access
Took backup by Tiger tool ( Amdoc product)
Applied patch on different environment.
Used stats pack diagnosis tool & Dynamic performance view.
Script scheduling using cronjobs on Solaris, and Scheduled Tasks on Windows
Identified the poorly performing reports and the corresponding sql Statement.
Monitored File System and Tablespaces on daily basis.
Performed SQL statement tuning (TKPROF, Explain Plan & AUTOTRACE).
Team Size : 4
OS : IBM-AIX, HP-UX, Sun Solaris, Linux
Databases : Oracle 8i, Oracle 9i
Environment: Oracle 9i/10g/11gR1, Linux, AIX, Shell Scripting, RMAN, Data pump
Mind mill Software Ltd, Patech Support, Noida, India Oct 2005– Apr 2006
Role - ORACLE DBA
Description
Patech Solutions Limited operates as an implementation and managed services company. Its services include asset life-cycle management, customer relationship management, enterprise resource planning, human capital management, project management, procurement, product life-cycle management, supply chain management, manufacturing, business intelligence, performance management, output document management solutions, third party system integration, and training; upgrades; implementation and managed service for front and back office operations; and hosting services. The company also provides Oracle-in-a-box, a hosted and managed environment
Responsibilities:
Database administration, managing table spaces, objects.
Identifying the poorly performing reports and the corresponding sql Statement.
Monitoring File System and Table spaces on daily basis.
Performing SQL statement tuning (TKPROF, Explain Plan & AUTOTRACE).
Tuning the Shared pool, Buffer cache, Log buffer.
Security Administration and User Management involving roles, privileges etc.
Maintaining the Control File, Maintaining Redo Log Files, Managing rollback Segments.
Creation of Indexes.
Creation of oracle database users and managing them.
Implementation of scheduled online backups in the development database and in the production database
Taking Logical backup of full database using Export.
Created users and roles.
Supported development team in their day-to-day activities.
Using crontab utility to schedule the backup operation.
Installation of stats pack for gathering statistics
Team Size : 3
OS : Solaris, AIX
Databases : Oracle 9i
Environment: Oracle 9i/10g, Solaris, AIX, Shell Scripting, RMAN, Data pump
Punjab College of Medical Science & Information technology, Rajasthan, India May 2003– Oct 2005
ORACLE DBA
Description:
Punjab College of medical & information technology is education center which provide the nursing & IT education in different part of India
Responsibilities:
Database administration, managing table spaces, objects.
Monitoring File System and Table spaces on daily basis.
Security Administration and User Management involving roles, privileges etc.
Maintaining the Control File, Maintaining Redo Log Files, Managing rollback Segments.
Creation of Indexes.
Creation of oracle database users and managing them.
Taking Logical backup of full database using Export.
Created users and roles.
Installation of stats pack for gathering statistics
Team Size : 1
OS : Window
Databases : Oracle 8i
Environment: Oracle 8/8i, Solaris, window,
EDUCATION
Ajmer University (INDIA).
BSc. (PCM),
CERTIFICATION & TRAINING
OCP – 9i DBA ORACLE CERTIFIED PROFESSIONAL
AWS CERTIFIED SOLUTIONS ARCHITECT ASSOCIATE
Oracle Autonomous Database Cloud 2019 Specialist
Oracle Cloud Infrastructure 2019 Certified Architect Associate
Oracle Cloud Infrastructure Foundations 2020 Certified Associate
Oracle Cloud Infrastructure 2019 Certified Architect Professional
Oracle Cloud Infrastructure 2020 Certified Architect Professional
Contact this candidate