PROFESSIONAL SUMMARY:

• Oracle SQL Database Administrator with Years of experience performing all database administration activities like installation, configuration, cloning, patching, upgrade and performance tuning of Oracle RDBMS 10g/11g/12c on Windows and Linux platforms.
• Expertise in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Created various types of database objects Indexes, tables, Sequences, Synonyms
• Proficiency to create composite data types such as PL/SQL records and PL/SQL collections
• Strong knowledge of Oracle utilities like SQL*Loader, Export/Import, Data Pump and External Table.
• Expertise in using tools such as Oracle SQL Developer, SQL*Plus.
• Implementing various backup strategies for large to medium - sized databases using RMAN.
• Cloning and Duplication of databases using RMAN.
• Performing backup and recovery using PITR, Export/Import and Flashback Technology.
• Monitoring and solving performance issues.
• Golden Gate installation, administration and configuration for database replication purpose.
• Implementation and technical expertise in Oracle Applications R12/11i, across the SCM and Financial modules such as General Ledger (GL).
• Proficient in Reconciling Sub- ledger Applications with GL.
• Hands on Experience on Oracle Financial Modules like (AP, AR, and GL).
• Working hands on Experience with EXADATA databases.
• Experience with Working on Reporting Software like ( SQL server reporting, Jasper report, ZOHO office suite and BIRT project)
• Hands on experience over SQL DB, MS SQL, T- SQL,SQL server
• Experience in performing major & minor Kafka /Hadoop upgrades on large environments.
• Installing and configuring Kafka and monitoring the cluster using Nagios and Ganglia .
• Set up/installation and configuration of Oracle 11g R2 RAC with ASM & 11g CRS on Linux.
• Implemented and administered Oracle Golden Gate for database replication between production and reported node using Oracle Streams to secure data.
• Experience in handling, configuration and administration of databases like MySQL and NoSQL databases like MongoDB and Cassandra.
• Having Experience working on Human Capital Management and Cloud Human Capital management.
• Having Experience of working on Oracle Transportation Management OTM.
• Maintain the security, data integrity, and availability of data in production environments.
• Manage assigned risks and monitor potential impacts as part of the data migration plan.
• Experience in Extracting, Transforming and Loading (ETL) data using MS SQL loader utility.
• Proficient in using various database Utilities like EXPORT/IMPORT, Data Pump, and TOAD.
• Experience on Designing, Planning, Administration, Installation, Configuring, Troubleshooting, Performance monitoring and Fine-tuning of Cassandra cluster.
• Experience on working with MongoDB Ops Manager, Cloud Manager and Atlas Manager
• Proactively monitoring the database 's health and taking preventive or corrective actions.
• Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms.
• Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).
• Excellent knowledge on Spark Architecture and Hadoop Architecture and its ecosystems such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and Map Reduce programming paradigm.
• Excellent experience in MS SQL Server database and ETL capabilities using SQL Server Business Intelligence Studio (BIDS) and SQL Server Management Studio (SSMS).
• Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM.
• Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 3 TB.
• Set up/installation and configuration of Oracle 11g R2 RAC with ASM & 11g CRS on Linux.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9/10, Windows 95/98/NT/2000

RDBMS: Oracle 12c, 11g, and 10g

Languages: SQL, PL/SQL, UNIX Shell / Batch Scripting

Tools: Cassandra, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM, Hadoop,HIVE, and, Toad, Putty, Winscp, Kafka, Remote Desktop Connection, EXADATA, Spark, VNC, Team Viewer, Log Me In and Cisco VPN Client

PROFESSIONAL EXPERIENCE:

Confidential - Washington, DC

Oracle SQL Database Developer

Responsibilities:

• Provide administrative support and maintenance on Oracle 10g, 11g and 12c installations, database creation, database security, database optimization and tuning.
• Provide and maintain high availability and disaster recovery using ORACLE DATA GUARD.
• Monitoring and troubleshooting database performance using OEM, AWR, ADDM, ASH, Explain Plan, and TOAD.
• Manage database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption (TDE).
• Used PL/SQL (Stored procedures, triggers, packages (DBMS *, UTL *)), MS SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database.
• Used Oracle Loader and import/export utilities for loading data.
• Installation, configuration and support of Oracle Exadata X3-2/X4/X5 databases.
• Troubleshoot Exadata technical issues, plan and co-ordinate migration of EBS from standalone to Exadata database.
• Experience in developing inbound and outbound interfaces for Oracle General Ledger, Account Receivables, Purchasing, Quoting, Order Management and Inventory Modules.
• Expertise in developing and customizing reports using Oracle GL Reports using 10g/6i.
• Developed various procedures and functions in PL/ SQL for doing the ETL.
• Loaded data into Oracle database that used to come from others sources in different format such as Text or Access tables.
• Migration and consolidation of multiple Databases into Exadata servers.
• Involved in fine-tuning stored procedures by making use of PL/ SQL Collections and its BULK FETCH and BULK INSERT features.
• Created complex queries in PL/ SQL on SQL plus and SQL developer environment for making easy and fast way to retrieve data to others user in the department
• Developed database objects such as users, tables, Views, sequences, functions, procedures, packages and triggers
• Worked with tools like PL/ SQL Developer, SQL Developer, SQL *Loader, TOAD, SQL Plus FileZilla, WinSCP.
• Create reports with the help of BIRT report and Jasper report.
• Designed and developed Oracle PL/ SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Provide Solution to user requirements/Configuration Oracle Transportation Management.
• Developed Domain based Cloud Data architecture models: conceptual, logical to physical.
• Built generic cloud migration solution based on Micro Services architecture. Azure Architecture pattern involved with webjobs, function apps, cosmos DB, Key Vault, Service Bus and SQL.
• Implemented complete cash management module for AP .
• Performed application setups, and provided Post-Implementation Support to Oracle ( AP /AR/ PO/CM) applications .
• Written Programs in Spark using Scala and Python for Data quality check.
• Experience in design and developing Application leveraging MongoDB.
• Experience integration of Kafka with Spark for real time data processing .
• Maintained compliance with all aspects of BSA, AML, and OFAC regulations.
• Installed and administered GOLDEN GATE in a unidirectional, bidirectional, and broadcast configuration to mainly replicate data and ensure high availability, in a heterogeneous environment, also worked with EXADATA Machines for high performance and availability.
• Created 30 node Cassandra cluster for EVENT AND ERROR HANDLING EVENTS ON DSE-5.0.11.
• Migration of on-premise SQL Server databases to Azure SQL database.
• Installing and configuring Kafka cluster and monitoring the cluster using Nagios and Ganglia.
• Managed SQL Server Security (creation of windows and SQL Server logins and users, assigning server and database roles and permissions.
• Apply Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances.
• Clone databases via RMAN and DATAPUMP utilities for various Database sizes.
• Extensively use AWR, ADDM, ASH, and Explain plan for periodic Performance tuning.
• Setting up and managing RMAN, Hot and Cold Backups, Exports and Production database support.
• Managing Database Structure, Storage Allocation, Table partitioning, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.
• Oracle Database performance-tuning services with EXPLAIN PLAN, AWR reports, ADDM.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Created loggings in the existing SSIS Packages.
• Used Spark API over Cloudera Hadoop YARN to perform analytics on data in Hive and involved in creating Hive Tables, loading with data and writing Hive queries which will invoke and run Map Reduce jobs in the backend.
• Hands on experience in developing SPARK applications using Spark tools like RDD transformations, Spark core, Spark ML lib, Spark Streaming and Spark SQL.
• Created profiler tool Meat DB for Automation tool Blade Logic Environment: DSE Cassandra, Blade Logic, Site scope, Intro scope, DNT, DSE Spark.
• Extensive use of Oracle Enterprise Manager (OEM) Grid control for Performance, Administration and Maintenance of Databases.
• Work on several OLTP, OLAP, and Enterprise Data Warehouse databases and provide 7x24 supports.
• Built storage approach for data and data center facilities migrations.
• Writing scripts in BOURNE and KORN shells for executing backups and other DML triggers.
• Developing Parameterized and Tabular Reports with SQL Server Reporting Services (SSRS).Created reports for OFAC and OATS.
• Hands on experience in Installation, Configuration, Upgradation, Administration, Troubleshooting of Golden gate issues.
• Work with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.
• Establishing connectivity to databases and monitoring system performance.
• Monitor AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS STATS, Trace Files, and System Event Logs for unusual events and took appropriate action according to company policies of incident reports.
• Imported data from AWS S3 into Spark RDD, Performed transformations and actions on RDDs .
• Implement table and index partitioning so as to Minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.
• Knowledge in PL/SQL programming.
• Checking top activity for system I/O, user I/O and other processes, monitoring SQL executions for Time & wait statistic, I/O statistic.
• Part of support team for 24/7 on-call production support.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Confidential - McLean, VA

Oracle Database Administrator

Responsibilities:

• Create databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.
• Follow System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db, and SQL 2005).
• Responsible for creating the Cassandra database across all the environments namely Development, Pre Production, UAT and Production.
• In depth knowledge on integrating Cassandra with Hadoop.
• Used MongoDB internal tools like Mongo Compass, Mongo Atlas Manager & Ops Manager, and Cloud Manager Etc.
• Created and maintained technical documents for pre-conversion and post-conversion of Oracle EBS .
• Helped the IT department successfully transition to the R12 EBS Oracle environment.
• Worked within Oracle EBS daily, creating concurrent programs, solving problems on frontend and backend.
• Worked on MongoDB database concepts such as locking, transactions, indexes, sharding, replication and schema design.
• Ensure customer needs and requirements considered critical to success are managed throughout the organization for SaaS Implementations and Oracle Human Capital management model.
• Oracle ERP Cloud experience in General Ledger, Accounts Payable, Accounts Receivable, Asset Management and Cash Management.
• Tested the Primary Secondary and Reporting ledger in Oracle GL.
• Setup of Oracle Exadata for various benchmark scenarios for advanced DW and OLTP database workloads sizing 10-20TB .
• Design and implement ETL utilizing PL/SQL and Talend Administration Suite.
• Manage database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption.
• Perform instance tuning by changing init.ora parameters and managed region parameters such as shared pool size and db cache size with the use of AMM and ASMM.
• Install and configure the Oracle Golden Gate software on Unix/Linux platform for both Unidirectional and Bidirectional replications.
• Implemented multiplexing control files and redo log files
• Writes PL/SQL stored procedure, triggers, etc. for application development and db monitoring. Monitors alert log and trace files using shell scripts or Batch Script and user activities by auditing, user privileges, and roles.
• Created SSIS packages with Error handling, notifications and package configurations.
• Coordinated Kafka operational and monitoring (via JMX) with dev ops personnel; formulated balancing.
• Experience in Oracle Applications framework (OAF) Personalization and Extensions.
• Design, Development, personalization and customizations of oracle application framework (oaf) pages as per business requirement.
• Loaded log data into HDFS using Flume, Kafka and performing ETL integrations.
• Develops and modifies database definitions including entities, attributes, relationships, and referential integrity triggers. Maintains detailed database design documentation.
• Configure Oracle tools like SQL*Net to access the database across the network.
• Configure and manage ASM instances on Oracle 11g and 12c.
• Assisted the Government Sanctions Group (GSG) users in the submission of SAR, CTR, and in complying with OFAC .
• Responsible for system configurations and testing of Oracle Financials R 12 ( AP, AR and Cash Management).
• Building out and scaling Kafka clusters across business functions for large scale and large volume usage.
• Worked in a cross functional team that oversaw the Oracle RAC installation and configuration for Linux environments.
• Extensive experience in Installation, Migration, Database Upgrade, Backup and Recovery, DR, RMAN, ASM, 10g RAC administration, data pump, performance tuning of Oracle Database.
• Create and manage pluggable databases in the multitenant container database of the Oracle 12c architecture.
• Experience migrating database objects from development through test and into production environments.
• Capacity planning (supported 3 tier architecture, planning of tables, indexes, table spaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.
• Created and modified MS SQL Server tables, stored procedures, functions, and views (T-SQL).
• Created and modified SQL Server databases, tables, stored procedures, functions, and views.
• Maintained the data integrity and security using integrity constraints and database triggers.
• PL/SQL objects creation. Create trigger/ function/ stored procedure / packages. Tune and trouble-shooting PL/SQL codes. Write database Monitoring PL/SQL objects. Create Materialized view.
• Tune database for higher performance, analyze, explained and trace sessions for bottleneck queries, and configured instance optimal parameter setting.
• Supported daily Database call for maintenance and administration such as performance, connections, locks, refresh data and security issues.

Environment: Oracle 10.2.0.1, HP-UX 11, MongoDB, Sun Solaris 10.0, Oracle Streams, Oracle Exadata V2, RMAN, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN, Shell Script, Batch Script.

Confidential - Dublin, OH

Oracle Database Administrator

Responsibilities:

• Involved in 24x7 Oracle Production Database Administration.
• Performed all the database administration activities like installation, configuration, cloning, patching, upgrade, performance tuning, backup & recovery, space management in database, user and role administration and schema management.
• Installation, configuration, upgrade, patching of Oracle RDBMS and applications.
• Golden Gate installation, administration and configuration for database replication purpose.
• Experienced in ETL TALEND Data Fabric components and used features of Context Variables, MySQL, Oracle, Hive Database components.
• Supported 100+ databases including production databases, data warehouse database development and test databases, and upgraded from 10g to 11g and some to 12c.
• Set up/installation and configuration of Oracle 11g R2 RAC with ASM & 11g CRS on Linux.
• Experience in coding MS SQL, PL/SQL package, function, stored procedure, triggers, and materialized view for Oracle database .
• Installed and configured 2 nodes Oracle 11gR2 RAC for production environment.
• Installed 12c databases and responsible for upgrading Oracle 10g RAC to 11g RAC.
• Troubleshot Golden Gate EXTRACT and REPLICATE issues.
• Implemented and administered Oracle Golden Gate for database replication between production and reporting node using Oracle Streams in parallel to secure data and having the availability of the database during regular upgrade or maintenance operation.
• Developed SQL scripts for administration task.
• Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
• Performed T- SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• Excellent SQL skills for daily testing of data using various SQL queries.
• Experienced in Code Migration, Version control, scheduling tools, Auditing, shared folders and Data Cleansing in various ETL tools.
• Implemented Data Pump, Export and Import on day-to-day basis as per development and test servers. Cloned RAC to RAC and RAC to NON RAC using hot backup and RMAN.
• Responsible for performance monitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History). Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Utilized Cassandra tools including ss table loader, sstable2json and json2sstable, COPY for application data loading and analysis.
• Configured and managed the Concurrent Managers, Workflow Notification Mailers and monitored their operation. Strong experience in Space and User Management, Capacity planning, standby setup and Backup & recovery (Import/Export, Data pump, RMAN).
• Delivered Oracle database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, ADDM, ASH, and SQL tuning advisor.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Manager).
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Applied database patches using O patch utility & building clone instances for development and test teams.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2 and 10g.
• Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild, materialized views refresh and db exports.
• Maintained DATA GUARD to provide high availability by implementing physical stand-by database and snapshot-standby and worked with Oracle 11g features 11g Grid Control and Automatic Storage Management (ASM).
• Troubleshot space management, user accounts and privilege issues while coordinating with UNIX and application teams.
• Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shell scripts for automation of day-to-day activities.
• Identified top SQL consumed heavy resources and provided support to the development team in identifying SQL queries that were consuming high resources and interacted with the development team to see if these queries could be fine-tuned further.
• Regular security patching and critical patches updates (CPU) and patch set updates (PSU) on Oracle databases for various bug fixes on database products.
• Production support for Oracle database 10g/11g RAC.
• Implemented and configured of Oracle Enterprise manager OEM 12C and Oracle Management Server for maintenance and monitoring of production databases.
• Managed users, roles, privileges, profiles, schemas, using Grid Control of Oracle Enterprise Manager (OEM) 12C.
• Created and managed primary objects like custom tables, procedures, packages, triggers, alerts & functions. Views, indexes, user accounts, roles and grants.
• Monitored database using Oracle Enterprise Manager (OEM).

Environment: Oracle RMAN, Oracle 10g, 11g, 12c, DBMS STATS, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN, SQL Server 2012, Sql developer, TOAD, OEM grid control.