SUMMARY

• Over 14 Years of experience in the Information Technology field with extensive experience on Oracle Database Administration.
• Good experience in Database designing, setting up the complete Database with Security Implementation troubleshoots.
• 14 years of experience as an Oracle Database Administrator (versions 8i, 9i, 10g,11g,12c) on Microsoft, Unix, Linux Platforms, AIX, Solaris, which includes Installation, Management, Administration, Backup and Recovery, Maintaining and Tuning of Oracle RDBMS.
• Proven ability of providing production support for 24X7 on multiple databases.
• Expert in troubleshooting database performance issue which include SQL query,DB internals, memory, OS parameters, Network, storage, application performance, web performance etc..
• Upgraded Oracle 11.1.0.7 to Oracle 11.2.0.4 and 11.2.0.4 to 12.1.0.2 by using Golden Gate.
• Configured Data Vault, DB Vault /TDE/Data Redaction/ DB Firewall (dbfw) in Oracle 11g/12c.
• Migrated SQL Server 2005/08 to Oracle 10g/11g and vice versa with Oracle Golden gate.
• Administered Configure, Monitors, troubleshoots, performance tunes,clones,patches and upgrade the Oracle Enterprise Resource planning applications for errective bussiness operations.
• SME expert for Golden Gate / Veridata.
• Build Golden Gate framework for replication from relational to irrational (Oracle/SQL server to JMS/Flat Files).
• Enables GoldenGate to interchange real - time relational transactional data with non-relational systems.
• Installed Oracle Golden Gate Application Adapters for Java and Flat Files.
• Experience in Analysis/Design/Development in SDLC.
• Troubleshoot and diagnose issues with non-standard systems for CyberArk.
• Working on SDLC and AGILE methodologies.
• Knowledge of Mongodb.
• Installed Oracle Weblogic 12c.
• Good Knowledge of Oracle SOA and Oracle RUEI.
• Experience in Database Management control.
• Experience in Hadoop Cloudera.
• Knowledge of concepts of database machine EXADATA X3-2.
• Knowledge of Hadoop, MapReduce, PIG, Hive and Impala.
• Strong Knowledge in Logical / Physical & Dimensional Modeling, Normalized (up to 3NF) / Demoralized Databases on both OLTP /OLAP environment used Erwin.
• Handled Functional Analysis /Business Process model/ ER Model /Physical Model.
• Intensive experience in mapping document for ETL environment.
• Experience in Weblogic administration.
• Excellent knowledge in Data Profiling.
• Experience in process improvement, Database Design, Database creation, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Standby Database (Data Guard), Replication, Real Application Clusters, Automatic Storage Management (ASM)
• Experience in Multi Node RAC cluster design, administration and support.
• Knowledge on Web Sphere components such as Work Load Management (WLM), Servlet Engine, Session Manager, Admin Client
• Experience in configuration, implementation of Oracle 10g /11g/12c Oracle RAC.
• Worked on data encryption mechanisms TDE, FGAC, Backup encryption.
• Administered GoldenGate11gR2 for bidirectional replication.
• Configured and taking care of performance issue with bi-Directional and unidirectional Oracle Golden Gate replication.
• Expert in Oracle performance tuning, SQL tuning and Real Application Clusters (RAC) specializing in tuning and monitoring for high availability.
• Knowledge of RAID levels namely RAID 0 through RAID 5.
• Experience in developing Unix Korn Shell and perl scripts.
• Experience with tools used at capitalone controlm, RMAN, HP-Service Desk, BEN (Project1) & TSM.
• Good experience in SAP HR plateform and Peoplesoft application.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Demonstrable experience with PL/SQL including writing and optimizing code in PL/SQL using various tools such as TOAD, SQL Navigator and SQL Developer
• Experience creating an Oracle Database, creating application structures including implementing security using roles.
• Administer database, web, application and batch process servers with a primary focus on database monitoring and management.
• Provide basic support and troubleshooting for several database environments and SQL 2005/2008.
• Work closely with developers, support and QA teams to maintain all database environments.
• Refresh SQL databases as needed by developers or functional teams.
• Perform database administration activities including installation, monitoring, space management, database backup and recovery and disaster recovery.
• Good Experience in administering Oracle database in SAP environment.
• Familiar with any Change Control Tools (basically understands the need for an audit trail of change requests).
• Experience with any on-call procedures.
• Oracle patches, Migrating database across releases.
• Diverse industry experience including Banking and Finance.
• Designed and developed plans to achieve high availability, scalability, recoverability of the Oracle RDBMS servers.
• Familiarity with Web Applications like Portal, releases etc
• Familiarity with ETL Tools like AbInitio, DataStage, Informatica, Sybase etc.
• Demonstrable experience with other databases like TeraData, SQL*Server, DB2, Sybase etc.
• Database upgrades experience from 9.2.0.7 to 10g/11g and 10g to 11g/12c.
• Hands on experience of managing Very Large Databases (VLDB) in the range of 500 GB to 120 TB.
• Managed Linux servers running Oracle 9i/10g/11g/12c production Instance.
• Installation of Oracle Database and Application Server according to the requirements.
• Implementation and Administration of Data Guard for disaster and recovery setup.
• Acquainted with Real Application Cluster and Cluster Management.
• Acceptance and Pilot testing of the Application Software using test case.
• Excellent analytical, problem solving, communication and interpersonal skills.
• Analytical and Systematic thinking ability with a goal and solution oriented approach.
• Project Management skills includes recommendation and installation of Hardware, Software, Network, WAN, Security Policy formation and implementation, Creation and implementation of Database, vendor co-ordination, Acceptance testing and Pilot testing of the software.
• Expert in Administering 24 X 7 OLTP, Data Warehouse, OLAP, and Hot Standby (Data Guard) databases. Ability to analyze, plan and execute to perfection.

TECHNICAL SKILLS:

Database Administration: Oracle 8i/9i/10g/11g/12c, SQL Server 2005/2008/2012, MySql, Sybase, Teradata, DB2, MongoDB, Hadoop casandra

Oracle Tools and Utilities: OEM, Grid Control, RMAN, SQL*Loader, SQL*Net, Toad, Oracle Streams, Data Replications, BEA, JDE, Golden Gate 11/12, Oracle Veridata, Oracle Golden Gate Application Adapters for Flat File and Java, Java API, Data Guard, SQLNET, JDBC, Weblogic12c, Oracle SOA, AVAMAR, TSM, Netbackup, Oracle RUEI, JMS, DGMGRL, Statspack, AWR, ADDM, ASH, Oracle Application Express, Oracle 11.5 E - Business, CyberArk, Tuning Advisor

Operating Systems: Windows 2008/2012, Windows NT, HP-UX, Linux (RHEL), AIX, Solaris

Programming Languages: SAP, ABAP, ECC6.0 C, C++, Java, VB6.0, Pl/SQL, T-SQL, PeopleSoft, .net, C#, Hadoop, pig, hive

ETL Tools: Data integrator, Erwin, Power Designer, DbArtisian, Data Stage, Informatica, AbInitio etc

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Database Administrator

Responsibilities:

• Leading OLTP Database migration and up-gradation projects.
• Working with business and stakeholders in order to meet business and customer expectations for quality, scope and schedule.
• Responsible for enterprise-wide data security, integrity, performance and availability of Business Solutions Database Administration operations.
• Create, maintain and apply SQL Server database administration standards to align with SQL Server Best Practices.
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Refine and automate DBA processes, track issues, and document changes.
• Assist developers with complex query tuning and schema refinement.
• Provide 24x7 support for critical production systems.
• Supporting and leading database project efforts across the agency by preparing and working with disparate teams in the delivery of business information and data needs.
• Overseeing the development, collection, signoff and maintenance of SDLC artifacts in support of agency business systems.
• Ensuring proper documentation and reporting efforts of program activities are appropriate, thorough, complete and signed off.
• Develops new standard operating procedures (SOPs) for Oracle EBS application software installation and configuration including high availability and disaster recovery solutions.
• Solved production database performance issue after and before upgrade/migration.
• Subject matter expert for Oracle golden gate and Oracle Veridata.
• Leading Golden gate replication projects.
• Using Oracle Veridata for checking data consistency.
• Compare database by using Oracle Veridata after upgrade/migration.
• Compared Source and target data through Veridata.
• Created Golden gate performance monitoring script.
• Migrated Oracle 11g databases to Oracle 12c.
• Upgraded Oracle 11i databases.
• Upgraded Oracle 11.2.0.2 to Oracle 11.2.0.4 databases.
• Upgraded Oracle 11.2.0.4 to Oracle 12.1.0.2 databases.
• Upgraded database from 11g to 12c by using oracle golden gate.
• Building Oracle data guard platform for replication.
• Install Oracle Application Express.
• Created Physical standby, logical standby databases.
• Switching primary and physical standby databases for DR testing.
• Enable Fast Start Failover for critical application supporting databases.
• Build Linux server for database migration.
• Worked on Infrastructure project.
• Configured Backup thru AVAMAR tool.
• Build ASM, Cluster ware on Linux.
• Working with Engineering team for Exadata establishment.
• Worked on Performance tuning related to new migrated databases.
• Assisted with review of Oracle Golden gate replication architecture.
• Implemented Oracle Golden gate in non-prod and prod environments.
• Monitoring and compare data report by using Oracle Goldengate Veridata.
• Configured Golden gate capture process in source and target.
• Configured pump, trail discard file, replicate and extract process in Golden gate.
• Supported in go-live activities.
• Created Golden gate performance monitoring script.
• Provided 24*7 supports during production implementation.

Environment: Windows, MSSQL 2012, Linux, AIX, Solaris, Oracle 11g/12c, OEM, Data Guard, Oracle Golden Gate 12c, JMS, TDE, Veridata, RMAN, RAC, ASM, AWR, ADDM etc.

Confidential, Wilmington, DE

Sr. Database Administrator

Responsibilities:

• Oracle subject matter expert and technical lead for major finance projects on HA/MAA Oracle RAC/Oracle Advance security.
• Leading Oracle Golden Gate and infrastructure project.
• Configured Goldengate 12c RAC -- RAC Active configuration with 12c database.
• Upgraded Oracle database to 12.1.0.2 by using various techniques (Golden gate, Data Pump, Data guard).
• Assist in installation and configuration of audit vault and database vault in oracle 12c in single instance and cluster database (2-3 node).
• Work with Architecture, Development, and Business teams to identify Privileged Account Management and Multi-Factor functionality that can be enabled and integrated to improve security or performance.
• Design and build platforms in CyberArk for new environments.
• Worked with different teams of SMEs to design technical solutions for CyberArk integration.
• Design/engineering, administration, and third-level support of the Privileged Account Management infrastructure components for CyberArk.
• SME for Oracle golden gate and Oracle Veridata.
• Worked with Oracle to configure Half rack Exadata machines.
• Monitored Exadata Storage server with CellCLI.
• Monitoring smart scans.
• Apply patches on Exadata storage servers.
• Upgraded Oracle databases from 11g to 12c by using Oracle golden gate, data guard.
• Created standby / logical standby databases from primary databases.
• Configure data guard observer.
• Created Fast failover for data guard, switching databases.
• Involved in yearly DR exercise for Oracle databases.
• created physical standby and data guard broker by using active duplication.
• Install Oracle software, binaries, client on Linux, AIX, Solaris, Unix and Windows operating system.
• Worked on Designing of database/application infrastructure architecture to support company growth.
• Working on OEM for administering Oracle databases.
• Working on various types of performance issue related with Oracle databases, OS, Network, Storage and application.
• Applying CPU, PSU patches on Oracle databases.
• Enable Advance security feature in Oracle 11g/12c (TDE, Data Vault, Data Redaction, Application Security, Wallets, database firewall policy).
• Protecting database files on disk and on backups thru TDE.
• Protecting sensitive data using TDE column encryption and protecting entire application using TDE tablespace encryption.
• Monitoring events and audit logs by consolidating Oracle Audit Vault and database firewall.
• Applying Advance compression.
• Enable Oracle ASM Cluster File System encryption to protect log and configuration files.
• Configure Oracle Key Vault to centrally manage oracle Wallets with AES256 and TDE/ACFS master key.
• Configure Data Redaction in Oracle 12c for cardholder data/national identifiers/personal identity/medical record etc.
• Provided presentation to higher management for Oracle security features (av, dv, dbfw, data redaction, wallets, TDE etc.)
• Created data Redaction Policy in Oracle 12c OEM.
• Applying Oracle Security Patches to databases.
• Leading DR and HAA exercise during production deployments.
• Working on Hadoop and MongoDB installation.
• Delivered real-time change data to Flat Files, JMS Messages and Java APIs.
• Captured data in real-time from JMS messages and deliver to databases.
• Plug into the Oracle GoldenGate architecture for centralized management and monitoring.
• Worked on installation and configuration of Oracle GoldenGate on source and target databases.
• Worked on installation and configuration of the Oracle GoldenGate flat file adaptor on the target.
• Worked on testing the Oracle GoldenGate replication of to the flat file output destination and load data in tables with SQL loader.
• Replicating to an unsupported database as well as creating flat files for Hadoop.
• Extensively involved in collaborating with testing team in performing load testing which will help in capacity analysis of databases to scale up to concurrent load from end users.
• Gathering statistics on databases using stats pack to analyze database bottlenecks.
• Created OLTP/Warehouse Oracle 11g and Oracle 12c databases on Linux/AIX with failover mechanism.
• Performing checks on CPU, Memory and Storage while load testing is being performed as the loads are of different types which flood the database.
• Performed Cross plateform migration by using oracle golden gate.
• Migrated SQL server 2008 database to Oracle 11g by using Golden Gate.
• Configure and install Oracle GG Java adapter for replication to JMS.
• Configure Replicate framework for Java Message Services.
• Complete requirement with SLA’s.
• Replicate data from Oracle 11g to JMS.
• Replicate data from SQL Server to JMS.
• Configure replication between ERP (RAC 2 nodes) and a staging database at target and then replicate from staging in to JMS queues.
• Migrated single instance database from AIX(Single instance) to Linux (RAC 2 node) by using Golden Gate and Monitored thru Veridata.
• Troubleshoot Oracle Golden gate issue after replication (Lagging time, Extract/Replication Slow, DB issue like SQL Performance etc.)
• Provide 24*7 support if required.

Environment: Solaris, AIX, Linux, Unix, Windows 2008/12, MSSQL 2008/12, Oracle 11g/12c, TDE/Database Vault/Audit Vault/FW, SQL Server 2005/08, Exadata, Oracle Golden Gate 11/12., Oracle Golden gate adapter for Java and Flat files. SQL Loader, RAC, JMS, Oracle Veridata, AWR, ASH, ADDM, TOAD, JAVA, PL/SQL, JDBC, CyberArk, SQLNET, Peoplesoft etc..

Confidential, CA

Lead Oracle DBA

Responsibilities:

• Assisted with review of Oracle Golden gate replication architecture.
• Implemented Oracle Golden gate in non-prod and prod environments.
• SME for Oracle golden gate and Oracle Veridata.
• Upgraded Oracle 11.1.0.7 to Oracle 11.2.0.4 by using Oracle Golden gate with near to zero downtime.
• Monitoring and compare data report by using Oracle Goldengate Veridata.
• Reviewed Golden Gate Parameter files.
• Review Golden Gate process and parameters for Transactional Data Delivery to WebLogic Java Messaging Service (JMS).
• Configured Golden gate capture process in source and target.
• Reviewed pump, trail, discard file, replicate and extract process in Golden gate.
• Supported in go-live activities.
• Supported once GG process is up and running.
• Reviewed golden gate process and suggest modification.
• Compared Source and target data through Veridata.
• Created Golden gate performance monitoring script.
• Provided 24*7 supports during production implementation.

Environment: Windows, Linux, Solaris 10, Oracle 11g/12c, OEM, Golden Gate11g/12c, JMS, TDE, Oracle Golden gate Veridata, RMAN, RAC, ASM, AWR, ADDM etc.

Confidential, Wilmington, DE

Senior Database Administrator

Responsibilities:

• Leading couple of high availability projects. Installation, Administration and Maintenance of SQL Server Instances.
• Setup Test, Dev, Staging and Production Environments.
• Create Users and assign permissions based on the level of database access the user would need.
• Create Linked Servers to SQL Servers and with Oracle.
• Design database Backup and Restoration Strategy.
• Once created the database Backups, monitor those backups are being performed regularly.
• From time to time recover the databases to a specific point of time, as per the requests.
• Setup High-Availability as part Disaster Recovery Strategy for the Databases includes Failover Clustering, Database Mirroring, Log Shipping and Replication.
• Troubleshoot various problems that arise in a day-to-day work and fix the issues.
• Monitoring SQL Server Error Logs and checking your email alert.
• Monitoring and Performance Tuning. Physical Server Level, Database level (Database settings and options) and query tuning.
• Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc.
• Documenting major changes to the SQL Servers.
• Apply Service Packs.
• Oracle subject matter expert and technical lead for major finance projects on HA/MAA Oracle RAC/Oracle Advance security.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Worked with Oracle for X3-2 half rack configuration (eight database server with 2 8-core Xeon processors and 256 GB of RAM, fourteen storage servers, 168 disk drives).
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Leading Oracle Golden Gate and infrastructure project.
• Worked on various type of database performance issues in single instance and in cluster database.
• Configured Goldengate 12c RAC -- RAC Active configuration with 12c database.
• Assist in installation and configuration of audit vault and database vault in oracle 12c in single instance and cluster database(2-3 node)
• Enable Advance security feature in Oracle 11g/12c (TDE, Data Vault, Data Redaction, Application Security, Wallets, database firewall policy).
• Protecting database files on disk and on backups thru TDE.
• Protecting sensitive data using TDE column encryption and protecting entire application using TDE tablespace encryption.
• Monitoring events and audit logs by consolidating Oracle Audit Vault and database firewall.
• Applying Advance compression.
• Enable Oracle ASM Cluster File System encryption to protect log and configuration files.
• Configure Oracle Key Vault to centrally manage oracle Wallets with AES256 and TDE/ACFS master key.
• Configure Data Redaction in Oracle 12c for cardholder data/national identifiers/personal identity/medical record etc.
• Provided presentation to higher management for Oracle security features( av, dv, dbfw, data redaction, wallets, TDE etc..)
• Created data Redaction Policy in Oracle 12c OEM.
• Applying Oracle Security Patches to databases.
• Leading DR and HAA exercise during production deployments.
• Delivered real-time change data to Flat Files, JMS Messages and Java APIs.
• Captured data in real-time from JMS messages and deliver to databases.
• Plug into the Oracle GoldenGate architecture for centralized management and monitoring.
• Worked on installation and configuration of Oracle GoldenGate on source and target databases.
• Worked on installation and configuration of the Oracle GoldenGate flat file adaptor on the target.
• Worked on testing the Oracle GoldenGate replication of to the flat file output destination and load data in tables with SQL loader.
• Implemented Oracle advance security features(av, dv, dbfw, wallets, TDE) in Oracle 11g.
• Extensively involved in collaborating with testing team in performing load testing which will help in capacity analysis of databases to scale up to concurrent load from end users.
• Gathering statistics on databases using stats pack to analyze database bottlenecks.
• Created OLTP/Warehouse Oracle 11g and Oracle 12c databases on Linux/AIX with failover mechanism.
• Performing checks on CPU, Memory and Storage while load testing is being performed as the loads are of different types which flood the database.
• Performed Cross plateform migration by using oracle golden gate.
• Migrated SQL server 2008 database to Oracle 11g by using Golden Gate.
• Configure and install Oracle GG Java adapter for replication to JMS.
• Configure Replicate framework for Java Message Services.
• Implemented DR/HAA architect and plan.
• Replicate data from Oracle 11g to JMS.
• Replicate data from SQL Server to JMS.
• Configure replication between ERP (RAC 2 nodes) and a staging database at target and then replicate from staging in to JMS queues.
• Migrated single instance database from AIX(Single instance) to Linux (RAC 2 node) by using Golden Gate and Monitored thru Veridata.
• Migrated Oracle 10g to SQL Server 2008 by using golden gate.
• Installation and maintainance of 2 node RAC databases with ASM.
• Maintainance and troubleshooting of RAC issues in production databases.
• Monitoring of Oracle databases on Exadata machine using scripts.
• Involved in the design of datawarehouse using Star-Schema methodology and OWB for IR( Inventory Reporting application) and converted data from various sources to oracle tables.
• Developed views, functions, procedures, and packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Created SQL*Loader scripts to load legacy data into Oracle staging tables.
• Created staging tables necessary to store validated customer data prior to loading data into customer interface tables.
• Installation of GoldenGate 11gR2 for to implementing bidirectional replication POC.
• Planned GoldenGate setup to achieve Unidirectional and Bidirectional replication.
• Prepared GoldenGate parameter files for Extraction and Replication.
• Tested initial Data Load option of GoldenGate during environment build.
• Investigated Goldengate Replication failures using LogDump utility.
• Goldengate 11gR2 Integrated Capture and Advanced compression features testing.
• Designed and developed several mappings to load data from source system to ODS and then to Data Mart.
• Creation of AWR, ADDM, ASH reports to detect bottlenecks in database if loads running multiple high volume queries take long time to execute.
• Executing plans for TOP SQL to tune them and avoid hard parses and waits.
• Knowledge of OEM 12C architecture pieces Oracle Management Agent, Oracle Management Service, Oracle Management Repository, Oracle Management Plug-ins and Enterprise Manager Cloud Control Console.
• Active management of Oracle Weblogic Server through OEM 12c cloud control.
• Proactively installing OEM agents and monitoring databases through OEM 12c cloud control.
• Set up of Active Dataguard 11g for reporting in IR( inventory reporting application).
• Performed cross platform migrations using heterogenous dataguard to reduce downtime.
• Performing Index analysis and rebuilding Indexes on objects if broken and creating them if missing.
• Refreshing databases in DEV and QA with new builds.
• Maintenance of Oracle Database parameters (SPFILE) with values to support application needs.
• Created documentation and separated data, indexes, LOBS from schema objects and migrated them to their specific tablespaces in PROD database for better management and faster access.
• Migrated Oracle 10gR2(10.2.0.4) databases on AIX to Oracle11gR2(11.2.0.3) on RHEL along with application schemas.
• Performed database upgrade from 10.2.0.4/11.2.0.2 to 11.2.0.3.10 and 11.2.0.4 on all databases in DEV, QA and new PROD VMs
• Proactively creating housekeeping scripts and monitoring databases and objects using them.
• Patching of database and grid home with latest patch set updates(PSU).
• Developed POC doc for database backup using hot backup scripts and RMAN, tested recovery scenarios and implemented it .
• Familiarity with SOX compliance process.
• Worked on internal POC for integration of Cassandra with Hadoop and HDFS.
• Installation of CassandraDB version 2.0.
• Migration of transactions from Oracle to Cassandra.
• Using Remedy to log tickets and resolving them.
• Knowledge of creation of CR (Change Request)/CM through Unicentre and REMEDY after gathering information from concerned teams and getting approval.
• Expertise in creating and maintaining documentation and prepare report.

Environment: Windows, Unix, Linux, Solaris, AIX, SQL Server 2008, 2012, Oracle 10g/11g/12c, Peoplesoft, TOAD, OEM, Golden Gate11g, Exadata, Golden Gate Adapter, Veridata, JMS, MViews, SQLNET, Oracle Streams, GPFS, RMAN, STATSPACK,TOAD, RAC, ASM, Microstregy, AWR, ADDM, TKPROF, Grid Control, Control-m, TSM,SAP HR, Peoplesoft, Weblogic, Hadoop, Cassandra2.0, Golden Gate 11gR2/12c, Oracle Veridate and SDLC etc.

Confidential Richmond VA

Senior DBA

Responsibilities:

• Worked in multiple project related to finance, ecommerce, Payment accounts, Digital IT, Clarity, Banking etc.
• Providde DBA support to development/implementation projects as assigned, doing installations, database loading, conversions, testing etc.
• Protecting sensitive data using TDE column encryption and protecting entire application using TDE tablespace encryption.
• Troubleshoot non-prod and production database performance issue which include query slowness, application tuning, storage issue (Confidential’s allocation) and network slowness.
• Monitoring events and audit logs by consolidating Oracle Audit Vault and database firewall.
• Applying Advance compression.
• Enable Oracle ASM Cluster File System encryption to protect log and configuration files.
• Configure Oracle Key Vault to centrally manage oracle Wallets with AES256 and TDE/ACFS master key.
• Lead DR setup for High availability database.
• Supported Production, Development, QA, Testing Oracle and ms-sql databases.
• Analyzed source system data like Business Hierarchy, Commodity Hierarchy and Geographical hierarchy, sites, Utilization and produced mapping document.
• Administered SQL Server databases.
• Migrated database from SQL to Oracle and Oracle to SQL server.
• Configuration planning and installation of Oracle servers and Server upgrades and conversions.
• Performance and general health / capacity monitoring.
• Created the Data models using E-Rwin.
• Configured ASM, Dataguard (bi directional).
• Configured, install Oracle Golden Gate for replication and perform post installation jobs.
• Troubleshoot performance issue in golden gate replication.
• Replicate data from SQL-Server to Oracle and vice versa.
• Used exadata concept for large databases.
• Implementation of traditional relational and dimensional modelling standards along with naming conventions provided by data governance committee ensures sustainable growth.
• Interacted with Business and finalized data elements.
• Prepared Data Migration document and test data based on business rules.
• Developing a backup and recovery strategy and tested several recovery scenarios Perform ongoing database administration, maintenance, troubleshooting, tuning, installation, backup / recovery Management of table spaces for different users by granting quota on Default & Temporary tables paces.
• Worked on various data migration activities using Export/Import utility and SQL * Loader Database security, job scheduling and documentation investigating suspicious database activity using Auditing.
• Working with Oracle regarding troubleshooting with SR creation.
• Working with UNIX Team regarding DR Testing, new server installation, memory configuration etc.

Environment: Windows, Unix, Linux, Solaris, AIX, Oracle 8i/9.2i/10g/11g, Sql Server 2005/08, NCR Teradata V2R6.2, TOAD, OEM, Golden Gate, Exadata, RMAN, STATSPACK, Data integrator, RAC, ASM, Crystal Reports, AWR, ADDM, TKPROF, Control-m, TSM.

Confidential TN

Database Administrator Team Lead/Manager

Responsibilities:

• Responsible for providing data base management services that may relate to data monitoring, data management and programming.
• Managed organize, and design databases (e.g. Object Oriented Data modeling, ER data modeling, UML), table structures and data schema, logical and physical design, reports and forms development, naming conventions and other issues related to systems planning and data migration.
• Managed team of 4 database administrator.
• Provided data base consultations in a timely and professional manner.
• Allocated New Project to DBA’s and explain them functionality.
• Worked as Oracle DBA with database and application design and support.
• Worked with VLDB (Very Large Databases) with understanding in large table partitioning.
• Developed custom utilities to automate manually intensive tasks including mass schema changes, repartitioning tables and rewinding/restarting GoldenGate to recover from trail file corruption.
• Worked with Oracle Data Pump restoring and managing databases across multiple environments, dev levels particularly.
• Administered single-node and RAC 9i, 10g and 11g Oracle databases on Linux, Solaris and Microsoft
• Created the conceptual model for the data warehouse with emphasis on insurance (life and health), mutual funds and annuity using EMBARCADERO ER Studio data modeling tool.
• Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.
• Configured Oracle golden gate with oracle team.
• Provided basic support and troubleshooting for several database environments and SQL 2005/2008.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Implemented SAP application by using Oracle 10g database.
• Designed Logical & Physical Data Model /Meta data/ data dictionary using ERwin for development teams.
• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS packages.
• Designing and populated reporting tables, views and stored procedures
• Implemented partitioning to handle tables with over 500 million rows.
• Physical data model definition, design and implementation.
• Worked on Database Physical, Logical Design, Physical and Logical Data Modelling.
• Worked on 3/4/6 Node Clustering environments.
• Configured ASM, RAC with 4 nodes.
• Configured oracle streams, sharplex and Oracle golden gate for replication.
• Worked with in UNIX, Linux, Solaris, AIX environment.
• Worked for Oracle database performance and tuning.
• Worked with OEM (Oracle Enterprise Manager) for administration.
• Administered Oracle E-Biz like upgrade, patching and migration to 11i.
• Worked with SQL Loader, Imp/Exp, Data pump..
• Worked SQL and PL/SQL tuning.
• Configured Backup and Recovery tool OBACKTRACK.
• Worked on Creation of Instances in different nodes in clusterware environment.
• Worked with pl/sql developer team for designing and coding of sql.

Environment: Windows, Unix, Linux, Solaris, AIX, Oracle 9i/10g/11g/12i, Pl/sql, T-Sql, OEM, RMAN,AWR,ADDM, RAC, ASM, OBACKTRACK,SAP ECC 6.0, VERITAS, Sybase, SQL Server, Ab Initio, Data Stage, Informatica, Disaster Recovery, Erwin, DbArtisian, Power Designer13.0, Data Modelling, Oracle Golden Gate and Oracle streams,SDLC

Confidential, Richmond VA

Oracle DBA

Responsibilities:

• Back up the production database, synchronizing the standby database by responding to any physical changes in the primary database.
• Troubleshoot production database performance issue which include query slowness, application tuning, storage issue (TIER’s allocation) and network slowness.
• Experienced in RMAN, GRID, Physical and Logical Standby, Failover methodologies and Disaster recovery(DR)
• Performed status checks by monitoring the status of databases, logs, archived redo logs etc.
• Applied ARCHIVE logs.
• Worked as part of a team and provide 7x24 support when required
• Involved in testing phase of implementation of RMAN for various advanced backup and recovery options.
• Planed and Implemented backup and recovery of the oracle database.
• Completed DR Site User Location maintenance for any major disasters
• Created of the Test and Production Oracle 8i/9i/10g databases Maintenance and support of the Oracle Applications and Oracle Databases Cloning of production database to the test environment using Recovery Manager (RMAN).
• Resolved Oracle listener and TNS names problems by using Net Manager and Oracle Net Configuration assistant Implementation of Security of database down to cells by creating users, groups, profiles.
• Database Administration and Planning including logical design, physical design, backup & recovery Applied various patchsets and upgraded databases from 9.1.0 to 9.2.0.6 Installed Oracle 10g on Solaris and Linux platforms.
• Developed a backup and recovery strategy and tested several recovery scenarios Perform ongoing database administration, maintenance, troubleshooting, tuning, installation, backup / recovery Management of table spaces for different users by granting quota on Default & Temporary tables paces.
• Implemented Tivoli Storage Manager for RMAN PL/SQL Coding and modifying packages, procedures and functions RMAN copy from Prod database to development, Snapshot refresh, Schema Refresh.
• Managed Application user profiles and managing concurrent managers, concurrent processing, load balancing etc Creation of rollback segments and planning application activities accordingly to enhance system performance.
• Copied databases, monitoring system performance, SGA tuning, rollback segments, space usage Database & Application Tuning through TKPROF & Explain plan Adept in Advanced Replication techniques using Materialized views.
• Tuned test and production database by altering the parameters Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using UNIX Shell scripting.
• Configured and implemented Data Storage Devices like SAN, NAS and implemented replication for existing system Estimated Storage capacity for database objects Monitored the growth of the database objects for capacity planning.
• Worked on various data migration activities using Export/Import utility and SQL * Loader Database security, job scheduling and documentation investigating suspicious database activity using Auditing.
• Worked with Oracle regarding troublshooting with SR creation.
• Worked with Capacity Planning team.
• Worked with UNIX Team regarding DR Testing and performed failover process.
• Data loading in oracle from different sources.
• Configuration of system databases like dbccdb, sybsecurity for monitoring and dbcc operations.
• Involved in troubleshooting of oracle servers and capacity planning.
• Responsibled for fixing log full/tempdb issues.
• Supported database performance in SAP environment.
• Checked storage on Oracle databases regularly.
• Performed changes in packages after migration.
• Designed file system with Oracle Optimal Flexible Architecture (OFA).
• Taken care of Crontabs & writing Unix Shell-scripts for data extract.
• Created and modifyied Scripts for user manage hot backup.
• Allocated system storage and planning future storage requirements for the database.
• Databases Patching.
• Implemented Database Backup (Physical and Logical) and Recovery strategy.
• Configuring TNSNAMES.ORA and LISTENER.ORA for Client-Server connections.
• Creating Database objects like (Tables, views, indexes, procedures, triggers etc).
• Monitored Alert Logs.
• Created, monitoring tablespaces and re-org them.
• Tuned Oralce9i database server using tools dynamic, dictionary views, Statspack, Diagnostic and tuning packages.
• Planed and Implemented backup and recovery of the oracle database.
• Created & Configured RMAN recovery catalog.
• Performance tuning for the production databases.
• Back end Programming using SQL and PL / SQL.
• Closely worked with SA.
• 7x24 support when required.

Environment: Win 2K, Win 2003 Server, Unix, Oracle 9.2/10g, TOAD, OEM, RMAN, STATSPACK,SAP 4.7 & ECC 6.0, Data integrator, Oracle Discoverer

Confidential, GA

Oracle DBA

Responsibilities:

• Installation, upgrading, configuration and maintenance of 9i/10g on both Windows NT and UNIX environments
• Having Good exposure for oracle 10g.
• Created and Maintained Roles and assign necessary privileges to users according to business rules.
• Allocated system storage and planning future storage requirements for the database
• Build and monitoring events.
• Implemented Database Backup (Physical and Logical) and Recovery strategy
• Configured TNSNAMES.ORA and LISTENER.ORA for Client-Server connections
• Monitored Alert Logs
• Choosing different types of data storages (Locally managed tablespaces, IOT and partition tables) and indexes in order to have good performance for SQL and DML.
• Tuning Oralce9i database server using tools dynamic, dictionary views, Statspack, Diagnostic and tuning packages.
• Created & Configured RMAN recovery catalog.
• Performance tuning for the production databases.
• Back end Programming using SQL and PL / SQL.
• Coordination with front-end developers in designing complex queries.
• Help users in creating database objects, and enrolling users.
• Coordinate all system changes with the Operational DBA.
• Worked as part of a team and provide 7x24 support when required.
• Created users and Creating Roles, and assigning privilege in it, grant to the role to the users, and Profiles
• Monitoring the alert logs regularly
• Coordinated with clients, in their regular activities in troubleshooting.
• Storage management, sizing the database objects, monitoring file Systems and tablespace growth
• Backing up the production database, synchronizing the standby database by responding to any physical changes in the primary database.
• Performed status checks by monitoring the status of databases, logs, archived redo logs etc.
• Applied ARCHIVE logs.
• Involved in testing phase of implementation of RMAN for various advanced backup and recovery options.
• Planed and Implemented backup and recovery of the oracle database

Environment:Oracle 8i, Windows NT