SUMMARY

• Over 12+ years of Experience in Information Technology industry as a Database Administrator.
• With 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 with 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 knowledge of Linux, Solaris, Windows operating system, and server processes monitoring, and the interaction between the database and the operating system such as shared memory processes and networking concepts.
• Strong learning abilities with keen interest in learning new technologies and best practices with passion to take on challenges to deliver and add value to the clients, good communication and inter - personal skills, accustomed to work in a team environment with 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 knowledge document and presentation.
• Extensively worked with Oracle Support on several issues, by opening Sev tickets.
• ASM Administration, maintenance, troubleshooting, Storage Migrations.
• Worked closely with Application Team/Developers, Troubleshooting with 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 with 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.
• Handy on all Greenplum database utilities like (pg dump, pg restore, gp dump, gpcrondump, gp restore, gpdbrestore, gpstart, gpstop, gpstate, gpinitsystem, gpinitstandby, gpactivatestandby etc.,

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 with normal redundancy
• Worked on Grid upgrade from 19.3 to 19.9 in Cloud platform
• Liaise with other Teams & Design Architects ex: Storage, Network, Monitoring etc.
• Raising and following up of Oracle service request.
• Troubleshooting performance issues reported by the 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 with 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 the failed segments of database.
• Handing Back-ups and restores of Database with db utilities.
• Maintaining database level and system level parameters.
• Handling Users and Privileges on the database.
• Analysing and tuning the functional codes for smooth performance of the 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 the 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 with Oracle Support for fixing repeatedly occurring software bugs.
• Coordinating with 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 the database.
• Monitoring production batches, attending job failures and subsequently fixing problems. Preparing impact analysis about the changes.
• Installation and upgrade of new technologies of oracle like Grid Control, OCM and its efficient usage. Also working with 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 the 20 production and 20 developments and staging databases and pro-active monitoring of the 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 the 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 with 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 the tablespaces.
• Executed the scripts as on when asked by the developers and provided them the log files of the executed scripts.
• Worked on Oracle Enterprise Manager (OEM) used to schedule the database backups and handle the failed backups through OEM, used to extract the AWR and ADDM reports and extract the 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 the Application Team.
• Worked with application development team to resolve app related issues.
• Monitoring the Table space and thus help Predict Trends and take Appropriate Steps like adding and resizing the 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 with testing/dev teams.
• Ensure space management on servers and user management at the database and OS Level.
• Involved in scenarios where we brought up the database after they got crash.
• Experience in opening, managing, and resolving Oracle TAR's to resolve prod issues.
• Interaction with client/users on various issues.
• Monitoring native tools for tickets and Ensuring quality of the deliverables as per the SLA and maintenance standards agreed upon.
• Working under the environment of 24X7 DBA support.
• Acting upon the critical ORA 600 alerts checking daily alert logs.