Oracle Sql

Sai Krishna Mandalika

************@*****.***

(**0) – 378 -3343

Summary:

8+ years of experience as Oracle DBA, providing 24/7 support of development and production 12c/11g/10g/9i/8i databases on Various Platforms.

Excellent experience in Installation and configuration of Oracle12c, 11g, 10g, 9i and 8i in UNIX/LINUX and Windows environment. .

Experience in Installation, configuration of Oracle RAC, developed 2 node RAC environments for a 1TB database by implementing WAN technology to reduce the network traffic.

Experienced on HP-UX and Windows with Oracle8iParallel Server and Oracle9iRAC.

Implemented strategy for partitioning and management of historical data tables in RAC.

Experience in Upgrading databases (11g R2 to 12C,10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1).

Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 12c, 11g RAC with EMC.

Installed Audit vault and rolled out agent to critical databases and hosts which helped in tightening the security.

Experienced in setting up/installation and configuration of release 12c, 11g RAC/10g R1 RAC with EMC Storage.

Installation and monitoring of Elasticsearch, Logstash, and Kibana ( ELK stack) on UBUNTU.

Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication, Audit vault, DB Vault.

Planned and implemented DR & high availability solutions using OEL 10g Standby Database using Oracle Data Guard 12c, 11g and 10g RAC.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Employed predefined UNIX scripts to cleanup database files such as outdated archived redo logs and trace files out of bdump, udump and Audit directories.

Experience with Oracle database security in the banking domain projects.

Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

Expertise in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER and Strong experience in Data warehouse concepts, ETL.

Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.

Configures Oracle environment to efficiently support ERP and business needs, performs database backup and recovery. Remain current on database and technology advancements. Recommend new technologies as warranted.

Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Designed and implemented Oracle Real Application Clusters (RAC) on Solaris for an OLTP application with Transaction Application Failover and high transaction volume.

Proficient in using OEM and RMAN.

Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Performance Tuning, capacity planning, script development, and documentation.

Upgrade/Migration of Databases from Oracle 11g to 12c.

Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.

Expertise in Oracle Golden Gate installation, configuration, troubleshooting GoldenGate issues.

Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.

Excellent working experience on EMC, NetApp and ASM Storage technologies.

Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues

Expertise in Oracle Golden Gate software.

Planned and implemented high availability solutions using Oracle 10g RAC, Standby Database using Oracle Data Guard

Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering 40 Terabytes of Oracle Databases on Oracle 12c/11g/10g/9i.

Expertise in supporting replication with snapshots, Materialized Views and Streams.

Good knowledge on Oracle streams, data guard physical standby databases, working knowledge on BCV’S, SRDF, and managing of partitions and clustering of tables.

Experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using Load testing tools

Configuring DB Links for users located remotely.

Installation, configuration, upgrade and performance tuning of Oracle RAC.

Database Tuning, PL/SQL tuning using explain plan and HINTS extensively to optimize the SQL statements, used cost based approach extensively and also used rule based methods to tune the SQL.

Excellent experience in OLTP database systems, implementing and managing large Oracle databases

Expertise in maintaining Database Security using auditing.

Experience with mid-tier architectures 10giAS, Knowledge of OEM, TOAD, Oracle grid-control.

Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, Logical and Physical database design.

Experience on Script Programming using Korn shell, bash shell, Perl, Awk and knowledge on archiving tolls like tar, gunzip, backup, auditing both external auditing and internal auditing, experience on various UNIX platform like Redhat, AIX

Management of schemas, objects & partitioning the tables & indexes.

Worked on Advanced Replication including synchronous and asynchronous scenarios

Experience with Oracle 10g features: Flash-Back Recovery, Datapump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin.

Solid experience with Oracle technology architecture, Oracle and Real Application Clusters.

Knowledge of Data transfer between SQL Server and Oracle.

Ability to function successfully in a highly stressful, 24x7 mission critical environment.

Excellent analytical and problem-solving skills.

Result oriented, self-motivated, team player, ability to work independently.

Excellent written and verbal communication skills.

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, SQL*PLUS, C, JAVA, JAVASCRIPT, HTML, CSS, PHP, LARAWEL.

Database: Oracle 12c RAC/11g RAC/10g RAC/9i/8i.

Operating System: UNIX, Solaris, AIX, HP-Unix, Linux, Window (10, 8, 7, Vista, 2005, 2003, XP, 2000, NT).

Tools: SQL*PLUS, SQL Developer, TOAD, Sql Navigator, PUTTY, OEM, RMAN, SQL*LOADER, Imp/Exp and Data pump, Aqua Data Studio 4.7, Humming Bird connectivity, Cygwin –X.

Other Technologies: ODBC, Crystal Reports, MS Office, SFDM, Erwin 4.0/4.2/7.6, Relational Database Design.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM.

TOOLS/Utilities: RMAN, ASM, Grid Control, Golden Gate, EXP, IMP, expdp, impdp, Maximo.

Client: Charles Schwab, Phoenix, Arizona. 18 Mar ’15 - Present

Role: Senior Oracle DBA

Description: Charles Schwab is an American Banking company, providing a range of traditional and consumer directed Banking solutions.

Environment: ORACLE, SQL Server, SQL*Plus, OEL 12c/11g, Red Hat Linux 4.x, RAC, Solaris 10, IBM AIX 5.3, Data Guard, Golden Gate, ASM, PL/SQL, RMAN, Toad, OEM GRID, EMC, NetApp. Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1.0, PowerMart 5.1, Power Connect/Power Exchange for SAP R/3, MainFrame and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.

Responsibilities:

24x7 Oracle Production Database Administration including Oracle 12C/11g RAC.

Installed, configured and maintained Oracle Databases.

Install and configure Oracle Golden Gate and Establishing standards, policies and procedures for Golden Gate replication administration.

Responsible for installing and configuring Golden Gate 12c, v11 on Oracle Linux Servers.

Managing, troubleshooting and resolving oracle database, RAC and applications issues.

Involved in Upgrade/Migration of the oracle databases from Oracle 11g to Oracle 12c and Sun Solaris to OEL (Oracle Enterprise Linux).

Installed Audit Vault and rolled out agent to critical databases and hosts which helped in tightening the security.

Setup database firewall for improving the security on the databases.

Setup of logstash to gather syslogs on multiple servers.

Setup of Kibana to visualize the gathered logs generated.

Installed and configured OEM Grid Control and OEM Grid control to monitor all databases.

Implementation of High Availability solutions with Oracle 11g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Golden Gate.

Developed back-end logic for business applications, e.g. views, procedures/functions, triggers.

Developed scripts and reports using SQL, PL/SQL and Perl.

Designed and implemented Oracle Real Application Clusters (RAC) on Solaris with EMC Storage for an OLTP application with Transaction Application Failover and high transaction volume.

Established best practices and best procedures for database administration. Responsible for Software life-cycle support to include migration of all custom application changes through four different instances to production.

Standby Database (Data Guard) setup and configuring DB links.

Developed 2 node RAC environments for a 1TB database and Implementing Data guard on this RAC environment with another RAC Standby Database.

Monitored/managed 2 node RAC environments, databases using OEM Grid control, and RMAN database backup and recovery.

Working alongside programmers and contributing to the development process; Enabling and analyzing trace files and performing monitoring and performance tuning.

Defining and Setting backup and recovery procedures and Performed and tuned using AWR, OEM Grid and tkprof etc Oracle Databases.

Tuning the database using stats pack and custom script and Responsible for continuous database monitoring and reorganization for ensuring performance.

Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.

Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.

Optimal Space utilization in tablespace by avoiding fragmentation.

Installation of Oracle RDBMS server software and version upgrades.

Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)

Usage of Partitions to improve the query performance and manageability.

Analyzed the user requirements and Designed views using STAR schema for improving performance of Data marts.

Performed partition maintenance and automated the process of creating new partitions as and when required.

Writing Shell Scripts for managing day-to-day activities and automation of backup.

Created shell scripts for invoking the sql scripts.

Installation and configuration of Oracle Client software and Tools.

SQL and PL/SQL Programming.

Automated the process of analyzing tablespaces every night.

Yale University, Newhaven, CT. 11 Sep ’13 - 29 Jan ‘15

Role: Oracle DBA.

Description: Yale is one of the largest Iv league university in the world. It is located in the northeastern part of USA.

Environment: HP Integrity Superdome Sx2000 chipset, 32 processor, 1TB, Solaris Fire 440, IBM z/OS 1.12, Fire 880, Oracle 9i/10g/11g, HP Integrity rx 8640, RHEL AS 5, SQL * Plus, OEM, Erwin Data Modeler.

Responsibilities:

Installed and configured OEM Grid Control.

Managing, troubleshooting and resolving oracle database, RAC and applications issues.

24x7 Oracle Production Database Administration including Oracle 11g RAC.

Performed Oracle Database upgrades from 10.2.0.2 to 10.2.0.3 in AIX RAC environment.

Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.

Scripting (shell) of automated backup for Cold / Hot backups and also defining and Setting backup and recovery procedures.

Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.

Involved in Database Administration, Installation, Maintenance and development of FACETS for medi-care.

Perform installation, maintenance, and troubleshooting and performance administration of Oracle 11g under IBM z/OS 1.12.

Worked on Oracel Audit vault for security encryption data.

Managed with separate user for Audit Vault and configured steps along TNS service.

Performing Online and Offline database backups on schedule.

Refresh/Cloning of Database and applications for development and testing purpose.

Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Golden Gate.

Performing daily Archive log file backup and checking Alert Log files.

Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.

Using RMAN & User Managed backup methods for better control.

Upgrade/Migrated the production and development of FACETS.

Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and to see if these queries can be fine-tuned for better performance.

Involved in Database sizing, Capacity Planning.

Perform database cloning/exp/imp to setup identical databases in the production and development environments.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Installation and Maintenance of Shareplex Replication, Quest-Spotlight.

Monitoring the table space growth and resizing the table space on 9i RAC environment.

Involved in monitoring the lock/block processes, releasing locks in case of resource blockage and gathering statistics.

Creating ODBC for users & Application Developers.

Maintained Microsoft SQL Database Server 2003.

Co-ordination has been extended to Application developers for coding to improve the performance of the database.

Co-ordination has been extended to nearly more than 10 Units for online database activities.

Managed database security using groups, roles and handled number of databases in different places.

Automated the procedures and interface programs using Oracle Advanced Queuing, Oracle Enterprise Manager.

Created database objects and managed the permission access on the objects with necessary security.

Review alert logs and dump files to check for any problems related to the database/user.

Experience with Repository Manager to import Metadata for sources and targets and the mapping designer to map source to the target.

Presenting user-friendly reports, and providing training to end users on reporting functions.

Client: Standard Chartered, New York, NY. 13 Jul ‘11 - 25 Aug ‘13

Role: Oracle DBA

Description: Standard Chartered is a European multinational financial services corporation. It is one of the largest mutual funded financial services groups in the world.

Environment: ORACLE 11g/10g/9i, RAC 11g, RHEL, Windows 2003/NT, OEM Grid Control 12c/11, RMAN, ASM, CRS, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Erwin, AWR, ADDM and DB Artisan.

Responsibilities:

Provided 24x7 on-call support to the Production databases as a primary DBA.

Experience in upgrading oracle database from 11.2.0.3 to 11.2.0.4 by applying a patch and downgrading a RAC Cluster database from 11.2.0.4 to 11.2.0.3.

Experience in setting up a 2-node RAC cluster environment with Oracle 11g and applying patches.

Experience in building a new 2-node RAC and migrating the existing database on to the newly built servers including ASM storage migration.

Experience in applying the quarterly Oracle DB PSU's.

Experience in trouble shooting DR issues, applying logs manually, monitoring DR and its replication.

Cloning databases using scripts as well as HOTBACKUP.

Setup and Monitoring of all the four components of the ELK stack in UBUNTU.

Setup and monitoring of Logstash, Elastic search, Kibana and the Filebeat.

Involved in building a physical Standby for the Production RAC servers with Data guard.

Cleaning the ORACLE_HOME file system by cleaning the log files, alert log file and listener.log files.

Installed database firewall for the security.

Experience in adding an additional node a stand-alone database and get the cluster services available for that.

Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.

Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.

Involved in using Oracle database features like Undo Tablespaces, External Tables, Locally Managed Tablespaces, Automatic Space Segment, Transportable Tablespaces, Autonomous Transaction, Dynamic SQL, Functions, Partitioning, Sub-Partitioning, Materialized Views, Bitmap Indexes, etc.

Provided assistance in getting the tickets resolved.

Experience in migrating databases on cross platform i.e. from Oracle to SQL.

Experience in building a new OEM 12c server, installing OMS, RCAT.

init disk, alter Databases added space as required in replication server and ASE servers databases. Did server space management including SAN request and NEW disk initiation.

Set up Security and audit on servers, user's access per firm policy and standards. Maintained Top security for applications.

Support Day to DAY OLTP and Workstation batch run progress and monitored batch processing

Performance and meet all SLA for Clients.

Client: Gland Pharma, Hyderabad, India 2 Nov ‘09 - 6 Jun ‘11

Role: Oracle DBA

Description: Gland pharma, is a recognized leader in the healthcare, and Pharmaceutical resource, with a steadfast commitment to success and a record of achievement that continues a tradition of delivering excellence.

Environment: Oracle 8i, Oracle 9i (9.0.1.2.0 & 9.2.0.4.0) 10g (10.2.0.1)RHEL 3.X, 4.X; Windows NT 2000/2003; LPARS; VMware ESX Server; Veritas Volume Manager; HP DL320, DL330, DL380; EMC Celerra NS; Hitachi; IBM arrays.

Responsibilities:

Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications Work on IBM z/OS with OEM Grid control to maintain the database effectively.

Configuration & Administration of Red Hat Linux 3.X/ 4.X at various client servers and service provider's servers.

Install FTP/TFTP/SFTP Server and set up network connections.

Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.

Troubleshoot hardware, software and Operating system related errors on Red hat Linux and AIX.

Database cloning/exp/imp to setup identical databases in the production and development environments.

Performed system-monitoring tools like TOPAS, SAR, VMSTAT, IOSTAT to report systems usage and performance.

Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.

Backup/Recovery of Oracle 9i/10g databases using Oracle RMAN.

Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.

Configure servers to use HTTP, DNS, NFS, NetBackup, Storage Disk configuration.

Diagnose and correct boot failures arising from boot loader, module, and file system errors on Red hat Linux.

Setup and configured 2 node Oracle 10g RAC with ASM.

Maintaining, Building and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting.

Creating ODBC for users & Application Developers.

General Network issues troubleshooting related to network outages.

Monitored performance and availability of the VIS application a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN.

Configure RAID control partitions.

Hindustan Petroleum, Hyderabad, India 3 Jul ’08 – 26 Oct ‘09

Role: Oracle DBA

Description: Hindustan petroleum is one of the largest company that provides oil and gas in India.

Environment: Oracle 10g RAC/9i/8i, SUN SOLARIS, REDHAT LINUX, OEM (Grid Control), RMAN, Explain Plan, Data Pump, EXP/IMP, SQL*Loader, STATSPACK, AWR, ADDM.

Responsibilities:

Installation and configuration of Oracle 8i, 9i, 10g databases.

Issues related to Space Management, Locks, Database Hit Ratios, Backup failures and UNIX related On-Call alerts.

End-user requests in terms of assisting them in effectively create tables, views, packages, sequences, schema refreshes.

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.

Alert monitoring and Ticketing.

Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers

Database backup & Recovery.

Maintenance of Oracle Production, Development, Testing and QA databases.

Coordinating Backup and Recovery operations over all databases.

Load data using SQL*Loader.

Creation of users and Granting them privileges and roles.

Worked with developers to provide queries and tuning the queries for better performance.

Export and Import Data according to the users request.

Education:

Masters of computers (MCOM) Jun ’06 - April ‘08

Osmania University

Bachelors in Engineering (Computer science) Sep ’02 – May ‘06

Osmania University

Contact this candidate