We provide IT Staff Augmentation Services!

Sr.oracle Dba Resume

NY

CAREER SUMMARY:

  • Sixteen years of Information Technology experience including ORACLE Database Administrator (12 years), Database Developer (4 years), Data Modeling and SDLC (2 years), Data Warehouse (3 years), Project Management & Application Integration (4 years), Database Administration, Performance Tuning and Optimization (12 years), Distributed Databases and Replication (3 Years), Heterogeneous Services(2 years), High Availability (7 years), Disaster Recovery (4 years), Installation, upgrade and Migration (10 years), Application Design, Development and Implementation (4 years), Backup and Disaster Recovery (8 years), 24x7 production database support - on-site and remote (7 years), Application/Web Server Administration (3 year), Team Management (4 years).
  • Performed the role of Sr. DBA / Project Coordinator and successfully implemented critical hands-on technical solutions for various clients - Healthcare/Pharmaceutical companies, financial industry, and media industry and web portals.
  • Also worked for Mail Stream Technology company. Implemented projects utilizing Enterprise Client/Server Methodology, 3-tier Web-enabled Applications, On Line Transaction Processing (OLTP) system, Batch Processing System, Decision Support System (DSS), Data Warehousing System, distributed database systems.
  • Expert in all aspects of architecting Confidential database, designing High Availability systems for 24/7, and administration functions including physical database design and implementation, RDBMS install and configuration on IBM AIX, HP-UX, Linux, Sun and Windows. Oracle Database Administration including installation and maintenance of the database (backup, recovery, tuning, security, capacity planning). Determining the design of the system hardware, software, configuration, and network required satisfying the business needs of the client.
  • Detecting and diagnosing production system performance problem by, ASH report, AWR Report, Oracle Statspack, Analyzing Oracle trace file, Analyzing SQL statements, Measuring system and database activity, Querying Oracle dynamic performance views; Tune Database and Applications by shareable SQL statements, bind variables, detect contention and deadlocks, Pin large packages and procedures, optimize initialization parameters and operating system variables, I/O distribution and striping, optimize redo logs, rollback contention and archive process, Optimize latch contention in the shared pool and buffer cache, Optimize locks and enqueue contention, Tune SQL*NET, pre-compilers and OCI; SQL statement tuning using SQL Advisory, TKPROF, SQL Trace and EXPLAIN PLAN tools. Operating System specific kernel tuning and memory tuning, Database analysis using Oracle Enterprise Manager for database performance tuning and dynamic view tables and self made SQL, PL/SQL code, Shell/PERL Scripts.
  • Designed and implemented Multi-Master Symmetrical Replication system, read-only and updatable materialized views replication system along with Oracle Heterogeneous Service for pharmaceutical clients. This includes data recovery and performance enhancement for parallel propagation.
  • Design and Implemented Oracle 10g Rel2 Data Guard ( Physical Standby ) along with Switchover/Back, and Failover process across the different platforms (HP-UX, AIX, Windows, Linux) for the mission critical OLTP/DW Application with 24*7 uptime, HA..
  • This includes load balancing and failover strategies. Design, Installed, Configured and Implemented Oracle 10g Rel.2 Real Application Cluster ( RAC) on Windows-2003 Servers with 24 x 7 uptime, scalability and high availability.
  • Successfully Implemented all versions of Oracle 8.x, 8i and 9i, 10g, 11g Installation, Upgrade and Migration process on Windows and Unix environments.. Supported various database upgrade projects across the platforms like, HP-UX to AIX. Participated in testing Oracle 9i/10g new features. Successfully rolled out and managed “CPU Patching “ project include deployment of various Oracle Security-CPU patches, Back Port like Patch set, Interim patch, and DST patches across the production (OLTP, HYBRID) and non-production database landscape.
  • Implemented clients’ in-house and third party applications and utilized Oracle Case tools, Third party case tools, Oracle SQL, PL/SQL. Designed and implemented complex user interface and reports with Developer-2000 Forms and reports. Performed data-migration activities between Oracle and SQL Server databases with Oracle SQL Loader, External tables, UTL FILES, Oracle Heterogeneous service, Linked server and DTS.
  • Implemented robust hot backup strategies using home-grown shell scripts, SQL Backtrack and RMAN/TSM, Data Pump (EXPDP/IMDP) and EMC-SERD. Evaluated Disaster recovery options and implemented business continuity plans. Planned and coordinated DR drills.
  • Led Confidential team providing 24x7 remote DBA support to various clients. Implemented monitoring scripts using Windows Scheduler, UNIX shell and SQL with automatic paging to DBA. Provided production support to over 4000 database instances spread over 1000+ servers worldwide. Liaison with Oracle Corporation customer support for critical issues, bug fixes and back ports.
  • Feasibility study, business requirements, technical design and analysis, application module development using SQL, PL/SQL. Testing, integration testing, system testing and implementation of the database and application system.
  • Designed, optimized and implemented databases for DW platform. This includes Data Model and Re-Architecture for Complex Data Warehouse and Data Mart, Tuning of ETL Jobs, Queries against large volumes of data, Highly complex queries, Intense load activity, Optimized data access by tuning redo logs, temporary tables and Oracle parameters; Optimized system load by using Parallel Query option, usage of Partition tables, partition exchange to implement rollover windows, Bitmap indexes, Bitmap join indexes, Direct Path, Data Pump, Function-based indexes, Materialized views, Parallel analyze, Parallel DML, Parallel Index build, Monitor Network traffic, Heavy I/O usage, redo logs, rollback segments and large amount of memory.
  • Installed, Configured, Applied patches and deployed various web-application on production/staging servers like IIS 4.0, IIS 5.0, IIS 6.0, Apache 1.3, 2.0, Tomcat-Jakarta 3.2.4, 4.0.25, Oracle9iAS, Oracle10g AS, Jrun 4.0.1sp1 on RedHat Linux, Sun-Solaris & Windows-2000 Advanced servers. Implemented Data-Farm, Clustering for OC4J, Infrastructure and Business Intelligence with Oracle9i/10g Application Server. Configured various protocols like Telnet, Ftp, SAMBA, NFS, UUCP for Linux and Windows.
  • Designed, optimized and implemented OLTP platform for various clients this includes, large number of users management, response-time constraints, data is accessed with both read and writes, continuous uptime, optimized data access by tuning redo logs and oracle parameters, optimized system load by significant number of process switches, Heavy network traffic, Heavy I/O usage, Heavy redo log usage, Heavy use of rollback segments and large amount of memory.

EXPERIENCE

Confidential, NY

Sr.Oracle DBA

Responsibilities:

  • Design and developed robust queries against OEM metadata repository to get extract of database inventory.
  • Architect and Design OEM 12c architecture with DR capabilities.
  • Resolved database performance issues for various production issues.
  • Worked with Oracle Support on multiple SRs,
  • Developed Unix shell scripts to redirect critical database alerts to iPhone.
  • Implemented Oracle 11g R2 SCHEDULER for jobs automation and converted DBMS JOBS into SCHEDULER.
  • Implemented RMAN backup strategy for enterprise databases.
  • Performed Instance tuning and SQL tuning with ASH, AWR, ADDM and various Advisories.
  • Supported application developers for fine tuning SQL statements.
  • Recommended and implemented Oracle Best Practices
  • Resolved data replication issue across applications.

Environment: Oracle 10g, 11g, RedHat Linux 5.0, HP-UX 11.x

Confidential, NY

Sr.Oracle DBA

Responsibilities:

  • Perform database upgrade from 9.2.0.8 to 11.2.0.2 for 1.5 TB of OLTP database
  • Migrated 1.5 TB of production database from WINDOWS-2003 to Red-Hat Enterprise Linux 6.2 with Advance Data Pump.
  • Evaluated various options for Cross Database Platform Migration with minimal downtime.
  • Performed complex Query optimization in 11.2.0.3.5 to support post database migration performance issues.
  • Generated 10046/100053 traces for bad performing queries and worked very closely with Oracle-Support.
  • Implemented Oracle 11g R2 SCHEDULER for jobs automation and converted DBMS JOBS into SCHEDULER.
  • Designed and Developed database script with DBMS METADATA to fetch metadata for logical objects.
  • Supported Database POLICIES tagged with Fine-Grain-Access control (FGA) and resolved wrong dataset issue.
  • Installed/Configured/Implemented Oracle 11g Transparent Gateway (Heterogeneous service) for MS-SQL and QB databases.
  • Extracted DG40DBC and HSODBC traces with TRACE level 255 and worked with Oracle-Support to troubleshoot issues.
  • Installed/Configure 11.2.0.3 binaries and databases on Windows-2008 and Red Hat Enterprise Linux platforms.
  • Successfully implemented Transparent Application Failover (TAF) For Data guard Connections using Database Services
  • Setup Data guard for 10g and 11g production databases to provide the DR capability.
  • Configured Oracle 11g R2 ( 11.2.0.3.5 ) Active Data Guard to facilitate Reporting Application users.
  • Performed critical Data guard Recoveries for VLDB database for missing Archive Logs.
  • Performed critical recovery for Physical Standby database with ORA-26040 for No-Logging transactions/operations.
  • Successfully implemented Snapshot Standby Database for 11g R2 databases.
  • Performed Data Guard Role Transition for Switchover and Switchback.
  • Configured Flash Back Database (FDB) for 11.2.0.3 critical production database.
  • Implemented RMAN backup strategy with Backup-Based and Active Database solution.
  • Performed Instance tuning and SQL tuning with ASH, AWR, ADDM and various Advisories.
  • Supported application developers for fine tuning SQLs during application testing for 11g migrated database.
  • Installed, configured and implemented log mining for table recoveries.
  • Recommended and implemented Oracle Best Practices

Environment: Oracle 9i,10g, 11g, SAN, RedHat Linux 6.2, Windows-2003/2008

Confidential, Rahway, NJ

Client Facing DBA

Responsibilities:

  • Worked on the assigned projects for the entire life cycle and added value by recommending oracle features that will assist the projects and deliverables to be more efficient.
  • Performed database design, data modeling and database architecture.
  • Performed Instance tuning and SQL tuning with ASH, AWR, ADDM and with various Advisories.
  • Support Application owners, Resolve and Troubleshoot Application issues, Tune database and Application performance bottlenecks.
  • Supported advanced bi-directional replication with Materialized Views and Snapshot.
  • Implemented Oracle High-Availability features like Data guard and Standby databases.
  • Implemented Oracle 11g Transparent Gateway (Heterogeneous service) for MS-SQL Server.
  • Implemented Oracle Jobs and Schedulers to automate the business logic code.
  • Installed, configured and implemented log mining for table recoveries.
  • Supported 11g and 10g RAC and ASM environments on Solaris and HP-UX.

Environment: Oracle 10g, 11g, ASM, Solaris 8, HP 11.x

Confidential, Stamford, CT

Sr. Oracle DBA

Responsibilities:

  • Installed and configured Oracle 10g Rel 2 10.2.0.4 and 11.0.1.7 on AIX, Linux, Wintel
  • Supported all missions critical (OLTP, DW) instances on Oracle.
  • Installed, Configured 6 site with 2 node RAC on Windows-2003 along with EMC-SAN/OCFS.
  • Worked on Oracle-RAC Assessment towards production environment with 99.99% Uptime.
  • Installed, Configured and Supported Physical Standby (DG) with Switchover/back and FAILOVER.
  • Converted Standby databases into Physical Standby databases.
  • Online and offline backups, DB Refresh & DB Cloning with RMAN/SRDF and Scripting backups.
  • Performed huge upgrade/migrates from 9. 2.0.8 to 10.2.0.4.
  • Install and applied Critical Oracle CPU patch for all production 9.2.0.8 and 10.2.0.4 databases
  • Key Contribution towards Oracle-Security projects ( App-Detective, RSA rollout, DB-Audits, e.t.c )
  • Participation in PB-Isolation Drill and Infrastructure-weekend assignment
  • Configured Monitoring and Housekeeping scripts across the database-servers.
  • Tuned database and application performance with homegrown shell scripts and Oracle utilities Like ExplainPlan, TKProff and Statsspack.
  • Monitored database health using tools like MM, TOAD, OEM and SPOTLIGHT
  • Provide on call DBA support on rotation basis.
  • Install Oracle Database Software, Install different database options like JVM, OLAP etc, and Apply patch sets and create databases,
  • Install Oracle Agent for Grid Control Monitoring

Environment: AIX, Oracle 9i/10g/11g, RAC, DG, RMAN

Confidential, Stamford, CT

Sr. Oracle DBA

Responsibilities:

  • Installed and configured Oracle 9.2.0.4, 9.2.0.6, 9.2.0.8, 10.2.0.2 on Solaris 8.0/10
  • Supported all mission critical (OLTP, Hybrid) instances on Oracle.
  • Online and offline backups, DB Refresh & DB Cloning with SQLBackTrack 5.6 and Scripting backups.
  • Performed huge upgrade/migrates from 9.2.0.4 to 9.2.0.8 and to 10.2.0.2
  • Participation in Confidential -Isolation Drill and Infrastructure-weekend assignment
  • Performed mission critical 10g upgrade for production databases with Data-Guard
  • Configured Monitoring and Housekeeping scripts across the database-servers.
  • Restoration management activity hot and cold
  • Installed, configured ImportHUFS on production database servers.
  • Tuned database and application performance with homegrown shell scripts and Oracle utilities Like ExplainPlan, TKProff and Statspack.
  • Monitored database health using tools like MM, TOAD, OEM and SPOTLIGHT
  • Installed configured and supported Oracle 8i Standby and 9i Data-Guard support..
  • Provide on call DBA support on rotation basis.
  • Execute Service Requests like creating users, assigning roles etc, Writing procedures to automate DBA jobs and scheduling reports. Used Remedy, GRS, GCMS for Change Control Management.
  • Performing Data warehouse operations like Loading Data into Warehouse using SQL*LOADER into temporary table, Exchange table with table partition, Rebuilt indexes and Gather Statistics after loading data.

Environment: Solaris 8/10, Oracle 8i/9i/10g, Oracle 9iAS

Confidential, New York

Sr. Oracle DBA

Responsibilities:

  • Installed and configured Oracle 9.2.0.1, 10.2.0.1. Also configured Oracle 10 Grid Control Release.10.2.0.2
  • Supported all mission critical (OLTP, Hybrid) instances on Oracle and SQL Server 2000.
  • Online and offline backups, DB Refresh & DB Cloning.
  • Restoration management activity hot and cold
  • Tuned database and application performance with homegrown shell scripts and Oracle utilities Like ExplainPlan, TKProff and Statspack.
  • Monitored database health using tools like TOAD, OEM and SPOTLIGHT
  • Installed configured and supported Oracle 8i Standby and 9i Data-Guard support.
  • Wrote documentation for installation of 10G and 10G grid.

Environment: HP-UX 11i, Oracle 8i/9i/10g, SQL-Server-2000

Confidential

Sr. Oracle DBA

Responsibilities:

  • Installed configured and Supported over 25 Oracle instances (Production, Development, and QA) running on RedHat Linux AS 4.0, Solaris 9.
  • Installed configured and support Red-Hat Linux AS 4.0, SLES 9.0 on staging & production servers.
  • Installation and configured Oracle APPS 11.5.10 under RedHat Linux Advanced Server 4.0.
  • Used OEM, SpotLight, STATSPACK, and other Enterprise monitoring Tools for database monitoring.
  • Responsible for performance tuning of all database instances using Explain Plan, TK Prof.
  • Used RMAN for backup and recovery.
  • Installation of Oracle 9iAS/10gAS for website deployment

Environment: RedHat Linux AS 4.0, SUSE Linux 9.0, Solaris 9, Oracle 9i, Oracle 9i/10g Application Server, Oracle Apps 11.5.10.

Confidential

Sr.Oracle DBA

Responsibilities:

  • Gave 24 x 7 production support to 100+ mission critical databases running either at offshore or at Onsite on high-end server (upto E10k)
  • Responsible for Instance creation, deletion, Logical & physical design of the databases.
  • Upgraded 15 Oracle OLTP instances from 8i to 9i
  • Upgraded 3 Oracle OLTP/Hybrid instances from 9i to 10g.
  • Installed configured and supported Oracle versions 10g, 9.x, 8.x on RedHat Linux and SUN Solaris.
  • Maintained database environment (OLTP/HyBrid) with database sizes ranging from 50GB to 400GB+.
  • Supported offshore setup of Oracle 10g with Automatic Storage Management (ASM).
  • Successfully completed Performance tuning assignment for Max-New York Life Insurance with database size of 250GB with 150 concurrent users hosted on SUN Solaris 9.0.
  • Strictly followed Change Control management, SEICMM-5, BS7799 guidelines.
  • Installed configured and optimize RedHat Linux Advanced Server 2.1/3.0/4.0 & ES 3.0 for 10+ servers.
  • Worked extensively on Oracle Statspack report, collecting statistics, generating & analyzing statspack report for Performance Monitoring and Tuning.
  • Physical Hot & Cold backup/recovery with Logical backup/recovery(Export/Import)

Environment: RedHat Linux AS 2.1/3.0/4.0, Oracle 9i, 10g, Oracle 9i/10g Application Server, Apache 2.0, SunOne Web Server 7.0, SAMBA, NFS

Confidential

Oracle DBA

Responsibilities:

  • Installation and configuration of Oracle 9.x, 8i, 8.x on RedHat Linux AS 2.1/3.0, ES 3.0, SUN-Solaris 8/9 and Windows-2000 Advanced servers.
  • Maintaining 260+ Oracle databases deployed across 40 Unix servers & 15 Windows server, aggregating more than 5.5 Terabytes of data with more than 1200 users accessing concurrently.
  • Planning and implementing Backup strategy for the databases using Veritas Netbackup, RMAN, Scripting backup.
  • Detecting and diagnosing production system performance by analyzing Oracle trace, log files, analyzing SQL statement, measuring system and database activity, Querying Oracle dynamic performance view. Optimization of various initialization parameters, batch processes with Tkprof, SQL Trace and explain plan.
  • Install and configure RMAN, Veritas NetBackup for Backup and Recovery. Scheduled daily backups and performed periodic recovery tests.
  • Done regressive performance tuning with Oracle Statspack for production performance problem.
  • Configuration of various production web-application servers like Apache 1.3/2.0, Tomcat-Jakarta 3.2.4/4.0.25 , Jboss 4.1sp1, Jrun 3.5, Oracle9iAS across the Unix & Windows to support web based 3 tier applications.
  • Configured SAMBA between Linux and Windows for smooth data-communication.
  • Installed, configured and managed 5+ installation of SQL Server - 2000 with support to 8+ SQL Server-2000 databases hosted on Windows-2000 Advanced server.
  • Integration of Apache with servlet engines like Tomcat-Jakarta and with SUN JDK software.
  • Managed NFS, UUCP & War-FTP.

Environment: RedHat Linux AS 2.1/3.0, ES 3.0, HP UX 10, SUN Solaris 2.8/2.9, Oracle 9i, 8.x, 7.3, SQL Server- 2000Veritas Netbackup, Oracle 9i AS, Apache 1.3/2.0, Jrun 4.1sp1, Tomcat-Jakarta 3.2.4/4.0.25 , SAMBA, NFS

Confidential

Software Consultant/Oracle Developer

Responsibilities:

  • Involved in database designing based on the requirement gathered from client.
  • Developed technical specification for various modules.
  • Developed complex database stored package, stored procedure, function, triggers.
  • Involved in designing Oracle forms, reports and graphics.

Environment: SUN Solaris 2.8, Developer-2000 6.0, Oracle 8.0

Confidential

Oracle Developer

Responsibilities:

  • Developed stored package, procedure, function, triggers, SQLs.
  • Involved in designing Oracle forms, reports and graphics.

Environment: SUN Solaris 2.8, Oracle 7.3, Developer/2000 2.0.

Hire Now