SUMMARY:

• 9+ years of extensive IT and database systems analysis, design and implementation experience with Major experience with Database Administration and Development. Have Sound exposure to RDBMS and NOSQL database technology.
• ORACLE DBA experience with Database Creation, Database Maintenance, Database Backup and Recovery on UNIX / Linux and Solaris environments for 8i, 10 g, 11gR2, 12c versions.
• Experience configuring and supporting Oracle RAC Environments on EXADATA and ODA with ASM, ACFS file systems.
• Working on DBaaS (Database as a Service) environment with Supporting various database service tier including (GOLD/SILVER/BRONZE).
• Applying database security patches and Database upgrades.
• Exposure to HP Database and Middleware Automation Tool (DMA).
• Experience in setting up and Supporting Physical Standby database with DataGuard.
• Supporting Databases with GoldenGate environment.
• PL/SQL Development and Shell Scripting.
• Very good knowledge at database performance tuning and troubleshooting.
• Experience using Oracle Enterpriser Manager (OEM) 12c.
• Backup and Recovery with RMAN and EXPDP/ IMPDP
• Strong Understanding of High Availability Concepts.
• Working exposure to PCI and SOX compliance environment.
• OID and LDAP for Authentication
• Work on Oracle Utilities and Advance Tools like OEM, AWR, ADDM, ORACHK, Oracle Wallet, Oracle Log Miner, and SQL Loader.
• Good understanding of ITIL processes.
• Mongodb NOSQL Database experience of around 8 Months, with Installation and configuration of Replica Set and Sharded Cluster.
• Working with Developer for Designing issues on NOSQL.
• Exposure to Other database technologies including PostgreSQL and MS SQL Server with Past Project experience.

TECHNICAL SKILLS:

• ORACLE 8i, 9i, 10g, 11g, ORACLE RAC, Oracle LDAP, Oracle 10g Application Server, PostgreSQL, MS SQL Server
• Windows - x86, HP-6000 Server, HP SAN System, VERITAS Net backup
• Pl/Sql Developer, TOAD, SQL Developer, CA Erwin. Autosys jobs. BMC Remedy

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, New Jersey

Sr. Database Administrator Consultant

Responsibilities:

• Working in DBaaS and Legacy environment with Exadata and Oracle Database Appliance (ODA) and OEM 12c.
• Experience managing Database via Oracle EM 12c.
• Managing DATAGUARD Environment.
• Database Performance Tuning with OEM, AWS, ASH and ASH Analytics.
• Database Upgrade and Patching for RAC, RAC ONE NODE and Non RAC Environment with Grid Infrastructure.
• Strong ORACLE RAC knowledge.
• Database provisioning for Gold, Silver and Bronze service level.
• Developing and Maintaining SOP documentation as per the Confidential Standards in Confluence.
• Highly involve with client communication for database and application migration and transformation work during project.
• Database backup and recovery using RMAN.
• Supporting Database with GoldenGate replication.
• Database Migration from Legacy to DbaaS Environment.
• Supporting MongoDB Nosql Database with Initial Development and Production Setup
• Managing Databases on Virtual Environment.

Confidential, New Jersey

Sr. Database Administrator Consultant

Responsibilities:

• Oracle Database Administration and maintenance including backup and recovery in Single and RAC environment.
• Installation of oracle Database, Creating and managing schema, Managing Daily backups and deployment of product code in Production / QA / Test environment.
• Creating and Managing Physical Standby Database with Actve Data guard
• Performance tuning with AWR / Statspack Report / Quest Tuning Pack.
• Managing Production and development jobs through AUTOSYS.
• Database Upgrade and Patching.
• Database Cloning.
• Setting up of new Database for development teams as per specification for Testing.
• Setup and maintain documentation and standards
• Highly involve with client communication for database and application migration and transformation work during project.
• Database backup and recovery using RMAN
• Lead Oracle to PostgreSQL Data Migration Project
• Experience using SQL Server Management Studio 2012
• Managing Databases on Virtual Environment.

Confidential

ORACLE DBA

Responsibilities:

• Oracle Database Administration and maintenance.
• Installation of oracle Database, Creating and managing schema, Managing Daily backups and deployment of product code.
• Analysis of Database Pl/SQL blocks and its remediation.
• Database Upgrade and migration.
• Capacity planning / Architecture designing to support new databases.
• Setting up of new Database for development teams as per specification for Testing.
• Setup and maintain documentation and standards
• Mentoring team Members.
• Highly involve with client communication for database and application migration and transformation work during project.

Confidential

Database Technical Lead

Responsibilities:

• Installation of oracle Database, Creating and managing schema, Managing Daily backups and deployment of product code.
• Pl/SQL Development, Creating, Managing & Maintaining Database Objects.
• Setting up of new Database for development teams as per specification for Testing.
• Managing Physical Standby Database on 10gR2.
• Extensive Database performance tuning, query optimization and PL/SQL Debugging.
• Monitoring DB and Space usage, handling Backup Jobs and tuning on production database server.
• Performance tuning at database and Instance level.
• Setting up Physical Standby database for Disaster Recovery.
• Handled PostgreSQL database Installation and configuration in Development and Production Environment on Linux environment.
• Lead Oracle to PostgreSQL database Migration Project
• Extensively working with PostgreSQL (Enterprise DB) support while Migrating and converting Logical entities from ORACLE to PostgreSQL.
• Designing and Developing SOPs on working with Production and Development databases running on Oracle and PostgreSQL.

Confidential

Oracle DBA - Developer

Responsibilities:

• Daily Oracle database Administration and monitoring on Development and Production databases.
• PL/SQL Development
• Handling incident management and severity case management with tools like BMC Remedy.
• Interacting with cross-functional Team in gathering database requirements and to designing / supporting application migration, enhancements.
• Excellent Team working skills and ability to handle responsibilities.
• Highly involve with client communication for database and application migration and transformation work during project.

Confidential

Consultant - Oracle Developer

Responsibilities:

• Designing and implementing this activity, Involving Data Migration from MS SQL Server 2000 to Oracle 10g R1 with Data Analysis, Data Cleaning and Data Loading.
• Atomized the Process by developing PL/SQL Procedures, Functions and SQL Loader.
• Migrating and Loading Large Objects (LOBs).
• Developed and migrated data on Production Server.
• Post Upgrade and Remediation Activities.