PROFESSIONAL SUMMARY:

• Total of over 10+ years of IT experience in design, implementation, enhancement and maintenance of software applications.
• 4 years as NoSQL Cassandra admin in implementing, deploying, maintaining and administration of new platforms of Cassandra Database including systems architect, implementation and tuning mission critical enterprise applications.
• 10 years as Oracle DBA, Worked extensively on Oracle 12c, 11g, 10g, and 9i versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance
• Expertise in installation, setup and configuration of Oracle 12c, 11g, 10g, & 9i on SUN SOLARIS, HP - UX, IBM-AIX, LINUX.
• Strong background knowledge in installing, configuring and maintaining Oracle 12c, 11gR2 RAC (Real Applications Clusters) with ASM.
• Expertise in Oracle Enterprise Manager (OEM) and setup of Oracle Grid Control
• Implemented RMAN backups (Full, Incremental and Cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard
• Implemented and delivered core edge technologies of Oracle 10g (EM Grid Control, and RAC)
• Installed Oracle 12c, 11g & 10g RAC software with ASM & OCFS2 file systems on RHEL, AIX, HP-UX.
• Have implemented two type of standby databases supported by DATA GUARD, logical standby and physical standby databases in 11gR2 on two node RAC
• Worked on large-scale databases with size more than 13 TB in large system environments
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS NetBackup
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise
• Good experience in applying security patches and migration of Oracle server from 11g to 12c, 10g to 11g, 9i to 10g & 8i to 9i
• Worked as a team member to provide 24x7 on-call production database support
• Logical and physical modeling using Erwin
• Data loading using SQL*Loader, Logical backups using full export and DATAPUMP
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Expertise in maintaining and reinforcing standards for change management, database security plan and auditing
• Proficient in raising SR with Oracle Support to resolve the bottlenecks in the database environments.
• Worked on different types of storage structures (SAN/NAS)
• Management of Schemas, Objects & Partitioning the tables & indexes.
• Over 5 years of experience working with Oracle GoldenGate for performing database upgrades and Replications.
• Expertise on the Oracle GoldenGate installation, configuration, troubleshooting GG issues.
• Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities)
• Expertise in using Python version 2 and 3 to automate.
• Excellent knowledge of Oracle Architecture, SGA, Configuration of TCP/IP protocol, Listeners, TNSnames, SQLNET, V$ and DBA views
• Experience in Load and Performance testing of the database servers and application servers, analysis and documentation of results
• Database replication using snapshots, materialized views and advanced Replication methods.
• Excellent communication and interpersonal skills
• Design, install, monitor, maintain and performance tune databases while ensuring high levels of database availability.
• Developed tooling to automate repeated tasks and assist with the release process.
• Monitoring database performance in production and work with development teams to optimize performance and troubleshooting problems.
• Database modeling and schema design.
• Spread data across the cluster evenly.
• Minimize the rate of partition reads.
• Cassandra installations and troubleshooting performance related issues.
• Automation of Cassandra cluster builds using GitHub version control and Jenkins Integration.
• Supported Cassandra Clusters range up to 80 nodes across multiple Data Centers.
• Expand/Shrink Cassandra cluster by adding, removing and replacing nodes.
• Configure backup, alerts, repairs and monitoring of Cassandra clusters and automated them with custom scripts.
• Closely worked with DataStax support for troubleshooting performance issues.
• Knowledge on CQL (Cassandra Query Language) for obtaining the data present in Cassandra clusters.
• Designing data models along with managing and scheduling of data backup and restore operations of Cassandra applications.
• Experience in installing multi-data center and multi-rack Cassandra cluster.
• Supported Java applications connected with Java Driver and experience in debugging issues with Java stacktrace.
• Troubleshoot of read/write latency and timeout issues using nodetool, cfstats, tpstats, cfhistogram and repair.
• Theory knowledge on AWS.

TECHNICAL SKILLS:

OPERATING SYSTEMS: RHEL, HP, Sun Solaris, AIX, IBM

RDBMS: Oracle (12c, 11g, 10g, 9i)

NOSQL: Apache Cassandra 2.2.9

LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash and Python

SOFTWARE/ APPLICATIONS/ TOOLS: Golden Gate, DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, ERwin, TOAD, Data Pump (expdp, impdp), Shareplex, Autosys, Query Analyzer, VERITAS NetBackup, SQL*Plus, SQL*Loader, PyCharm.

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Sr. Database Administrator

Environment: RHEL 7.5, Cassandra 2.2.9, Oracle 12c, 11.2.0.4 RAC, Dataguard, GoldenGate, Veridata, Oracle Enterprise Manager (OEM), RMAN, ASM, ACFS, Datapump, bash scripting, Cqlsh, PL/SQL.

Responsibilities:

• Installed 12c RAC on 3 Node and 2 Node and created multitenant databases.
• Created automated bash script for DataGuard and configured for multiple databases.
• Successful in creating TLS/SSL encryption between Oracle Databases (RAC & SA) and Application client servers.
• Configured Oracle TDE on tablespaces on both RAC and SA databases for encrypting Data Confidential Rest.
• Installed and configured GoldenGate 12.3 classic architecture replicating data between DBs which are across multiple Data Centers.
• Successfully added GoldenGate 12.3 to cluster as a resource using latest XAG v9.
• Created new OEM database and installed OMS 13c for both Non-Prod and Prod environments.
• Installed GoldenGate plugin (JAGENT) for monitoring GG processes from OEM.
• Installed OEM agent silently on multiple database servers by creating bash script.
• Created monitoring templates and notification alerts in OEM for Oracle Databases, GoldenGate and etc.
• Configured and scheduled compressed backup jobs from OEM.
• Applied quarterly PSU patching on DBs to meet the compliance.
• Installed and configured Apache Cassandra 2.2.9 cluster between multi-datacenter using network topology strategy.
• Configured SSL/TLS encryption between cluster nodes and between Cassandra cluster and Client servers.
• Involved in configuring Encryption for Data Confidential Rest using IBM Vormetric Transparent Encryption.
• Automated backup jobs using python and scheduling full and incremental jobs.
• Successfully created and tested in restoring cluster data using automated script.
• Configured and scheduled automated Anti-Entropy Repairs by using Python to deal with tombstones.
• Created, Configured and scheduled maintenance scripts to parse log files for alerts, storage and performance.
• Performed DDL and DML statements within Cassandra using CQL.
• Troubleshooting performance issues.
• Capture CQL output to a file, Import and export data with CQL.
• Execute CQL scripts from within CQL and from the command prompt.
• Adding and removing nodes from Cassandra Cluster.
• Monitoring Cassandra Cluster.
• 24x7 Production support and on-call.

Confidential, St. Louis, MO

Database Admin - Cassandra / Oracle / GoldenGate

Environment: RHEL 6.4, Cassandra 2.1, Cqlsh, Oracle 12c, 11gR2, 10g, RAC, Golden Gate, Oracle Enterprise Manager (OEM), RMAN, Import/Export, ASM, Datapump, Unix Scripting, SQL*Plus, PL/SQL, Oracle Developer, TOAD.

Responsibilities:

• Successfully configured complex bi-directional replication with Oracle GoldenGate between Confidential &T and DirecTV databases during DirecTV merge.
• Installed and Configured Oracle 12c and migrated 71TB of physical DB from 11.2.0.4 to 12c pluggable database on a 3RAC node Confidential 6 data centers with zero downtime using Oracle GoldenGate.
• Installed Oracle GoldenGate on RAC clusters, skillfully configuring multi-directional replication across four production data centers with conflict resolution methodology in managing user authentication and authorization privileges, thus preserving data integrity and availability.
• Created and configured Oracle GoldenGate failover script in RAC and added as action script in the GG cluster resource.
• Added alias process for pumps for auto stop and start during GoldenGate failover.
• Created and configured shell script to drop partitions and automated for nightly maintenance.
• Refreshed application schemas from Production to Non-Production environments using DataPump and Export/Import.
• Successfully applied latest PSU patch updates from MOS to Oracle Clusterware and RDBMS.
• Installed 12c pluggable standalone databases on total of 62 servers and configured GoldenGate replication across them as part of cloud migration.
• Configure and Involved in failover testing with Global Dispatched and Apache Tomcat teams for Oracle cloud production servers.
• Implemented and Configured Physical Data Guard in Maximum performance mode for production system in case of disaster recovery.
• Configured Data Guard Broker and tested DR failover and failback.
• Plugging and Unplugging into XML files.
• Created Container database and pluggable databases.
• Cloned from one pluggable database to another.
• Upgraded Oracle GoldenGate from 12.1.2.0.0 to 12.1.2.1.2.
• Created and scheduled PL/SQL scripts for maintenance based on the project requirement.
• Averted project red jeopardy through immediate self-professional development by installing, configuring and implementing IBM Sterling ConnectDirect application for secured data distribution per client’s requirements for the project implementation.
• Work within Product Development teams to design and deliver scalable, robust data-driven applications and work to up-level the capabilities of the team generally in the area of data technologies.
• 24x7 Production, Ops, Dev & QA DBA support delivery for different lines of business.
• Cassandra installations, troubleshooting performance issues.
• Support Cassandra Clusters range up to 80 nodes across multiple Data Centers.
• Expand/Shrink C* cluster by adding, removing and replacing nodes.
• Configure backup, alerts, repairs and monitoring of Cassandra clusters, in conjunction with custom scripts.
• Responsible for designing a scalable, high throughput, real time, highly concurrent, distributed, machine learning based decision platform for fraud detection with Cassandra as the backend Data Store.
• Designed and evolved the data schema to support multiple lines of businesses.
• Designed a health monitoring dashboard for various components of the cluster.
• Responsible for forecasting and scaling infrastructure to meet the traffic demands from all the supported LOBs.
• Test-driven development, ensuring the entire test suite succeeds and target maximum code coverage.
• Perform Data Definition Language (DDL) Statements within Cassandra.
• Perform Data Manipulation Language (DML) Statements within Cassandra.
• Create and modify Users and User permission within Cassandra.
• Capture CQL output to a file, Import and export data with CQL.
• Execute CQL scripts from within CQL and from the command prompt.

Confidential

Sr. Oracle DBA

Environment: RHEL 6.4, Sun Solaris 5.10 x86, Sun Sparc 10, Oracle 11gR2, 10g, Oracle RAC (11.2.0.4), Oracle Enterprise Manager (OEM), RMAN, Import/Export, ASM, Datapump, Unix Scripting, SQL*Plus, Oracle Developer, TOAD, EMC DataDomain.

Responsibilities:

• Installed and Maintained 11.2.0.4, 11.2.0.2 and 10.2.0.4 2 Node RAC on RHEL 6.4, Sun Solaris 5.10 x86 and Sun Sparc.
• Migrated and supported total 74 databases of a Customer’s Oracle Databases to CTL with RMAN Restore, RMAN Duplicate, Export/Import and Datapump.
• Migrated 13 TB Data Warehouse database using RMAN to 11.2.0.4 RAC.
• Implemented Disaster Recovery for the productions databases from 2 Node RAC on primary to Standalone database server on standby using RMAN Active Duplicate and involved in DR testing.
• Modified and updated Public IP, VIP and SCAN IP on oracle 11gR2 RAC.
• Performed Cloning from production database backups to Dev and Test environments using RMAN and DBNEWID Utility.
• Refreshed 10g and 11g databases with RMAN Duplicate from ASM to ASM RAC and Filesystem to ASM RAC.
• Refreshed Application schemas from Production to Test using DataPump and Exp/Import.
• Installed and Configured Active/Passive clusterware for 2.9TB database on 11.2.0.4.
• Converted Standalone database to RAC using RCONFIG utility.
• Applied latest PSU patch updates from MOS to Oracle Clusterware and RDBMS on 11.2.0.4.
• Upgraded 2 Node RAC cluster from 11.2.0.2 database to 11.2.0.4
• Migrated Dataware housing database from one DC to another DC using Data Guard.
• Configured RMAN cumulative backups and Recovery with EMC DataDomain storage.
• Configured SSL/TCPS on Oracle RAC and created Server and Client Oracle wallets.
• Renamed database with DBNEWID Utility.
• Installation and configuration of Oracle Client on Application servers.
• Created and troubleshoot of DB Link issues in Oracle for communicating with external databases.
• Performed a Rolling forward on Standby database using RMAN Incremental Backup for un-resolveable large archive gap.
• Experience with identifying and solving database issues related to performance tuning and query optimization using Performance Monitor, SQL Profiler and SQL tuning.
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes.
• Analysis and management of Oracle problems/defects using SRs and/or MOS with Oracle Corporation and installation of patches.
• Scheduled maintenance jobs by creating/developing Unix shell scripts and Oracle scheduler jobs.
• Administering, maintaining, developing and implementing policies and procedures for ensuring the accessibility, integrity and security of all databases by following policies and procedures and documentation of every step.
• Managed crontab file, rescheduling the failed jobs( due to errors), changing timings for the scripts to run if the job fails and adding new jobs (scripts).
• Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control.
• Responsible for Change Management, Incident Management, Problem Management, Security Management, Backup Management etc.
• Developed Unix shell scripts and SQL scripts to carry out routine checks on databases. This includes checking database status, listener is running, database locks, alert log error messages, Unix error messages, disk space availability, segments nearing max extents, checking for errors in alert logs and trace files, etc.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Materialized Views and Indexes on the tables.

Confidential, Columbus, OH

Sr. Oracle DBA

Environment: IBM-AIX 5.1 & 6.1, Sun Solaris, Oracle 11gR2, 11gR1, 10g, and 9i, Oracle RAC (11.2.0.2, 11.2.0.3), Golden Gate, Oracle Enterprise Manager (OEM), RMAN, Import/Export, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL

Responsibilities:

• Installation and Maintenance of Oracle 9i, 10g, 11gR2 RAC on IBM-AIX, LINUX, HP-UX, Solaris.
• Implemented the Oracle 11gR2, Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
• Upgraded 2 Node RAC from 11.2.0.2 to 11.2.0.3 including standby database.
• Responsible for supporting and administrating both Data warehousing and OLTP databases of size 10TB on RAC.
• Involved in the process of tuning and refining queries of various applications.
• Upgradation of databases applying patches, patch sets, critical patch updates and PSUs. Configured and implemented Oracle 11g ACTIVE DATAGAURD for Database Disaster Recovery by using DATA GAURD broker (DGMDRL).
• Configured Physical Standby databases and logical Standby database for ACTIVE DATA GAURD.
• Performed oracle database refreshes using expdp/impdp from production to test database.
• Configuration and implementation of Golden Gate based replications through GGSCI.
• Managing the existing the GoldenGate replication process and setting up new GoldenGate replications for ETL process.
• Worked with very large scale Database environment and mission critical OLTP and OLAP systems ranging from 1TB to 4TB.
• Bi-directional replication and Uni-directional replication in Golden gate.
• Upgraded database from 10.2.0.4 to 11.2.0.3 using Golden Gate.
• Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
• Involved in monitoring the database related activities using Oracle Enterpriser Manager 11g Grid Control and monitoring the backup jobs scheduled in Oracle Enterpriser Manager (OEM).
• Migrated database as part of the Tech refresh from 11gR2 Standalone to 11.2.0.3 RAC using DataPump.
• 24x7 remote support and on call support for Production databases.
• Performed cloning of database using RMAN tool.
• Performance tuning of database by using the reports AWR, ADDM, ASH, TKPROF, STATSPACK, SQL TRACE, EXPLAIN PLAN.
• Performed policies on data confidentiality, integrity, availability, and audit ability, Based on Access Controls for Access to Data Confidential the database level.
• Implemented oracle Resource manager to minimize the excessive CPU load.
• Worked on creation of users, granting roles and privileges to users, tablespace management.
• Planning the backups Hot & COLD backup, Incremental Level 0 and Level 1 Back and scheduling.
• Automating the daily routine activities backups using the DBMS JOBS, DBMS SCHEDULER.
• Scheduled maintenance jobs by creating/developing Unix shell scripts and Oracle scheduler jobs. Ex: Data-pump export, listener log maintenance, Stats Gathering etc.
• Taken backups using RMAN, logical (import/export, impdp/expdp), hot and cold backup.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Implemented Security user management, privileges, roles, profiling, auditing, authentications etc
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Materialized Views and Indexes on the tables.

Confidential

Oracle DBA

Environment: HP-UX Itanium, Oracle 11g, Oracle Enterprise Manager (OEM), RMAN, Import/Export, Data Guard, ASM, AWR, TOAD, ERWIN, Toad Data modeler, SQL Developer Data Modeler Unix Scripting, SQL*Plus, HP Data Protector, Tidal Scheduling, Time Finder Cloning, HP Operations Manager

Responsibilities:

• Supported Oracle 11gR2 RAC databases on HP-UX Itanium and Linux 5 and 6 servers.
• Responsible for supporting and administrating both Data warehousing and OLTP databases of size 12TB on RAC.
• Installed and upgraded from 11.1 to 11.2.0.3 RAC database with the latest Oct PSU on Linux 6.4 for symantic security application.
• Scheduled maintenance jobs by creating/developing Unix shell scripts and Oracle scheduler jobs. Ex: Data-pump export, listener log maintenance, Stats Gathering etc.
• Cloned 11grR2 RAC Production databases (size of 10TB) for UAT environments using Transportable Tablespaces.
• Cloned Productions databases for Test environments using EMC TimeFinder clone.
• Re-engineered production schema from ERWIN to both Toad and SQL developer data modelers.
• Configured RMAN Hot and Cold backups with HP Data Protector media management.
• Proactive database monitoring by using OEM grid control.
• Implemented Security user management, privileges, roles, profiling, auditing, authentications etc.
• Refreshed schemas from production to lower environments with re-mapping tablespaces for partitioned objects.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• Worked on both ASM and cooked filesystems for managing data in SAN.
• Documented the issues/resolutions/process details with maintaining them up to date.
• Created and troubleshoot DB Links’ issues in Oracle for communicating with external databases.
• Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
• Managed crontab file, rescheduling the failed jobs( due to errors), changing timings for the scripts to run if the job fails and adding new jobs (scripts).
• Involved in capacity planning and resource planning.
• Generated weekly performance reports to identify and solve the problems with performance.
• Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
• Performance tuning of database (overall Performance gain) which includes optimization of UNIX Kernel, Oracle INIT.ORA, Oracle SGA, I/O balancing and memory.
• Used Oracle Streams for data migration and data distribution.
• Involved in team management, team building exercises for the DBA team.

Confidential, Columbus, OH

Oracle DBA

Environment: IBM-AIX, Sun Solaris, Oracle 11g, 10g, and 9i, Oracle RAC (11g), Oracle Enterprise Manager (OEM), RMAN, Import/Export, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL

Responsibilities:

• Responsible for administration and supporting Oracle 11g, 10g RAC databases in DEV, QA, UAT and Prod environments
• Maintained and supported 10g and 11g RAC in AIX environment and 11g ASM.
• Responsible for supporting and administrating both Data warehousing and OLTP databases of size 10TB on RAC.
• Scheduling and maintaining RMAN (Recovery Manager) backups to the FRA
• Downsizing and defragmenting the Large Databases by export/import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g.
• Configuration and implementation of Golden Gate based replications through GGSCI.
• Managing the existing the GoldenGate replication process and setting up new GoldenGate replications for ETL process.
• Replicated databases using Oracle Golden Gate for reporting purposes in OLTP environment with minimum lag.
• Uni-directional replication in Golden gate.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection
• Proactive database monitoring using 11g grid monitoring tool.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas
• Applied PSU patches to Oracle Databases and Oracle Applications.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM
• Worked on Automatic Storage Management (ASM) for managing data in SAN
• Monitoring and resolving tickets in different environments
• Export and Import of database objects to copy from one database to another database between different environments
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities)
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
• Created UNIX shell scripts to automate batch jobs through Cron
• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc

Confidential, Packard, Cincinnati, OH

Oracle DBA

Environment: HP-UX, Windows 2000/2003, and Linux, Oracle 9i, 10g, and 11g, Oracle RAC (11g, 10g), Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, Autosys, Clearcase, SQL*Plus, PL/SQL, Post Gre SQL, SQL*Loader

Responsibilities:

• Supported Oracle 11g, 10g and 9i databases
• Installed and created 11g databases
• Performed upgrades from Oracle 10g (10.2.0.3) to 11g (11.1.0.1) on Intel and HP boxes
• Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) running Oracle 10g over to HP Itanium boxes running Oracle 11g
• Installed Oracle 10g RAC software with ASM & OCFS2 file systems
• Configuration, maintenance and tuning of 10g RAC
• Setup of Disaster Recovery databases (Data Guard)
• Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Installing and Configuring Recovery Manager (RMAN)
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
• Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints
• Experienced in migrating databases to higher releases including incremental migrations
• Migrated database from 9i to 10g and 11g supporting various incremental releases
• Performed Conversion of data from Post Gre SQL to Oracle
• Query optimization for reporting and ETL
• Created & Managed Jobs using AutoSys Job Scheduler
• Extensive UNIX Shell scripting in csh, Pro*C
• Planned version control of production source code using Clearcase
• Writing SQL scripts, stored procedures, functions and transactions analysis for performance tuning
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
• Created database maintenance plans, including updating statistics, re-indexing, structure modifications, Capacity plans, and index analysis
• Storage Management Managing Space, Table Spaces, Segments and Extents, Rollback Segments & Data Dictionary
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle Corporation and installation of patches
• Used Oracle Internet Directory to leverage the scalability, high availability and security features of the Oracle Database
• Taking Hot and Cold Backups, Exports etc
• Data Modeling, Database Design and Creation using ERwin
• Created Triggers for multi-master replication

Confidential, Springfield, MA

Oracle DBA

Environment: HP-UX, AIX, and Linux, Oracle 10g and 9i, Oracle RAC, Oracle Streams, TOAD, Enterprise Manager, EXPLAIN PLAN, TKPROF, SQL Trace, Query Analyzer, Oracle Fail Safe

Responsibilities:

• Provided Primary architectural and administrative support for new projects
• Installed Oracle 9i and 10g RAC database on HP-UX 11.0, Redhat 4
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage
• Performance Tuning i.e., Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Configured, administered and monitored Streams environment using various tools like OEM Console
• Performed Network Traffic Tests for Streams
• Oracle Grid Control Management Server Installation
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps
• Have created database on SQL Server 2005, backup and recovery
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same
• Generated Reports using crystal reports
• Devised & Implemented backup strategies using hot, cold and exports based on the business requirements
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer
• Trouble shooting of various database performances by proper diagnosis Confidential all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, operating system and java calls
• Developed UNIX shell scripts to perform the above tasks efficiently
• Worked as a member of production DBA team in perfect coordination with seniors and team members.