SUMMARY:

I have over 4+ years of day to day experience as a PostgreSQL Database Administrator and 6+ years as an Oracle Database. Administrator, having hands on experience in database administration, production and development support, installation, configuration, upgrades, performance tuning, backup and recovery, data guard, Goldengate Replication and database security. Worked with Oracle (10g, 11g, and 12c) on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platforms.

TECHNICAL SKILLS:

Operating Systems: Proficient in Sun Solaris, Linux, Unix, HP-UX, IBM AIX, and Window.

Databases: Oracle 10g, 11g, 12c, Exadata, Microsoft SQL Server, PostgreSQL database, Exadata AWS.

Language: SQL, PL/SQL, T/SQL, PL/pgSQL, Using Scripting.

Tools: RMAN, OEM, SQL*Loader, FTP, WINSCP, EXP, IMP, Data Pump, TOAD, SPM, SQLT, OSWATCHER, SQL*Plus, Grid Control, DBCA, Data Guard, TKPROF, Golden Gate, EMC Storage, NET Backups, PgAdmin.

PROFESSIONAL EXPERIENCE:

SQL Database administrator

Confidential

Responsibilities:

• 4+ years working as a database administrator with PostgreSQL
• Installing and Configuring PostgreSQL from source or packages on Linux machines.
• Expert Level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
• Ability to efficiently write database code without compromising data quality, privacy or security.
• Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
• Knowledge of fault detection and resolution processes.
• Ability to proactively identify, troubleshoot and resolve live database systems issues.
• Configured PostgreSQL databases to replicate across multiple sites using RepMgr and streaming replication.
• Experience with Data warehouse concepts and designs.
• Installing / Configuring PostgreSQL from source or packages on Linux machines.
• Experience designing database structures, indexes, views, partitioning and data rollup strategies, federation, and stored procedures.
• Data migration while upgrading database versions.
• Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL (9.x and greater).
• Maintaining custom vacuum strategies for high volume databases.
• Performed heavy query and database design analysis for multiple SQL Server databases to improve performance.
• Linked database security controls to external authorization sources to provide row-level security.
• Built master to warm standby failover scripts on Amazon EC2 cloud servers and PostgreSQL 8.4.
• Utilized the Amazon EC2 API Developer Tools to interface with cloud server management.
• Programing various scripts to load data into a database and process it from various sources, (XML, CSV, JSON, API data feeds, Database dumps).
• Hand-on experience on performance tuning/ index maintenance and backup and restoring PostgreSqL database on a regular basis.
• Experience with mtk, a tool for migrating databases from Oracle to PostgreSQL.
• Use of the Git Version Control System for code repositories.
• Experienced writing Perl to run on both Linux and Windows environments.

Oracle Database administrator

Responsibilities:

• 5+ as Linux administrator Diagnosed and resolved hardware problems with Dell servers, workstations, and other hardware equipment
• Setup, configured, and debugged network configurations for RedHat servers and workstations
• 5+ experience with full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle and SQL-server databases.
• Performed troubleshooting of database using AWR and ADDM reports.
• Automated monitoring the databases, performance parameters, backup and recovery.
• Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Migrating and consolidation of 11g databases into 12c in both QA and Production environments.
• Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and pluggable database administration and cloning.
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Goldengate.
• Experience in configuration of Oracle 10g, 11g and 12c physical & logical standby database.
• Expertise in Disaster Recovery Planning and high availability solutions by performing switchover and failover operations in Data Guard.
• Experience in creating and managing Single Instance databases and RAC primary and standby databases under various business critical environments.
• Good hands-on experience in High Availability solutions with Oracle 10g, 11g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams, GoldenGate.
• Good hands-on experience in configuration of Oracle 10g R2, 12c OEM Grid Control to monitor database.
• Good hands-on experience applying recommended Upgrade Patches as well as CPU/SPU and PSU patches to the standalone and RAC databases. Design development, system integration phase, quality assurance phase, development and production support activities.
• Monitored and tuned long running jobs by working with the application development team and analyzing objects created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
• Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 11 TB.
• Experience in the Upgrade of Oracle Databases in patch set Level and in version Level (9i to 10g), (10g to 11g) and (11g to 12c).
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. Preparation of High Level & Low-Level Design documents.
• Written SQL scripts to create database objects like tables, views and sequences.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Solid skills to configure Exadata to meet company internal security requirement. performance bottlenecks improve existing schemas and design new ones.
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
• Gathering and updating project materials, completing budgeting, farecasting, project documentation, business flows, and lessons learned documents.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization...

Confidential, Phoenix, AZ

Oracle Database administrator

Confidential

Responsibilities:

• Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification.
• Upgrade DBs from 11.2.0.4 to 12.1. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMANT Granting required privileges to users.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 10G to 12c.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab and $UNIVERSE.
• Installation of oracle 11g and 12c databases in production, development and test environments depending on project requirements. Capacity planning: Allocate system storage and plan future storage requirements.
• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for test, Development and Production for various home-developed applications.
• Configured and Managing Oracle 11gR2 Data Guard (Active Physical Standby on 2 nodes RAC).
• Design and Maintaining Physical standby maintenance (Switch over -using Data Guard Broker).
• Installed and currently Managing Oracle 12c Grid Control (OEM) for monitoring Production, Active Data Guard (DG Broker), Stage and Dev systems.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Monitoring and troubleshooting the gaps between source and target databases configured with GoldenGate.
• Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments. (Sun Solaris, Linux Red hat)
• Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure (Clusterware and ASM) and Oracle rdbms software on a 3 nodes RAC architecture in development and UAT running.
• Experience in designing and configuring high-availability systems using Data Guard with physical standby effectively configured and used Data Guard Broker utility.
• Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
• Performed logical backups using Export/Import and Data Pump
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction
• Performance Tuning of SQL statements and Database Tuning using tools like Explain plan, TKPROF, SQL Analyze, UTLBSTAT, UTLESTAT, STATSPACK, ADDM, AWR reports etc.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization...
• First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts) using OEM
• Monitored and troubleshoot database issues with OEM grid control.
• Built physical standby using RMAN Active duplication method as well for Disaster recovery site
• Performed database recovery using GRP (Guarantee Restore Point)
• Comfortable in using ASM for creating disk groups, adding additional storage (DISKS) and troubleshooting ASM issues.
• Worked with a team project to migrate from Oracle to PostgreSQL platform.
• Install, monitor, and maintain PostgreSQL & MySQL software, implement monitoring and alerting, implement backup and recovery processes, provide system and SQL performance tuning and assist in business process integration with various data sources.
• Fulfills user requests ranging from access control, backup, restore, refresh to non-production to performance tuning.
• Experienced in installing, configuring and upgrading Enterprise DBPostgres databases and clusters.

Confidential, Minneapolis, MN

Oracle Support Database Administrator

Responsibilities:

• Responsible for network configuration and involved in a Client-Server environment. using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.
• Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
• Applied security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU) and One-off Patch) using runInstaller and opatch.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Installed Oracle and grid software on standalone servers on ASM and file system.
• Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Worked on disaster recovery of Exadata Data Guard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.
• Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.
• Part of a team to install and maintain ORACLE 10g RAC, ASM database for high availability.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases. Administered databases of various sizes from 500GB to 6TB.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage. Debugging SQL tuning
• Plan for contingency, disaster management that includes standby databases, data guard and cloning/refresh of the databases.
• Working on Exadata X2, X3 and X6 machines which included Half Rack and Full Rack
• Monitored and tuned long running jobs by working with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
• Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.