SQL, PL/SQL, Visual Basic, Unix Scripting, Linux Scripting
Murali Dharmapuri
Oracle Database Administrator
Melbourne,VIC
Summary
Highly accomplished, deeply-driven, professional Database Administrator with over 20 years of experience, with a profound knowledge in database security and user management, backup and recovery, database design, performance monitoring and tuning, migration, upgrades, cloning, and replication. Proficient in an assortment of technologies including Oracle 10g, 11g, 12c and SQL server. Exceeds ongoing and overlapping deadlines in fast-paced environments. Proficient in Linux, Unix and Windows environments.
Overview
20
20
years of professional experience
Work History
Senior Oracle Database Administrator
Dept Of Health & Human Services
12.2006 - 11.2023
- Providing administrative support and maintenance on Oracle 10g, 11g and 12c installations, database creation, database security, database optimization and tuning.
- Experience with providing and maintaining high availability and disaster recovery using ORACLE DATA GUARD.
- Monitoring and troubleshooting database performance using OEM, AWR, ADDM, ASH, Explain Plan, and TOAD.
- Performing other Security related tasks including Transparent Data Encryption (TDE).
- Implementing Security policy enhancement through roles, profiles, privileges and password policies as per business requirements.
- Cloning schemas, objects and databases on new server using exports from 10g database and imported in 11g using data pump.
- Performing backup and recovery procedures using RMAN and Data Pump utility for Oracle databases.
- Upgrading databases from 10g to 11g and 11g to 12c. Appling PSU and bug fix patch.
- Implementing, tuning and maintaining Oracle database using OEM.
- Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report.
- Participating in the 24/7 on-call DBA rotation schedule.
- Managing Database Structure, Storage Allocation, Table partitioning, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges
- Oracle Database performance-tuning services with EXPLAIN PLAN, AWR reports, ADDM
- Extensive use of Oracle Enterprise Manager (OEM) Grid control for Performance, Administration and Maintenance of Databases
- Day to day maintenance included patching, cloning, and administration of concurrent manage process, Users, Forms, Reports and performance issues.
- 24x7 remote support and on call rotation
Senior Database Administrator
Rural Ambulance Victoria
06.2003 - 12.2006
- Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.
- System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
- Designed and implemented the ETL utilizing PL/SQL and Talend Administration Suite.
- Used range, hash and composite table partitioning which greatly decreased the DB_time and SQL execution time.
- Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption.
- Worked on user management mainly on grants, privileges, roles, and profiles.
- Performed hot and cold backup and recovery using RMAN
- Worked on application and database security (data access, passwords, network, etc.).
- Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
- Tuning test and production database by altering the parameters.
- Export and Import of database objects to copy from one database to another database.
- Investigating suspicious database activity using Fine-Grain Auditing.
- Write database documentation, including data standards, procedures, and definitions.
- Reconciled functional and technical problems through research and training workshops, achieving a 65% increase in satisfaction rate of database end users and supervised the coaching of junior DBAs.
- Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report.
- Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances
Education
Oracle Certified Professional 11g
Oracle University
Melbourne, AustraliaCertificate Course - Certified Unix Admin Sun Solaris
Sun Solaris
Melbourne, AustraliaPost Graduate Diploma in Computer Applications
SQL India
Hyderabad, IndiaMaster of Science - Electrical, Electronics Engineering Technologies
Osmania University
Hyderabad, IndiaBachelor of Science - Electrical, Electronics Engineering Technologies
Jawaharlal Nehru Technological University
Hyderabad, IndiaSkills
- Backup and Recovery
- Data Pump and Export/Import
- Transparent Database Encryption
- Database Security
- Database Upgrade and Migration
- Oracle Performance Tuning
- Patch Set Management
- Oracle RAC
- Oracle Data Guard
- TOAD
- SQL Developer
- SQL Loader
- Oracle Enterprise Manager
- Oracle VM Virtual Box
- SQL Server Administration
- Linux, Unix AIX, Solaris, Windows
- SAP Administration
Timeline
Senior Oracle Database Administrator
Dept Of Health & Human Services
12.2006 - 11.2023
Senior Database Administrator
Rural Ambulance Victoria
06.2003 - 12.2006
Oracle Certified Professional 11g
Oracle University
Certificate Course - Certified Unix Admin Sun Solaris
Sun Solaris
Post Graduate Diploma in Computer Applications
SQL India
Master of Science - Electrical, Electronics Engineering Technologies
Osmania University
Bachelor of Science - Electrical, Electronics Engineering Technologies
Jawaharlal Nehru Technological University
Certification
Oracle Certified Professional
Oracle Applications Certified
Unix Systems Administrator Certified
Accomplishments
- Achieved Database Administration by completing Effective Tasks with accuracy and efficiency.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Preference
Work Type
Contract WorkWork Location
HybridImportant To Me
Work from home optionQuote
The way to get started is to quit talking and begin doing.
Walt Disney
Software
Interests
Travel, Swimming, Singing, Cooking
Languages
English
Bilingual or Proficient (C2)
Similar Profiles
Aida CardenasAida Cardenas
Human Services Caseworker at Dept Of Health & Human ServicesHuman Services Caseworker at Dept Of Health & Human Services
Yari BritoYari Brito
Front Desk /Front Office Worker at SPS Consulting/ Dept. Of Health & Human ServicesFront Desk /Front Office Worker at SPS Consulting/ Dept. Of Health & Human Services
Suzanne MacartneySuzanne Macartney
Senior Social Science Analyst at U.S. Dept of Health & Human ServicesSenior Social Science Analyst at U.S. Dept of Health & Human Services