ORACLE / PostgreSQL Database Administrator

addfn8@r.postjobfree.com

718-***-****

DATABASE ADMINISTRATOR

Over 5 years of experience in IT industry as an Oracle Database administrator, SQL server, PostgreSQL Databases administration and good exposure to MariaDB. Responsible for the implementation, design, and optimization of various database environments ranging from small business databases to large enterprise databases. Worked on complete SDLC. Expertise involves in Performance Tuning, Production support, installation, Upgradation, monitoring and, optimization of Oracle databases on various platform like Red Hat Linux, Sun Solaris and Windows. Great team player, quick learner, bilingual (French and English) and excellent motivator that has been very instrumental in vital DBA team collaboration and has also excelled working alone in various environments.

EDUCATION

ASSOCIATE’S DEGREE in Computer Information System CUNY New York.

Oracle Certified Associate (OCA 12C)

SCRUM MASTER (In progress)

Oracle Cloud Infrastructure (In progress)

PROFESSIONAL SUMMARY

Five years Knowledge in Oracle Databases 10g, 11g and 12c

Five years’ Experience in database. MIGRATION – 10g to 11g, 11g to 12c databases, cross-platform using Data guard, Golden Gate, Transportable tablespaces. Non-ASM to ASM. Maintain performance across all phase. Worked on oracle migration workbench. Responsible for Datacenter Migration from old Datacenter to new datacenter.

Five years’ Experience with performance tuning and troubleshooting Completed Oracle University performance tuning course. Using Explain plan, ASH, ADDM, AWR, v$, dba views, HIST tables &TKPROF, SQL Profile. Instance, database & SQL performance optimization. Forcing index, hints. I/O & CPU utilization trend analysis. Top SQL/session, bottleneck issues, locks, identifying oracle wait events. Create performance baseline, comparing performance and Investigate top activities; generate trend report of tablespace usage & estimate future growth. Extensive use of OEM grid control for tuning. Worked on ADRCI command-line 11g

Five UPGRADE&PATCHES - Apply security/PSU patches. Validate database structure. Troubleshoot failed component in upgrade process. Upgrade ASM and RAC from 10g to 11g.

Five years in backups, restores and recovery processes.

Five years DATA GUARD - Set up physical standby for DR. Configure data guard broker, open standby in read-only, manage archive gap, testing fail-over/switch-over scenarios, changing protection modes. Configured Active, Logical, and Snapshot Data Guard.

Five years RAC - Implementation & administration of 10g/11g RAC on Linux. Oracle ASM, OCFS, RAW devices. FAN, TAF, load balancing, inter instance parallelism, add/remove node. Troubleshooting & Admin ASM. Apply patches. Setup SCAN Listeners on 11gR2.

Four years’ experience with Data Security, Transparent Data Encryption (TDE) and data protection best practices.

five years GOLDENGATE: Setup, data mapping, filter, troubleshoot, developing parameter file. Live reporting, CDC, Active-Active standby configuration. STREAMS replication at table, schema and database levels. Down steams, advance queuing, change data capture.

Two years AWS: Migrating databases from Oracle to AWS vice versa

Migrated databases using SCT and DMS tools.

Administered Amazon Aurora databases on AWS cloud.

Two years SQL Server: Software installation, databases and user creation, Recovery models.

Two years POSTGRES: Software Installation, user and tablespace creation.

Responsible for all backup, recovery, and upgrading the PostgreSQL databases.

Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within and outside the database environment.

Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.

Troubleshooting PostgreSQL database using Explain and analyze.

TECHNICAL PROFICIENCIES:

Operating Systems

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 2010,2012

RDBMS

Oracle 10g, 11g, 12c

Languages

SQL, PL/SQL, UNIX Shell Scripting, PERL

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

PROFESSIONAL EXPERIENCE

Synacor - New York, NY

August 2016 – Present

Oracle Database Administrator

Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.

Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the datable.

Other activities like applying RDBMS patches, security patches, sox reporting proactive monitoring of databases and applications.

Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.

Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.

Ensure databases adhere to corporate standards and policies. Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.

Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.

Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.

Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.

Successfully implemented oracle 11g grid control in different environments.

Experienced in handling database issues using OEM as well as command prompt.

Upgraded the databases to version 12c from 11g and 10g

Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and RHEL 6

Up-gradation and Migration of Database from 10g to 11gand then to 12c and also applying patches whenever required.

Applying upgrade patches, maintenance and interim patches on all the databases.

Worked on ASM with EMC storage for managing data in SAN.

Successfully implemented 10g RAC on nodes for high availability.

Experience in Working with RAC Databases.

Hands on experience in troubleshooting RAC environment, using srvctl, crs_stat and crs_profile.

Responsible for setup and implementation of 2Node RAC on IBM-AIX in log and 11gR2 using Veritas cluster server.

Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.

Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.

Performed Online and Offline backups with RMAN, export/import and expdp/impdp.

Implemented Point in time recovery using RMAN.

Configuration and implementation of Oracle) for high availability.

Performed Schema as well as Table level Replication using Oracle Streams.

Implemented downstream capture at the destination database using Oracle Streams.

Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.

Tuning SQL queries when the performance is poor.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage. Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)

Installed the Oracle software using silent feature and also created databases

Worked on designing, installing & maintaining OCR, 11gRAC and Dataguard components of Oracle.

Supported & maintained the Production/Development databases on various servers

Extensively worked on setting up auditing in many databases we supported

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.

Cooper Vision, Inc - Rochester, NY

June 2014 – July 2016

Oracle Database Administrator

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Loading data from flat files to database using SQL*Loader, External Tables.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 10g/11g environments.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting

Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.

Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.

Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 10g (10.2.0.2) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Used TOAD for database management.

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Contact this candidate