SUMMARY

• 17+ years of IT experience in analysis and design, 5+ years as an oracle instructor. Taught oracle 8i and 9i & 10g certification programs.
• 15+ year’s experience as an Oracle DBA using Oracle 6.x, 7.x, 8i.x,9i.x, 10g.x and 11g.x and 12c.x
• Over 3 years of experience in Apache Hadoop, Big Data administration and big data systems deployment
• NoSQL database expertise (MongoDB, Oracle NoSQL, Cassandra, HBASE)
• Experience in installing and managing Cloudera Hadoop clusters and Hadoop file system (HDFS)
• Experience in Big Data Hadoop echo system including Map Reduce, Map reduce 2, YARN, flume, Sqoop, Hive, Apache Spark, Scala
• Extensive experience writing scripts in SQL, PL/SQL packages, procedures, functions and triggers in multiple Oracle environments.
• Extensive experience scripting in SED, AWK, GREP and KORN shell
• Oracle Database installation, migration, upgrade, patching, administration and performance tuning proficiency in Linux, Solaris, HP, AIX and windows
• Some experience with Perl, PHP and Java programming languages
• Excellent written and verbal communications skills plus strong analytical, problem solving and troubleshooting skills
• Good understanding of oracle big data(Oracle NoSQL, Big data appliance)
• Full life - cycle software development expertise in OLTP and data warehouse environments with 24*7 support
• Solid experience managing Multiple Databases and projects, in multi-terabytes environments, overseeing and managing multiple personnel
• Good experience using Gloden Gate products for bi-directional, one-way, disaster recovery and zero-downtime migration replication.
• Extensive knowledge of Real Application Cluster configuration, installation, administration and performance tuning in multiple OS environment
• Exadata x2-2, x3-3,x4-2, x4-5 Database Machine installation, administration and performance tuning experience

TECHNICAL SKILLS

Operating Systems: HP-UX, SUN SOLARIS, AIX, RHEL, Windows 95/98/ME/NT/2000/XP/Vista/7/8/10

RDBMS: Oracle 7x,8i,9i,10g,11g,12c MS SQL server 7.0/2000, DB2, MySQL

Languages: SQL, PL/SQL, C, C++, Java, Unix shell scripting, PERL, COBOL, assembly language, HTML, XML, PHP

Tools: &Utilities: TOAD, Crystal Report Generator, OEM grid control, GlodenGate, Real Application Testing (RAT), Eclipse, VirtualBox, VNC, SQL developer

Network& Storage: EMC timefinder, Veritas NetBackup, Veritas volume manager, Veritas cluster server IBM TSM, HP data protector, HP service guard, IBM HACMP, SAN, ASM, Oracle ZFS storage appliance, RAID technology

Certifications: Oracle 7, 8i 9i, 10g, 11g, Exadata 11g Admin certified implementation specialist. Oracle 11g GlodenGate certified implementation specialist

Webservers: WebLogic, Tomcat, IIS WebSphere, WebMethods

NoSql DB: MongoDB, Cassandra, Oracle NoSQL database, HBASE

Engineered systems: Exadata v2, x2-3,x3-3,x2-8,x3-8,x4-2,x5-2,ZFS storage appliance, Big data appliance, Database appliance, Exalogic, Exalytics

Big Data: Hadoop Administration, Cloudera, Flume, Squoop, Apache Spark, Apache Scala, Solr, Mapreduce, Hive, Pig Latin, Mahout, Impala

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Big data consultant

Responsibilities:

• Extensive experience in designing MongoDB multi-sharded cluster and monitoring with MMS
• Responsible for MongoDB (versions 2.x, 3.0.0 and 3.0.5) installation, configuration and administration.
• Full life cycle experience in highly secure, extremely large-scale deployments of very high volumes of critical data with extensive security.
• Responsible for building scalable distributed data solutions using Hadoopand installed and configured Hive, Pig, Sqoop, Flume and Oozie on the Hadoop cluster.
• Responsible for cluster maintenance, adding and removing cluster nodes, cluster monitoring and troubleshooting, manage and review data backups, manage and review Hadoop log files
• In charge of Continuous monitoring and managing of Hadoop cluster using Cloudera Manager
• Involved in loading data from Unix/Linux file systems to HDFS and developed Simple to complex Map/reduce Jobs using Hive and Pig
• Execute technical assignments to foster new program designs for BDPA businesses
• Implement innovative software systems to solve key business challenges
• Acquire technical knowledge of technologies and proofs of concept
• Ability to execute tasks technically and report results
• Design and develop scalable software architectures; Manipulate massive-scale datasets;
• Setup Architecture for big data capture, representation, information extraction and fusion.
• Relational, hierarchical and graph databases, distributed data file systems, data federation and query optimization
• Setup and manage Oracle Tools Suits (Application Express) for collaboration solutions.
• Worked on pulling data from oracle Exadata to Oracle big data appliance for data processing and analytics

Environment: HBase, Oracle, R, impala, Linux, Oracle Nosql, Oracle big data appliance, Flume, Cloudera manager, MongoDB, Cassandra, Apache spark/Scala, Hadoop, Exadata

Confidential, Atlanta, GA

Lead Oracle Exadata, GG Architect/MongoDB Admin/Big data consultant

Responsibilities:

• Deployed and managed Oracle big data appliance in a test environment, using Cloudera enterprise Hadoop distribution
• Installed and managed Cloudera Hadoop clusters and Hadoop file system (HDFS)
• Worked on Big Data Hadoop echo systems including Map Reduce, Map reduce2, YARN, flume, Sqoop, Hive, Apache Scala and Spark
• Developed, deployed and managed several MongoDB clusters whilst implementing robustness and scalability via Sharding and replication, including automating tasks with own scripts and open-source tools for performance tuning and system monitoring
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design
• Worked on other NoSQL databases such as Cassandra and Oracle NoSQL, Hbase
• Successfully installed, validated and deployed Exadata (x2-2, x3-2, x4-2 and x5-2), eighth, quarter, half and full rack for various clients
• Configured and activated Exadata ASR and associated assets for hardware fault monitoring, and alerting. Configured oracle 12c OEM for comprehensive Exadata administration, performance tuning and monitoring
• Successfully migrated several clients (Siebel, SAP, proprietary) from both single and RAC instance onto Exadata machines using several migration methodologies to meet client’s need
• Successfully maximized database performance on Exadata using smart scan technologies such as storage index, Hybrid columnar compression and predicate and column filtering
• Designed and implemented database backup and recovery strategy on several multi-terabyte Exadata systems over ZFS storage appliance subsystems for various customers
• Solid experience with Installation, configuration and administration of Glodengate for bi-directional, Unidirectional and zero-downtime migration replication on single instances, RAC and Exadata machines
• Designed and implemented extracts and replicats for loading, refreshing, and keeping oracle databases in sync, near real-time via incremental transaction and DDL replication using Glodengateversions 10g, 11g and 12c
• Designed and implemented active-active/active-passive Glodengate processes that encompass transaction filtering, conflict detection & resolution, performance tuning and troubleshooting
• Successfully configured, installed and managed several multi-terabyte databases from oracle 8i through 12c in both single instance and RAC cluster environments
• Successfully upgraded and migrated several customers to 11g and 12c using a variety of migration and upgrade tools and methodology (DMA, DMU, scripts, manual)
• Implemented solid and TEMPeffective DR strategies for multiple clients using Dataguard and implemented TEMPeffective backup and recovery strategies using RMAN
• Resolved several performance tuning issues and successfully used troubleshooting and problem solving skills to improve database performance in single instance, RAC and Exadata environments

Environment: Oracle Linux, Oracle RAC, 11gr2, 12c, x2-2,x3-2,x4-2 and x5-2 Exadata database Machine, Oracle Big data appliance,, Oracle gloden gate (11g.x,12c.x), Oracle VM for SPARC, MongoDB, Cloudera, Hadoop

Confidential, Atlanta, GA

Lead oracle DBA/ RAC, Gloden Gate Architect

Responsibilities:

• Successfully compressed over 30+ v490's, v880's,v440's v240's into Sun SPARC 3*T4-2 (Prod and DR) and 2*T4-1 (UAT) data center
• Saved Confidential 500k over 12month period, with savings in cooling, power, weight and space of over 83%
• Successfully designed and installed oracle 11gR2 Clusterware and ASM on top of oracle 10g RAC database
• Successfully managed multiple oracle RAC databases on oracle VM server for SPARC LDOMS and zones
• Successfully managed both single instance zones and RAC LDOMS from development, UAT, go-live, to production support
• Resolved RAC performance issues on oracle VM server for SPARC LDOMS
• Successfully implemented and utilized Oracle real applications testing (RAT) for workload management and analyzing and optimizing SQL performance
• Implemented, setup and utilized oracle cluster health monitor for diagnosis and fixing cluster issues
• Utilized RAC check utility to also diagnose CRS, ASM and RAC database setup issues
• Successfully designed, implemented and managed oracle physical and logical dataguard solutions
• Implemented RMAN strategy for all backups, refreshes and restores
• Designed, installed and configured oracle gloden gate on both Unix and windows platform
• Designed, implemented, and supported both unidirectional and bidirectional replication leveraging multiple features within the Oracle GlodenGate product suite
• Tuned extract and replicate lags and implemented gloden gate monitoring scripts
• Wrote several PL/SQL procedures and SQL scripts, used by gloden gate processes for data filtering, computation and transformation
• Wrote conflict resolution scripts for bi-directional support to maintain data integrity in high performance, high volume databases
• Implemented DDL replication, resolved performance tuning issues on extract and replicate processes

Environment: Solaris 10 & 11, Oracle RAC 10g, 11gr2, Solaris Zones, LDOMS, Windows 8, Oracle data guard, Oracle gloden gate 11x, Oracle VM for SPARC

Confidential, Atlanta, GA

Lead oracle DBA/Architect

Responsibilities:

• Managed multiple databases on both RAC and single instance on Linux
• Successfully migrated several QA/test, staging and multi-tera byte production 9i/10g HP/Solaris DB to oracle 11gr2 DB using RMAN TTS on Linux and documented migration procedures
• Managed and updated several automated Unix scripts used for the migration project to expedite the migration process with minimal manual intervention
• Resolved numerous performance issues like top wait events, sub-optimal execution plans, outdated statistics, data fragmentation, latch contention, CPU constraints, physical & logical me/O, disk usage, query optimization, hard/soft parsing by application tuning, disk me/O and memory tuning.
• Regularly planned and scheduled physical (hot/cold) backups, logical (import/ export, data pump) backups, and incremental backups using RMAN on daily, weekly and monthly basis.
• Performed troubleshooting duties on Oracle production databases and determined RCA (Root Cause Analysis) and resolved known issues
• Handled performance tuning and application monitoring with Quest TOAD, Oracle enterprise manager, AWR and Explain plan and greatly reduced execution times of several problematic queries
• Applied quarterly CPU and PSU patches to over 100 mission critical databases
• Diagnosed Oracle bugs and coordinated with oracle support to resolve them in timely manner and applied patch sets to make application environment up-to-date.
• Involved with streams administration for data replication purposes
• Developed fully optimized SQL and PL/SQL scripts that successfully assisted with timely offloading of reporting data and analytical data

Environment: Linux, HP, Windows XP, 9i, 10g, 11gr2, Dbconsole, Grid control, Dataguard, VERITAS cluster, streams

Confidential, Atlanta, GA

Lead (RAC) oracle DBA/Architect

Responsibilities:

• Successfully upgraded, installed and managed proprietary clinical applications
• Successfully Installed and implemented multiple oracle 11gr2 RAC databases on customer client sites
• Diagnosed and resolved performance and workload issues using Oracle real application testing tool and documented best practise procedures.
• Provided troubleshooting expertise for both clinical application tier and database tier and resolved several SQL, OS and application tier issues
• Used Oracle enterprise manager (OEM) to monitor, diagnose and resolve database performance issues
• Managed Oracle active data guard & standby database and provided critical solution with strategic disaster recovery plans with different recovery procedures and methods
• Cloned development databases from PROD using RMAN plus configured and scheduled RMAN Backups as per business requirements
• Designed implemented, and supported both unidirectional and bidirectional replication leveraging multiple features within the Oracle glodengate product suite
• Identified and resolved causes of slow startups, monitored process lag and statistics, identified network and disk bottlenecks, and performed tuning of key components
• Monitored and resolved different process problems, such as extract and replicat process issues
• Utilized Oracle glodengate troubleshooting tools such as knowledge documents, documentation, SHOWSYNTAX parameter, and the Logdump utility
• Participated in logical and physical database design reviews to ensure application design integrity

Environment: Linux, Windows XP, 10g, 11gr2, Dbconsole, Grid control, Dataguard, VERITAS cluster, Gloden Gate 11.x.

Confidential, St Paul, MN

Lead (RAC) oracle DBA/Architect

Responsibilities:

• Successfully upgraded oracle 10g RAC databases to 11gr2 RAC databases
• Developed and deployed SQL, PL/SQL stored procedures, functions and triggers for several in-house projects
• Created and maintained physical, logical and snapshot standby databases for disaster recovery, near real-time reporting, load-testing and production database backup
• Utilized Oracle automatic storage management (ASM), Oracle managed files (OMF) and recovery manager (RMAN) to improve me/O performance, reduce administration overhead and provide a comprehensive backup and recovery strategy.
• Utilized cluster health monitor utility to manage and clusterware and OS resources and resolved known issues
• Successfully implemented and utilized Oracle real applications testing (RAT) for workload management and analyzing and optimizing SQL performance
• Installed and deployed oracle gloden gate on Linux server for data replication
• Experience with installing and managing gloden gate with DDL support
• Proven Knowledge of gloden gate architecture and database replication using gloden gate technology
• Experience with replicating big source environments with multiple initial load methods and managing big transactional volumes
• Diagnosed and resolved extract, replicate and network issues during glodengate replication
• Developed monitoring scripts to monitor glodengate and report issues proactively
• Employed Logdump utility to troubleshoot and fix glodengate replication issues
• Unix shell scripting, SED, AWK scripting for automating several DBA tasks
• Configuration and administration of full rack Exadata databases
• Resolved smart scan performance problems, like passthrough mode and selective fallback to block IO - with Exadata Snapper
• Utilized performance tools like V$SQLSTATS, ASH and SQL monitoring views to resolve Exadata performance related waits
• TEMPEffectively utilized Exadata Hybrid columnar compression on historical data which led to realizing 6-7 times SQL performance gains

Environment: Linux, Windows XP, 10g, 11gr2, Dbconsole, Grid control, Dataguard, VERITAS cluster, Exadata v2, Glodengate 10

Confidential, Memphis, TN

Advanced Customer Service Engineer

Responsibilities:

• Diagnosed and resolved oracle RAC performance issues using SQLT and AWR
• Upgraded 10g RAC database to 11gr2 RAC databases
• Used OEM, CVU &SRVCTL, and CRSCTL commands extensively to maintain the RAC environment like add/remove node, start/stop clusterware app services on node and add TAF services.
• Involved in performing several quarterly CPU & PSU patches on multiple databases
• Diagnosed and resolved client RAC related data corruption, ASM and clusterware corruption issues and resolved cache fusion related contention issues
• Supported multi-tera byte oracle 10g, 11g RAC databases and data guard DR solutions on multiple platforms
• Involved in SQL query tuning and optimization for client on multiple applications and databases and reduced query performance times to acceptable levels
• Successfully installed and deployed oracle gloden gate in unidirectional and bidirectional modes on Linux platform
• Developed and implemented administrative scripts for supporting, monitoring and tuning gloden gate replication and monitoring replication lags
• Worked on various conflict detection and resolution scenarios for different types of DML, including quantitative resolution and transactional resolution
• Resolved all ongoing support and problem determination of data replication issues, including identifying and resolving data inconsistencies and data replication lag
• Supported and deployed glodengate in a heterogeneous replication environment
• Successfully configured and deployed and managed glodengate director and veridata.
• Documented and published RAC, ASM best practises and procedures for client.
• Served as SME (subject matter expert) and project lead in a variety of areas including Oracle streams, database security and auditing, backup and recovery, performance tuning and UNIX shell scripting.
• Initiated media recovery, Instance and crash recovery using RMAN and performed database point-in-time recovery and TSPIT recovery during scenarios like loss of RLF, system/non-system DBF, Control file, table drop and whole DB Crash.
• Created and published standards and operational procedures to provide continuity of operations between geographically distributed DBA groups.

Environment: AIX, HP, Linux, Oracle 10g, 11gr1, 11gr2, RMAN, Dbconsole, Grid control, Dataguard, GlodenGate 10

Confidential, Atlanta, GA

Lead oracle (RAC) DBA

Responsibilities:

• Created Oracle 11g database for departments, from planning and testing through production.
• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation.
• Utilized SQL Tuning Advisor to tune SQL statement and the recommendations to rewrite poorly performing SQL code.
• Installed, configured and supported Oracle Enterprise Manager, evaluated Oracle Database Monitoring and PL/SQL tools.
• Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading and Tuning SQL statements using Explain Plan and STATSPACK.
• Migration of data to Oracle 10G Databases utilizing Oracle and ESRI Products.
• Experience implementing Restore and Recovery strategies using RMAN cold/Hot backups and cloning databases using RMAN duplicate.
• Performance Monitoring and Tuning at Instance level, Database level, OS level and Query level using Oracle diagnostic tools like Explain plan, STATSPACK, AWR, Tuning Advisors like SGA/Shared Pool/PGA tuning advisors etc.
• Implemented different Table partitioning schemes like Range Partitioning, Hash Partitioning, List partitioning etc.
• Experience in writing Shell scripts (purging and archiving data for partitioned tables) and automating day to day maintenance procedures.

Environment: AIX, HP, Linux, Windows XP, Oracle 9i,10g,11gr2, sqlbacktrack, Dbconsole, grid control, Dataguard, VERITAS cluster

Confidential, Atlanta, GA

Lead oracle (RAC) DBA/Architect

Responsibilities:

• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases.
• Involved in Up-gradation of databases from 9i to 10g.
• Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.
• Played a lead production support executive role which included but not limited to designing, development, quality testing, user acceptance testing of a complex relational database management system (RDBMS) that resulted in reduction of cost for 20% in annual budget and also helped digitizing of records for enhancement security and any integrity issues.
• Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.
• Converted physical standby databases to Snapshot standby database.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Configured and Tuned RMAN for better performance and backup strategies.
• Involved in writing for shell scripts for taking RMAN backups.
• Restored and Recovered database at the times of occurrence of critical failures using RMAN.
• Extensive used Oracle Data pump, Exports/Imports utility for moving data among the servers.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Performed automated backups and scheduling using scripting.

Environment: Windows 2003 server, Linux, Solaris Sunsparc, oracle 10g and 11g, 10g Grid, 10g RDBMS, Apex 3.1, Vista

Confidential, Atlanta, GA

Lead oracle (RAC) DBA/Architect/Instructor

Responsibilities:

• Review of Database logical and Physical design.
• Installation, setup and configuration of DATA GUARD.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc and Implementing Database Security, Management of role-based security.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Migration of data to Oracle 10G Databases utilizing Oracle and ESRI Products.
• Invited to participate in Holistic Testing for ESRI GIS Products.
• Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved in gathering requirements from end users.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

Environment: Windows XP, Solaris, Linux, 10g RAC, 10g Grid, 10g RDBMS, AIX, Linux, HP, windows vista

Confidential, Atlanta, GA

Senior oracle (RAC) DBA/Architect

Responsibilities:

• Review of Database logical and Physical design.
• Installation, setup and configuration of DATA GUARD.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc and Implementing Database Security, Management of role-based security.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Migration of data to Oracle 10G Databases utilizing Oracle and ESRI Products.
• Invited to participate in Holistic Testing for ESRI GIS Products.
• Performed Data Migration as a part of enterprise data warehouse project.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Established database backup/recovery strategy for different databases.

Environment: Solaris, Windows XP, Linux, 10g RAC, 10g Grid 10g RDBMS, VERITAS cluster server and volume manager, DBartisan

Confidential, Atlanta, GA

Senior Oracle DBA/Database Architect

Responsibilities:

• Creation of new databases, deciding the location of data, index, rollback, redo log and control files on the disks.
• Defining and developing data inter-relationships and designing the Dataflow diagrams in building an efficient Database architecture.
• Creating, checking, extending table space. Administered database security, created users, granted/revoked roles, privileges, extended databases storage capacity, monitored and reduced database fragmentation, managed data files, rollback segments, extents, segments, re-indexing, monitor storage, backup & restore/recover database, export/import database objects.
• Identified common functionalities, implemented them using PL/SQL, Stored procedures, Packages, Triggers, form Libraries.
• Implemented and maintained database activities include database backup (Cold, Hot, Import/Export), database recovery, tuning, installation, database creation, logical and physical databases design.
• Database activities include allocation and maintenance of Rollback and Undo Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.

Environment: HP-UX, Oracle 8.1.7,9i and 10g,Windows XP, SQL server, Linux, AIX, EMC storage, VERITAS cluster server

Confidential, Atlanta, GA

Senior Oracle DBA/Database Architect

Responsibilities:

• Creation of new databases, deciding the location of data, index, rollback, redo log and control files on the disks.
• Defining and developing data inter-relationships and designing the Dataflow diagrams in building an efficient Database architecture.
• Creating, checking, extending table space. Administered database security, created users, granted/revoked roles, privileges, extended databases storage capacity, monitored and reduced database fragmentation, managed data files, rollback segments, extents, segments, re-indexing, monitor storage, backup & restore/recover database, export/import database objects.
• Identified common functionalities, implemented them using PL/SQL, Stored procedures, Packages, Triggers, form Libraries.
• Implemented and maintained database activities include database backup (Cold, Hot, Import/Export), database recovery, tuning, installation, database creation, logical and physical databases design.
• Database activities include allocation and maintenance of Rollback and Undo Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.

Environment: Sun Solaris, Linux, HP, XP, Tomcat, Oracle 8i, 9i, Weblogic, IIS

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Perform analysis and implement Oracle Financials Application from an already existing legacy system. Implement customizations according to user requirements.
• Developed SQL*Loader control files for importing data from legacy system into temporary GL interface tables and wrote interface programs using PL/SQL procedures
• Responsibilities included data conversion and data validation according to the clients business rules into the new system using SQL*Loader and PL/SQL
• Involved in designing ER diagrams for custom tables with user interaction
• Created 15 customized Forms with Oracle Developer 2000 (Forms 4.5)
• Customized the Auto-invoicing process in Oracle Receivables
• Modified the auto-invoicing printing report to change the grouping criterion using Reports 2.5

Environment: AIX, NT, Win2k, SUSE Linux, Erwin, Oracle 8i

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Recommending database backup recovery strategy for each database application, developing and implementing operational procedures for disaster recovery.
• Installation, Upgrades, and database administration of Oracle database, tools like SQL Net, Oracle Enterprise Manager.
• Used Shell scripts to load data, export / import of data and backup of the database.
• Created various database objects for application requirements, triggers, roles and assigned privileges to users. Reorganized the database objects based on the extents' growth and size.
• Conducting database monitoring, performing or refining physical database design, optimizing database performance.
• Application integration on database troubleshooting, obtaining technical information and support from database vendor for bug fixes.
• Optimized performance of queries by building indexes and removing unnecessary indexes.
• Converted Data from SQL Server Database to Oracle Database.

Environment: Oracle 7x, Aix, MS SQL Server, win 2k

Confidential, Minneapolis, MN

Oracle DBA/ Developer

Responsibilities:

• Installation, Upgrades, and database administration of Oracle database.
• Development of SQL Plus Formatted reports for various purposes of analysis with respect to space management, Performance tuning and query optimization.
• Created various database objects for application requirements, triggers, roles and assigned privileges to users. Reorganized the database objects based on the extents' growth and size.
• Development of SQL plus Formatted reports for various purposes of analysis with respect to space management, Performance tuning and query optimization.
• Responsible for migration of databases from Oracle 7.1 to 7.3.3.
• Management of Rollback segments to support for large data loads.
• Optimized performance of queries by building indexes and removing unnecessary indexes.
• Created, configured and maintained high availability 24 x 7 Oracle Database that supports large no of users.

Environment: Oracle 7x, Win NT, Sun Solaris, Oracle designer, Oracle Report Writer

Confidential

Oracle DBA / System Analyst

Responsibilities:

• Responsibilities include analysis, design development and implementation of the Order Processing system.
• Designed and Developed procedures to update stocks etc. Developed several reports like Stock Detail using Oracle Reports 2.5 which include both batch reports and on-line reports.
• Wrote shell scripts for data transfer from old system to the New system using SQL * Loader. Also involved in routine DBA activities like calculation of object size, tablespace etc. Used Sql * Net to connect Developer 2000 to the server.
• Tuned the kernel parameters like SHMMAX, SHMIN for semaphore settings. Configured Oracle Server for multi-threaded server processes.
• Created various Backup/Recovery Scripts for databases both in ARCHIVELOG and NOARCHIVELOG mode

Environment: Oracle 7x, Win NT, PowerBuilder 5, Oracle Designer, Oracle developer