Manager Data
Resume:
Vijay Shankar Chirra
*****.*******.******@*****.***
Professional Summary
Over 13 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, High availability solutions, Disaster recovery solutions, shell scripting and documentation.
Education
Bachelor of Technology in information technology, Warangal India (2002-2006)
Master’s in computer science from State University of New York, New Paltz NY (2009-2011).
Certifications
Oracle certified professional in Oracle 10g.
AWS Solutions Architect.
DBA skills include:
Oracle 19c/12c/11g/10g Database Monitoring.
Performance Tuning
Golden Gate 11g/12c.
RMAN, Data Security, Backup & Recovery.
Database Upgrades/Migrations.
AWS Cloud
Exadata –X2, X3, X4, X5, X6
Oracle Linux, Red hat Linux, Sun Solaris, IBM AIX, Windows.
Oracle RAC 10g/11g/12c/18c/19c & ASM Installs.
Physical/Active Data guard, Snap shot standby
Oracle Enterprise Manager 12c, 13c
DBA Core experience lists
Extensive knowledge on database administration for Oracle 8i, 9i, 10g & 11g, 12c,18c and 19c with experience within very large-scale database environment and mission critical large OLTP and OLAP systems.
Hands on experience in migrating on Prem-databases to AWS cloud and also configured standby databases in AWS cloud for disaster solutions.
Hands on experience in spinning AWS EC2 and RDS instance using CLI commands and with Console.
Experience in setting up Oracle Golden gate configuration from on-prem database to AWS Cloud
Experience in upgrading/Migrating DB’s from Legacy versions to new versions which includes from Oracle 10 to 11g, Oracle 11g to Oracle 12c, Oracle 11g to Oracle 19c and Oracle 12c to Oracle 19c.
Supported 200+ mission critical databases on Linux, Solaris, IBM and Exadata Machines.
Experience in supporting MS SQL server 2014/2016 databases and supporting systems.
Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g, 11g, 12c,18c and 19c in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
Hands on experience in Oracle X5/6 Exadata Database Machine Administration
Experience in Golden gate installation, configuration and monitoring as Primary DBA.
Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g and from 11g to 12c.
Worked Closely with Oracle Platinum Support and Oracle Advance Customer Support Teams in maintaining the environment.
24*7 production database support with Support to developers & end-users.
Installed Oracle 11g ASM & 11g RAC software with ASM & OCFS2 File systems.
Experienced in Installation of high availability RAC environment and upgraded standalone databases to 11g and 12c RAC environment.
Migrated production databases with minimal downtime using Oracle Golden gate
Expertise in Configuring, maintenance of Data guard in RAC environment and standalone environments.
Managed very large database (VLDB) of maximum size 75TB
Managed and provided support for 65 production databases.
Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
Worked on implementing backup policies for Exadata Databases on ZFS server.
Implemented RMAN backup (Full, incremental and cumulative) and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard.
Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
Involved in Monitoring, Optimizing Oracle database for Performance Tuning & system/modules for Application Tuning using tools like AWR, ADDM, ASH, STATSPACK, CBO, TKPROF, EXPLAIN PLAN and SQLT.
Good with concepts of Database Links, Materialized views, Flashback Technology, Partitioning Tables to improve Performance and Manageability.
Hands on experience in Data Archiving
Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
Experienced in using Oracle's Transportable Table space (TTS) feature allows users to quickly move a user table space across Oracle databases.
Good experience in applying Patches (Patching), Critical Patch Update(CPU)/Patch Set Update(PSU) and One-off Patches using OPatch and run installer, also involved in Upgrading and Migration of a Oracle server to higher version available.
Effective troubleshooting of database and Performance problems.
Good experience in Data Migration using export/import.
Prepared DBA work plans, Documented Client site’s “Site specific work procedures”, Change Management and control, Best Practices and did Capacity planning for clients.
Management of Objects, Schemas, Partitioning the tables and Indexes.
Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
Expertise in using OEM, SQL Developer and third party tools like TOAD.
Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.
Technical Skills:
RDBMS
Oracle 19c,18c,12c,11g/10g/9i/8i/7X, Oracle 10g (RAC, Data Guard & Streams), SQL Server 2014/16 and DB2
OPERATING SYSTEMS
Exadata X2/X3/X4/X5/X6. HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10,11 AIX 5.1, 5.2, 5.3,6.1,7.1 Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x,6.x,7.x and Windows NT/2000/2003/XP.
LANGUAGES
SQL, PL/SQL, T-SQL, MYSQL, C, C++, VB, UNIX Shell Scripting, Ksh, bash and Perl Scripting.
SOFTWARES, APPLICATIONS & TOOLS
DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, VCS, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, ERwin, TOAD Data Modeler, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.
WEB TOOLS
HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio.
Professional Experience:
Wells Fargo, Charlotte, NC. Dec’18-Till Date
Role: Sr Oracle DBA
Responsibilities:
Worked on creating standby databases on AWS cloud for disaster recovery solutions.
Worked on spinning of EC2 and RDS instances with CLI commands and Console.
Worked on migrating databases from Oracle to PostgreSQL on to AWS cloud using DMS tool.
Migrating and upgraded databases to Exadata x5, x6 full Rack.
Migrated 60 TB database from Oracle Linux to Oracle Exadata Machine and migrated the DB from Oracle 11.2.0.4 to Oracle 12.1.0.2.
Migrated OLTP systems to Exadata Machine with a very minimum down time using Golden gate.
Worked on Consolidating databases into Multi-tenant database and configured active standby databases for all Multi-tenant production databases.
Migrated 12C non container databases to 19c Container/Pluggable databases on Red hat Linux 7.1.
Worked on upgrading 12c Container databases to 19c version using in place upgrade method and also migrated databases from 12c to 19c using Oracle Golden gate to minimize downtime.
Installation, configuration, patching and upgrades of Oracle RAC.
Implementing Change controls in production environment
Worked on upgrading databases from 12.1.0.2 to 12.2.0.2 on RAC systems.
Upgrade/Migration of Databases from Oracle 10g to 11g and 11g to 12C
OEM Grid control to monitor all databases using OEM 13C.
Planned and implemented high availability solutions using Oracle 11g and 12C RAC, Standby Database using Oracle Data Guard
Created and maintained RAC databases on Oracle Linux, Solaris 11 and IBM AIX 7.1 and configured standby databases for disaster recovery solutions.
Worked on Active Standby Database and snapshot standby database.
Experience in oracle Golden Gate installation, configuration, troubleshooting Golden Gate issues.
Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
Database refresh, schema refresh, database creation, Implement table partitioning
Co-ordinate with application team and developers in resolving issues and prepare deployment plans
Configured and tested backup and recovery using RMAN
Cloning of production database to the test environment using Recovery Manager (RMAN).
Provide support on production server to the clients after the live upgrade until the transition.
Worked and configured Golden gate Integrated Downstream Capture and Coordinated components for Active-Active, Active-Passive and Multi-Tier Architecture.
Instrumental in setting up Golden Gate Farm Server (a cluster, which hosts multi, databases GG in one Home).
Worked on Migrating Databases of 2 Critical Financial Applications from 11.2.0.4 to Exadata 12c Pluggable Environments along with Migration the existing Golden Gate Active-Active setup to new environments.
Worked on Compliance Project in resolving the compliance issues in stipulated deadlines to meet the Banking standards.
Hands on experience in working on Data Vault, 12C pluggable environment, Exadata Database Machines.
Effectively managed day-to-day tasks / activities in coordination with a team of developers to effectively meet the deliverable and schedule of a data solution component within a larger application project.
Manage production support to deliver full-time support (24x7) in an environment where uptime is critical.
Environment: Oracle 12C,11g,10g RAC, Exadata DBA, OEM, HP-UX, Red Hat Enterprise Linux 5,6,7 AIX 7.1, ASM, RMAN, Golden gate, FTP, putty, Data Guard, OEM11g/12C/13c, TOAD, PL/SQL, SQL*Loader.
Client: NYC-HRA Brooklyn NY March’13-Dec’18
Role: Sr Oracle DBA
Responsibilities:
Migrated Critical production databases from 11g database version to 12c database version using Golden gate replication.
Migrated 8 TB production database from 11.2.0.3 version to 12.1.0.2 version and also migrated the database from Solaris 10 to EXADATA X-6 machine.
Work with internal teams to create the migration process of legacy systems to the AWS cloud
Worked on providing disaster solutions by configuring standby databases in AWS cloud with Oracle Data guard.
Configured Golden gate to replicate transactions from 11g source database (8 Node RAC) to 12c target database (5 Node RAC) so that we can cutover to 12c database with minimum downtime.
Migrated and upgraded mission critical database (18TB) to 11g to 12c on Solaris and Linux systems with minimum downtime.
Worked on Configuring 11 Node RAC and Supported critical application on this RAC database.
Configured 11 node RAC Active Data guard environment for disaster recovery of Production database.
Worked on implementing Data guard role transitions like switch over operations and also provided POC for failover operations and also used DGMGRL utility for these role transition operations.
Configured snapshot standby database from physical standby database for application testing before implementing major changes on production database.
Configured 5 node Standby databases for 12c production database and also configured it as snap shot standby database so that we can test production load and performance using RAT (Real application testing).
Converted Physical standby database to snap shot database so that we can capture 11g Production database and replay it on snap shot standby database using RAT for performance testing and tuning before cut over to 12c Database.
Worked on recovering standby database using SCN incremental backups from Production primary database.
Restored and recovered a dropped table using new RMAN features in Oracle 12c.
Worked on applying latest PSU patches and also applied required CPU and one-off patches on both Linux and Solaris Operating systems.
Worked on patching RAC databases in rolling fashion to maintain high availability.
Worked in cloning the GRID infrastructure binaries onto different server.
Installed and configured OEM 13c Enterprise Management system to monitor 12c production databases and deployed mass agents on Linux, Solaris, IBM platforms.
Supported mission critical databases and extensively involved in resolving the performance issues.
Worked on Configuring OEM 12c Enterprise management system on Solaris and IBM machines and installed all different platform agents to monitor the production databases.
Worked on configuring and setting up notifications for database alerts and incidents from OEM 12c.
Worked on implementing standard RMAN backup policies and successfully was able to restore huge database when required.
Worked on resolving performance related issues with AWR, ASH, ADDM, SQLT reports and analyzing with Explain Plan and also tracing the SQL’s.
Assist with database administration activities as requested, responding and fixing all database issues
Assist in sizing database objects for effective space management and optimal performance
Worked on refreshing production databases on sandbox for application testing.
Provided on call support for every 3 weeks and provided support on weekends.
Supported MS SQL server 2014/2016 databases
Client : Idexx Laboratories, Westbrook ME June’12-Feb’13
Role: Sr. Oracle DBA.
Responsibilities:
Golden Gate Implementation: Migrated critical application data from 10g Database to Exadata 11gR2 (11.2.0.3) using Golden gate technique.
Migrated 4T application schema to Exadata Machine Database using Oracle Golden Gate with minimum
down time.
Provided support for 3 Oracle Exadata machines – Prod, DR, QA – to be used for mission critical applications.
Architecting and implemented a RAC database solution for a global laboratory application. The database environment also includes a physical standby database for DR and a logical standby database for reporting.
Designed and implemented a RAC database for in-house global CRM application.
Worked on implementing RAC database and also implemented Physical standby database on Windows Environment.
Maintained a 99.99% uptime for all databases by using DBA best practices and proactive monitoring.
Supported 24T Data warehouse environment.
Implemented and provided support to IDEXX Germany team in migration their production environments to the 11gR2 database server machines.
Designing, implementing and supporting backup and recovery solutions using RMAN, Data Guard and flashback database technologies.
Partitioned large tables using DBMS_REDEFINITION technique, so that the applications never had downtime.
Responsible for setting and managing user accounts, and granting required privileges to users.
Played a key role in release management and change management for many production deployments.
Environment: Windows 2000/2003/XP, AIX 5.2/5.3 and Red Hat Linux 5.4, SOA, Oracle 10g and 11g, Exadata X2, TOAD 11.0, SQL tuning optimizer, Oracle Enterprise Manager (GC), EM12c, RMAN, RAC, ASM, DataGuard, ASM, SCP/SFTP, Shareplex, TKPROF, Explain plan, AWR, ADDM, ASH, SQL Developer, SQL* Plus, PL/SQL, Golden Gate.
Client: Liberty Mutual, Dover NH Oct’11-June’12
Role: Sr. Oracle DBA.
Responsibilities:
24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
Involved in installation of Oracle 11g RAC using cluster ware and ASM.
Resolved complex RAC issues which involved with virtual IP addresses, Subnet masks while assisting the functional team.
Managed and resolved RAC (10g, 11g), ASM and cluster ware issues.
Successfully applied latest Patch Set Update (11.1.0.7.10) on 11gR1 databases.
Used OPatch Utility to install one-off patches to fix specific bugs on Oracle Database.
Tuned the database instances based on the reports generated by AWR,ADDM,EXPLAIN PLAN,
TKPROF, ASH and STATSPACK.
Performed sql tuning by generating execution plan and AWRSQRT reports for the required sql statements.
Implemented cleanup strategy method to cleanup huge loads of old data in a well design techniques and executed the strategy successfully without having any impact on the business logic.
Intensively worked with developers and helped them by improving the database performance.
Responsible for providing documentation for database design, analysis, modifications, creating schemas etc.
Management of schemas, objects partitioning the tables & indexes.
Involved in refreshing the QA databases with PRODUCTION backups
Effectively restored and recovered database by using Oracle RMAN techniques.
Developed scripts for monitoring Tablespace sizes, alert log files, Tablespace growth and implemented Crontab job to alert if the tablespace size exceeds above 80%.
Responsible for taking backup of schemas, tables and table spaces using Oracle 11g Data pump.
Expertise in using the parameters of Oracle export/ import Data pump.
Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints and database access.
Responsible for setting and managing user accounts and granting required privileges to users.
Responsible for moving files to remote serves with secure SCP/FTP techniques.
Played a major role in release management and change management for Production Deployments.
Responsible in handling some critical and generic errors like ORA-600, ORA-7445 by creating SR’s with oracle Tech support.
Environment: Windows 2000/2003/XP, AIX 5.2/5.3 and Red Hat Linux 5.4, SOA, Oracle 10g and 11g, TOAD 11.0, SQL tuning optimizer, Oracle Enterprise Manager (GC), RMAN, RAC, DataGuard, ASM, SCP/SFTP,Shareplex, TKPROF, Explain plan, AWR, ADDM, ASH, SQL Developer, SQL* Plus, PL/SQL, SQL* Loader, T-SQL, SQL Server 2005, Golden Gate.
Chinmaya Technologies Aug 05-April 09
Client: Apollo Health Street, Hyderabad INDIA
Role: Oracle DBA
Responsibilities:
Installation, Upgrade and Configuration of Oracle 9i and 10g Databases.
Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
Data Refresh in Test and Integration Databases using Transportable Table spaces.
Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level.
Implemented backup strategies using hot/cold, exp/imp used on the business req.
Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR) using RMAN.
Implemented Streams replication between RAC and non RAC database environments.
Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink)
Environment: HP-UX 11, Red Hat Linux4, Windows 2000/2003, Oracle 9.2.0.8/10.2.0.3/11i, DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL*Plus, PL/SQL, ASM, J2EE, ToadV9.7 & SQL, Navigator V6.1.
Contact this candidate