Oracle System Administrator

Dayanand Mamidyala

Email: ac1xlb@r.postjobfree.com Cell : 512-***-****

SUMMARY

Experienced Oracle Database Administrator with over 8+ years of IT experience with hands on experience in database administration and production support of large database environments.

Around 1 year of Experience as System Administrator.

Experienced in configuring high availability environments using Data-guard and Golden Gate.

Outstanding ability in performing DBA activities involving multiple phases of application life cycle including requirements gathering, database design and promotion of database changes.

Hands on experience in Oracle software installation, Databases creation and Upgrades.

Experienced in Database upgrades and application of PSUs and Critical patch updates.

Good Experience in Database Backups and Recovery Strategies using RMAN. Performed Database clones using RMAN Duplicate.

Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicat issues.

Experience in automation of database processes using Shell scripting and SQL.

Solid experience in monitoring database performance and recommending tuning suggestions.

Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Failover and Switch over cases.

Good experience of setup & configuration of Oracle 10g and 11gR2 RAC two-node on Linux with ASM.

Experienced in providing 24/7 support for database systems including performance monitoring, performance tuning, troubleshooting.

Good communication with excellent analytical skills, willingness to learn and improve and ability to work within a team and independently.

TECHNICAL SKILLS

Databases

Oracle 12c, Oracle 11g, Oracle 10g, MongoDB

Engineered Systems

Oracle Exadata

Operating Systems

Sun Solaris, Red Hat Linux, Oracle Linux, Windows-98/NT/XP, MS-DOS

Languages

SQL, PL/SQL, VB scripting, Basic, C, Pascal, Unix Shell Programming

Tools

Enterprise Manager for Oracle (OEM),AWR, ASH, ADDM, RMAN

EDUCATION & TRAINING

B.Tech in Electrical and Electronics Engineering from JNTU, Hyderabad, in 2007.

Oracle DBA Training from Gowtham Technology, Bangalore.

PGDCA Training from Matrix Info, Hyderabad.

MongoDB Course Completion Confirmation from Mongo University.

PROFESSIONAL CERTIFICATIONS

Oracle Database 12c Administrator Certified Associate (OCA)

PROFESSIONAL EXPERIENCE

Sobha Ltd, Bangalore, India Nov 2010 to April 2017

Oracle Database Administrator

Responsible for installation, configuration, support and maintenance of Test and Production Oracle databases.

Administration of Oracle RAC and single instance environments.

Configure RMAN and implement best practices for database backup and recovery.

Perform refreshes of Dev and QA databases using RMAN Duplication.

Implemented Disaster recovery environment for production databases using Active Data guard.

Converted physical standby to Snapshot standby and back to physical standby as per business requirement

Configured the single and bi-directional replication (Active-Active) using Golden gate between data centers

Diagnosed Golden gate issues using log files such as ggserr, and utilities such as logdump.

Writen shell scripts for automating repetitive and maintenance tasks.

Analyzed the problematic SQL’s through tools such as TKProf and EXPLAIN PLAN, to generate traces, interpret execution plans, identify performance issues, deadlocks/contention and resolve them. Utilized wide variety of Performance tuning tools such as AWR, ADDM, OEM advisors.

Co-ordinated with UNIX administrators for space managements on various servers.

Work closely with application developers to implement best practices for coding and design, and providing SQL and PL/SQL expertise.

Identified the indexes which are fragmented and rebuilt those to improve the performance.

Experience in the development of database procedures, triggers and SQL scripts for development teams.

Participate in functional test planning and unit testing of SQL and PL/SQL programs.

Used data movement utilities such as expdp/impdp to refresh the schemas and tables.

Perform code reviews submitted by application team to ensure all standards are met.

Assist in performance analysis and tuning, using various tools such as AWR and ADDM reports.

Troubleshoot and resolve database connectivity issues.

Creating tables, tablespaces, users, views and related objects.

Support application developers with database operations including development of SQL, and creation of stored procedures.

Maintain data integrity and security through managing roles and permissions of database users.

Document database standards, guidelines and processes as required.

Reclaimed lot of space on the Server through Archival of data, and cleanup of unused schemas.

Participate in on-call rotation for production database support.

Gowtham Technology, Bangalore Aug 2010 to Oct 2010

Oracle RAC and Golden Gate Training

Built a strong foundation on administration of Oracle 11g RAC and got a conceptual understanding of the Oracle RAC architecture and how its components work and interact with each other.

Tested installation and configuration of RAC database on two-node Linux cluster.

Conceptual understanding of various Golden gate topologies, and its components.

National Wheel J & P Company, Dubai Jul 2008 to Jul 2010

Oracle Database Administrator

Installed patches, performed database version upgrades with the Sr.DBA support.

Creating user accounts and appropriate privileges as well as maintaining Database security.

Enabled the Database in Archive Log Mode / No archive log mode.

Modifying the database structure, as necessary, to support activities of application developers

Created Database storage structures residing in Data Tablespace, Index Tablespace.

Managing user, resources and privileges.

Creation of Materialized views and partitioned the oracle tables to improve reporting performance

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

Upgrade, patching Oracle databases.

Experience in performing system backups and restoration.

Involved in doing Hot, Cold backup.

Involved in doing RMAN backup.

Backups using export and import of schemas.

Used Stats pack for troubleshooting SQL query performance issues.

Creation of development and test databases using export/import of full database.

Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.

APEX, Hyderabad April 2007 to Jun 2008

System Administrator

Installed and configured secured environments, VPN Internet connectivity of virtualized server environment and clients.

Managed and administered Windows/Linux systems – Performed periodic maintenance, provided technical support and executed systems engineering.

Implemented proper recovery procedures for disasters and administered user-accounts mailbox.

Maintained the timely back-up of important data and management resources.

Assisted in the timely recovery of data lost due to software crash or hardware failure.

Conducted periodic performance tests on existing servers.

Managed and advised the deployment of new system designs.

Monitored the LAN/WAN network environment including routers, switches, firewalls, Internet access and software applications.

Performed troubleshooting and diagnosis to hardware/software network failures, and provided resolutions.

Contact this candidate