Zalak Makwana

Oracle Database Administrator

864-***-**** ac4lkk@r.postjobfree.com

Charlotte, NC

Extensive Summary:

Around 8 Years of experience as Oracle Database Administrator. Oracle 12c, 11g RAC/10g RAC/9i

Databases running on different environments such as Sun Solaris, HP-UX, AIX, Red Hat Linux, and Windows.

Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Cloning, Backup & Recovery, Performance Tuning, Multi-Node RAC, Goldengate, Apex (module) capacity planning, shell scripting, and documentation.

Administrative experience in Hadoop, Cassandra and knowledge on MongoDB and MySQL databases.

Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management, and monitoring

Hands on Experience in installing, configuring and managing Oracle 11g R2 RAC, Oracle 10g RAC

Experience in handling very large databases (VLDB) ranging up to 100TB.

Successfully implemented physical Standby database using Oracle Data Guard feature for High availability configuration.

Experience in working in an Agile environment and Devops infrastructure automation tools like Chef, Puppet and Ansible.

Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation.

On call 24x7 Production Support Worked beyond regular hours. And also done customer support activities

Experience in Cloud Computing (Oracle Java cloud, Microsoft Azure). Knowledge in AWS (Amazon Web Service)

Extensive knowledge on database administration for Oracle,9i, 10g & 11g with experience within very large-scale database environment and mission critical OLTP and OLAP systems.

Experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB)

Extensive experience in Dataguard Configuration, Implementing and Maintaining Standby Databases i.e. Active Dataguard & Snapshot Standby

Experienced at using Oracle Enterprise Manager/Grid Control (OEM/GRID CONTROL)

Performance monitoring and tuning with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10046, TRACE, AWR, ADDM.

Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.

Backup, Recovery and Cloning of databases using RMAN also profound in using the new oracle 11g features in these utilities.

Migrated databases from Windows to Linux, Sun Solaris to AIX

Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)

Knowledge on Oracle Support processes for technical requests through Meta link.

Planning and scheduling for the backup of database information using UNIX shell script and Crontab jobs.

Experienced in using Oracle's Transportable Table space (TTS) feature allows users to quickly move a user Table space across Oracle databases.

Implementing data layer access to Oracle databases for Web Applications

Data transferring with Export, Import, Data Pump and SQL* Loader utilities.

Experience in using packages like DBMS_JOBS, DBMS_SCHEDULER to schedule tasks and used DBMS_STATS to gather the statistics.

Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulativebackup.

Good experience in Transportable Table spaces, SQL Tuning Advisor, Data Pump, Flashback Table, Table space Management, Virtual Private Database (VPD) and Materialized Views.

Refresh/Cloning of Database and applications for development and testing purpose.

Dealing with database security and auditing.

Have extensive knowledge Oracle Application Server Administration (weblogic)

Having good Knowledge on Exadata 2.0

Excellent communication, interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

Working Experience Summary:

Client: Time Inc New York City, NY Jan 2016 to Present

Job Title: Oracle DBA

Time Inc. is among the largest providers of video, high-speed data and voice services in the United States, connecting more than 15 million customers to entertainment, information and each other the project involves in Providing support with new database requests, Database migrations, Implementation of High Availability solutions with Oracle 11g/12c RAC, Physical and Logical Standby Databases (Data Guard).

Responsibilities:

Successfully migrated multi-terabyte databases related to Oracle Transportation Management across data centers.

Database/server monitoring through Solarwinds Orion, New Relic and OEM Grid 11g/12c.

Oracle RAC implementations (4-node) with RAC standby dB’s.

Database refreshes (full/partial/schemas) between various environments.

Upgraded databases from 10g/11g to 12c.

Install setup and configured Oracle Enterprise Manager Cloud Control 12c as a tool of administration, performance tuning, monitoring, alerts and also OEM Grid Control 11g.

Implementation of High Availability solutions with Oracle 11g/12c RAC, Physical and Logical Standby Databases (Data Guard).

Implemented Enterprise DB 9.5 Advanced server in AWS POC EC2 Environments

Implemented MySQL in AWS EC2 Environments and multiple migrations from Rackspace boxes

Develop Unix shell script and Powershell script for automating tasks.

Support RAC and single instance installations and replication across a hybrid physical/AWS environment.

Close liaison between SE, Storage, Network, Application teams to ensure database performance and availability.

Engineering, implemented, documented and support builds of new clusters to use Oracle 11g/12c RAC on Red Hat Linux. This included installing Clusterware, ASM (and shared disks) and creating new databases.

Patched database servers based on BU downtime schedules.

Responsible for using Flashback query mechanism along with automatic undo management.

Worked on integrating SNAPI/Curl scripts with Service Now.

Implemented backup and recovery strategies using export/import, Datapump, RMAN Incremental backups, Traditional hot, cold backups.

Maintained high availability databases and implemented Disaster recovery plans using Oracle DataGuard/ RAC

Running the extract convert and load process through the power shell using commands.

Built and supported Microsoft Azure databases as PAAS (platform as a service) and IAAS (infrastructure as a service)

Developed strong networking relationships with resources from Azure, AWS, EDB & Oracle.

Evaluated server/instance architecture, hardware, system specifications, and capacity planning for new projects

Supported application built using technologies Dot net, PL/SQL, Java, J2EEE, JDBC, Open Source (Hadoop/NoSQL/MYSQL/MongoDB)

Export and Import of database objects to copy from one database to another database between different environments.

Use of Shell scripting languages including BASH for Linux and PowerShell for windows systems

Troubleshooting various Database Features like Mean time to recovery (MTTR), Flashback Query, LogMiner, Replication to keep database as available as possible

Excellent interpersonal skills and analytical skills.

Provide support for Oracle Enterprise Manager Grid Control (11g/12c) and Agent issues.

Provide after-hours 24x7 database support for critical business applications.

Environment: Oracle11g(R2),12c, OEM 11g/12c, Red Hat Linux 6.8, Solarwinds Orion, New Relic, Service Now, CommVault, NetBackup

Client: State Street Corporation, Boston, MA Nov 2014 – Dec 2016 Job Title: Oracle DBA

State Street is the world’s leading provider of financial services to institutional investors. Their broad and integrated range of services spans the entire investment spectrum, including research, investment management, trading services and investment servicing. Their offices are located in twenty-five countries worldwide. Involved in the entire development life cycle right from development to production, other tasks included were supporting and tuning applications

Responsibilities:

Responsible for administration and supporting Oracle 12c, 11g & 10g databases in DEV, QA, UAT and Prod environments.

Installation and Setting up of 11g RAC in AIX environment and 11g ASM on RAC databases.

Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups to the FRA.

Initial evaluation of Talend and the Apache Hadoop software library for the distributed processing of large patient health data sets across clusters of computers

Established processes for automatically refreshing data from on premises production databases to QA environments in AWS using SharePlex replication and Oracle Data Pump API.

Automating the Database Maintenance tasks using PowerShell scripts.

Downsizing and defragmenting the Large Databases by export/import, cloning those using RMAN duplicate features and then upgrading them to Oracle 12C.

Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.

Tuned OBIEE, ODI queries on date-ware house environments.

Applied various PL/SQL scripts in Oracle database projects.

Managed the flashback space and performed recovery of dropped tables and data using flashback recovery

Building a Hadoop Cluster with Amazon EC2 and S3.

Install and configure the MS SQL Server-Hadoop Connector.

Worked on Different operating systems for OLTP & OLAP environment on Very Large Databases (VLDB).

Used database automation tools like SQL Server Integration Services (SSIS), PowerShell, BCP, TSQL, Chef, Puppet, and Docker.

POC of putting application on AWS cloud and Microsoft Azure cloud

Proactive database monitoring using 11g grid monitoring tool.

Standby Database (Dataguard) setup and configuring DB links.

Monitored Oracle Golden Gate replication and used log dump utility to read tracefiles.

Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas

Applied patches to Oracle Databases and Oracle Applications.

Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM.

Conducted integrated capture and logical change record in Oracle Golden Gate.

Worked on Automatic Storage Management (ASM) for managing data in SAN.

Monitoring and resolving tickets in different environments.

Participated in Exadata database migration.

Export and Import of database objects to copy from one database to another database between different environments.

Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities).

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Created UNIX shell scripts to automate batch jobs through Cron..

Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases.

Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Environment: IBM-AIX, Sun Solaris, Oracle 12C,11g,Oracle RAC (11g), Oracle Enterprise Manager Grid Control, RDBMS,RMAN, Import/Export, Golden gate, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL

Client: MassMutual, Springfield, MA Feb 2013 – Oct 2014

Job Title: Oracle DBA

Massachusetts Mutual Life Insurance Company (MassMutual) is a leading mutual life insurance company with 1800 offices and 13 million clients worldwide. This project was designed to help the insurance agents generate quotes for various organizations based on different criteria, state and various working conditions of workers and the class codes. The project involved calculating the premium based on the input data from the Data file. Premium will change depending on the agent code, classification code, zip code, policy term.

Responsibilities:

Worked on Performance Tuning Oracle DBA (11g &10g) on Solaris 10, AIX 5.2.

Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Installed and upgraded Oracle10.2.0.1 database to 10.2.0.4.

Developed a bunch of Index monitoring scripts in order to sort out the unused space occupied in table spaces.

Maintained Dataguard to ensure high availability, data protection and disaster recovery for enterprise data.

Full Deployment of Hadoop environment to migrate SQl data

Configured disaster recovery databases using dataguard and performed DR Testing

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance. Modified and updated the Performance tuning scripts.

Tested database performance issues (monitoring and tuning) to ensure database optimization.

Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS storage.

Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.

Working Experience with latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.

Created custom services for RAC database for distribution of load across the nodes.

Tuning SQL statements using Explain Plan and STATSPACK.

Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading.

Installed & managed 10gOEMgrid monitoring solution and deployed agents.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Performed Logical backup using and full/partial export/import and Data Pump.

Performed Schema as well as Table level Replication using Oracle Golden Gate and also did set up Disaster Recovery solution using Golden Gate.

Environment: Oracle 11g/10g, Solaris, VERITAS, OEM, EXPLAINPLAN, TKPROF, AIX, Oracle 12c RAC, TOAD, Dataguard, GOLDEN GATE, PERFORMANCE TUNING, SQL /PLSQL, Soap WebService, SQL*PLUS, PL/SQL, SQL*Loader, UNIX, Windows XP, SQL Developer 1.2, Weblogic.

Amisys Software Ahmedabad Gujrat India Mar 2010 to Nov 2012

Job Title: Oracle DBA

Responsibilities:

Responsible for support and maintenance of very critical 24x7 Production and Development

Databases in Oracle 9.2.0.8

Performed Database migration from Oracle 9.2.0. To 10.1.0.3.

Worked on designing, creation and administration of databases.

Performed logical and physical tuning, monitored extent growth and fragmentation, audited object creation

Backup and recovery utilizing RMAN.

Perform Instance tuning using tools like Stats pack etc.

Installing patches and upgrades for the database.

Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.

Worked on export and import utilities.

Responsible to see that database backup and recovery strategies are in place, and to coordinate with Network Services and/or Data Center personnel to keep the integrity of the physical system backups.

Responsible for optimizing data access and performance by tuning indexes.

Managed the existing databases by applying new required release modification to existing database structure and applied new Oracle patches as required.

Environment: SQL*Loader, SQL*Plus, Oracle 9i/10g, LINUX, HP-UX, Solaris 9, SQL Server 2005, Windows 2000

Contact this candidate