Atul Agarwal PMP

Product Engineer

Overland Park, Kansas, United States31 yrs 8 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • 20 years of experience in database administration
  • Expert in database migrations and performance tuning
  • Led offshore and onshore outsourcing initiatives
Stackforce AI infers this person is a Database Administration expert with extensive experience in enterprise-level database management and migrations.

Contact

Skills

Core Skills

Database AdministrationCloud Database ManagementDatabase MigrationDatabase DesignData IntegrationDisaster Recovery PlanningOutsourcing ManagementPerformance OptimizationHigh Availability Solutions

Other Skills

AWS AuroraBackup and recoveryBackup and restoreBusiness IntelligenceData ModelingData WarehouseData WarehousingDatabase installationDatabase managementDatabase supportDatabase upgradesDisaster RecoveryETLEnterprise ArchitectureGolden Gate

About

• Oracle Certified DBA with 20 years of experience. Provided full life-cycle support of large Oracle, MS SQL, DB2 Server environments supporting key mission critical applications for Fortune 1000 companies. • Proven expertise in area of Database migrations due to technology change or application migration (dedicated to virtual, Unix to Linux, HP & Sun to IBM, Data Centers and Application consolidation) • Played key role in offshore and onshore outsourcing initiatives for Sprint, IBM and Ericsson. Adept at interacting with business managers, project managers, developers, vendors and technical support. • Outstanding performance tuning and troubleshooting skills for very large databases with high performance along with high availability (Local & Geo) failover, backup and recovery needs. Technical Summary: Database Technologies: Oracle (12c/19c), AWS Aurora/MySql, RAC, Data Guard, ASM, RMAN, MS SQL Server (2008/2005), DB2, Goldengate Operating Systems: IBM AIX 6.1/5.1, Solaris 10, HP-UX 11i, Linux (Red Hat 6.x), Windows Server Database Tools: Grid Control 12c, DBArtisan, Erwin, Data Pump, SQL Developer, TOAD High Availability: Grid infrastructure (GI), Oracle Clusterware (CRS), Datagaurd, HP Service Guard, Veritas Cluster, EMC Isilon Snapshot, Goldengate. Application Packages: NetCracker, PeopleSoft (Finance and HR), CRM (Siebel), Amdocs Ensemble Billing Suite, Cerner Millennium (Health-Care), Clarify, Oracle Apps Languages: SQL, Oracle PL/SQL, Unix Shell Script (ksh), Pro* C, Perl

Experience

Enterprise

Sr Oracle/AWS Database Administrator

Dec 2014Present · 11 yrs 3 mos · Greater St. Louis Area

  • Supporting Oracle 19c and AWS Aurora/Mysql/Postgres Databases for 6 mission critical applications.
Oracle 19cAWS AuroraMySQLDatabase AdministrationCloud Database Management

Sprint

Sr. Database Administrator

Jan 2007Oct 2014 · 7 yrs 9 mos · Overland Park, KS

  • Designed, developed and implemented mission-critical databases for Sprint. Managed over 250 different databases of varying sizes and complexities for over 30 applications. Provided expertise in full life-cycle database support, complex technology migrations and offshoring initiatives. Tenure included 4 years with Sprint and 3 years with Ericsson which was as an outsourcing partner to Sprint.
  • Responsible for the day to day operations of development, test and production databases in a 24/7 on-call environment. Led the design, configuration, installation, patching, upgrading, troubleshooting and management of the databases.
  • Implemented Backup and Restore procedures using RMAN, export/imports, data pump, Isilon snapshot etc.
  • Created databases using Oracle ASM (Automatic Storage Management).
  • Managed users, security, redo logs, materialized views, jobs, partitioning, and DDL installations.
  • Troubleshooted problems and performance issues utilizing built in Oracle tools such as AWR report etc.
  • Supported PeopleSoft Finance and HR on RAC and Data Guard environment.
  • Designed and implemented Replication of PeopleSoft using Mviews for Data Warehouse.
  • Upgraded many Oracle 9i/10g databases to 11g databases.
  • Supported Sql Server Databases.
  • Trained new offshore DBAs in India and Brazil.
  • Installed OEM 12c Cloud Control on databases.
Database designDatabase managementRMANOracle ASMPeopleSoftDatabase Administration+1

Cerner corporation

Database Administrator

Jan 2006Dec 2006 · 11 mos

  • Maintained 50 medium and large databases for 30 different hospitals independently. Received award for performing the work without downtime with advance and detailed planning.
  • Provided support for around 10 Oracle RAC databases on both IBM AIX and OpenVMS 7.1 operating systems. Support includes on call support, troubleshooting problems, working with Oracle Support when necessary, and implementing problem resolutions.
  • Worked with Oracle Partitioning Option to segregate data and facilitate purging of rolling data.
  • Installed Oracle software and build new Oracle databases on a regular basis.
  • Worked on planning and implementation of disaster recovery using and RMAN Backups and data guard.
  • Was an active member of DBA standards committee for the enterprise. Suggested, documented and implemented suggested improvements.
Oracle RACOpenVMSDisaster RecoveryDatabase AdministrationDisaster Recovery Planning

Ibm

Lead DBA

Sep 2004Dec 2005 · 1 yr 3 mos

  • Played key role in transition of the database support to offshore teams across 3 continents by developing the detailed hand over plans and production support manuals. I am also responsible for coordination between on site and offshore teams for several outsourced projects.
  • Provided second level DBA support for 6 mission critical applications (50+ databases) when offshore DBA team could not resolve the issues.
  • Expertise in technical walk through of new database designs with the offshore project teams to ensure satisfaction of technical standards, hardware and capacity planning and client requirements.
Database supportTechnical documentationDatabase AdministrationOutsourcing Management

Sprint

Database Administrator

Sep 2001Aug 2004 · 2 yrs 11 mos

  • Provided full life cycle DBA support for several mission critical applications in the area of Network, billing, customer care, sales, finance databases (80+ databases, 100GB-5TB size) for wireless division of Sprint.
  • Implemented appropriate backups & recovery strategies for a VLDB (>4TB) using EMC Time Finder (BCV), the same script was used to build the data barn for reporting purpose.
  • Received Sprint Values Excellence award in recognition of exceptional customer satisfaction for a billing project by troubleshooting of performance issues involving multiple applications with the knowledge from different applications and functional areas.
  • Member of database standard committee to develop and recommend new and revised Database standards, policies and procedures for the data management group. Developed database implementation methods for H/W and S/W upgrades without impacting the application availability.
  • Designed and Implemented high availability solution using Oracle 9.i for a retail management application used across 2000+ Best Buy, Circuit City and Radio Shack stores..
  • Worked on Golden Gate for replication.
Backup and recoveryPerformance tuningGolden GateDatabase AdministrationPerformance Optimization

Marsh & mclennan companies, inc.

Database Administrator

Feb 2001Sep 2001 · 7 mos

  • Supported Oracle and Sql Server databases with 24 x 7 on-call rotation. Designed and implemented backup and restore process and off-site tape storage for critical databases.
Backup and restoreTape storageDatabase Administration

Michelin

Database Administrator

Jan 2000Jan 2001 · 1 yr · Greenville, South Carolina Area

  • Responsible for installing, upgrading and configuring the Oracle environment by creating multiple databases, storage structures, database backup and recovery, monitoring and optimizing database performance.
Database installationPerformance monitoringDatabase Administration

Umb bank

Database Administrator

Aug 1999Jan 2000 · 5 mos · Kansas City, Missouri Area

  • Provided full life-cycle support for online (Scout) and warehouse (SAP) Oracle environments. Worked on Y2K intensive data testings.
Database supportY2K testingDatabase Administration

Micron technology

Database Administrator

Jul 1997Jun 1999 · 1 yr 11 mos · Boise, Idaho Area

  • Worked as Oracle Apps (EBS) and Clarify DBA. Provided development, test and production support. Worked on application and database upgrades.
Oracle AppsDatabase upgradesDatabase Administration

Blue dart express limited

Database Administrator

Oct 1993May 1997 · 3 yrs 7 mos

  • Provided lead oracle DBA support for big projects like cargo booking system and online shipment tracking system.
  • Trained technical support and operations personnel in the use of applications and day to day DBA activities.
Lead DBA supportTrainingDatabase Administration

Education

.

Bachelor of Science (B.S.)

Stackforce found 100+ more professionals with Database Administration & Cloud Database Management

Explore similar profiles based on matching skills and experience