SUMMARY:

• Full responsibility and expertise in database administration (DBA), performance tuning, database optimization, database backup, database recovery, database security, data migration of Oracle instances.
• Installation of SQL Server (2012,2014 and 2016) and implementing of the Business Intelligence Development Studio (SSIS, SSAS and SSRS).
• Good communication and cooperation skills with an aptitude to learn quickly, welcome responsibility, work under pressure.
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 9 TB.
• Experience in Installation of Oracle Databases 10g, 11g and 12c versions as well as SQL Server 2014 and 2016.
• Experience in the Upgrade of Oracle Databases in patch set Level and also in version Level (9i to 10g), (10g to 11g) and (11g to 12c).
• 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.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, Datapump export/import.
• Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, development and production support activities.
• Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.
• Performing Fault Injection Test Cases for verifying the High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover.
• Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms.
• Configuration and Management of Data Guard on RHEL, OEL.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) /Network Attached Storage (NAS).
• Proactively monitoring the database's health and taking preventive or corrective actions.
• Proficient in Database Design (Physical and Logical Database Design) and Normalization.
• Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).
• Used EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Proficient in using various database Utilities such as EXPORT/IMPORT, DataPump, TOAD.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.
• Automated many common tasks using Crontab including Backups, exports and imports.

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g, 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Statspack/AWR, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

PROFESSIONAL EXPERIENCE:

Confidential, St Paul, MN

Oracle Database Administrator

Responsibilities:

• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.3 & 6.1. Database sizes range from 2GB to 3TB (in ODS & EDW environments).
• Applying CPU/PSU Patches on ERP instance and Plain databases.
• Cloning of Test/DEV instances from Production systems.
• Maintained Oracle 11gR2 RAC high availability with ASM file system with Cluster Stat and Grid infrastructure on Linux environments. Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Analyzed SQL queries causing performance problems.
• Created, Configured, Upgraded and Administered 10.2.0.4/11.2.03 & 12.1 versions Oracle databases on Linux Red Hat and Cent OS on Vmware and bare-metal environments.
• Performed an upgrade of Oracle Database from 11g to 12c.
• Creation and configuration of new database server and database environments.
• Performing Monthly Re-org of complete databases using expdp and impdp
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Disaster Recovery (DR) Plan Implemented using DATAGUARD (Physical Standby) for high availability/disaster recovery purpose on Oracle 11g.
• Performing DR switchover and failover operations.
• Participated in meetings for Project Updates/Project Enhancements/Trouble shooting periodically
• Maintaining database and middleware/SOA layer performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases.
• Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities
• Troubleshoot installation errors both independently and with Oracle support (via My Oracle Support)
• Create oracle databases on configured servers using both the DBCA & Database creation scripts.
• Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 10g database control, oracle 10g Grid Control as well as other third party tools (TOAD, SQLDeveloper and DBArtisan for Oracle).
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration.
• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)
• Provided valuable inputs for various performance tuning issues.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, TKPROF.
• Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory. installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance
• Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins.
• Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.

Tools: Used: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential

Oracle Database Administrator

Responsibilities:

• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Worked on disaster recovery of e Dataguard 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.
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
• Performed troubleshooting of database using AWR and ADDM reports.
• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.,
• Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
• 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.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly 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.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• 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.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, Richfield, MN

Oracle Junior DBA

Responsibilities:

• Migration from Linux to Solaris and 32 bit to 64 bit
• Restore and Recovery of database in case of database crash, disk/media failure.
• Applying patches and works closely with Oracle to make Application environment up to date.
• Backups & Recovery Maintenance, Databases Performance Tuning.
• Typically involved in database Designing, creation and maintenance.
• Good working knowledge of SQL, PL/SQL, and shell scripting.
• Created users and grant privileges according to the requirements.
• Provided System support for both development and 24*7 production environments.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference. Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues, disasters from happening.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Involved in session management and monitored the critical wait events, blocking sessions in the database.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.
• Write database documentation, including data standards, procedures and definitions.

Tools: Used: Oracle 10.2.0.1, Oracle 11g, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential

Soccer Coach/Administrator/Club President/Youth Mentor

Responsibilities:

• Youth Soccer Coach, coaching ages 6 through 19
• Age group coordinator
• Technical and tactical advisor
• Train coaches and referees
• Coached Olympic Development
• Designed skills training programs for club and colleges
• Founded an inner-city soccer club
• Former Club President and Coaching Director

Confidential, Minneapolis, MN

Network Engineer

Responsibilities:

• Supported functionality and maximum performance and to ensure proper backups of all database files
• Monitored quota on table spaces in line with resource planning guide
• Implemented database security measures based on vulnerability reports generated by security team Measures included password policy, patching, parameter modification, and system privileges restriction for users and or schemas
• Created database objects such as tables, views, synonyms, sequences, and triggers
• Worked with project teams to identify database changes needed and implement changes
• Assisted in the implementation of Sarbanes-Oxley Act of 2002 by ensuring sound backup policy
• Implemented, maintained and supported communication networks (LAN, WAN, Wi-Fi, VoIP etc.)
• Assists in implementation and management of database security
• Securing network system by establishing and enforcing policies, defining and monitoring access
• Ensure high availability of network infrastructure to provide maximum performance for users
• Provided network troubleshooting and administrative support
• Monitored performance, troubleshooting network problems and outages.
• In charge of all hardware, including laptops, servers, switches and electronic library

Confidential, Minneapolis, MN

Helpdesk/ Network Engineer

Responsibilities:

• Implemented, maintained and supported communication networks (LAN, WAN, WiFi, VoIP etc.)
• Assists in implementation and management of database security
• Securing network system by establishing and enforcing policies, defining and monitoring access
• Ensure high availability of network infrastructure to provide maximum performance for users
• Provided network troubleshooting and administrative support
• Monitored performance, troubleshooting network problems and outages