Oracle Database Administrator
Resume:
Prashantagouda Patil
adifnm@r.postjobfree.com
Summary of Qualifications:
Over 13 years of experience as an Oracle DBA in IT industry.
Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12c with experience in very large-scale database environment and mission critical large OLTP and OLAP systems.
Experience in 11g and 12c RAC databases.
Experience in golden gate Install, configure, troubleshoot and monitor replication.
Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
Experienced in data encryption using Oracle TDE to protect the organization’s critical information.
Experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.
Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces and advanced compression.
Good experience in PATCHING AND UPGRADATION. Expertise in upgrading Oracle Development and Production databases from 9i to 10g & 11g, 10g to 11g.
Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.
Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
Experience in Relational Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering ERWIN diagrams, analyzing data sources and creating interface documents.
Technical Competencies:
Database: Oracle 12c, 11g/12c RAC, Oracle 11g, Oracle 10g
Technologies: Oracle Enterprise Manager (OEM), DataPump, Import/Export, RMAN, BRTools, Data modeling.
Tools and Utilities: PL/SQL, SQL*Plus, UNIX Shell Scripting, TKPROF, Toad, Win SCP, Putty, Golden Gate, Exadata, AWS, Erwin Data Modeler.
Education Details:
Bachelor of Engineering in Computer Science from UBDTCE Davanagere/Karnataka/India, in 2004.
Professional work experience
Database Application Consultant, Edward Jones, St Louis, Missouri.
Dec-2019
Till Date
Database Consultant, Charter Communications, St Louis, Missouri.
Mar-2019
Nov- 2019
Database Consultant, CIT Group, Livingston, New Jersey.
Jan- 2018
Feb- 2019
Team Lead (Database Services),
Larsen & Toubro Infotech, Bangalore.
Apr- 2012
Nov- 2017
Sr. Database administrator, CAPGEMINI TECHNOLOGY SERVICES INDIA LIMITED (Formerly known as AXA Technologies Shared Services Private Limited), Bangalore.
May- 2010
Apr- 2012
Sr. Software Engineer (DBA), Wipro Technologies, Bangalore.
Sep- 2009
May -2010
Consultant-IMS Support, CTE Pvt. Ltd. (Formerly known as Q-soft systems and services Pvt. Ltd.), Bangalore
Jun -2007
Sept -2009
Software Developer, Open Sols Infotech Pvt. Ltd. Bangalore.
Apr -2006
Aug -2006
Professional Experience:
Client: Edward Jones, St Louis, Missouri Dec’ 19 –Till Date’
Role: Database Application Consultant
Role & Responsibilities:
Responsible for data modeling, database design review process, database support for application upgrades.
Responsible for performance tuning and adhoc data modifications for open systems database platform.
To ensure database availability and address systems issues in a timely manner.
Provided technical leadership, advice, and mentoring to: DBAs, application developers, project leaders, and business users.
Ensured compliance with audit, security, and regulatory requirements.
Understood the integrity, security and privacy of the firm's critical business data.
Created and implemented physical data models for new or existing databases and reviewed data access code, recommending changes to developers under minimal direction.
Environment: Oracle 12c, Red Hat Linux, Oracle Enterprise Manager (OEM 12c/13c), Data Modeling
Client: Charter Communications, St Louis, Missouri Mar’ 19 –Nov 19’
Role: Database Consultant
Role & Responsibilities:
Responsible for upgrades, performance monitoring, installations, managing replications, diagnosing system problems, disaster recovery testing and maintaining user accessibility.
Primary point of contact for one of the critical application for Charter provisioning service platform.
Working with the Application development teams to deploy software releases in the UAT, Production and DR environments.
Responsible to trouble-shoot and resolve production outages, perform root cause analysis and implement remedial solutions.
Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.
Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use.
Installed, configured, and maintained Oracle 11g and 12c.
Applied and maintained oracle patch cycle for all non-prod and prod databases.
Worked with developers to provide queries and tuning the queries for better performance.
Resource Management (Create and manage Indexes, Clusters, Tables), allocate and manage physical storage structures like Data files, Redo logs, Control files. Allocate and Manage logical storage structures like Table spaces.
Coordinated with developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, security, backup & recovery, SQL coding guide lines
Greatly improved performance in daily transforms by identifying and reorganizing indexes on major tables.
Environment: Oracle 11g/12c, Red Hat Linux, AIX, Data Guard, Oracle Enterprise Manager (OEM 12c/13c), RMAN, Exadata, Golden Gate, and Data guard broker.
Client: CIT Group, Livingston, New Jersey Jan ’18 –Feb 19’
Role: Database Consultant
Role & Responsibilities:
Extensive use of Oracle DataPump Exports/Imports utility for moving data among the servers.
Working on a POC to automate service now tasks like database access/grants and etc.
Created standard OEM templates to monitor the databases and hosts for critical alerts.
Created control jobs to automate schema backup to remote servers to meet business needs.
Worked on database repository to maintain all employees’ data and database details.
Primary point of contact for few applications for all database related requirements/planning/issues.
Developed a script to analyze database growth and generate alerts to team to action appropriately.
Scripted proactive & DBA related health analysis & monitoring including instance, index and log health, Maintenance alerts.
Supporting oracle database maintenance activities, database patching with latest PSU/BPU and DR.
Have experience in working in a production support environment to be able to understand and appreciate the criticality of issues and trouble shoot quickly to meet SLAs to avoid service downtime
Provisioning new database(s) as per business needs.
Performance monitoring and tuning using ExplainPlan, STATS PACK, AWR, ADDM, and Oracle Enterprise Manager.
Environment: Oracle 11g/12c, Red Hat Linux, AIX, Data Guard, Oracle Enterprise Manager (OEM), RMAN.
Client: Citigroup, Tampa, Florida Dec ’16 –Nov ‘17
Role: Lead Oracle DBA
Role & Responsibilities:
24x7 Production database administration and support.
Install, patch and upgrading Oracle 10g/11g to support internal production and test environments.
Created, upgraded, and cloned Oracle databases for Development and testing databases.
Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
Restoration and Recovery of databases during critical failures.
Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
Tested database performance issues (monitoring and tuning) to ensure database optimization.
Extensive use of Oracle DataPump Exports/Imports utility for moving data among the servers.
Created user accounts, roles and granting required access permissions and privileges to the users based on the applications they are accessing.
Experience in database migration using advanced compression feature.
Responsible for configuring and backing up database using RMAN (Incremental Backups), Conventional Hot backups, Cold backups and Logical backups.
Worked with DataPump to take the logical backups of databases.
Performed point-in-time recovery during critical situation.
Performed large batch jobs, and tuning of SQL queries and database systems.
Capacity planning and benchmarking
Responsible for migration of databases from legacy system to OraaS platform.
Involved in gathering requirements from end users.
Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.
Applying patches for both Server side and Client side.
Scripted proactive & DBA related health analysis & monitoring including instance, index and log health, Maintenance (Partition tables, Materialized views refresh, Reorg, index), PDA alerts.
Approve, schedule, plan and supervise the installation of new tools and applications, as well as new databases
Client: Johnson & Johnson, New Jersey Apr’12 – Nov’16
Role: Lead Oracle DBA
Role & Responsibilities:
Primarily responsible for production support. To keep all databases up and running in production.
Responsible for Oracle 9i/10g/11g logical and physical databases design, implementation and maintenance.
Installation, Configuration and administration of 10g RAC/11g RAC environment.
Performed extensive tuning / troubleshooting of databases for optimal performance. Tuning the application SQL / lock contention / index usage etc., Monitor object growth and modify segment storage for better performance.
Upgraded Oracle 9i, 10g databases to 11g.Applied patches.
Performed Backup Administration by using BRTools online and offline backups.
Developed strategies for optimal backup and restores procedures.
Implemented data encryption using Oracle TDE to protect the organization’s critical information.
Oracle Database installation and maintenance of 11g and 12cMultitenant on NFS and ASM file systems.
Created and managed users, roles and profiles, implementing security, granting roles and privileges etc.
Responsible for all database build activities like install, configure, implement best practices.
Implemented and monitored BRTools scripts on regular basis for successful backup.
Involved in Database Performance tuning and analyzing Statspack/AWR reports on regular basis to resolve performance bottlenecks.
Partitioned large tables, created global portioned indexes for manageability and performance improvement.
Developing SQL, PL/SQL stored procedures, packages, functions, triggers and views.
Created primary database storage structures (tablespaces), altering, and modifying the database structure according to the business requirement as necessary.
Planning and implementing Backup and Recovery procedures (Conventional Cold &Hot Backups, and RMAN Backups), scheduling daily backups and performed periodic recovery tests.
Developed Unix Shell scripts to automate database cloning, backups and database monitoring.
Performance monitoring and tuning using ExplainPlan, STATS PACK, AWR, ADDM, and Oracle Enterprise Manager.
Helped developers to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.
Defining and Setting backup and recovery procedures.
Environment: Oracle 11g, Oracle 10g, Oracle 9i, Sun Solaris, HP-Unix, RedHat Linux, RMAN, ASM, BRTools, DataGuard, Grid Control/OEM
Contact this candidate