We provide IT Staff Augmentation Services!

Oracle Dba Resume

Montvale, NJ

SUMMARY
More than 6 years of IT experience, including 5 years in Oracle Database Administration experiences for various kinds of applications in UNIX environments with a proven background of technical problem solving. A self-motivated, responsible, and reliable team player with a set of very strong technical skills

  • Experience working in various domains like Financial, Manufacturing, Portals to deliver new products, upgrades. Resolve application problems to maintain high level of customer satisfaction.
  • Experience in Installing and Configuring Automatic storage management (ASM) Instance, CRS and 2 nodes UNIX RAC environment for high availability databases.
  • Developed Recovery Manager (RMAN) scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
  • Very proficient in installing and Implementing physical Data Guard.
  • Maintaining Oracle Data Guard & Standby Database and providing critical solutions with Strategic disaster recovery plans with different recovery procedures and methods.
  • Automated many common tasks using crontab including: Backups, exports and imports, archiving old records and verification of such processes.
  • Experience in writing scripts proactive monitoring like monitoring the disk usage and the memory usage of the server and monitoring tablespaces.
  • Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
  • Experience in taking logical backups of data using oracle data pump utilities EXPDP and IMPDP, to move Oracle data from a database or schema to another.
  • Expertise in developing SQL and PL/SQL codes through various procedures, functions, and in Oracle packages to implement the business logics of database.
  • Experience in designing, testing, managing and troubleshooting database architecture and management policy.
  • Performance tuning with SQL TRACE and TKPROF.
  • Hands on experience with various tools like SQL*Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager (OEM).
  • Analyzed Automatic Workload Repository (AWR), Active Session History (ASH) reports.
  • Experienced in generating statistics of database using ADDM.
  • Tune the SGA components like buffer cache, shared pool to avoid paging & swapping
  • Thorough understanding and excellent experience in tuning, assigning proper indexes such as BITMAP or B-Tree Index according to requirement.
  • Experience with AIX, HP-UX, Solaris, Linux and Windows NT.
  • Experience in tuning and managing Undo Segment in order to avoid "Snapshot too old"
  • Creating stored procedures, functions, packages triggers, according to business requirements.
  • Hands on experience working with different FTP clients like Smart FTP, cute FTP, SFTP and WinSCP.
  • Extensive experience in supporting multiple production databases running 24 x 7 mission-critical / OLTP applications demanding high availability and increased performance.
  • Analyzed Tables, Indexes periodically to optimize the SQL queries.
  • Strong Knowledge and experience of Creating Users, Public Synonyms, materialized views, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users.
  • Strong knowledge of volume and different storage technology like RAID 0, RAID 1, RAID5, Veritas volume manager, ASM etc.
  • Developing complex shell scripts (korn mainly) for backup, rotating logs/files, etc.
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills

TECHNICAL SKILLS

Programming Languages

C, PL/SQL, VI editor, Unix shell

Operating Systems

LINUX, UNIX, Sun Solaris 5.8, SunOS 5.6, HP-UX 11.0, IBM AIX5, Windows XP

Database Systems

Oracle10g/ 11g, MS Access 2000

Oracle Utilities

Oracle Data Grid control, OEM, RMAN, ASM, RAC, DATA PUMP, SQL Loader, DGMGRL, SQL Expert, SQL*PLUS, SQL*Net, SQL Developer

Software

TCP/IP, DBArtisan, Core FTP, Cute FTP, F-Secure SSH Client,
TOAD, PUTTY, MobaXterm

Designing/ Analysis

Oracle Designer 2000, Oracle Developer 2000, Oracle Forms 4.5, Oracle Reports 3.0, ERWIN 4.14

EDUCATION/CERTIFICATION

  • Oracle Certified Associate (OCA)
  • Oracle 11G SQL Exam (IZ0-051)
  • Oracle 11G Database Fundamentals I (IZ0-052)
  • BS, Computer engineering - Gujarat University, India

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ (Mar'12 - till date)
Oracle DBA

Description
Confidential, is aFortune 100company, and it is one of the largestpharmacy benefit Managementorganizations in theUnited States. The company processespharmaceuticalclaims for members at network pharmacies and at their ownmail orderpharmacies. Express Scripts provides integrated pharmacy benefit management services including network-pharmacy claims processing, home delivery services, specialty benefit management, benefit-design consultation, drug-utilization review, formulary management, and medical and drug data analysis services to managedrugplans forgovernmentagencies (both as administrator of employee benefits and public assistance programs),corporations, andunions. One of their largest clients is theUnited States Department of Defense\'sTRICAREprogram.

Responsibilities

  • Perform Backups and Recovery, maintain 24 hours uptime for the database
  • Served as Oracle DBA in a 24x7 Production environment managing several Database instances.
  • Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment
  • Organizing Oracle Database operations, installation, creation, configuration, laying out database tables and database schema design, startup and shutdown of Databases
  • Setting init.ora parameters, maintaining Data Files, Control Files, Redo Log Files, managing Tablespaces, segments, extents, indexes and managing Undo Data.
  • Carrying out EXPORT and IMPORT operations on Oracle Database, and monitoring the performance of the database using of OEM (Oracle Enterprise Manager)
  • Upgrading from Oracle 9i to Oracle 10g database
  • Install and configure Database as of Oracle's Optimal Flexible Architecture (OFA).
  • Knowledge of DATAGUARD.
  • Mentored and provided oversight and backup for the production Databases.
  • Maintained Test Database for testing and research work
  • Used Flashback feature to recover a dropped table and also to recover a database.
  • Knowledge of Oracle11g RAC on the Same Cluster Using CRS
  • Visualizing future requirements of the resources based on the ongoing performance.
  • Automating the daily routine activities backups using the DBMS_JOBS, DBMS_SCHEDULER.
  • Monitoring of the queries with high response time and high disk reads per execution and tuning the same using Explain Plan, TKPROF, Auto trace.
  • Used Automatic Workload Repository (AWR) for analyzing the database performance.
  • Use TOAD to Optimize and test SQLs, PL/SQL statements developed by the Development Team.
  • Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
  • Implemented Change Control for the Production Databases as and when required.
  • Communicated with Oracle support via the Metalink in order to troubleshoot important issues.
  • Performed general technical troubleshooting and give consultation to development teams
  • Provided support to ETL developers in loading data to datawarehouse using ETL tool Informatica
  • Planned the index rebuilding, analyze index and analyze table on periodical basis

Environment
Oracle 11g, Sun OS 5.6, Exp/Imp, ERWIN 4.14, SQL Developer, OEM, SQL*LOADER, Cute FTP
DB2 SQL, MVS Workload Manager,
Performance software: BMC Mainview for MVS/CICS/DB2, Strobe, SAS/MXG, SAS report code

Confidential, (Oct'08 - Jan'12)
Oracle DBA

Description
PK info technologies is the prime franchisee holder of over 150 branches of KIFS securities along with Medical Billing. KIFS SECURITIES LTD. is in the business of shares and stocks brokership, investment advisory, financial services and portfolio management in stock markets, debt markets and derivatives markets providing dematerialized accounts services.
Also, are corporate member of National Stock Exchange having equipped with sophisticated infrastructure in various cities in India.

Responsibilities

  • Performed migration from Oracle 10g to Oracle 10g Release2 RAC database
  • Responsible in Managing and optimizing transactional replication in OLTP environments.
  • Developed backup and recovery strategies for Oracle Server databases.
  • Creation and configuration of Standby Database (Dataguard)
  • Worked on monitoring and optimizing the database by performance tuning
  • Monitored indexes and analyzed their status for performance tuning and query optimization.
  • Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
  • Responsible for taking logical backups of datausing exp, Imp.
  • Responsible for taking HOT and COLD backups of the databases and also the individual tablespaces
  • Experience in Backup & Recovery techniques and conducted disaster recovery drills.
  • Responsible for partitions on tables and indexes for managing large tables
  • Maintenance & modification of Shell Scripts
  • Extensive use of Crontab in UNIX environment for scheduling routine tasks.
  • Creation and maintenance of test schema
  • Physical and Logical Design of the database which includes Database creation, tablespace creation, table and index partitioning and also mapping of different objects with disks
  • Performed ongoing capacity planning and expansion to meet requirements of database growth.

Environment
Solaris, Oracle 10g, RAC, ASM, UNIX Shell scripting, VI Editor, RMAN, Data pump, OEM, Oracle Data Grid Control, Putty

Confidential, (Aug'07 - Sept'08)
Oracle DBA

Description
Wipro Global IT Business delivers winning business outcomes through its deep industry experience and a 360 degree view of "Business through Technology" - helping clients create successful and adaptive businesses. A company recognized globally for its comprehensive portfolio of services, a practitioner\'s approach to delivering innovation and an organization wide commitment to sustainability.

Responsibilities

  • Performed migration from Oracle 10g to Oracle 11g Release1 RAC database
  • Performed logical backup using export/import and datapump (remote export) utilities
  • Configured the RMAN backup
  • Configured the OEM for the database monitoring
  • Carried out hot backup, cold backup and RMAN backup
  • Carried out the Binary Installs in the Oracle 10g RAC environment
  • Done the Migration Review required before the database migration and QA after the database is migrated.
  • Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora
  • Created schema (tables, indexes, views, sequences, synonyms, roles, packages), grant roles to users
  • Loaded flat file data into tables using SQL*Loader
  • Undergone the SOX Training
  • Provided full technical support to various application teams before the databases go live
  • Experience in interaction with the top management and escalations of the complex issues
  • Attended the call conference meetings
  • Performed the capacity planning required to create and maintain the databases
  • Perform Backups and Recovery, maintain 24 hours uptime for the database
  • Managed the databases of various sizes ranging from 50GB to 2.5TB

Environment
Oracle 10g RAC, Quest Toad 8.5, SQL Loader, Windows 2003/XP, Sun Solaris 5.8, DBArtisan,
Core FTP, F-Secure SSH Client

Confidential, (Feb'06 - Jul'07)
Oracle Analyst

Description
A full service firm, that provides turnkey solutions, may it be custom developed or own products. A comprehensive business solutions and outsourcing facilities provided to clients across the world in the fields of finance, healthcare, ecommerce, education and manufacturing activities.

Responsibilities

  • Involved in requirement analysis and design documentation.
  • Designed and developed database tables necessary along with the necessary constraints to enforce business rules.
  • Created and modified several Database Triggers, especially for Audit and Security purposes.
  • Developed many Stored Procedures, Packages, and Cursors and involved in the performance tuning of PL/SQL.
  • Involve in Tuning, Performance, Optimization of queries and standardization of the code
  • Resolved several hardcore business rules and issues at the client site.
  • Created users, roles with privileges, grant the appropriate roles.

Environment
Oracle Designer 2000, Oracle Developer 2000, Oracle Forms 4.5, Oracle Reports 3.0, PL\\SQL, SQL*PLUS, SQL Loader, SQL Navigator, TOAD, Oracle 7.3.4, Oracle 10g, MS Access 2000, MS Word 2000, MS Excel 2000, MS PowerPoint 2000, Windows NT 4.5

Hire Now