OBJECTIVE

• Aspiring a challenging and motivating position as an Oracle DBA where I could utilize my broad and in - depth technical expertise, applications experience and educational background.

SUMMARY

• Engineering graduate wif 8+ years of experience in Oracle database administration (DBA), RAC, SQL and Linux.
• Providing 24/7 on-call support
• Installed RHEL, setup configured 10g and 11g R2 Databases.
• Upgraded from 9i through 12c
• Migrated database from data center to another data center
• Performed refresh.
• Experience maintaining relational database systems such as Oracle Spatial, Microsoft SQL Server, and PostgreSQL.
• Applied CPU, PSU Patches.
• Worked wif Oracle on issues.
• Experienced in managing and reviewing Hadoop log files.
• Experienced in defining job flows.
• 2 and half Yearshands onexperience inOracle ADF 11g Architecture, JDeveloper, Oracle ADF Development (ADF, ADF Faces, ADF Task FlowsandBusiness Components)wifWeb Services.
• Used various methods of Backup and Recovery including user managed and RMAN
• Worked on Windows, AIX, Sun Solaris, HPUX, and RHEL wif various flavors of Linux.
• Performed various Instance Tuning activities like tuning SGA, PGA and memory parameters.
• Generated and analyzed statspack, ASH, AWR, ADDM to address areas of concern.
• Worked wif Development team on gathering requirements and for performance tuning.
• Developed tip and techniques for capacity planning
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Mining, Data Auditing, Data Integration and Metadata Management Services.
• Experienced Developer wif exceptionally good in Unix Shell Script, PL/SQL, tSQL, Solaris, Linux.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Poses expertise in Building RAC from scratch include OS deployment.
• Written Shell Scripts to automate jobs
• Experience in developing commercial web applications, Multi-lingual web apps, enterprise applications and web services by using enterprise technologies, such asJava, J2EE,Spring,JSF,Oracle ADF,Hibernate,EJB, JMS, JSP, Struts, Servlets, Beans, JMS, RMI, HTML, JDBC, XML (XSL,XSLT, XPath),Web Service, SOAandAXIS.
• Provide DBA support wif proactive monitoring using 10g 11g OEM and cloud Control.
• Experienced working wif Gloden Gate. Configure, Setup, Install, & support.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Build multiple Oracle Data Guard environment for DR.
• Worked wif Storage team to carve out partitions for ASM.
• Supported Oracle RAC wif Data Guard environment.
• Familiar wif Materialize Views set up and configuration for replication.
• Used Export/import and Data pump for data movement.
• Configured and Worked on Flash Recovery Area (FRA)
• Good understanding of Oracle Wait and Wait Classes.
• Used SQL Developer, TOAD for ERWIN as tools to manage databases.
• Good noledge of explain plan and query tuning.
• Good noledge on Management of schemas, objects & Partitioning teh tables & indexes.
• Build and administered Oracle GlodenGate uni-directional replication.
• Worked on Migration projects
• Used RMAN’s Duplicate Database feature to clone databases.
• Worked on Redo Log sizing to reduce waits.
• Identified performance bottlenecks and recommended usage of right indexing mechanism.
• Worked on consolidating databases project.
• Very good noledge on Data Dictionary
• Poses working noledge on PL/SQL

TECHNICAL SKILLS

• Oracle Database (9i, 10g, 11g and 12c)
• SQL tuning and GlodenGate
• Real Application Clusters (RAC) 10g and 11g
• Installation.
• Operating Systems
• Linux, Solaris, HP-Unix
• Languages
• SQL
• Version control
• Tortoise SVN
• Virtualization
• VMWare Workstation, and Virtual Box
• Date Modeling
• CA Erwin

PROFESSIONAL EXPERIENCE

Confidential, DUBLIN, OHIO

Oracle DBA

Responsibilities:

• Member of DBA team supporting database infrastructure containing 500+ databases by regular administrative
• Activities from database creation to retirement.
• Worked on Fusion applications and oracle Spatial wif SaaS Pot environments.
• Prepare UNIX shell scripts for testing teh application.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Mining, Data Auditing, Data Integration and Metadata Management Services.
• Worked autonomously wifin a team of Data Analysts, to analyze, review, update, edit, clean, translate, and ensure accuracy of customer data.
• Migrated 30 SQLServer 2000 and 2005 Databases to Oracle 10g -- All stored proc's,Unix shellscripts and jdbc programs.
• Creating and managing different kinds of tablespaces, monitoring and fixing tablespace space issues on regular basis.
• Creating and managing database objects, users, roles, privileges, profiles.
• Worked onNumerous Adhoc Data Pull requests from Business Analyst, DATA Analyst,BSA and Financial Analyst.
• Migrated Oracle to Cassandra for a predictability around cost growth of their database environment as well as better scalability.
• Created UNIX ShellScripts wif VMware vSphere PowerCLI 6.3
• Worked for Confidential as a Geospatial Engineer/Analyst.
• Worked for Confidential as a Geospatial Application Developer.
• Design teh schema (XSD) for Spatial Web Service wif ArcGIS Server, ArcObjects/SOE, ArcSDE, WCF, XMLSpy and C#, .net.
• Scheduling different kind of jobs, monitoring and fixing of broken jobs on regular basis.
• Installed and configured Hadoop Map Reduce, HDFS, Developed multiple Map Reduce jobs in Java for data cleaning and preprocessing.
• Wrote complex UNIX shell script& VBScript “Server Compliance Program” (10,000+ Lines)
• Performing database refresh using RMAN, Export/Import, and Data pump utilities.
• Experience in installing, configuring and using Hadoop Ecosystem components.
• Migrating large databases to Linux servers wif minimal downtime.
• Upgrading from Oracle 9i/10gto Oracle 11g.
• Exadata X4, X5, Exalogic X4, Exalytics, Glodengate and EBS Migration and Upgrade Expert -- R12.2 -- Oracle Certified Exadata.
• Oracle migration to Cassandra in order to resolve customer shopping cart experience issues related to performance and scalability issues. Teh decision to move to Cassandra was an easy one.
• Design and developed user interface components usingADF Rich Faces.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Upgrading and configuring GlodenGate on Cluster Environment.
• Participated in development/implementation of Cloudera Hadoop environment
• Replication and Extracting data and applying on production using GlodenGate.
• Responsible for developedADF Data Controlsfrom Web Services and Java Components.
• Creating logical and physical database design as per application requirement wif E/R models and normalization using CA Erwin Data Modeler.
• Design, Implement and Test Oracle ADF applications using JDeveloper 11g
• Authoring change management scripts to production databases.
• Implementing partitions to teh tables, also implemented daily/weekly/monthly purge process for dropping/adding partitions.
• Design and developed SPSS wizard components using ADF task flows (BTF and UBTF), train stops, regions, templates and fragments.
• Capacity planning for teh current and future storage requirements based on database volumetrics.
• Developing queries for complex business requirements using SQL.
• Configuring databases and listeners through Oracle Enterprise Manager (OEM).

Confidential, Parsippany, NJ

Oracle DBA

Responsibilities:

• Working on 24x7 production support.
• Monitoring Database Alerts and making report of some Critical Database's Daily Growth size and Tables growth size and Top SQL events and Database Cluster's Node Activity.
• Managing RMAN Backups.
• Develop spatial views for dynamic data updates, query, and delete traffic events on CHART (coordinated highway administration advisory and traffic) application.
• Updated mapping tables related to assigned functional areas as directed by teh Data Analysts.
• UNIX Shell Scripting& VBScripts was delivered and remotely executed to multiple server via “BladeLogic”, or from any server running teh script.
• Develop WebTasks wif ArcGIS Server 9.3 C# .NET for Spatial-Bookmarks, Quick-Find wif SQL Server for Anadarko Petroleum.
• Analyze spatial data for failed mobile calls wifin spatial grids wif Alteryx ETL tool, FME Safe and present wif MapInfo/ ArcMap.
• Design and developed multiple fragments using ADF Rich Faces, Facets, JSF and HTML.
• Imported a large csv file into a Cassandra table using teh COPY command provided in CQL.3.2
• Oracle binaries installation, patching and upgrade.
• Developed ADF Model components (creation, configuration, and tuning of entity objects, view objects, application modules, bindings and data controls).
• Responsible for building, debugging and tuning SPSS application using ADF 11g.
• Installed/Configured/Maintained Apache Hadoop clusters for application development and Hadoop tools, including: Hive, Pig, HBase, Zookeeper and Sqoop.
• Managing production deployments.
• Created UNIX Shell scriptingand VBScripts to detect to assist wif this project.
• Monitoring Growth of Table-spaces and undertaking necessary re-organization of database.
• Proficient in designing and maintaining databases.
• • Analysis of Web logs using Hadoop tools for operational and security related activities.
• Designed and managed a High Availability database infrastructure providing scalability and reliability wif multi-site replication architecture and DR strategy to comply wif firm-wide critical application.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Install and configure Apache, MySQL5, and PHP on multiple servers, create custom classes, assist in optimizing performance of teh databases and SQL queries.
• Experienced in managing and reviewingHadooplog files.
• Used GlodenGate for GUI-based centralized management.
• Create and manage Oracle users wif appropriate grants and privileges.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Creating Knowledge Base Documents for Oracle Database.
• Installation and Configuration and Managing 2 nodes RAC database.
• Cloning production database on development servers.
• Set up and maintain teh listener.ora, tnsnames.ora and ORATAB file as per Security requirements.
• Designed application framework and developed Oracle APEX Application.
• Full Database, Tables and Schemas refresh using logical backups.
• Handling Request for Schema change, modifying TNSNAMES.ORA & Parameter files,
• Database backup, Database Startup, Database Shutdown and Bounce.
• Create Accounts and Table-spaces.
• Monitoring of Cluster's node of RAC database.

Environment: Oracle 10g and 11gR1/R2, OEM, RMAN, RAC, Data Guard, ASM, Explain plan, ASH,AWR, SQL* Plus, PL/SQL, SQL* Loader,Cassandra, AIX 6.1, Red Hat Linux 5.0 and Windows MSCS 2003, TOAD 10.0,GlodenGate12c,Hadoop, Oracle Application Express (APEX)UNIX, LINUX,Oracle RAC. MySQL

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g.
• Construction of Catalog databases and developed scripts to perform Backups of Large Databases to fit teh backup window using RMAN.
• Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.
• Developed Chebotko diagrams by combining teh conceptual and query workflow of teh application for translating existing domain model into a running Cassandra schema.
• Actively participated in gathering teh requirements and planning teh capacity for multi data center Cassandra cluster.
• Used ASH, AWR, ADDM and stats pack Reports for troubleshooting performance issues and Capacity Planning. Extensively used Explain Plan, Tkprof and SQL Trace.
• Setup procedure for Database statistics gathering - Frequency, Best Time of teh day to execute stats gathering jobs, correct level of gathering statistics.
• Extensive Experience wif RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Data pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using "runInstaller" and perl based utility "opatch".
• Performance tuning of teh database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROFEXPLAIN PLAN, ASH,AWR, ADDM and Tuning of SGA, distribution of disk I/O.
• Experienced in configuration of ASM for RAC and NON- RAC environments.
• Configured Repository and clients for GRID Control and also implemented DB Control for some databases.
• Utilized Oracle streams to Capture, Propagate and apply teh transfer of data, transactions and events wifin managed Databases.
• Database reorganizations and refresh schema-using Export/Import. Creating teh database, table spaces, tables, indexes, setting privileges and user logins
• Used hints for SQL tuning and optimization
• Performed Explain Plan analysis for Query Optimization and SQL tuning.

Environment: Windows, RHEL, Oracle 11g, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, Red Hat Linux 5.0, STATSPACK, SQL Developer, TOAD, SQL*Plus.Oracle RAC.

Confidential, Richmond, VA

Oracle DBA

Responsibilities:

• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained teh data integrity and security using integrity constraints and database triggers.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling teh Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring teh scheduled jobs.
• Install and configure block change tracking to work wif RMAN Merged incremental backups.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning teh users to groups and grant necessary privileges to teh relevant groups.
• Constantly monitor teh performance (V$ dynamic performance views at peak load) of teh Databases and viewing Alert log files & Trace files.
• Used to run teh scripts to check teh status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of teh databases.
• Provided 24X7 supports for all teh production and development databases.

Environment: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Red Hat Linux 5.0,Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN,Powershell, PYTHON.

Confidential

Oracle DBA

Responsibilities:

• Oracle 10g Installation on UNIX OS and Windows.
• Oracle 10g database cloning, patching.
• Database creation as per project requirements
• Space management database using OEM.
• User Management & Security Management
• Taking Physical and logical backups of teh databases.
• Maintaining Prod, Test.
• Transferring data using Export-import, Datapump.
• Daily Logical Backup and restore for UAT database.
• Used Tools - Oracle Enterprise Manager (OEM), Toad.
• Monitoring teh system resources using vmstat, iostat, top etc.
• Renamed teh Database.
• Creation of database objects & of table, indexes
• Changed init.ora parameter.
• Gathering statistics using Statspack.
• Check alert log & backup log file for possible oracle errors
• Managing stand by database, MIS database & Test database.
• Co-ordination wif users & responsible for quick solutions to their problems.
• Reorganization of Table spaces to reduce teh number of data files wifin teh tablespace.