We provide IT Staff Augmentation Services!

Resume

Lead Database Administrator, NJ

SUMMARY:

  • 15+ years of Oracle DBA experience in Exadata, RAC, HA, Data Guard and ASM with particular emphasis on performance, configuration, database design, problem resolution, backup/recovery and architecture.
  • 22+ years of total IT experience including 8+ years of investment domain experience.
  • Extensive experience in installing, configuring Oracle E - Business suite in a multi-tier, cloning of environments, applying patches and overall system management of E-Business suite.
  • Excellent interpersonal and communication skills, both oral and written.

TECHNICAL SKILLS:

Database software: Oracle 12c,11g/10g/9i/8i/7.x

Cluster Technology: Oracle ClusterWare, Veritas VCS, IBM HACMP

Interconnects: Linux Network Interface Bonding, VLANs

Oracle Software Features: ClusterWare, RAC, Data Guard, ASM, RMAN, Partitioning

Applications: Oracle E-business Suite 11.5.10.2 (Financials), Peoplesoft HRMS 9.1PeopleTools 8.52.08, Quest STAT 5.7.1,ETL Informatica 9.5.1

Operating Systems: Linux, AIX, Solaris, HP UX and windows

Languages: SQL, PLSQL, Unix Shell scripting with SED/AWK, NT Commands, Perl

Server Hardware: Oracle Exadata X3-2,X2-2 Database Machine, HP Server family, Sun Enterprise Server Series, IBM pSeries/iSeries, Compaq, Sun StoreEdge Family,EMC storage family

Monitoring Tools: Oracle Grid Control (OEM), Oracle Application Manager (OAM), Quest Products like Toad, Spotlight, Database utilities like AWR, ASH, statspack, Tkprof

EXPERIENCE:

Lead Database Administrator

Confidential, NJ

Responsibilities:

  • Setup, configure, Support and maintain two-node 12c and 11gR2 RAC databases.
  • Participate in 7x24 on-call rotation, troubleshoot production database problems.
  • Performed Peoplesoft Object migration and Project build.
  • Managed database-related production incidents and coordinated timely responses.
  • Coordinated projects as technical lead; provided design and implementation standards to team members.
  • Interacted with development regarding support requirements. Lead and participated in the database design and review process.
  • Worked closely with different teams to improve uptime, performance and reduce outages.
  • Efficiently managed and directed a team of 3 DBAs to manage OLTP databases and Datawarehouse databases.
  • Designed, configured and implemented Data at rest encryption using Oracle Key Vault 12.2.0.5.
  • Wrote shell scripts for automation of jobs and daily database activities. Created script to backup databases through RMAN.
  • Upgraded 11gR2 databases to 12c databases.
  • Worked closely with development teams for various projects to setup and configure databases.
  • Setup, configure and administer Dataguard for standby databases.
  • Deployed agents for OEM grid control 12c on servers. Setup incidents for metric alerts.
  • Performed point in time recovery and database refreshes through RMAN.
  • Worked on Data Warehousing using Informatica, oracle and OBIEE. Worked on performance issues.
  • Responsible of administration of Informatica server on linux.
  • Provided backup support for SQL server databases.

Lead Database Administrator

Confidential, NY

Responsibilities:

  • Analyze database requirements for Developers and Business Systems Analysts.
  • Defined and implemented production monitoring and management processes for new data warehouse database running on Oracle Exadata X-2 Database Machine.
  • Supported Database administration of single instance on Sun Solaris and Linux machines and RAC databases on Exadata X2 Database Machine of various applications.
  • Managed team of 2 dbas to efficiently perform Database activities in DEV,QA,UAT and PROD environments.
  • Migrated standalone databases to Exadata server.
  • Migrated 11g (RAC) databases from X2-2 to X3-2 new Exadata server by setting up dataguard.
  • Implemented OEM grid control 12c as a single interface for monitoring databases.
  • Created large partitioned tables with hcc compression. setup and configure oracle RAC 11gR2 databases.
  • Quarterly full stack patching and create patching runbook.
  • Used query execution plans, statistics and wait events to examine exadata smart scan and improve performance of applications on Exadata.
  • Create and maintain appropriate documentation as it relates to database creation/implementation.
  • Refined existing processes for easy maintenance and support. Eg. automated rman refresh procedure from prod to non-prod database. Setup export dumps. Implemented rman backup jobs by creating a generalized script. Setup Oracle standby database delay.
  • Wrote script to generate tnsnames from OID.
  • Upgraded databases from 11.2.0.2 to 11.2.0.3.
  • Wrote script to generate tnsnames from OID.
  • Setup standby databases to move 11g databases to a remote site.

Sr. Database Administrator

Confidential, NY

Responsibilities:

  • Supported and maintained JD Edwards application on Oracle 10g and 11g databases.
  • Involved in migrating 10g RAC and NON-RAC databases to 11g RAC and NON-RAC databases
  • Assisted in interviewing and mentoring DBAs.
  • Performed point in time RMAN recovery.

Sr. Database Administrator

Confidential, NJ

Responsibilities:

  • Participate in 7x24 on-call rotation, troubleshoot production database problems.
  • Database administration of single instance and RAC databases for various applications.
  • Plan and implement database migration to Oracle 11gR1 and 11gR2 versions from 10g and 9i databases.
  • Plan and upgraded 10g (RAC) to 11g (RAC) database.
  • Implement RMAN backup and recovery and duplication procedures.
  • Support ASM and converted databases to use ASM.
  • Setup database monitoring and alerts through Oracle Enterprise Manager and shell scripts.
  • Assist developers in tuning SQL and acquiring skills with oracle.
  • Wrote Shell scripts to backup databases through RMAN, to take export dump of schemas,database objects.
  • Wrote Shell scripts to perform regular refreshes from Production to Dev, QA or Release environments.
  • Implement and support Oracle Data Guard 10g.
  • Provide primary support for Oracle APPS (Financial) database.
  • Applied various patches for Oracle Applications as a bug fix or prevention.
  • Designed, built and configured Oracle Internet Directory (OID).Wrote scripts to add tns entry to OID and remove it from OID.
  • Performed administrative task such as forms recompiling, reports regeneration, recreating synonyms, granting privileges, recompiling database objects, activating new modules within the database and the applications etc using adadmin, adaimgr, adpatch, adsplice and rapid install.
  • Work with oracle support for root cause analysis. Test and apply patches suggested by Oracle to resolve those issues. Assisted in interviewing, hiring and training Junior DBAs.

Sr. Database Administrator

Confidential, NJ

Responsibilities:

  • Installation of Oracle & create clustered databases using AIX HACMP technology and Veritas Cluster on Solaris 8.
  • Created materialized views. Refreshed materialized views for data refresh.
  • Implemented and maintained Oracle9i/8i Data Guard/standby databases, in both local and remote locations, for fail-over purposes.
  • Experience with ‘graceful’ switchover and switchback between primary and standby databases.
  • Responsible for handling Authoria content management software on oracle database.
  • Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals. Used Statspack for performance Tuning.
  • Configured RMAN. Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via shell scripting.

Database Administrator

Confidential, NJ

Responsibilities:

  • Implemented Data Guard 9i with one physical standby database.Configured primary and standby databases. Configured Transparent Application Failover in a Data Guard Environment.
  • Performed Switchover and switch back from primary to standby and vice-a-versa. Also performed failover testing.Involved in planning for High Availability. Capacity planning for a database.
  • Installing and configuring oracle databases on Linux. Performance tuning of database using STATSPACK.
  • Tuning of shared pool, buffer cache, redo mechanisms. Distributed I/O to reduce contention of disks.

Database Administrator

Confidential, NYC

Responsibilities:

  • Logical and Physical Design of Databases.
  • Cronjobs setup and Shell Scripts for hot and cold backup. Implemented Hot and cold backups through Veritas NetBackup.
  • Identified worst performing SQLs and rewrite, index or otherwise tune for high performance. Extensively used Explain Plans for SQL statement tuning.
  • Capacity planning for new and changing databases.
  • Installing and configuring oracle databases, Oracle 9iAS Server and Webdb on Unix and NT platforms.
  • Performance tuning of databases and applications. Sizing databases and data-dictionary maintenance.
  • Wrote shell scripts to automate checking of Space utilization, control of contention for resources.
  • Tuning of shared pool, buffer cache, redo mechanisms. Distributed I/O to reduce contention of disks.
  • Upgraded Discoverer 3.1 to 4.1. Upgrading Application server from 4.0.8.1 to 9i, Webdb from 2.1 to 2.2.
  • Migrating sites of webdb from Windows NT to Sun Machine.

Hire Now