Administrator Oracle
Resume:
Professional Summary:
**+ years of experience as an Oracle Database Administrator having hands on experience in Production Support, Application Development, Installation, Configuration, Upgrades, Patching, Performance Tuning, RMAN Backup and Recovery, Migrations, Exadata, AWS, RDS, EC2, Cassandra, Postgres, ASM/RAC Administration, Golden Gate Replication, Cloning, Space management, Database Security, Patching and Auditing,
Progressive experience in Oracle database Design and Architect. Proven track record of providing strategic direction while deploying tactical technical solutions. Exceptional analytical and problem solving skills. Excellent ability to look at problems from a macro level and a detailed level, always keeping the appropriate business prospective
Excellent experience in Installation, configuration and cloning of Oracle 8i, 9i, 10g,11g, 12c and 11g,12c,18c,19c, RAC, EXADATA,AWS,RDS, EC2, Oracle Cloud(OCI), Postgres, Cassandra.
Expertise in Application Development as Application development admin and Production Support 24X7
Duties included installation, patching, upgrading, performance tuning, space allocation and maintaining Oracle Server according to Oracle OFA Standards.
Expertise in Troubleshooting Performance issues, Bottlenecks and RCA( Root cause analysis) for critical failures.
Perform timely patching and upgrades to avoid security vulnerabilities and maintain company policies.
Prepare and execute Database Migration plans for ONPREM to AWS ( RDS) without downtime using OGG and other methods.
Prepare Space forecast for the future needs for the DB and perform Reorg on db’s for the better utilization of space.
Good hands on experience on bash, shell scripting and exposure to python.
Good hands on experience and working on oracle 10gR1,10gR2,11gR1,11gR2,12c, 18c,19c, RAC,ASM and Data Guard, Goldengate,AWS, RDS, EC2, DMS, Ora-to-PG, SCT for migrations.
Experience in data loading utilities like SQL*LOADER, Logical backups using full export, import and DATAPUMP
Create Guidelines for the user maintenance and security based on company policies.
Create and maintain proper security groups on AWS depending on company security policies and standards.
Build-Installation, configuration, upgrading and migration across platforms of Oracle (9i, 10g &11gr2 RAC- DATAGUARD).
Hands on experience on Jenkins and knowledge on Kubernetes.
Hands on experience with CURAM Software development environment as CURAM DBA
Proficient in Database Administration activities such as installing, upgrades, patches, cloning, backup and recovery, performance tuning, script development, and documentation.
Good hands on experience working on physical standby databases.
Hands-on experience in planning & designing Oracle Backups and Recovery strategies like RMAN, export/import – logical and physical backup.
Intensively used latest Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM), ASH reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control and 11g (11.1.0.1.0)
Handled High volume production databases around 60 TB size along with Physical standby databases
Proficient in Oracle High Availability features like RAC, DATA GUARD, GOLDEN GATE, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.
Design and support a disaster recovery plan to enable timely failover of all instances when necessary
Performed Data file recovery from logical and physical block corruptions
Good understanding and Implementation expertise in RAC, ASM, Data Guard like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
Exp on Cluster management, event management, application management, connection management, storage management, load balancing and availability.
Extensive experience in DBA activities including schema/user management, space management monitoring on oracle.
Large high volume site experience with database monitoring and tuning on OLAP 24*7*365 systems.
Installing, Configuring, Administering, Cloning, Patching, Upgrading and Migrating the Oracle Technologies Database Products on Unix, AIX, Sun Solaris SPARC, Linux, Cent OS and Windows server family.
Expert in database installations, configuration, test instances creation and refreshes and the change management.
Work with Architect and planning teams to identify right technology investments and technical architectures upgrades
Knowledge on Designing and implement database structures for all instances of Meter data management (MDM ) and Meter Asset Management (MAM)
Expertise in performance- tuning, SQL tuning services with EXPLAIN PLAN, TKPROF,STATSPACK,SQL,TRACE,AWR,ADDM to collect and maintain performance statistics and improve the database performance.
Hands on Exp with recovery of datafiles and block corruption problems.
Developer UNIX Shell scripts and SQL scripts to carry out routing checks on databases. This includes database health check, automate RMAN backups, disk space availability, alert log errors, stats gathering etc
Expert with Data Guard, creation of physical standby and resolving the physical standby database gap.
Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN
Experience in platform migration from Sun Solaris to HP Linux using traditional export/import and datapump utilities
Supportive Individual capable of Managing incidents, being proactive in terms of preventive maintenance and knowledgeable in terms of risk management.
Expert in Support and Maintenance, shell scripting, database upgrades and enhancements.
Conduct Knowledge sharing and training sessions to Train staff to perform all aspects of on-going support of the databases.
Proficiency in Analytical, Presentation, written and oral Communication and Interpersonal skills.
Work profile:
Working as Oracle Database administrator with Verizon wireless from Feb 1st 2019 to till date
Worked as Oracle Database Administrator with IBM India Pvt Ltd. From Jan 2010 to Jan 2019.
Worked as Oracle Database Administrator in SMILAX TECHNOLOGIES Hyderabad from Dec 2005 to Dec 2009.
Awards, Certifications & Trainings:
Achieved Award Eminence and Excellence Recognition (E&E) in IBM
Oracle 11g Database administrator. Oracle Certified Associate (OCA).
Education:
Master of Computer Applications (M.C.A) from Acharya Nagarjuna University, 2006 ( Masters )
Bachelor of Computer Science (B.Sc. computer science) From Acharya Nagarjuna University, 2003 (Bachlors)
Trainings Completed
Oracle administration I workshop from Oracle University
Oracle administration II workshop from Oracle University
Oracle Database 11g Performance Tuning.
Oracle Database 11g Advanced PL/SQL
UNIX shell scripting from IBM
Oracle Database 11g:Performance Tuning Ed2 from Oracle University
Technical Skills:
Database Admin
AWS, RDS, EC2, S3, Oracle Cloud, Oracle 19C, 18C, 12C, EXADATA, 11gR1, 11gR2,10g/9i,SQL Server, DB2, Aurora Postgres, Cassandra, Mongo Db, DMS, Ora-to-PG, Lambda, SCT
RDBMS
Oracle, Microsoft SQL Server, MySQL, DB2
High Availability
Exadata,19c, 18c, 12C, 11G, 10G, RAC, Data Guard, ASM, GOLDEN GATE
Languages
SQL, PL/SQL, Shell Script, bash, C, Core Java
Operating System
LINUX (4.x, 5.x, 6.x), Sun Solaris 8/9/10, SuSE Linux Advanced Server, and HP-UX 10/11.x, IBM AIX 5.1, 5.2, 5.3 & Windows Server 2003/2000/NT, AWS, Oracle Cloud ( OCI)
Development Tools
SQL Developer, Toad, SQL*plus, SQL* Loader,TIDAL, DMS, SCT, OratoPG
Database Tools
SQL*PLUS, TOAD, Putty, OEM( 11g & 10g), RMAN, EBU, SQL* LOADER, imp, exp & Data pump (expdp and impdp).
Web Tools
IMPACT, Rational Clearcase, Clear Quest, Remedy
Web Technologies
Html,
Ticketing Tools
Remedy, Impact, JIRA
Tuning Tools
TKPROF,EXPLAINPLAN,STATSPACK,AWR,ADDM, ASH
Experience:
Role: Oracle Database Administrator Jan 2019 – Till date
Client : Verizon wireless Irving Tx
Tittle : WBN COFEE
Create and support PROD, Stage, UAT, ST, DEV and DR Oracle 11g, 12c databases
Create Cloud Databases for PROD, UAT and Dev 12c, 18c and 19c
Perform cloud migrations for Oracle and Postgres and ONPREM oracle to AWS, RDS
Perform ONPREM to Cloud, ONPREM to ONPREM Oracle to Postgers migraitons
Configure Oracle GOLDENGATE between the databases and Migrate db’s using OGG
Create new Cluster environments, ASM and databases as per the requirements.
Create New Standby databases for PROD environments and Perform DR tests.
Develop, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created databases
Refresh Lower environments with prod data for multiple releases.
Perform review meetings for PROD deployments.
Work closely with Development teams for application related performance issues and fix them
Implement Microservices databases for all the applications.
Implement and maintain database security (create and maintain users and roles, assign privileges)
Perform database tuning and performance monitoring
Perform application tuning and performance monitoring
Setup and maintain documentation and standards
Take care of the Database design and implementation
Plan growth and changes (capacity planning)
Work as part of a team and provide 24x7 support when required
Perform general technical trouble shooting and give consultation to development teams
Create instances and databases with appropriate initialization parameters and database structures
Document migration procedures and test results
Perform database maintenance functions Move, rebuild, or change database objects as required in production Providing assistance in the development of the conceptual & logical database design
Supporting application programmers in the testing of database applications
Provide ongoing database support/review in the CPC production environment
Assist the Application Developers in developing efficient SQL code to access and manipulate database objects as projected in functional requirements.
Env : Oracle 11G, 12C, 13COEM, Dataguard, RAC, ASM, Remedy, TDP, Tspace, Toad, Sql Developer, Shell scripting, Jira.
Role : Oracle Database Administrator March 14 – Jan 19
Client: State of Missouri, Jeffersoncity MO
Title : MEDES
The State of Missouri, Office of Administration has realized an emergency situation with regard to Project development of the MEDES project which is intended to result in a Medicaid Modified Adjusted Gross Income (MAGI) system module for purposes of enrolment and adjudication of Missouri Medicaid applications.
Provide technical solution (enhancement of existing functionality/ propose new functionality) to client. This requires frequent face to face interaction with the client also be responsible for performing technical risk assessment and prepare the mitigation plan accordingly (both proactively and reactively). Provide technical guidance to team members and developers.
Performing consolidated health check reports for the entire application which includes Database server utilization and generating reports for the underlying database, Web Sphere Portal database health check and bellow mentioned activities.
Capacity planning for database growth, space management, physical and logical database design.
Dynamic changes of database parameter for the optimum performance of the database.
Analyse and design new databases based on client requirements
Work with various teams like Development, test and application teams to understand the issues and help to provide solution from Database level.
Configure Physical standby databases with Data guard
Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse
Mapping client’s requirements and implementing processes in line with the guidelines specified by the client through ETL process
Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results
Developed mappings to load into staging tables and then to Dimensions and Facts
Configure Goldengate between Legacy and New databases for Data migrations
Configure Goldengate between PROD and Reporting databases
Monitor the databases using Database metrics from OEM and Automated adhoc Shell scripts.
Refresh the lower environments for the Development, test teams.
Recover the database for physical and logical data file corruptions and other failures
Analyse the bottlenecks and performance issues and provide resolution with efficient database, query tuning for smoother functionality of database with best response time.
Perform successful Database Deployments in PROD as well as lower environments.
Develop, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 10g/11g and 12C databases
Work with development teams for database performance issues.
Schedule jobs using TIDAL job scheduler for database and ETL
24x7 production support and on call rotation
Configure Data guard between production and DR site with Max performance replication.
Analyse and resolving any technical issues in the applications related to the Project.
Monitor the performance of the system and resolving any issues to ensure stable performance.
Monitoring the critical system parameters and analysing and resolving any issues found during the monitoring
Monitoring the performance of the system and resolving any issues to ensure stable performance.
Environment: Oracle 11g, RAC, DATAGUARD, Informatica, TIDAL, Goldengate, DB2, JIRA, AIX OS 5.1,5.2,5.3, Toad, Shell Scripting, MQ, WebSphere, CURAM and Hadoop
Role: Oracle Database Administrator July 13 – March 14
Client: AT&T, Dallas, TX
Title: GCP Transformation
Roles & Responsibilities:
Support 24x7 production for 180 Oracle databases and 60 Sql Server Database and Applications.
Create and support new DEV, SIT, UAT, BAU, TechTest and Prod /DR Oracle 11.2.0.3 databases
Create new Cluster environments, ASM and databases as per the requirements.
Develop, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 10g/11g and 12C databases
Involved in Implementing Oracle Golden gate between Production databases Active – Active configuration with CDR implementation.
Migration of around 2000 Schemas across 65 prod databases to New 8 Node 12c PROD RAC database
Creation of Deployment plans for the Cut overs activities
Preparing the deployment plans with pre and post installation steps
Created replication environments as physical standby for the prod databases using High availability feature Data Guard in Max performance mode.
Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose’s
Responsible for managing production, development & test databases and applications.
Extensively worked with export/import and datapump utilizes to migrate data from Sun Solaris to AIX
24X7 production support and on call rotation
Involved in database migrations, cloning production system, for testing and development.
Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth
Extensively worked with indexes and table partitioning.
Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
Planning for storage spaces requirements and placing them for optimum I/O performance.
Tuning the databases for optimal performance.
Partitioning tables by determining the suitable methodology to improve performance and manageability.
Implemented custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
Provided application support to users and created a log of all the problems with solutions for future reference.
Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.
Environment: Oracle 10g, 11g, 12C, RAC, ASM, Data Guard, EXADATA, Goldengate, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Linux( RHEL 4.x, 5.x 6.x), Sun OS 5.8/5.9/5.10, AIX OS 5.1,5.2,5.3, Toad, Shell Scripting, PL/SQL, SQL*Plus.
Role: Oracle Database Administrator Oct 2012- July13
Client: ONCOR, Dallas, Tx
Title: Oncor Electric Delivery (Smart Meter Texas)
Roles & Responsibilities:
Developing, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 11g/10g databases
Involved in Implementing Oracle Golden gate between Production databases Active – Active configuration with CDR implementation.
Migration of around 2000 Schemas across 65 prod databases to New 8 Node PROD RAC database
Creation of Deployment plans for the Cut overs activities
Preparing the deployment plans with pre and post installation steps
Created replication environments as physical standby for the prod databases using High availability feature Data Guard in Max performance mode.
Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
Perform Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments
Responsible for managing production, development & test databases and applications.
Extensively worked with export/import and data pump utilizes to migrate data from Sun Solaris to AIX
24X7 production support and on call rotation
Involved in database migrations, cloning production system, for testing and development.
Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth
Extensively worked with indexes and table partitioning.
Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
Planning for storage spaces requirements and placing them for optimum I/O performance.
Tuning the databases for optimal performance.
Partitioning tables by determining the suitable methodology to improve performance and manageability.
Implemented custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
Provided application support to users and created a log of all the problems with solutions for future reference.
Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.
Implement and maintain database structures for all instances of Meter data management (MDM ) and Meter Asset Management (MAM)
Worked with multiple teams for to Maintain complete data for MDMS databases ( Command centre and LCIS )
Worked with Maximo implementation teams for MAM database instances maintenance and support.
Environment: Oracle 11g/10g, RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, AIX OS 5.1,5.2,5.3, Toad, Shell Scripting, PL/SQL, SQL*Plus.
Client: ONCOR, Dallas Texas Jan 2010 – Oct 2012
Title: SMART METER TEXAS Dallas Tx
Role: Oracle Database Administrator
Project Description:
SMT is one of the most highlighted project in IBM. This is about installing and maintaining smart meters in Texas. Here we deal with multiple clients termed as TDSPs. IBM is responsible for maintaining and managing all the Production, Development and Staging environments (hardware and databases) for all the clients who provide electricity in Texas. It required teams having diversified technical background, viz., Java, J2EE, Portal and Portlet factory, Oracle, Testing competency to name a few.
The database is working as a warehouse for all the TDSPs where we store the usage data, meter information and other information regarding the end customers for all the TDSPs. The TDSPs send us the data in form of flat files which is processed by the ETL team via sql loader to load it into the Oracle database. Each and every usage details of each meter id is stored with respect to ESIIDs. Usage data related to 15 mins usage, daily usage,
Weekly usage and monthly usage is stored into our databases which can be retrieved by the user at any point of time with graphical representation of his/her meter usage.
The database version used here is 11g release 1. It’s a 3 node RAC system using ASM as the storage manager. It also has a 2 node RAC DR (Disaster Recovery) site where data gets replicated from Production. We also maintain a 2 node RAC staging environment for testing
Roles & Responsibilities:
As a Oracle DBA my role was to support Client's Production and Development databases
Supporting/monitoring 3-node Production Oracle 11g RAC on Oracle Cluster ware platforms on high availability environment and writing shell scripting for various database maintenance and alerting activities
Creating RAC databases in various environments when ever required.
365 X 24/7 Production support and deployments of new releases.
Maintained large sized prod and Disaster recovery databases of around 25 TB size
Creation of New Cluster environments, ASM and Databases
Maintaining 11Gr1 and 11Gr2 Databases.
Performed upgrades from 11GR1 to 11GR2
Created RAC11g standby database on 2 node cluster for large production system as per specification.
Created new ASM disk groups using RAW disks, LUNS and adding, dropping disk members from ASM.
Working extensively with Oracle support for Sev 1 issues like Datafile corruption, Block corruption problems in Production environment.
Installed RAC 11G Staging database Installed and configured EM Central Grid control on 11g to administer and manage large number of databases and enterprise wide targets.
Plan for backup, recovery, and fault tolerance of database; back up and restore the database
Control and monitor user access to database; monitor and optimize the performance of database
Allocate system storage and plan for future storage requirements for the database system
Provide technical resolution to Oracle database related problems
Create primary database storage structures and primary objects
Create and maintain clone/staging database environment as well as hot standby database
Responsible for installation, account management, backup/recovery of Oracle 11g databases
Performing Rman Level 0 and leve1 backups daily and weekly.
Performed automatic monitoring of users, tablespaces, tables, indexes
Creating Shell scripts to automate database monitoring activities and regular Rman backups.
Performed logical exports and imports of database, users, and tables as and when required.
Manage and maintain SMT's Production and Development databases.
Maintain MNF Tracker which directly goes to the client for verification
Carry out day to day activities in production includes sanity test, schema management and space management.
Work with various teams involved in this project as when needed to resolve issues.
Refreshing Development Databases with production data
Working as a team member of an integrated group that provides consistent support in a collaborative manner to the client.
Environment: Oracle 11g/10g/9i, RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Linux(RHEL 4.x,5.x),Sun OS 5.9/5.10, AIX OS 5.1,5.2,5.3, Toad, Performance Tuning Shell Scripting, PL/SQL, SQL*Plus.
Role: Oracle Database Administrator ( India) Feb’ 08- Dec’ 09
Client: McKesson, San Francisco,CA
Title: McKesson Encore
Project Description:
Mckesson is a leading software provider in Healthcare services. Encore is a Web based product. The Encore mainly deals with Hospitalization and Insurances of patients. Encore contains two main modules AM & RM, In that how patients are claims for Insurance and how the charges are made for that claims. The main aim of this product is Usability and easy use of Maintenance.
Roles & Responsibilities:
Creating New RAC database as per the requirement.
Space management, Uesr management
Refreshing data from prod to lower environments for testing
Creating the new jobs for report generation, Database monitoring and alert mgmt.
Creating RMAN backup strategies as per the requirements.
Creating, adding new disk groups and members to ASM for new databases
Resolving user issues immediately and closing the issues on timely manner
Monitoring jobs, troubleshooting on failure and addressing alerts
Performed heavy data loads using SQL *Loader, Export, Import for backing certain tables.
Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
Plan and implement appropriate backup and recovery strategies for the database.
Rebuilding indexes for faster access and to reduce disk I/O.
Observing Logs generated every day.
Environment: Oracle 9i/10G/11G, MS SQL Server 2000/2005, Oracle Enterprise Manager (OEM), OEM 10g Grid Control, RMAN, RAC, ASM, DBArtisan, DataGuard, AIX OS 5.1,5.2,5.3,Linux( RHEL 4.x, 5.x),Sun OS 5.8/5.9/5.10, Toad, Shell Scripting, PL/SQL, SQL*Plus.
Role: Oracle Database Administrator (India) Aug’ 06- Feb’ 08
Client: Bronze Manufacture, In, Stanchfield, MD
Title: BSCS (Business Support Control System)
Project Description:
Developed an application for Bronze Manufacture Inc. the system has a database, which stores information about sales, profit and contacts of customers. Using this existing database, the system should analyze the sales and profit and generates repots for sales and profits in month wise and year wise. The resulting model gives us an idea about growth in profit, predication about increase in sales.
Role & Responsibilities:
Checking health systems of Oracle Database
Involved in Oracle database logical and physical Backups
Ensure the completion of all daily backups.
Monitoring database growth and space management.
Checking the alert logs regularly
Configuring the database to archive mode
Maintaining database security by creating users and profiles
Resolving user process error
Monitoring Database Performance by Dynamic Performance views.
Environment: Oracle 10g/9i, Toad, Oracle Enterprise Manager (OEM), RMAN, RAC, Data Suse Linux Advanced Server and AIX 5.1/5.2/5.3, TOAD, Performance Tuning, Shell Scripting, PL/SQL, SQL*Plus
Role: Oracle Database Administrator, Developer (India) Dec’ 05- Aug’ 06
Client: Central Institute of English and Foreign Languages
Title: CIEFL DESKTOP
Project Description:
CIEFL Desktop Project is to integrate the various Departments/sections of entire University with the centralized database. All the departments and deans of the institute communicate through the EDMS( Electronic Document Management System) concept. This project was divided into 10 modules those are Admin, Stores & Purchase, Accounts, Library, Hostel & Guesthouse, School of Distance Education, Academic, Dean of Studies and Publications & Workstations.
Roles & Responsibilities:
Creation of New databases as per the requirements for UAT, DEV and Test.
Resolving connectivity issues with the database from clients
Develop technical platform for global-client
Upheld quality control and data validity for Java Programs
Resolve application and connectivity problems in Java Programs
Creating oracle clients on application end
Creating new scripts to automate the monitoring jobs for faster response.
Scheudling the backups and jobs to maintain the better performance of DB
Performing exports and imports based on the application user requests
Application trouble shooting with respect to Database issues.
Designed and developed front view components using JSP and HTML
Backing up databases.
Providing security privileges to developers.
Managing Users and Giving appropriate permission’s.
Managing Default Temporary Table space
Creating and Managing Table space with Multiple Block Sizes.
Involved in database schema creations and writing queries.
Environment: Linux, Windows, core java, javascript,JSP, servlets, Sprint and Oracle 9i, 10G.
Contact this candidate