Post Job Free
Sign in

Oracle Database administration

Location:
Plano, TX
Posted:
March 31, 2020

Contact this candidate

Resume:

Sudhakar Govindassamy

*******@*****.***

+1-980-***-****

PROFESSIONAL SUMMARY

Highly accomplished, deeply driven, database engineer with a successful 11+ years track record of success in Oracle database administration. Strong infrastructure background includes logical and physical database installation, migration, upgrade, patches, replication; performance optimization, managing and developing backup and recovery plans of oracle databases. Handled production support and development works. Very detailed oriented with focus on minimizing risks and system down-time. Record to keep the project on track with effective use of resources. Exceed ongoing and overlapping deadlines in fast-paced environments, handle multiple assignments simultaneously and deliverables with key stakeholders in cross-functional groups.

Over 11+ years of experience in Oracle Database Administration for 9i, 10g, 11g & 12c databases to configure and implementation of RAC for High Availability (HA) clusters, Data Guard, ASM & Grid Control on UNIX (IBM-AIX, HP-UX, Linux)

Involved in DBA activities for 24/7 Production Support on all environments and ensure high availability.

Conduct basic health checks, management of Schemas, Objects & Partitioning the Tables & Indexes.

Expertise in Oracle Database administration, data migration across multiple platforms using Oracle Golden Gate technology, DATA Pump and RMAN for all the versions of database from 9i, 10g to 11g and 12c

Managed different sizes of database ranges more than 40TB.

Expertise in Advanced Security Transparent Data Encryption (TDE), Data Masking and Oracle Key Vault.

Expert in Cross platform migration for all the versions of database from 9i, 10g to 11g and 12c using Uni-Directional / Bi-Directional GoldenGate replication.

24 x 7 End-to-End High Availability Solutions. Oracle Backup and Recovery (Hot Backup / Cold Backup / RMAN Backup). Excellent command in creating backup & recovery procedures and implementing strategies for hot and cold backups.

Experience in application support for development and production of large and critical network.

Proficient in writing UNIX Shell scripts to automate business process and daily backup.

Planning and scheduling Backups, Database Recovery, taking Logical Backups (Export/Import).

Experienced in implementation of Disaster Recovery site (Physical Standby Databases (Data Guard)).

Experience in Application tuning using session trace file and TKPROF utility.

Proficient in performance monitoring and analyzing the database using AWR, ADDM and Explain Plan.

Installation of Oracle 11g & 12c and Oracle11g Grid Infrastructure for HA Cluster Database (RAC).

Experience in data transfer utilities like SQL*loader, Export/Import & Data Pump.

Strong experience in data warehouse concepts, data analysis and its performance.

Experience in Toad (Tool for Oracle Application Developers) for database maintenance tasks.

Strong experience in OEM 10g Grid Control and OEM Cloud Control 12c and 13c installation and configurations.

Expertized in virtualization using VMware Workstation and Oracle VM Virtual Box

TECHNOLOGY SNAPSHOT

Hardware’s

:

UNIX, Linux, Solaris, IBM-AIX, HP-UX & Windows Server

Database Software’s

:

Oracle 8i, 9i, 10g, 11g & 12c MySQL, SQL Server 2012/2008R2/2008 NoSQL Cassandra) PostgreSQL

Database Utility & Tools

:

SQL*Plus, SQL*Loader, TDE, Security Audit, Data Masking, Oracle Key Vault, Data Pump, Export/Import,, RMAN, Oracle 11g Grid Infrastructure, TOAD, SQL Developer, Putty, VNC Server, OEM 10g Grid Control, OEM Cloud Control 12c & 13c, ASM, RAC, Data Guard, Oracle Golden Gate and Streams, SharePlex, Amazon Web Services (AWS), VMware, JIRA, Service-Now, HPSM

Middleware Software

:

Oracle Golden Gate, Oracle Fusion Middleware, WebLogic Server, Tom Cat, IBM Web Sphere and IIS

Performance Tools

:

SolarWinds, SQL Tuning, Explain plan, SQL Trace, TKProf, Statspack, AWR & ADDM

Languages

:

PHP & PERL, SQL, PL/SQL, UNIX(bash, ksh, csh, sh)Shell Script, HTML & XML

PROFESSIONAL DEGREE

Bachelor of Technology in Mechanical Engineering (1995-1999), Pondicherry University

PROFESSIONAL CERTIFICATIONS

Oracle Certified Professional in 10g & 12c (OCP) Oracle Database SQL Expert Certified (OCE) in SQL

IBM Certified Database Associate DB2 9 Fundamentals

INDUSTRY

Tele Communication Verizon

Beverages & Food processing PepsiCo

Information Technology Hewlett Packard Enterprise

Retail Belk Inc

Financial Services Capital One

Infrastructure & Outsourcing Services Inspirage

Performance Benchmarking Oracle Corporation

Pharmaceuticals and Health Care Medtronic

Telecom Tele Pacific (Prepaid Management Solutions)

PROJECT DETAILS

Verizon (Irving, TX) Senior Oracle DBA May 2019 to Present

Environment: Solaris, OEL, RHEL, AIX Oracle 8i, 9i, 10g, 11g, 12c RAC, Data Guard, ASM, Goldengate, OEM 13c, SQL, PL/SQL, TDE, AWS, PostgreSQL, Cassandra

Responsibilities

Ensured reported issues were resolved more quickly by documenting and tracking application issues, using Agile Methodology, participating in scrum meetings, which assisted with prioritization of issues.

Closely working with problem owners, SMEs and other stakeholders to identify problem scope and escalate IT service outages to specialize engineering. Creating statistical reports and performing analysis on a weekly basis for areas of responsibility.

Coordinated activities by change management, business continuation and problem management for return to service and problem mitigation.

Deep understanding about Exadata specified features such as Smart Scan, HCC (Hybrid Columnar Compression), Flash Cache, etc.

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.

Provide and implement performance-tuning recommendations of all components in Exadata database machine.

Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.

Migration of 11g databases to 12c with large database size using RMAN backup and restore.

Managed different sizes of database ranging from 100GB up to 40TB

Implemented cross platform migration from HP-UX to Oracle Enterprise Linux Server and RHEL using DATA PUMP, RMAN backup and Performed database refresh whenever application team needed to restore the database from the available backup.

Configured physical standby for the production databases while performing migration to the new target server using Active Data Guard.

Experience in Installing oracle 11g RAC databases using ASM file system and managing using server control utility SRVCTL and CRSCTL to achieve high availability.

Configured high availability services Load balancing and SCAN features for clustered databases.

Troubleshooting Cluster Startup Issues, Node Evictions, Network Issues and Storage Related Issues.

Experience in Reviewing the Cluster Logs for troubleshooting and Implementing Cluster Health Check.

Helping other DBAs in RAC, standalone installation of databases with ASM

Experienced in software installation and configuration of OEM Grid control and OEM 13c Cloud Control.

Performed database upgrade from all the versions of oracle databases to 11g and 12c using manual and DBUA method.

Performed database refresh whenever application team needed to restore the database from the available backup using Business Continuity Volume (BCV).

Applied CPU Patches for standalone and online patches, rolling patches for RAC databases and Security patches as well.

User Account security audit by auditing default tablespace, temporary tablespace assigned, grants, privileges, roles, profile, database links created for remote database connection, grants with admin option, password management.

Configured physical standby for the production databases while performing migration to the new target server using Active Data Guard.

Performed database upgrade from all the versions of oracle databases to 11g and 12c using manual and DBUA method.

Experienced in performance tuning for problematic query by fixing the SQL plans with various methods and proficient in SQL Tuning using SQL Tuning Advisor, AWR, ADDM, ASH and Explain Plan in OEM 12c Cloud Control.

Configured Data Guard broker to manage standby databases for switchover and failover operations.

Develop batch processes for financial reporting applications and modules using Perl and Korn shell scripts on Oracle database, with partitions and sub-partitions

PepsiCo (Plano, TX) Senior Oracle DBA October 2017 to April 2019

Environment: HP-UX, AIX, OEL, Linux Oracle 8i, 9i,10g,11g,12c RAC, Data Guard, ASM, Goldengate, OEM 13c Audit, TDE, Database Vault

Responsibilities

Migration of 11g databases to 12c with large database size using RMAN backup and restore.

Managed different sizes of database ranging from 100GB up to 40TB

Handled Oracle databases for the enterprise data movement and their cutover activities.

Implemented cross platform migration from HP-UX to Oracle Enterprise Linux Server and RHEL using DATA PUMP, RMAN backup and Performed database refresh whenever application team needed to restore the database from the available backup.

Configured physical standby for the production databases while performing migration to the new target server using Active Data Guard.

Expertized in installation and upgrade of ASM Grid Infrastructure for ASM instances.

Experienced in software installation and configuration of OEM Grid control and OEM 12c Cloud Control.

Performed database upgrade from all the versions of oracle databases to 11g and 12c using manual and DBUA method.

Implemented Data Guard Fast Start Fail over (FSFO) to initiate failover to the standby site.

Applied CPU Patches for standalone and online patches, rolling patches for RAC databases and Security patches as well.

Experienced in performance tuning for problematic query by fixing the SQL plans with various methods and proficient in SQL Tuning using SQL Tuning Advisor, AWR, ADDM, ASH and Explain Plan in OEM 12c Cloud Control.

Expertized in OEM 13c Cloud Control to diagnose database tuning which includes I/O Contention, Memory contention, Block Contentions, Locks, Latches, Row Migration, Row Chaining

Performed Active duplication of databases and user-managed (hot/cold) backups through RMAN.

Setup Oracle Audit Vault and Database Firewall for monitoring and blocking SQL statements according to the company standard policies.

Implemented Oracle Security Auditing techniques for SOX compliance which includes Fine Grained Auditing (FGA), Fine Grained Access Control (FGAC) using DBMS_FGA and DBMS_RLS for implementing Row Level / Column Level Security, data and backup encryption, strong authentication.

Experience in setting up Oracle Database Vault for restricting access to special record for administrative users as a standard to SOX Compliance.

Used Oracle’s Transparent Data Encryption and Oracle Wallet to encrypt some of the data in the database.

User Account security audit by auditing default tablespace, temporary tablespace assigned, grants, privileges, roles, profile, database links created for remote database connection, grants with admin option, password management.

HPE (Austin, TX) Senior Oracle DBA October 2016 to January 2017

Environment: HP-UX, OEL, Linux Oracle 11gR2U4, Oracle 12c, RAC, Data Guard, ASM, OEM 12c TDE, Audit, Database Vault AWS, Putty, Win SCP

Responsibilities

Implemented cross platform migration from HP-UX to Oracle Enterprise Linux Server and RHEL using DATA PUMP, RMAN backup and restore.

Configured physical standby for the production databases while performing migration to the new target server using Active Data Guard.

Expertized in installation and upgrade of ASM Grid Infrastructure for ASM instances.

Experienced in software installation and configuration of OEM Grid control and OEM 13c Cloud Control.

Performed database upgrade from all the versions of oracle databases to 11g and 12c using manual and DBUA method.

Performed database refresh whenever application team needed to restore the database from the available backup using Business Continuity Volume (BCV).

Applied CPU Patches for standalone and online patches, rolling patches for RAC databases and Security patches as well.

User Account security audit by auditing default tablespace, temporary tablespace assigned, grants, privileges, roles, profile, database links created for remote database connection, grants with admin option, password management.

Experienced in performance tuning for problematic query by fixing the SQL plans with various methods and proficient in SQL Tuning using SQL Tuning Advisor, AWR, ADDM, ASH and Explain Plan in OEM 12c Cloud Control.

Expertized in OEM 12c Cloud Control to diagnose database tuning which includes I/O Contention, Memory contention, Block Contentions, Locks, Latches, Row Migration, Row Chaining.

Closely working with problem owners, SMEs and other stakeholders to identify problem scope and escalate IT service outages to specialize engineering. Creating statistical reports and performing analysis on a weekly basis for areas of responsibility.

Belk Inc (Charlotte, NC) Senior Oracle DBA January 2016 to September 2016

Environment: HP-UX, AIX, OEL, Linux & Windows Oracle 11gR2U4, 12c, RAC, Data Guard, ASM, OEM 12c TDE, Audit, Database Vault Putty, Win SCP

Responsibilities

Implemented Advanced Oracle Security features like Hardware Security Model (HSM), External Security Model (ESM) and Oracle Wallet for PeopleSoft Applications.

Performed migration of existing tablespaces to encrypted tablespaces (TDE) while the application remains fully available using Online Table Redefinition.

Implemented TDE, Oracle Key Vault and Data Masking.

User Account security audit by auditing default tablespace, temporary tablespace assigned, grants, privileges, roles, profile, database links created for remote database connection, grants with admin option, password management.

Created RMAN backup scripts for encrypted oracle databases to DISK in order to avoid ORA-19916 error if we attempt to create encrypted RMAN backups using SBT library other than Oracle Secure Backup.

Involved in Upgradation of ASM Grid infrastructure and upgraded 11.2.0.3 to 12c.

Implemented Oracle 11gr2u4 Grid Infrastructure on 3 node RAC on AIX and Oracle Enterprise Linux (OEL)

Configuration of the database as well as the daily production support on wherever I assigned as the Primary and handling the projects as well as the day to day operations.

Managed different sizes of database ranging from 100GB up to 40TB

Planning, Installation and Configuration of Oracle 11gr2u4 Grid Infrastructure on 2 node RAC on Oracle Enterprise Linux (OEL) and Red Hat Enterprise Linux (RHEL)

Implementation, Installation and Configuration of ASM on the 2 node 11gr2u4 RAC

Installation and Configuration of 2 nodes DR Primary Standby 11gr2u4 RAC database.

Performed rolling patches for cluster database.

Implemented Oracle Security Auditing techniques for SOX compliance which includes Fine Grained Auditing (FGA), Fine Grained Access Control (FGAC) using DBMS_FGA and DBMS_RLS for implementing Row Level Column Level Security, data and backup encryption, strong authentication.

Oracle security using Roles and Profiles and granting of the privileges according to the needs of the various users and adhering to the security and policies of the organization

Closely worked with an Application team to identify if there is any bottleneck found in Application Server to troubleshoot and administering.

Capacity planning: Allocate system storage and plan future storage requirements.

Performed Database Tuning for I/O Contention, Memory contention, Locks, Latches, Row Migration, Row Chaining, Block Contentions and etc.,

O/S monitoring for CPU, Memory and Disk I/O utilization

Develop and design dashboards, reports, ad hoc queries and analysis

Proficient in OEM Cloud Control 12c,Oracle 10g Grid Control, SQL Tuning Advisor, AWR, ADDM, TKPROF, ASH and Explain Plan

Oracle security using Roles and Profiles and granting of the privileges according to the needs of the various users and adhering to the security and policies of the organization.

Capital One (Richmond, VA) Lead Oracle DBA December 2014 to December 2015

Environment: AIX, HP-UX, Linux & Windows, Oracle 9i, 10g, 11g, 12c, OEM 12c, Golden Gate, Data Guard, RAC, Putty, Win SCP

Responsibilities

Performed Cross platform migration for all the versions of database from 9i, 10g to 11g and 12c using Uni-Directional / Bi-Directional GoldenGate replication.

Migrated standby, primary and secondary goldengate databases using RMAN backup/restore and recover to SCN strategy.

Worked with different application teams to carry out different Migration strategy and provided warranty support for 2 weeks after handing it over to app team.

Performed Cross platform migration for all the versions of database from 9i, 10g to 11g and 12c using Uni-Directional / Bi-Directional Goldengate replication.

Migrated standby, primary and secondary goldengate databases using DATA Pump, RMAN backup/restore and recover to SCN strategy.

Implemented Oracle 11gr2u4 Grid Infrastructure on 2 node RAC on Oracle Enterprise Linux (OEL) and Red Hat Enterprise Linux (RHEL) from the scratch.

Migrated the current Linux environment to AWS/RHEL Linux environment and used auto scaling feature.

Test and promote Quest SHAREPLEX replication tool between different instances for High Availability.

Installation and configuration of Oracle Client software and Tools.

Provided Production DBA support on rotational basis or on a 24/7 basis as needed.

Installation and Configuration of Standby for production databases.

Performed Database Configuration Tasks like creating tablespaces for data and indexes, adding datafiles to tablespaces, monitoring tablespace size, tuning SGA for optimal database performance, modifying redo log sizes and groups depending on the requirement, monitor v$ views for database related information

Automating Oracle backups to tapes using RMAN scripts for weekly full backups as well as daily incremental backups and monitoring the same using automated scripts

Created Korn Scripts to automate the batch scripts for RMAN.

Oracle monitoring and performance using Oracle recommended tools like OEM Cloud Control 12c, SQL Tuning Advisor, AWR, ADDM, TKPROF, ASH and Explain Plan.

Worked with all the application team and their application servers compatibility with the database and give recommendations to enhance their application servers.

Conducting sizing & capacity planning for Oracle databases.

Prepare project layout and provide technical guidance to the development team

Encryption of the entire contents of a tablespace and its tables using TDE techniques.

Pro-active business users support including performance tuning the SQL queries for reports and discussing the same to meet their requirements

Involved with the Unix admin teams regarding disk and storage requirements and also regarding server tuning efforts in case of performance issues

Inspirage (Bellevue, WA) Senior Oracle DBA February 2014 to November 2014

Environment: RHEL Linux & Windows, Oracle 11g, 12c, Data Guard, RAC, Putty, Win SCP

Responsibilities

Worked in Standalone, RAC and ASM environments.

Converted single instance to RAC in UNIX.

Created and configured Data Guard.

Installed and Configured Golden Gate for replication purposes.

Configured and maintained replication of data using Golden gate in Production and Non-Production environments for reporting.

Performed cross-platform migrations (Oracle 10g - 11gR2) from multiple databases using Oracle GoldenGate.

Designed and implemented database schema (logical and physical data models).

Created new 10g Database and performed regular RMAN backups for all the databases.

Worked with different application teams to carry out different Migration and provided warranty support for 2 weeks after handing it over to app team.

24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.

Created Procedure, Function, Triggers using PL/SQL.

Loading data using SQL Loader and Data Pump utilities.

Documented instructions for migrating & upgrading databases.

Handled Service Requests raised by application development teams.

Refreshed schemas from Production environment to DEV/TEST environment using exp/imp and Data Pump utilities.

Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements

Updated Table, schema and Database statistics using DBMS_STATS.

Maintained Checklist for monitoring Production and Test systems.

Administered and supported application servers, responsibilities included troubleshooting and monitoring servers.

Wrote various UNIX shell scripts to monitor databases, automate tasks, etc.

Developed UNIX Korn Shell scripts to run various utilities for the scheduled batch processes in production

Created tablespaces and managed tablespaces by adding/deleting/resizing data files.

Created schema (tables, Indexes, views, sequences, synonyms, packages).

Setup database auditing, granted privileges to users through system/object roles.

Monitoring and Maintaining standby databases.

Oracle Corporation Oracle DBA April 2012 to November 2013

Employer: Indium Software India Ltd, Chennai, IN

Environment: RHEL Linux & Windows, Oracle 11g, 12c, Data Guard, RAC, Oracle EBS, Oracle Golden Gate, OEM Grid Control, MySQL, SQL Server 2012/2008R2/2008, PostgreSQL

Responsibilities

Performed Oracle GoldenGate Performance Benchmarking based on TPC framework for Oracle databases, MySQL, DB2, PostgreSQL.

Configure and build GoldenGate replication (Extracts/Data Pump/Replicate) process for multiple databases to perform Oracle Goldengate Performance Benchmarking.

Configure and build heartbeat monitoring in Golden Gate.

Configure error handling for restart, logging, production support and status reporting in GG.

Benchmarking including encrypted tablespaces using TDE for replication.

Identify and produce documentation of best practices.

Trouble shooting and performance tuning golden gate replications and oracle streams.

Implementing necessary monitoring scripts for Golden gate in Unix scripting

Routine proactive maintenance of Oracle Database using shell scripts and standard data collection mechanisms

Working with team on production issues & and escalate the issues to appropriate team if required.

Installed, configured and maintained Oracle 10g,9i and 8i Databases on UNIX Platform.

Install & configure development PostgreSQL 8.1.1 databases on RHEL servers.

Installed Oracle Applications eBusiness Suite 11i and 12.1.3 and exposure on upgrade from R11 to R12

Reclaiming Physical disk space sizes after purging of unwanted data in the database thus saving storage space, reducing the backup time and improving performance of the queries as well

Taking HOT and COLD backups using RMAN and shell scripts

Responsible for capacity planning by collecting data regarding DB growth, application usage

Proactive monitoring and health checking of all DEV/TESTING/PROD databases

Created UNIX Korn shell scripts to simplify the generic testing procedures on test servers.

Connectivity and locking issues.

Monitoring Users access, Tablespace usage, CPU usage on server.

Recover / Restore the database if required.

Applied database patches using OPatch utility.

Installed statspack in the database to monitor the database

Logical Backup of Databases using EXP / IMP Utility.

Monitoring the Database size and add/resize datafiles when required.

Granting specific privileges and roles to the users.

Attending daily, weekly and bi-weekly calls with Customer (IT divisions) for discussing on-going activities and upcoming projects.

Medtronic Inc Senior Oracle DBA November 2011 to March 2012

Employer: WDC, Kolkata for IBM India Pvt Ltd, Chennai, IN

Environment: Linux, Solaris & Windows, Oracle 11g, Data Guard, RAC, TOAD, Oracle OEM Grid Control

Responsibilities

This Project consists of 1300 and more databases having wide ranges which are running on multiple servers from 8i to 11g versions. It has various departments like UNIX, Storage, Data center teams to accomplish DBA activities and also to fulfill the customer request or needs at any time. The major databases at Medtronic hold its own organization business information such as Cardiac Rhythm Disease Management (CRDM), Spinal and Biologics, Cardio Vascular, Neuromodulation, Diabetes, and Surgical Technologies.

Followed the Medicaid Management Information System (MMIS) is computer processing operations to enhance program control and administrative costs, service to recipients, inquiries, operations of claims control and management reporting for planning and control.

Involved in implementing and managing Oracle 10g RAC with ASM databases to deliver leading multi-OLTP and, enabled load balancing client-server, server-server as transparent application failover (TAF).

Configuring database entries and Monitoring of all the databases using Oracle Enterprise Manager (OEM) 10g grid control.

Installation and configuration of Oracle Database Software 11g.

Upgrading database from Oracle version 10g to 11g.

Communicating with Oracle to get the necessary patches required to fix up the database changes needed using TAR support and coordinating the patches and implementing the necessary changes.

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

Used Export/Import and Data Pump utilities for full/partial backup.

Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.

Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.

Performed logical backup using export/import and data pump (remote export) utilities.

Database refreshes based on Application requirements.

Wrote shell script to perform backup and schedule it with crontab.

Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.

Optimize SQL queries for better performance.

Carried out Optimizing performance and Query tuning using Statspack, TKProf, and OEM.

Use Explain Plan for monitoring the query execution.

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

Installation and configuration of Oracle Client software and Tools.

Provided Production DBA support, as needed, on a 24/7 basis.

OneZero Solution Pvt Ltd, Puducherry, IN Oracle DBA January 2008 to November 2011

Environment: RHEL Linux & Windows, Oracle 9i, MySQL 5.1.4, PHP

Responsibilities

Experience in Building, installing, and administering of Oracle instances on UNIX/windows systems.

Assisted Developers in tuning SQL and acquiring skills with Oracle. Identify worst performing SQL statements and tuned for better performance

Creation of users & roles, configuring user profiles, scheduling scripts to report space issues at table/index/table space/file system level.

Installation of database as per OFA standards.

Maintaining regular backups and regular monitoring of trace files & log files.

Working with SQL Loader, for loading the test data during the integration testing

Monitoring hit ratio of SGA components

Communicating with Oracle Technical Support

Partitioning tables by determining the suitable methodology to improve performance and manageability.

Generated scripts for daily maintenance activities like analyzing the tables/indexes, growth rate and SGA use.

Performed Hot, Cold, Table space level backups and Detection of corrupted blocks by using utilities like DBVERIFY and with RMAN Block corruption.

Creation and migration of DB and other related Objects including schema objects

Created scripts for hot backup and export on a daily basis scheduled with cronjobs.

Plan for system and monitor capacity usage for new hardware and software requirements

Interfacing with oracle corporation for technical support (METALINK)

Modified the listener port number and to archive log mode for one of the existing database

Clone and refresh environments to create patch test, development and QA environments.

Conducted multiple test runs to gather timings for production upgrades.

Designing of database and data flow in the system, creation of various objects like procedures, functions, views and sequences.

Creation of triggers for audit log of database.

Installation and setup of MySQL 5.1 Enterprise and Community servers on Windows/Linux and SUN Solaris Servers.

Configuring Active-Passive Cluster setup on SUN Solaris Servers.

Configuration of Primary and Disaster Recovery sites for Application and Database servers.

Configuring parameters for database tuning.

Scheduling snapshot incremental and full backups of MySQL database using third party tools like VERITAS Net Backup.

Scheduling hot and cold backups using MySQL dump.

Database optimization by tuning queries for various modules in the project for better performance.

Setting up Master-Slave replication between MySQL Servers for high availability of data.

Kalte India (p) Ltd, Puducherry, IN Software Programmer November 1999 to December 2007

Environment: Oracle, MS-Access, ASP, JSP, VB, PHP, MySQL 5.1.4, MSSQL Servers

Responsibilities

Designed and optimized the dynamic web pages for a search engine portal for vendors, supplier and customers using JSP, Java Scripts, MS-Access and FrontPage.

Designed, developed and implemented the complete automation



Contact this candidate