We provide IT Staff Augmentation Services!

Big Data Consultant Resume

5.00/5 (Submit Your Rating)

Atlanta, GA

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 wif 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 wif 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 wif 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 wif 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 wif 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 wif 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, wif 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 wifin 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 wif 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 wif 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 wif oracle support to resolve them in timely manner and applied patch sets to make application environment up-to-date.
  • Involved wif streams administration for data replication purposes
  • Developed fully optimized SQL and PL/SQL scripts that successfully assisted wif 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 wif strategic disaster recovery plans wif 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 wifin 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 wif installing and managing gloden gate wif DDL support
  • Proven Knowledge of gloden gate architecture and database replication using gloden gate technology
  • Experience wif replicating big source environments wif 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 - wif 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 halped 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 wif user interaction
  • Created 15 customized Forms wif 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 wif 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 wif 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

We'd love your feedback!