SUMMARY

• Over 12+ years of Experience in Information Technology industry as a Database Administrator.
• Wif exposure to Practices and Procedures that includes installation, configuration, administration, migration, upgrade, remote administration, and support of Oracle databases on all major Operating Systems.
• Migrated oracle 12c Database from on premise to AWS Ec2 wif minimal downtime.
• Data guard implementation both on premise as well AWS Cloud
• Experience on Oracle RAC administration, Greenplum DBA, AWS Cloud.
• Worked on OEM upgrade from 13.2 to 13.4
• Installed OEM 13.5 on AWS cloud
• Excellent noledge of Linux, Solaris, Windows operating system, and server processes monitoring, and teh interaction between teh database and teh operating system such as shared memory processes and networking concepts.
• Strong learning abilities wif keen interest in learning new technologies and best practices wif passion to take on challenges to deliver and add value to teh clients, good communication and inter - personal skills, accustomed to work in a team environment wif tight schedules, and capable of working efficiently under pressure and managing multiple projects.
• Work as great Team player, support each other, do smooth handoff on any work to shift people, do share noledge document and presentation.
• Extensively worked wif Oracle Support on several issues, by opening Sev tickets.
• ASM Administration, maintenance, troubleshooting, Storage Migrations.
• Worked closely wif Application Team/Developers, Troubleshooting wif various monitoring tools and scripts, generate various Reports, Explain Plan, create sql Profile and baselines - administer them.
• Flashback, Database Re-Org, Security, Day to day DBA activities like Prod, Non Prod Support, Work on Tickets/CRQs/Incident tickets/Violations.
• Develop and manage build and release processes and configurations to support daily software development, testing, production builds and deployment operations.
• Expertise in performing system administration tasks and change management process for implementation and migration, coordinating wif Oracle Corporation Support to resolve issues, and providing 24x7 application support.
• Administering and maintaining Production, Stage, Development instances 24X7 Production Database Support and maintenance.
• Handling Resource Queues on Database.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x

Languages: SQL, Unix

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp,, GRD, Webex Chat, Sqldeveloper, Cygwin, putty, winscp, psftp, vnc, Quality Center 9.2, 10.0

Products: RDBMS (10g, 11g, 12c and 19c), Grid Control, ASM, RMAN, RAC, Data guard

High Availability: 12c RAC,11g RAC, Data guard

Back up: BC backup, NetBackup

Other Tools: SDM, Service Now, GRD, Support central, Pgadmin-III

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead (SME)

Environment: Linux, Oracle 12c, AWS Cloud

Responsibilities:

• Migrating database from on premise to AWS cloud using Rman/Expdp and data guard.
• Configured Active data guard and tested for failover and switchover.
• Cronjob scheduling as part of backups
• Scheduling backups in S3 using oracle secure backups.
• Coordinating between application and infra teams
• Migrated database using transportable tablespace.
• Migrated database using transportable tablespace.
• Disk group creation and adding disks wif normal redundancy
• Worked on Grid upgrade from 19.3 to 19.9 in Cloud platform
• Liaise wif other Teams & Design Architects ex: Storage, Network, Monitoring etc.
• Raising and following up of Oracle service request.
• Troubleshooting performance issues reported by teh Application Team.
• Migrating non-RAC databases to RAC databases.
• OEM upgrade from 13.2 to 13.4
• Installed OEM 13.5 in aws Cloud

Confidential

Greenplum DBA

Environment: Greenplum, PostgreSQL, AWS Cloud control

Responsibilities:

• Handling Database operations which include DDL, DML and DCL operations.
• Experience in building Greenplum Cluster.
• Experience in migration database from On-Prem to AWS Environment.
• Handling database level configuration files like postgresql.conf and pg hba.conf.
• Experience in writing queries and shell scripts for database level health checks which include alerting long-running queries, alerting blocking Queries, alerting spill files, auto compressing database logs and queries for gathering database metrics.
• Performing partitioning for tables wif large size to increase performance.
• Handling deployments and Users requests.
• Performing Database Maintenance Activities.
• Refreshing data from one environment to another environment.
• Handling Resource Queues on Database.
• Handy on all Greenplum database utilities like (pg dump, pg restore, gp dump, gpcrondump, gp restore, gpdbrestore, gpstart, gpstop, gpstate, gpinitsystem, gpinitstandby, gpactivatestandby etc.,
• Recovering and rebalancing teh failed segments of database.
• Handing Back-ups and restores of Database wif db utilities.
• Maintaining database level and system level parameters.
• Handling Users and Privileges on teh database.
• Analysing and tuning teh functional codes for smooth performance of teh database.
• Handy on AWS S3 commands like creating new bucket, Creating New folder in a bucket, Copying files from on-prem to AWS S3 and vice-verse.
• Rebooting Greenplum servers.
• Installation of GPPERFMON Database for teh Greenplum performance metrics.
• Handling Greenplum client’s installations and operations.

Confidential

Oracle DBA

Environment: Linux, Oracle 11g/12c.

Responsibilities:

• Responsible for managing and supporting all Production, Development and Staging instances of Oracle Version 11g & 12c.
• Administration of database instances in standalone & ASM environment.
• Typical DBA tasks like database and schema refresh, partition table and materialized view management; character set conversion, space management, rollback segments, DB links, network file setup etc.
• Raising and following up of Oracle service request.
• Scheduling backups and monitoring.
• Starting and Stopping all Apps services and troubleshooting.
• Administering RAC databases using SRVCTL.
• Resolving user’s day-to-day issues.

Confidential

Oracle DBA

Environment: Linux, Oracle 11g/12c.

Responsibilities:

• Responsible for managing and supporting all Production, Development and Staging instances of Oracle Version 11g & 12c.
• Administration of database instances in standalone & ASM environment.
• Patched and upgraded databases from 11.2.0.2 to 11.2.0.4.11.2.0.2 to 12.2.0.2
• Migrating database from 11g to 12c using Rman/Expdp
• Raising and following up of Oracle service request.
• Scheduling backups and monitoring.
• Starting and Stopping all Apps services and troubleshooting.
• Administering RAC databases using SRVCTL.
• Resolving user’s day-to-day issues.

Confidential

Oracle DBA

Environment: Linux, Oracle 11g/12c.

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g/11g databases on Linux and Windows Platforms.
• Installation, Configuration and Administration of Oracle 11gR2 RAC databases on Linux Platforms.
• Migrating Data bases from NONRAC To RAC.
• Oracle Cluster ware Upgrade from 11.2.0.3 to 11.2.0.4.
• Database upgrade including 11g, 11gR2ASM conversation, migration across different OS and patching.
• Typical DBA tasks like database and schema refresh, partition table and materialized view management; character set conversion, space management, rollback segments, DB links, network file setup etc.
• RMAN and User Managed Backup procedures. Creating database back-ups and fixing backup failure issues. As and when required performing database recovery.
• Using Grid Control utility, monitoring and optimizing performance of Database, Memory, and Disk. Tuning of shared pool, buffer cache, redo mechanisms. Identify and resolve I/O, data storage and database configuration issues. Coordinating wif Oracle Support for fixing repeatedly occurring software bugs.
• Coordinating wif major production releases, weekend maintenance activities and checking database integrity. Performing BAU activity like Creating/Analyzing primary database objects (tables, views, indexes) once application developers have designed an application. -Controlling and monitoring user access to teh database.
• Monitoring production batches, attending job failures and subsequently fixing problems. Preparing impact analysis about teh changes.
• Installation and upgrade of new technologies of oracle like Grid Control, OCM and its efficient usage. Also working wif ASM databases and utilization all other new of latest RDBMS release etc.

Confidential

Oracle L2 DBA

Environment: Linux, Oracle 11g/12c.

Responsibilities:

• Daily maintenance of teh 20 production and 20 developments and staging databases and pro-active monitoring of teh performance.
• Installation, Maintenance & Configuration of databases.
• Created a number of dev/stg and prod database instances.
• Installing Oracle cluster software.
• Creating RAC databases using OCFS,ASM file system.
• Migrating non-RAC databases to RAC databases.
• Managed 800GB cluster database which having 3 cluster nodes.
• Very much acquainted to teh change management process (CCT) for production changes.
• Performing release level and version level upgrades.
• Expertise in applying Patches (CPU, DST & One off/bug fix patches) to all releases of Oracle on UNIX env.
• Monitor and report status of databases (capacity, size/limit, performance, etc.).
• Physical Database Backup and Recovery (hot and cold backups), Logical Backup and using Import and Export.
• Carry out wif Database refresh (Using Hot & Cold backups, RMAN), schema refreshes, table refreshes.
• Creation of table spaces, user maintenance, database security imposition by creation and granting of roles and privileges.
• Distribution of Table spaces among different Disks and creation of Database objects and monitoring teh tablespaces.
• Executed teh scripts as on when asked by teh developers and provided them teh log files of teh executed scripts.
• Worked on Oracle Enterprise Manager (OEM) used to schedule teh database backups and handle teh failed backups through OEM, used to extract teh AWR and ADDM reports and extract teh structure of tablespaces and tables through OEM.
• Production Support for Oracle 9i/10g Databases.
• Performed Refresh Activity for Databases from Production to Development, Testing Environment.
• Troubleshooting performance issues reported by teh Application Team.
• Worked wif application development team to resolve app related issues.
• Monitoring teh Table space and thus help Predict Trends and take Appropriate Steps like adding and resizing teh datafiles.
• Automating jobs by using crontab.
• Monitoring Alert logs for any errors, problems or processes running.
• Define, Create & Structure, ensure performance and efficiency of databases.
• Creating users and managing roles and privileges.
• Carry out database administration, backup, recovery & system monitoring.
• Generic .profile scripts setup for databases & env setup on brand new servers.
• Several load tests on databases in coordination wif testing/dev teams.
• Ensure space management on servers and user management at teh database and OS Level.
• Involved in scenarios where we brought up teh database after they got crash.
• Experience in opening, managing, and resolving Oracle TAR's to resolve prod issues.
• Interaction wif client/users on various issues.
• Monitoring native tools for tickets and Ensuring quality of teh deliverables as per teh SLA and maintenance standards agreed upon.
• Working under teh environment of 24X7 DBA support.
• Acting upon teh critical ORA 600 alerts checking daily alert logs.