We provide IT Staff Augmentation Services!

Senior Dba Professional - Tech Ops Resume

SUMMARY:

  • Oracle 11g, 10g Certified DBA (OCP)
  • Highly accomplished, deeply driven Database Administrator (DBA) with a proven track record of 22+ years in progressive management experience, team leadership and technical skills.
  • Hands - on technical leader with extensive experience ensuring the consistent robust performance of large, complex databases
  • Ability to manage multiple complex projects for internal and external customers
  • Dedicated to translating changing business objectives into leading-edge technical solutions that are practical and efficient but also meet or exceed business needs.

TECHNICAL SKILLS:

RDBMS: Oracle, MySQL 5.6, MongoDB, DynamoDB

Languages: SQL, PL/SQL, ‘C’, Bash, Perl, Python

Oracle products: 12c/11g/10g RAC, Exadata V4, Data Guard, 12c Cloud control, 11g/10g Grid Control, Oracle Advanced Replication, OEM, RMAN, Materialized Views

O/S: RedHat Linux, Ubuntu, CentOS, Windows, Solaris, AIX, HP-UX Itanium and RISC, SCO UNIX

Database Tools: Oracle GoldenGate, SQL Navigator, TOAD, SQK Developer, DBeaver

ETL: Informatica v5.1.2, 7.1.4, Ascential Data Stage

Backup Applications: VERITAS NetBackup

PROFESSIONAL EXPERIENCE:

Confidential

Senior DBA Professional - Tech Ops

  • As one of the senior DBAs in the team, responsible for 100% uptime of high-availability production databases running on 11g and 10g RAC and Data Guard.
  • Highly experienced with 12c, 11g & 10g RAC and Data Guard. Support about 20 physical Data Guard installations.
  • Led a successful migration project of legacy databases to Oracle Exadata v4 systems ahead of schedule saving the company thousands of dollars.
  • Experienced in managing Exadata systems and databases.
  • Have built several databases (Oracle and MySQL) on AWS RDS and EC2 systems for a number of cloud applications internally.
  • Extensive experience in Amazon AWS cloud infrastructure especially with database provisioning, security, and management.
  • Have worked with AWS DMS (Data Migration Service) for Oracle Oracle and Oracle MySQL migration and schema conversions.
  • Designated Project Lead for multiple projects within the Tech Ops team 10g-to-11g upgrade, OEM Grid control -CA Insight integration, Oracle GoldenGate setup, DR setup using SRDF/RMAN etc.
  • I am one of the designated OEM Grid Admins in the enterprise managing 4 Grid servers on 10g and 11g that monitors various targets across the enterprise.
  • Led and performed a data migration from Oracle 9i database on HPUX to 12c on 64-bit Linux in a record time using transportable tablespace method resulting in significant cost savings.
  • Performed numerous other data migrations between different architectures.
  • Migrated a few large databases from flash-based backup to Netbackup . Performed end-to-end configuration, tuning and testing backup/restore operations from/to NetBackup.
  • As a senior resource, take part in database availability technology discussions and decision-making processes.
  • Most significant achievement was to have designed a capacity planning/space forecast report with HTML/PHP/SQL/Shell scripts that warns of space utilization in advance so that DBAs can be better prepared for space related shortages. This report increased productivity and saved time by emailing intelligently based on ‘Warning’ and ‘Critical’ threshold values. Won accolades from management and the customer for the report and has been adopted by other teams in the enterprise for use.
  • As a subject matter expert in the team for technologies like RMAN, OEM Grid Control - provided recommendations to improve the current backup systems and improved the existing 10g OEM Grid Control environment to make it easier and efficient to manage.
  • Participated in a DR activity which involved building around 10 DR databases at a remote site using RMAN Data Guard/Duplicate procedure.
  • Utilized SRDF and BCV backup technologies to build DR sites and recover databases with the least downtime.
  • Performed numerous database refreshes from production to non-production through RMAN “Duplicate” method.
  • Instrumental in converting all UNIX cron jobs in multiple Linux servers to OEM GC jobs for easier single-point management and troubleshooting thereby improving team productivity and performance.
  • Possess excellent knowledge and experience of EMC PowerPath and Clarion systems.
  • Supported Oracle GoldenGate software for a few databases. Attended workshop with Oracle Corp.
  • Number of supported databases totals around 150 production and 200 non-prod databases mostly on Linux 64-bit.
  • Possess knowledge in MongoDB having started working on it since May-2016 for new initiatives within Dun & Bradstreet for cloud-based solutions.

Confidential

Expert DBA

  • As a senior DBA in the team, responsible for 100% uptime of high-availability production databases running on 10g RAC and Data Guard.
  • Highly experienced with 10g RAC and Data Guard
  • Performed numerous database refreshes from production to non-production through RMAN “Duplicate” method.
  • Most significant achievement was to have designed a capacity planning/space forecast report that warns of space utilization so that DBAs can be better prepared for space related shortages.
  • As a subject matter expert in the team for technologies like RMAN, OEM Grid Control - provided recommendations to improve the current backup systems and improved the existing 10g OEM Grid Control environment to make it easier and efficient to manage.
  • Participated in a DR activity which involved building around 10 DR databases at a remote site using RMAN Data Guard/Duplicate procedure.
  • Utilized SRDF and BCV backup technologies to build DR sites and recover databases with the least downtime.
  • Instrumental in converting all UNIX cron jobs in multiple Linux servers to OEM GC jobs for easier single-point management and troubleshooting thereby improving team productivity and performance.
  • Project Lead for multiple current projects - 11g upgrade, OEM Grid control-CA Insight integration.
  • Gathered excellent knowledge and experience of EMC PowerPath and Clarion systems
  • Increased productivity by designing a HTML based report to monitor ASM disk space in all the databases which gets emailed intelligently based on ‘Warning’ and ‘Critical’ threshold values. Won accolades from management and the customer for the report and has been adopted by other teams in the enterprise for use.
  • Supported Oracle GoldenGate software for a few databases. Attended workshop with Oracle Corp.
  • Number of supported databases totals around 30 production, 70 non-prod databases.

Confidential

Senior DBA Professional

  • As a Lead DBA, performed Proof-of-Concept testing to migrate around 40 TB of data from Teradata to Oracle Exadata systems
  • Oracle Exadata is Oracle’s solution for Very Large Datawarehouses
  • Exadata is a 8-node RAC/ASM cluster running on Oracle 11g with ~ 350 TB storage, 16 Quad-core CPUs and 192 GB RAM

Hire Now