SUMMARY:

• Working as Oracle DBA since last 13 years with Oracle products, both production and development environments spanning several industries health care, insurance, financials, telecom and retail industries
• Expertise in database administration, production support, installation, configuration, upgrades, patches, space management, database security, troubleshooting database design, UNIX shell scripting and documentation.
• Experience with Oracle 12c/11g,10g/9i/8i Installation, Administration, Monitoring, Maintenance, Performance Tuning, Database Backup and Recovery
• Duties included Database creation, Database upgradation, Database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, develop/integrate relations, script development, documentation
• Experience in HP - UX, AIX, SUN SOLARIS, Linux and Windows environments.
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN, EXPDP
• Installation and configuration of Oracle 12c/11g/10g/9i versions in UNIX/LINUX and Windows environment.
• Extensive experience in supporting Oracle PL/SQL based applications and experience with AWS technologies
• Comprehensively analyzed business function using ERP and performed changes for the better utilization of resources.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TN Names, SQLNet, V$ and DBA views.
• Database Administration tools OEM (Oracle Enterprise Manager), SQL Developer and TOAD
• Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS)
• Designed and implemented Backup and Recovery strategies by taking cold backup, hot backup through RMAN and logical backup through Data pump
• Cloned several databases through RMAN and also active database cloning through RMAN
• Utilized SQL Developer/Loader, export/import and data pump import to load data in to tables
• Experience in using SQL, PL/ SQL procedures, functions, triggers and packages, materialized views
• Highly experienced in performance monitoring/tuning/troubleshooting
• Worked on several OLTP, OLAP, Enterprise Data Warehouse databases and provided 7x24 support
• Worked On call for 24X7 Production Support. Willingness to work beyond regular hours
• Experience in Oracle Disaster Recovery and High Availability Solutions RAC Data Guard
• Experience in creating Logical standby and Physical standby databases on various platforms
• Worked on Golden Gate Replication, Configured Extract, Replicate processes for Golden Gate.
• Configured Golden Gate 11G for extraction and replication of transactional Data Manipulation Language DML operations and data definition language DDL changes.
• Experience in creating Logical standby and Physical standby databases on various platforms
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, AWR reports, ADDM
• UNIX shell scripts for hot backups RMAN and Datapump(expdp, impdp) for export and import of databases
• Strong experience in UNIX O/S and Shell programming
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment. managed Amazon Web Services infrastructure and hosting resources
• Extensive use of Oracle Enterprise Manager (OEM) Grid control for Performance, Administration and Maintenance of Databases
• Managing Database Structure, Storage Allocation, Table partitioning, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges

TECHNICAL SKILLS:

Operating Systems: Linux, Sun Solaris, AIX, WindowsDatabases Oracle 12c/11g/10g/9i/8i, DB2, MS SQL Server

ERP Systems: PeopleSoft, SAP, SalesForce, HadoopLanguages SQL, PL/SQL,Shell scripting, PowerShell

Tools: TOAD, SQL Developer,DB Artisan, OEM

Data Ware House: Hadoop, Micro strategy, Informatica and Cognos

Cloud Computing: Oracle Cloud, AWS, Azure

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, CA

Sr. Oracle DBA

Responsibilities:

• Installation, Configuration, Designing and Maintaining of Oracle 12c and 11g database on Linux (AWS hosted infrastructure)
• Creation and setup of Dev/TEST/QA/STG/TRN environment from Production database for all the applications for Java, ERP and LWC grown applications
• Upgraded more than 20 Databases each sizing at least 500GB from Oracle 11g to 12c supporting JAVA, Payments, PeopleSoft HRMS and Financials applications.
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with the Catalog.
• Setting up and managing RMAN, Hot and Cold Backups, Exports and Production database support
• Refresh the TEST, UAT and development databases from the source production databases on a regular basis using export/import utility and automate them
• Configured Golden Gate 11G for extraction and replication of transactional Data Manipulation Language DML operations and data definition language DDL changes
• Successfully maintained multiple databases. Implemented Grid Control for managing databases.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.
• Created and troubleshoot DB Links’ issues in Oracle for communicating with external databases
• Establishing connectivity to databases and monitoring system performance
• Experience in database monitoring and health check using Solar Winds, SCOM, Powersheell, SQL Scripts and by Windows Powershell Scripts.
• Worked with AWS(Amazon Web Services) for the hosted servers and configured all the necessary databases to support Student applications and Payment Gateways
• Created Profiles with the security standards followed by the organization
• Administering, maintaining, developing and implementing policies and procedures for ensuring the accessibility, integrity and security of all databases by strictly following the SOX -policies and procedures and documentation of every step
• Wrote Shell scripts for Alerts for ORA-errors, backup and recovery, Import and export procedures and managed crontab file, rescheduling the failed jobs (due to errors), changing timings for the scripts to run if the job fails and adding new jobs (scripts)
• Applied SSL certs for the transmission of Data between AWS and Local applications.
• Apply Oracle Critical Patches to delivered from Oracle to all databases
• Monitor Daily refreshes for QA Databases from Production for PeopleSoft, Salesforce, Datawarehouse and Reporting Databases
• Worked with Team to understand business needs and Involved in planning, designing and support for all databases

Environment:: Oracle 12c/11g, RAC, OEM, RMAN, Data Pump, Diagnostic and Tuning Advisors, PeopleSoft-HR, Fin, Hadoop, Java apps,Informatica and Micro strategy

Confidential, Charlotte, NC

Senior Oracle DBA

Responsibilities:

• Installation and Configurations of Oracle 11g, and 10g RAC on Linux.
• Supported bi-directional replication using oracle streams and designed the conflict resolution.
• Have worked as Data modular building complex logical data models using sophisticated modeling techniques and tools like Erwin
• Responsible for Data Modeling and converting Domain model to Data model- logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, streams, failover and Disaster Recovery
• Created and managed database objects such as tables, indexes, partition tables and views.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Managed the flashback space and performed recovery of dropped tables and data using flashback recovery
• Participated in teams designing, coding, testing, and implementing new features and corrective maintenance updates in the high-performance OLTP financial application.
• Used export/import for schema, table and database refresh
• Experience ensuring the high availability and integrity of databases.
• Used shell scripting for RMAN and hot backup and recovery.
• Worked on export/import in test Database for schema refresh.
• Manage data architects, data administrators and client enhancement requests.
• Write scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain tablespaces and other database objects and also did the patch management for oracle upgrade.
• Handling large database environments (Data warehouse) using ETL tool and Oracle Enterprise Manager (OEM), Grid Control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical)

Environment: Oracle 12C, 11g,10g, Red hat Linux 4.x, Solaris 10, SUN V480, HP-UX11, AIX 5L, Windows NT/2000, Toad 7.6, ASM, Oracle Enterprise Manager

Confidential, Silver Springs, MD

Oracle DBA

Responsibilities:

• Install, configure new Oracle databases for DB2 to Oracle Conversion.
• Analysis of SQL in DB2 and convert them to Oracle compatible functions
• Apply Patches for Oracle using OPatch
• Involved in Backups, restores of databases
• Created shell scripts to export the database - logical using expdp and impdp and Physical backups using RMAN
• Involved in PeopleSoft Financials upgrade and conversion of Re-platform from DB2 to ORACLE databases
• Automate of backups of restore scripts
• Automate Monitoring scripts for databases and user logins, long running SQL’s
• Involved in Tablespace management
• Involved analysis of bringing big tables from DB2 to Oracle during the cut-over for Financials Upgrade and re-platform
• Apply Archive logs and transport of database from one datacenter to another datacenter migration.

Environment: Oracle 11g, 10g, Linux 5, Solaris 10, RAC, DB2, Mainframes

Confidential, New York, NY

Oracle DBA

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Installation of Oracle 10g RAC and 10g Non RAC Databases includes CRS and Applying Patches.
• Configured Streams to capture propagate; apply changes in multiple databases.
• Upgrading databases to Oracle 11g from Oracle 10g and applying patches whenever necessary
• System Study & Analysis, Design &Development.
• Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling
• Migrated from non-ASM instance to ASM instance
• Used SQL server for ecommerce apps
• Creating and managing the database objects such as tables, indexes and views
• Daily Health Check Up of the Database using stats pack, AWR, ADDM, TKPROF, explain plan
• Personally responsible for performance, backup and recovery related issues of over 12 databases with 3 productions 6 development and 4 QA databases
• Space Management which includes table space creation, adding new data files
• Employed industry standard methodology and an iterative process based on Rational Rose for design, code generation and development.
• Used Rational Rose for the documentation and design phase of the application
• Monitored log apply rates, capturing diagnostic information, and detecting problems quickly with centralized monitoring, testing, and performance tools in physical/logical databases
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Designing the security and database access strategies using tools like ESM
• Installation of ASM into various storage parameters like SAN and NAS.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures.
• Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Indexed at the database level and used pre-tuned queries at the application level to tune OLTP.
• Monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention and fixing row chaining.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical and RMAN backup plans

Environment: Oracle 11g, 10g, Linux 5, Solaris 10, RAC