SUMMARY

• Fifteen (15) + years of experience in IT industry as a Database Administration in production & development environments. Possess a track record of success delivering quality databases work on time.
• Experience in IBM DB2(LUW), Oracle 11g|12C RAC, NON - RAC databases including database migration, database performance and exposure to AWS, Exadata, OEM12c|13c, Oracle12c multitenant database management and noSQL databases.
• Experience in Database Project Security Compliance Analysis, negotiating timelines requirements, Installation, Upgrade, Migrate, Convert and administration of Oracle Database versions starting from 7-10g/11g/12c (VLDB, support 24x7) including RAC Databases, Exadata, Compression, ILM, ITIL, Golden Gate, Flashback, TDE, VPD, Oracle Text, Intermedia, physical Standby Databases, Dataguard, RMAN and meets SLAs and timely project deliveries.
• Architected, Built & maintained Oracle RAC (ASM Real Application Cluster), Non-RAC (ASM) and File System based databases of varying sizes.
• Migrated Oracle 11gR2 RAC databases and non RAC databases to in-house Datacentre & AWS.

TECHNICAL SKILLS

Hardware: AIX, HP, Sun E25K, EMC, Exadata, EVA, Dell PowerEdge, Compaq Proliant, Intel, Gateway.

Operating Systems: Sun Solaris E25K, HP-UX, Mobile Laptop, SFRAC, Exadata Linux, EMC, EVA, XP Storages, OEL, Red Hat Linux Advance Server, Windows NT/2000/2003/2008; AIX (IBM) Unix, Raid 10 Raid 5, VMs, Raw Devices, ASM, CLI, ACFS, RAC.

Traditional RDBMS/Servers: Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, RAC, Oracle 9i, 9i AS, Oracle 8x, OEM, Grid, Flex, SQL Server, MS Access, BI, My SQL, DB2, Sybase IQ, AES, ADABAS, MongoDB, Cloud Control.

Exposure: Apache, Hadoop, Netezza, Exadata, Big Data, NoSQL, Cassandra, Mongo, PostgreSQL

Languages/Tools: SQL, PL/SQL, AWS RDS, UNIX Shells, Cronjob, KSH, SED, AWK, BMC Patrol, Informatica, CRS, Scan, Smart Scan, Storage Index, CLI, OEM, Wallet Manager, RMAN, EUS, ERP, FRA, Data Guard, Streams, Golden Gate, ORAPKI, Flyway, ER-Studio, Advent Net SwisSql, Erwin, eProgessa, SqlNet, TOAD, Talend, Autosys, Embarcadero DBArtisan, ER Architect, Change Manager, VBnet, Rapidwiz, ASPNET, Visual Studio, Java JDBC, JQuery HTML CSS XML XSLT, MDM, HP Quality Center QA testing, SQLT, Precise, Confio, Visio, SSMA, SQL Developer, ODSM, Directory Manager, Apache Studio, SQL*Plus, DCLI, IORM, RCA, RCU, Jira, SharePoint, Kronos, SQLways, Remedy, & Wily.

Application Servers: Oracle 10g/11g Internet Directory (OID), OAM, SSO, Content Management, Oracle 11g Fusion Middleware, Weblogic, Tomcat, PeopleSoft, SAP, WebCenter Portal, Oracle E-Biz (EBS) R12

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

Database Administrator

Responsibilities:

• Provided Database service to IBM DB2 databases and Oracle 10g, 11gR2 replacement project databases on Infinite contract project as an Oracle Database Administrator on-site and on-call support to High Availability Databases (Exadata) and Oracle Goldengate.
• Experience design of Oracle Schemas, tables, triggers, packages, procedures, DB links, views, sequence, constraints, and indexes.
• Provided services to COTS(EMPTORIS), MMIS HADR applications and Other applications.
• Provided Database services to datacenter move.
• Provided services to Data Refresh activities and services to patch/upgrade/migration of databases.
• Performed tablespace recovery, data set recovery and transaction recovery under various circumstances.
• Involved in capacity planning and storage management along wif the system administrator.
• Efficiently carried out DBA responsibilities in planning DB2 / Oracle version migration activities, in migration phases and in performing post migration tasks.
• Monitored and managed DB2 thread and locking issues.
• Involved in granting various authorizations and privileges to different users.
• Proactively monitored and performed daily maintenance activities.
• Produced and analyzed DB2 performance reports.
• Ensured proper backup and recovery by maintaining DB2 image copies and recoveries.
• Performed data maintenance using LOAD, UNLOAD, REORG, RUNSTATS.
• Worked on RMAN Backups, Data Pump, Logical, Physical Backups, Tape NetBackup’s & recovery
• Tuned Performance of SQL queries used in Oracle, Informatica & reporting Cognos and CTRL+M
• Provided 24x7 production support to Goldengate, IBM DB2 LUW & Oracle databases, HIPPA (PHI & PHII) compliance databases and applications support.

Confidential, Bellevue, WA

Database Project Advisor | Administrator

Responsibilities:

• Expertise in Oracle Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.
• Expertise in cloning, patches, up gradation, migration, troubleshooting, space management.
• Expertise design of Oracle Schemas, tables, triggers, packages, procedures, DB links, views, sequence, constraints, and indexes.
• Maintained no SQL Cassandra databases.
• Oracle Golden Gate implementation for Site to Site Replication.
• Excellent communication skills, day to day maintenance activities, automation, Jira, OEM, PIER, WO, MOP documentations, Datapump, Dataguard, OEM, SQLT, VMSTAT, IOSTAT, MPSTAT, Tracing positive problem-solving skills and team building.

Confidential, Mt Laurel, NJ

Oracle Database Administrator

Responsibilities:

• Provided services to Commercial Price Quote clients as an Oracle Database Architect/Administrator, short contract project, providing on-site and on-call support to High Availability Databases.
• Architect, Built & maintained Oracle 11gR2 RAC Cluster wif Physical Standby active databases and Data Guard
• Migrated Oracle 11gR2 RAC databases and non RAC databases to in-house Datacenter.
• Developed Oracle PL/SQL Packages to Scrub Data to refreshes internal lower environment databases and Data Masking.
• Team member and work well wif all levels of business & Oracle Advance Technology Team

Confidential, Rockville, MD

Database Administrator

Responsibilities:

• Provided day to day database admin activities to stabilize database automation and includes installation of Oracle 11g R2 Databases, and administration of Postgress migrations, AWS (EC2) managing Oracle Databases and Patches to single instance databases.

Confidential, Rockville, MD

Database Administrator

Responsibilities:

• Installation, Configuration, Maintenance and Documentation of Development, QA, Test & Production Oracle 10g|11g|12c RAC Databases, non-RAC databases and Golden gate but not limited to IBM DB2, SYBASE ASE & SQL Server (2005/2008).
• Supported not limited to various large size databases, Virtual Machines and Oracle 11g Fusion Middleware products & Oracle Internet Directory
• Involved in installation & configuration of noSQL & SQL Server, monitoring database in Production, Staging & Development environments, Performed Production support and on Call duties & involve in migrations from Oracle Databases to SQL Server vice versa.
• Installation, Configuration, Maintenance and Documentation of Oracle Databases and Fusion Middleware's Oracle E-Biz r12, Oracle Internet Directory (OID/OVD).
• Expertise in conversions of single instance Oracle 10gR4 (OID) databases to Oracle 11gR2 RAC databases.
• Provided 24 X 7 Support for Oracle Databases (ODA) on rotation and carried blackberry.
• Expertise in maintaining & configuring RAC clustered and non-cluster databases.
• Worked on cross platform Oracle Database Migrations, Conversions, Upgrades and Patching.
• Worked on multi-master replication technologies using ASR, LDAP and Golden Gate (OGG).
• Worked on Oracle Advance Security (ASO) using SOX compliance Transparent Data Encryption (TDE).
• Worked on Data guarded Physical Standby Databases and explore Active Data Guard.
• Worked on Load Balancing, Observer, FSFO, Flashback, (TAF) Transparent Application Failover.
• Worked on Database Partitions, Transportable Database, Tablespaces, moving reorg objects.
• Worked on RMAN Backups, Data Pump, Logical, Physical Backups, Tape NetBackup’s & disaster recovery.
• Worked on created & Modified ASM disk groups and space management.
• Linux/ UNIX operating system, Bash shell scripting experience for database tasks & reporting.
• Extensive performance tuning of web-based Database applications, partitioning and recommendations of code enhancements includes Large objects (LOB) and secured files.
• Management of web applications safety and sensitive PII information including confidential License, Credit, SSO, CRM, ERP accounts and social media Information.
• Agile (Scrum) Projects code migrations, Streamlined and applied best practices to have smart work accomplishments in moving databases to Cloud Infrastructure.
• Database physical & logical modelling design and implementation.
• Solid Implementation & management skills on OEM, Grid Control, Cloud Control, AWS, RAC DBMS, Dataguard, Data Studio, Bulk load, LDAP, OIDCTL, OIDMON, DP IMP, DP EXP, SQL* Loader, VPD, TDE, Data Mining, RMAN Auxiliary, Compression, CRSCTL, SRVCTL, Exadata, Storage Indexes, Smart Scan, WEB Logic, Remedy & ER Architect and IBM DB2 UDB databases.

Confidential, Fairfax, VA

Oracle Technical DBA/Consultant

Responsibilities:

• Involved in installation of Oracle 10g RAC and 10g Non RAC Databases, CRS, RDBMS, DB and Applying Patches.
• Worked to Apply Oracle 10g CRS, RDBMS and VERITAS Point Patches.
• Worked on Database migrations from Oracle 9i to Oracle 10g.
• Worked on Oracle 10g Streams and database Partitioning.
• Created many RAC & Non-RAC database instances for development and production of numerous ranges used high-end Sun-E25 K, Mobile Laptop machines. Involve in Supporting SafetyNet System, Spatial and maintained mostly all the database environments of various sizes
• Very proficient in taking backups using traditional logical backups, Data Pump, Hot, Cold, Transportable Tablespaces, RMAN, FRA Backups, database security and maintain data integrity.
• Handled Databases of 2-4TB in size, used dpexp/dpimp and SQL*Loader for data movement.
• Very well in performance tuning of Applications and Databases.
• Very well verse in monitoring Failovers, Connection Load Balancing, Dedicated Servers and Remedy.

Confidential, Hanover, MD

Sr. Oracle DBA/Consultant

Responsibilities:

• Oracle database Administration and Installation of Oracle databases RAC and non-RAC and management system software's Creating/maintaining various databases objects and maintaining SGA parameters and Net files; designed databases, database objects, referential integrity, views, materialized views, security access policies.
• Transferred database Schema's to and from databases; Writing PL/SQL Stored Procedures, Packages and Triggers.
• Monitored backups, exporting/importing data, Data Pump, database full backup, incremental backups and recoveries, Flashback, Transportable Tablespaces, Partitioning, Streams, Advance Replication and applying security patches and patch sets on all database servers.
• Ensured performance meets the standards of SHA and following the policy procedures defined by SHA.
• Oracle DBA HIPAA compliance support including backups, recovery, tuning, optimization, and monitoring, preparing and implementing security plan for databases to meet SHA policies, and maintains database performance, Oracle Text and intermedia.
• Performed database upgrades/migrations and scripts writing to automate backup jobs, database Backup and Recovery plan to minimize data loss and downtime.
• Lead Systems, Database Architect & more.