Manager Oracle

JANAKI RAM. K

Oracle DBA

Email: ***********@*****.***

Mobile: +91-970*******

CAREER OBJECTIVE

To work with a challenging, growth oriented environment and contribute my best efforts towards the progress of the organization through my knowledge, skills and a desire to excel database support and utilizing every opportunity to achieve both personal and professional development.

PROFESSIONAL EXPERIENCE

Having 4+ years of experience as of Oracle DBA, working on both Development and Production environment, providing 24/7 on-call support for various versions of databases (Oracle 9i, 10g, 11g, 12c) on different platforms like Linux, HP-UX, Ubuntu, Windows etc

Good Working experience on Oracle and MySQL DB Installation, Configuration, Support, Upgrade, Migration activities and good knowledge on MSSQL, DB2 and other databases.

Database Administration activities – Expertise on Oracle client/database installation, MySQL DB installation, Configuration, Database Migration, Database Upgrade, applied patches, Scheduling Backups, changing database parameters, Increase space for Table spaces and log files accordingly, D R setup, and DB Refresh/DB copy, RMAN, Enterprise manager, implement various table partitions for large tables.

Daily Health check of the Databases. User Management and Tablespace Administration.

Proficient in monitoring, configuration and administration of Enterprise Manager 12c

Performed Database Refresh, Database Copy, and Cloning activities on Linux

Scheduled the Database backups(Hot / Cold) using scripts and setup cronjob.

Extensively using DATAPUMP and Export /Import utilities for logical backups.

Good working knowledge on RMAN backup and recovery, Data guard and RAC.

Analyzed large tables, indexes based on performance, alert log file, tablespaces, datafile utilization regularly. Implement the automated Hot Backup scripts for the Daily full backup.

Resolved various complex issues within the database; for example; corrupted datafiles, redo log files, tns and listener connection issues, control file and spfile problems.

Performed Installation and configuration of OEM 12c Grid for monitoring all databases.

Implemented OEM 12c alert configuration mechanism for target DBs on OEM portal.

Strong Experience on MySQL Database Installation, Configuration, monitoring, manage and troubleshooting activities on different platforms.

Worked on MySQL database administration activities like backup & recovery, Database copy, assign privileges to users and support activities.

Good working experience in UNIX Administration activities like Installation, Disk partition, File Systems, Auto mounting, Patch/ package installations, file system backups and writing scripts on Shell/Perl.

Created and managed documentation on configuration and support of Oracle databases, database structure, changes, problems, and issues for future reference and analysis.

TECHNICAL SKILLS

Operating System

:

Linux, HP-UX, Solaris, Ubuntu, Windows 2000/2008/XP

Databases

:

Oracle 10g/11g/12c, MySQL, MSSQL

Scripting

:

Shell, Perl

DB Tools

:

Oracle Enterprise Manager (OEM 11g & 12c), Nagios

Telnet Tools

:

Putty, MobaXterm, VNC Server.

Languages : C++, Java

ACADEMIC QUALIFICATION

Master of Computer Applications (MCA) from JNTU, Hyderabad

PROFESSIONAL EXPERIENCE:

Organization : Synopsys India Pvt. Ltd., Hyderabad

Designation : Database Administrator

Duration : April 2014 – till date.

Client: Synopsys Inc. Pvt. Ltd., Hyderabad

Project #1: OEM 12c Implementation / Support

Version: RHEL 6.2, Oracle 12c, OEM 12c

Role: Database Administrator

Description: This Project is mainly for monitoring all the databases in our Organization. we can monitor database status, storage, performance of the database, downtime etc.. by using OEM 12c. we can set up alert configuration for the targets, then we can get email alerts for any database down, space issues, host status, listener status activities. This is very helpful and useful to Database administrators.

Key Responsibilities handled

Handling requests (tickets) coming from technical/functional/business users, then providing solutions to the users through internal Ticketing Tool.

Working as a part of team and providing 24x7 support for all Production and development systems on various platforms.

Performed OEM 12c installation and configuration on Oracle 12c database on Linux.

Extensive knowledge on administering, and monitoring databases using OEM 12c

Performed OEM agent Installation and configuration on target databases.

Configuring hosts and added databases to OEM 12c portal.

Setup alert configuration mechanism for targets in OEM 12c tool.

Create Incidents for host/database status, Listener status, File system Space, Tablespace etc...

Create a Ruleset for email alerts if any Incidents happened.

Get an email alert for concerned users if any incident happened in OEM.

Preparing a technical document for every procedure for future reference.

Client: Synopsys Inc. Pvt. Ltd., Hyderabad

Project #2: Implementation / Support

Version: RHEL 6.2, 5.3, SunOS 5.9, Windows 2008, Oracle 11g, OEM 12c, MySQL 5.x

Role: Database Administrator

Key Responsibilities handled

Looking into action requests (tickets) coming from users and solve the issues.

Create new database for the customer/user and export other monitoring scripts

Installation, configuration, creation, and support of Oracle 9i/10g/11g/12c databases in Development &Production Environments.

Creating new databases under various environments and maintaining different oracle homes in the same servers and Working on tablespace administration activities

Performed table Re-Organization with large Tables, and Re-build Indexes to improve performance of the database

Performing status checks by monitoring the Alert log, Trace files of the database.

Monitoring the table spaces periodically for growth.

Writing scripts for file system space checking and send an alert mail to team through email

Performed Imports and exports activities in Database administration

Performed backups and restoration activities in Database administration

Monitoring and Reorganizing Database objects, Tables & Indexes to minimize fragmentation.

Performed Database Refresh, Copy, and Cloning activities.

Refreshing the test database with the production database.

Performed Database copy with full export and import method to new database.

Preparing a technical document for every procedure for future reference.

MySQL DBA Activities

Performed installation, create new databases, configuration, backup, recovery, security, tuning and data integrity.

Performed database backup and restore / export and import activities when requested by other teams for testing purpose

Increased database performance by utilizing MySQL configuration changes for DB tuning.

Effectively configured MySQL Database Replication.

Documented all information about servers and databases for future reference.

Contact this candidate