Manager Data

Alex

Email: add11r@r.postjobfree.com

Phone: 267-***-****

KEY STRENGTHS

I have over 11 years of active experience in installation and configuration, system implementation and problem trouble shooting. Experience with Oracle 9i, 10g, 11g, 12c, 18c Installation, Administration, Data Guard, RMAN, ASM, and RAC Involved in different scenarios of OLTP and data warehouse farms.

Experience in creating development, test, stage, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.

Expertise in installation and configuration of oracle 10g, 11g, 12c, 18c on various platforms like IBM-AIX, SUN SOLARIS, HP-UX, Red Hat Linux and Windows.

Having a sound knowledge of new features of Oracle 11g R2.

Experience in implementing DR (Disaster Recovery) & High availability solutions using DataGuard (11g/10g), Standby Database (9i) and oracle 9i, 10g, 11g RAC,12c RAC

Proactive monitoring in identifying bottlenecks in the application and database using Statspack, AWR, ADDM and 12c OEM Cloud Control Monitoring.

Experience in development and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatics Power Center/Data stage.

Expertise in database backup/recovery strategy (BCV mirroring, RMAN, Export/Import & Data Pump), Performance Tuning, Capacity Planning, Standby database (Logical, Physical), Oracle configuration management, database cloning, refresh, and patch management.

Worked with latest 10g/11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.

Assisted in management and database administration of Oracle database applications on Exadata platforms

Performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Application Tuning and Database/Instance Tuning.

Experience in performance-tuning services like EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g/11g/12c OEM Grid Monitoring, custom scripts troubleshooting Oracle databases using sqltrace.

Involved in oracle technical support process through Metalink and other procedures.

Experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.

Expertise in basic and advanced replication using Oracle Streams.

Experience in using OEM, TOAD, Data migrations using export/import, Data pump, RMAN.

Maintaining Database Security using security compliance auditing, capacity planning.

Experience in using SQL *Loader and External Tables for Export/Import of data.

Experience in optimization of SQL statements using Techniques like cost based and Role based optimization and accordingly Generated Explain plan.

Experience in DBA activities like creating of databases, users and table spaces, partitions, Indexes, constraints and permissions.

Extensive use of TOAD for extracting scripts from the dictionary.

Strong experience in working with multiple projects in high-pressure environment.

Quick learner and willing to contribute in a team environment.

Installation, configuration & administration of Oracle Grid control.

Worked on the BMC remedy ticketing system.

Capacity Planning and bench marking the data growth year over year.

Experience as On-Call 24x7 production DBA support, Application/Development DBA.

Very familiar in creating TAR/SR with Oracle Support and Metalink to resolve the production database issues.

Excellent verbal and written communication and presentation skills and Strong interpersonal skills, ability to interact with people at all levels.

Excellent Communication, Presentation and Analytical skills.

TECHNICAL PROFICIENCY

Operating Systems

RHEL, CentOS, Windows, HPUX, AIX, Solaris

RDBMS

Oracle Server 9i/10g/11g/12c

Storage

ASM, Tivoli Storage Manager

Tools

Upgrade, Migration, RAC, Data Guard, ASM, GoldenGate, SQL*Plus, PL/SQL, SQL*Loader, TOAD, 12c Cloud Control, Export/Import, Data Pump, RMAN, Shell Scripts, RMAN Duplicate Database, Oracle SQL developer, DBvisit, GDS, OCI, AWS, Confluence, Jira

Programing languages

PL/SQL, SQL, C, C++

Degree/Certificates

A.S. Computer science – Normandale Community College (In Process)

Highschool/GED obtained

PROFESSIONAL EXPERIENCE

Organization

FedEx, Cranberry TWP, PA

Position

Sr. Oracle Database Administrator

Duration

Dec 2018 to Present

Roles and Responsibilities:

Configured and installed VMs on OCI

Maintained multi-tenant databases on OCI

Created TEST database over Exadata machines on ORACLE Cloud

Maintained 18c databases on OCI

Maintained databases from 11g to 12c multi-tenant

Configured GDS on RAC environment on OCI

Successfully tested and maintained GDS on RAC environment for multi-tenant databases on OCI

Configured open ports on OCI for GDS

Worked on dataguard issues like gaps and etc. in multi-tenant database

Maintained, worked and resolved issues for oracle databases on AWS

Maintained Exadata on Oracle Cloud

Created Exadata standby on Oracle Cloud (OCI)

Created 18c Database

Worked on MYSQL implementations

Organization

SYNTEL, Minneapolis, MN

Position

Sr. Oracle Database Administrator (Consultant)

Duration

Sep 2017 to Aug 2018

Roles and Responsibilities:

As part of Technology team, I maintained 8 oracle databases in total of 40 terabytes. I worked on database performance tunings, migration to newer versions (12c) from (11g) in RAC and ASM environment.

Used GoldenGate to support replication between a broad range of heterogeneous hardware platforms and database management systems

Worked closely with BA, Offshore and Onsite development and DBA teams on functional and technical requirements, development, QA, and releasing code to production.

Configured GoldenGate High Availability using Oracle Active Data guard.

Installed and configured GoldenGate to work with OEM GoldenGate Plugin.

Involved in deploying new application and setting up replication between the databases using GoldenGate

Setup/configured oracle RMAN for database backup and recovery. Application of different recovery procedures

Installing ASM environment and migrating database from NON-ASM to ASM.

Worked on the RAC environment for the high availability managed by ASM.

Resolved the issues in conflicts between the target and source database in GoldenGate

Configured and implemented Oracle Goldengate replication

Implementing 2- node RAC in different UNIX platforms and installing Oracle 12c RAC software with ASM

Migrated Non-ASM databases to ASM environment for high availability

Worked troubleshooting RAC and implemented ASM features

Handled numerous enhancement and maintenance requests, data updates, bug fixes.

Performed data analysis and validation to ensure the integrity of client financial reports.

Optimized and tuned long running queries and views using various techniques such as Explain Plan, Analyze table, adding explicit cursors with bulk collect, creating indexes, hints, temporary tables, etc.

Separated the development environment from the production server to allow for better testing without slowing or stopping production by having different databases environments.

Converted ad hoc code into PL/SQL

Worked with Data Science team to mask source data while preserving the relationships between different entities

Helped to scale data analysis to process multi-gigabyte data files

Monitored and resolved SQL performance issues for multiple applications, reporting systems and dashboards

Designed and implemented solutions to archive and purge data using IBM OPTIM

Migrated data from Oracle database to SQL server database

Designed, evaluated and managed Oracle schema securities plan by controlling all types of privileges for schemas in Database from system privileges to roles and individual object permissions.

Planed for different SQL profiles based on the function of schemas.

Created public and private DB links between different databases based on various applications’ structures by complying to company’s security and compliance rules.

Optimized the Partitioning and index design to be more compatible and efficient to the major SQL demands.

Designed audition plan for certain sensitive business tables.

Organization

GE, Bensalem, PA

Position

Sr. Oracle Database Administrator

Duration

Oct 2014 to Aug 2017

Roles and Responsibilities:

Involved in 24x7 support for production RAC databases with on-call pager

Supported production, development and testing databases of Multi Terabytes DB sizes.

Maintain and Administer SQL Server Databases on Windows Server VM

Applied Patch’s to Oracle 10g, 11g tested.

Upgraded oracle from 11g to 12c

Worked on databases on VMWare

Moved Oracle Databases between two HP-UX Servers using the Cold Backup.

Installed Oracle Enterprise Manager Grid Control 10.2.0.5 on Windows Server and configured the same with the other Oracle Databases.

Created and configured Oracle Enterprise Manager Grid Control Repository Database.

Monitoring Oracle Databases and SQL Server Databases using Oracle Enterprise Manager and SQL

Experienced with SRVCTL, OCR and Voting Disk of 10g RAC

Strong physical and logical Data Guard skills.

Handled RAC Node hangs and node eviction issues.

Maintaining schemas and partitioning tables.

Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.

Configure and manage tablespaces, tables, and users for custom applications.

Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area

Creating and dropping of users, granting and revoking permissions to users/roles as and when required.

Worked on Space Management and Security.

Rebuilding of Indexes for better performance and maintenance of Oracle Database.

Installing ASM environment and migrating database from NON-ASM to ASM.

Configure and manage tablespaces, tables, and users for custom applications.

Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area

Creating and dropping of users, granting and revoking permissions to users/roles as and when required.

Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes.

Back up of Archive Log files and monitoring space in that mount point.

Responsible for taking full hot/cold and Differential database backup.

Cloning and Refresh of Database (using backup and duplicate).

Assisted in integration of Exadata applications into current IT actionable events and solutions

Used GoldenGate to support replication between a broad range of heterogeneous hardware platforms and database management systems

Database health check using Statspack report, Tkprof, AWR

Managing and Resolving end user request via HPSC ticketing tool

Work on OEM issues, setup alerts thresholds.

Handled RAC Node hangs and node eviction issues.

Maintaining schemas and partitioning tables.

Implemented the Security using Oracle Database Vault

Maintenance of installed Oracle database and supporting multiple production, development and test instances of varied complexity including Multiple Tier and RAC environments.

Worked on the RAC environment for the high availability managed by ASM.

Organization

IBM, Dubuque, IOWA

Position

Oracle Database Administrator

Duration

Mar 2011 – Sep 2014

Roles and Responsibilities:

Managing and creating Oracle database.

Installed and configured Oracle 12c, 11g, 10g 64 Bit on Linux for Production, Development and Testing.

Installed, configured and tested oracle 10g and 11g RAC environment and trouble shooting.

Implemented Migration of Databases from 10g to 11g and applying patches whenever required.

Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.

Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy-included development of daily, weekly and monthly strategy incorporating incremental backups.

Monitoring & Managing the Tablespaces and datafiles growth

Proficient in database design, triggers, snapshot and stored procedures in Oracle 9i,10g and 11G

Database designing, Database administration.

Defining backup & recovery plan, Database tuning.

Refresh and Cloning of Database.

Experience in Database migration from 9i to 10g,11g on Production/Development databases

Enabling SSO services, Wallet manager, Oracle text installation

Expertise on database backup/recovery strategy (RMAN, Export/Import & Datapump) on Production environment.

Removing table fragmentation.

Dataguard implementation and maintenance for Disaster Recovery.

Alert Log Checking (Monitoring) and User Trace File and Archive log maintenance.

Creating users, granting roles, Creating and Maintaining snapshot.

Database Export and Import Utilities.

Monitoring locks and various sessions.

Managing OEM.

Configuring Virtual Private Database for Application Access Control and row-level security policies

Modified functions for specific query tuning on column-level VPD

Performing Day-to-Day DBA tasks - performance tuning, database design, system security, database installation configuration, patching, technical database support in 24X7 environment.

Responsible for quarterly patches, /maintaining/Monitoring/Upgrading the Production/Dev/Test and training databases for products.

Setup/configured oracle RMAN for database backup and recovery. Application of different recovery procedures for complete and incomplete recoveries depending on the type of failure by using export/import & OS scripts like shell & cron job schedule.

Installation of oracle database and clients on UNIX and windows (Silent installation, GUI installation.

Restore and Recover of database from offline, online and RMAN backup.

Maintaining 1300+ Database instances running on Linux in VERITAS cluster environments.

Retrieval of backup from TSM (Tivoli Storage Management).

OEM Monitoring (health, status, alerts, agents etc., Configuration of databases in different groups, Instances, agents, Listener, Setting/Removing Blackout)

Managing Agent using OEM and manually (upload Matrix, Resynchronization etc.)

Organization

Spectrum Health, Grand Rapids, MI

Position

Oracle DBA

Duration

July 2009 – Feb 2011

Roles and Responsibilities:

Supporting 24*7 Production databases along with development and maintenance databases.

Proactive monitoring through OEM 10G GRID Control.

Database refreshes using RMAN backups and hot backups also extensively using RMAN for all types of recovery/backup scenarios.

RMAN Catalog maintenance, purging sufficiently old backups from TSM Server etc.

Troubleshooting problems of development and application teams.

Upgradation of databases from Oracle 8i to 9i, 8i to 10GR2, 9i to 10GR2 etc.

Day-to-Day Maintenance of multiple 10G RAC environments on ASM

Applying Patches to RAC/Non-RAC databases.

Upgradation of RAC databases from 10.2.0.1 to 10.2.0.2 etc.

Space Management in ASM Disk groups Addition of new disks etc.

Configuring TAF

Work on Physical Standby databases in Dataguard environment and perform related activities i.e. Perform Role Switchover for maintenance of Primary database etc.

Created physical standby setups in Dev/Production environments.

Troubleshooting day-to-day Standby database issues.

Installation and Creation of new databases in Dev and Production environments.

Handling Production databases on High Availability Clusters (HACMP) on IBM-AIX platform.

Export and import of tables, schemas and Full db as per development/Application team req.

Configure rman backups for databases and schedule them through Crontab.

Resolve common database issues like Locking, Free Space, connectivity issues, Applying patches.

Performance Tuning of problem queries.

Work on Materialized views and handle related issues.

Configure Listener and tnsnames configuration and troubleshoot related issues.

Tracing problem user sessions and analyzing TKPROF reports.

Contact this candidate