We provide IT Staff Augmentation Services!

Oracle Dba Resume Profile

Lake, NJ

PROFESSIONAL SUMMARY

Database Administrator with over 6 years in Oracle DBA Admin and over 11 years in Web Development. Worked on wide range of projects ranging from implementations, architecture, development, upgrades, conversion, integration, customizations, security, testing and production support.

  • Proficient in end to end DBA executions such as Installation, Configuration, Upgrades, Patches, Performance Tuning, Backup Cold and Hot , Recovery, Cloning, Database Security, Troubleshooting, Database Design, SR support, Unix Shell Scripting and Documentation.
  • Extensive Database Administration in Solaris 2.8/2.7/2.6, Windows NT 4.0, HP-UX 10.2/11.0, Windows xp/7/8
  • Provided 24x7 on call Technical Support in Monitoring, Managing and solving production database issues including very large databases Terabytes DB .
  • Daily and intraday monitoring of database health includes availability, reliability, performance, Capacity Planning, Re-allocation and proactive approach in Monitoring Databases.
  • Maintain and Support 11gR2 RAC in Prod/QA environments.
  • Experience in configuration of Oracle Streams for replication between two databases.
  • Experience using Python within ArcGIS
  • Experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using Load testing tools
  • Space Management Table spaces, Rollback Segments and Monitoring Alert logs, Memory, Disk I/O, CPU, Network activity .
  • Experience in User Management Synonyms, Privileges, Roles, Quotas, Table Partitioning, Indexes, and Sequences ,
  • chained rows and avoid flushing shared pools.
  • Experience in OLTP system Tuning using hints in queries, running bstat/estat, Explain Plan, TKPROF, eliminating
  • Significant exposure to Informatica ETL complex mappings design, development and deployment.
  • Implemented RAID 1 /RAID 5 for data recover.
  • VPD Fine Grained Access Control and Row Level Security
  • Significant experience with Oracle Data Guard.
  • Solid exposure to Software Development Life Cycle.
  • Strong analytical and problem solving skills coupled with excellent written, verbal and inter-personnel communication skills.
  • Proven ability to quickly learn new technology and apply them to business solutions.

TECHNICAL SKILLS

Operating Systems Solaris 2.8/2.7/2.6, Windows NT 4.0, HP-UX 10.2/11.0, Windows xp/7/8
Databases Tools Oracle 11g/9i/8i/8.0/7.3, Oracle Enterprise Manager, Oracle Diagnostics Pack, Oracle Performance Pack, Erwin 3.5/4.0, TOAD, SQL Net/Net 8, Spotlight on Oracle
Programming Languages PL/SQL, UNIX Shell Scripting
Data Modeling Erwin
Hardware SunFire 15K, Sun E6500, Sun E4500, Sun E450, HP 9000, Compaq Proliant
ETL tools Informatica PowerMart 4.6/PowerCenter 5.1.1, Cognos DecisionStream

PROFESSIONAL EXPERIENCE

Confidential

Role: oracle DBA / DEVELOPER

description:

Confidential a Japanese pharmaceutical company, ranking among the top 25 in the world by revenue and achieving 8 billion USD in sales for the fiscal 2008 year ambiguous . Headquartered Confidential . The position is responsible for administrating/maintaining/Monitoring/Upgrading the Production/Dev/Test and training databases for products e.g. PKS, Viewpoint, ClinProd, QAAD, GCDMS, EDC Central Designer, DC Central Coder, EDC Inform, Primavera, Lotus Notes and Ellie and Oracle9i RAC

RESPONSIBILITIES:

  • Successfully upgraded Ellie application database on development, test and production environment, Validated and documented the upgrade as per Eisai Standard Procedure. Setup backup procedures and monitoring scripts.
  • Effectively configure Ellie-HR Connector on development, test and production environment, Validated and documented the upgrade as per Eisai Standard Procedure.
  • Configure Ellie-EDNA Integration on development, test and production environment, Validated and documented the upgrade as per Eisai Standard Procedure.
  • Experience using Python within ArcGIS
  • Setup backup procedures and monitoring scripts.
  • Upgrade Viewpoint application database on development test and production environment, Validated and documented the upgrade as per Eisai Standard Procedure. Setup backup procedures and monitoring scripts.
  • Upgrade database of the EDC modules - Inform, Central Designer, Central Coder and Central analysis. Thirty-three servers and twenty-one database instances are involved in this upgrade.
  • Complete production readiness state by applying latest patches, setting up the backup and monitoring agents.
  • Meet the objective of maintaining the high standard of the database security in firm deployed Oracle Security Patch released on Oct-2009 on all Eisai, WCL, EMR and Baltimore Oracle databases.
  • Notify and communicate to Business as well as Vendor application team for their respective application for above Security Patch release.
  • Perform Day-to-Day DBA tasks - performance tuning, database design, system security, database installation configuration, patching, technical database support.
  • Maintain databases on a 24/7 basis with on call weekend support.

ENVIRONMET: Linux, UNIX, Linux RHEL 4.x,5.x and Windows NT/2000/2003/2008

Confidential

Role: Oracle DBA / DEVELOPER

description:

Confidential is a pharmaceutical company that is engaged in the formulation, testing, manufacture, and commercialization of pharmaceutical products by using advanced drug-delivery technologies. The company has a primary interest in exploring those product candidates that fit their pre-determined therapeutic categories which include cardiovascular disease, pain management, central nervous system disorders and other specialty or niche areas. The position was responsible for administrating/maintaining the production databases for online products e.g. Government Pricing, Medicaid, Cars, Sales, HR, Validate IRMS , EDMS.

RESPONSIBILITIES:

  • Maintained the database on a 24/7 basis with on call weekend support.
  • Configured RMAN Catalog, Automated RMAN backup script and part of disaster recovery.
  • Migrated Oracle9i to 10g in test environment for online product Medicaid and Cars.
  • Supported SQL Server 2000 databases.
  • installation, technical support, and investigation of new technologies.
  • Performed Day-to-Day DBA tasks - performance tuning, database design, data modeling, system security database
  • Wrote extensive shell scripts to monitor health of the database.
  • Designed physical/logical database using Erwin tool.
  • Tested all the new features of Oracle10g in test environment.
  • Also involved in business/technical analysis/support of pharmaceuticals products GP/MEDICAID/CARS from vender of IMANY Inc.

ENVIRONMET: Linux, UNIX, Linux RHEL 4.x, 5.x and Windows NT/2000/2003/2008

Role: Oracle DBA / DEVELOPER

description:

Confidential is an American daily newspaper, founded and continuously published in Confidential since September 18, 1851. As a Oracle DBA, I maintained the Production Data Warehouse environment running oracle databases on sunfire 4800 servers connected to EMC and Sun StorEdge T3 disk arrays, using Informatica as the ETL tool and Siebel for marketing purposes. Worked on Prospect CRM project. Prospect data Leads that comes from different sources like LAD Leads Address Database , Fair Isaac Direct Mail etc. is loaded into Data Warehouse and then is passed on to the CMDM Data mart / PROSPECT PREBUILD so that the Siebel Analytics / Marketing can pull lists and campaign to the prospects / win-back customers.

RESPONSIBILITIES:

  • Responsible for administrating the CRM Data Warehouse, Data Mart and Informatica ETL tool repository.
  • Responsible for maintaining the database on a 24/7 basis with on call weekend support.
  • Migrated SAN from T3.
  • Configured RMAN Catalog, Automated RMAN backup script for leve0 and level2 and wrote UNIX scripts to compress
  • backup sets
  • Developed complex mappings in Informatica.
  • Evaluated Oracle 10g.
  • Used RAID 5 and RAID 0 1 for disk mirroring.
  • Wrote extensive shell scripts to monitor health of the database.
  • Table Partitions.

ENVIRONMET: Linux, UNIX, Linux RHEL 4.x,5.x and Windows NT/2000/2003/2008

Role: Oracle DBA / DEVELOPER

description:

Advisen generates, integrates, analyses and communicates unbiased, real-time insights for the global community of commercial insurance professionals. It is headquartered in New York City, with offices in the US and the UK. The company was established in 2000 by a team of seasoned insurance and technology professionals. Today, Advisen serves more than 150,000 commercial insurance and risk professionals from 8,000 organizations worldwide.

RESPONSIBILITIES:

  • Created and configured the databases for production, Test and development environments.
  • Upgraded the Oracle from 8.1.7.3 to 9.2.0 in development, test and production databases.
  • Implemented the recommendation of oracle databases for optimal performance and good throughput.
  • Refreshed the Test and development databases with the production data. Analyzing and rebuilding of indexes.
  • Created Rollback segments with different storage parameters.
  • Designed Backup Recovery strategy for 24x7 for all above products, Written Hot Cold Backup scripts for the production databases.
  • Written shell scripts in Ksh to run stored procedures and scheduled them on crontab to run daily.
  • Installed and upgraded several oracle 8i patches.
  • Configured Intermedia text.
  • Configured RMAN utility for backup and recovery.

ENVIRONMET: Linux, UNIX, Linux RHEL 4.x,5.x and Windows NT/2000/2003/

Role: Lead HTML Developer

description:

Confidential specializes in areas of software development and data analysis using new Client / Server and Web technologies. The company has evolved into a highly reputable technology solutions organization. In an era of jetting technological advancement where minute details are important, one cannot ignore the significance of Information Technology, which enables quick and correct decision-making, and is powered with the economics of scale of time, money and energy. In short a very reputable, quality oriented and reliable company valued amongst its clients across the US.

RESPONSIBILITIES:

  • Hand coded HTML templates from scratch using a notepad editor
  • Co-developed a vibrant, secure website using interactive features and best practices to optimize traffic, page views and the user experience
  • Integrated images, sound, animation and video highlights to improve the user experience.
  • Strong copyediting skills.
  • Identified and addressed operational and process issues.
  • Coded HTML email for responsive design
  • Personalization and dynamic content coding for email

Role: HTML Developer

RESPONSIBILITIES:

  • Build, lead, and manage team of up to 28 HTML Developers and graphic designers.
  • Hand coded HTML templates from scratch using a notepad editor
  • Provided decisions on project scope, spec, and direction. Resolve technical issues impeding project completion.
  • Worked directly with the CEO on implementation of requested UI changes.
  • Performed routine signoff reviews of newly developed code to ensure consistent coding style.
  • Conducted HTML group meetings and IT Department trainings and write accompanying training documentation.
  • Investigated new emerging web technologies for use in Friend Finder's network of sites to improve user experience.
  • Developed keen eye for good UI design while keeping web usability in mind.
  • Conducted comparative analyses of competitor's websites. Organize team-building social events.

Role: Senior Web Production Manager

description:

Services International is a leader in the Indian travel industry and are in the travel business since 1977.

RESPONSIBILITIES:

  • Promoted to Lead HTML Developer of initial 3 person HTML developer group.
  • Interviewed, hired, and built new Web Development HTML team to 5 members.
  • Personally trained new HTML Developers hired from other departments.
  • Managed workflow of new HTML projects for upcoming release cycle by assigning projects to individual developers based on workload, skill set, experience, familiarity with feature, and turnaround time.
  • Wrote new HTML Developer training documentation.
  • Established standardized template coding style guidelines.

REFERENCES: Available upon request.

Hire Now