SUMMARY

• 8 Years of experience in oracle Database administration, tuning, development, analysis, Design, all phases of SDLC, installations, patches, upgrades, migration, configuration, Database security, capacity planning, Space Management, Data modeling, backup and recovery, RAC, Golden Gate cloning, SQL, PL/SQL, troubleshooting, Documentation and Created databases, schemas, tables, indexes, views, synonyms, triggers, Packages, Indexes, users, user permissions.
• Experienced in working in collaborative team environment with other developers, Business Analysts, Project Management team.
• Excellent experience in Installation, configuration, Maintenance of Oracle 12C,11g,10g, 9i RAC/Non RAC databases on Operating Systems UNIX, Solaris, Linux, AIX and Windows platforms
• Experience in Installation, Configuration and Maintenance of Oracle 11g/10gRAC with ASM and single instance database and Multiple Instance Database.
• Good work Experience in SQL, PL/SQL, Stored Procedures, Functions, Constraints, Triggers, Indexes, Views, Materialized views, SQL Loader, TOAD.
• Having good experience in database Backup and security using the RMAN Backup Techniques
• Experience in Upgrading of Databases from 11g to 12c And Configuring the Golden gate on 12c databases
• Extensive work experience in 2 - NODE & MULTI-Node RAC Installation with ASM & GRID
• Performance and Tuning of databases using AWR reports both in single node and RAC'd environments.
• OEM 12c was used to look real time as well as historical performance data to help pinpoint where the highs and lows were during business cycles.
• Strong experience in capacity planning, implementing backup and recovery strategy for application and database.
• Experience in installation of Agents on Hosts in both OEM12c & OEM 13c, Database Health checkup & Performance tuning running AWR report taking backups creating users by OEM 13c
• Setup RAC 2Node Configuration on the Databases on EXADATA and Configure Golden gate Between Two Different Datacenter’s
• Development of stored procedures, functions and assemblies in SQL server 2005
• Extensive experience with MS SQL SERVER 2016, 2014, 2012, 2008 R2, 2008 and 2005 Versions.
• Experience in migrating Code, database change management and data management through the various stages in development life cycle
• Configured Golden Gate and configured extract and replicate pumps for golden gate replication 11g/12c and troubleshooting issues using report files, Monitor status, lag and Checkpoint with golden gate
• Good knowledge of maintaining SQL authenticated and Windows authenticated logins /users and grant proper privilege.
• Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN.
• Extensive Experience in Database Cloning perform weekly refresh using RMAN duplicate as per the application team requirement
• Strong experience in monitoring and tuning sql server databases for optimum performance and assistance in capacity planning of sql server database servers.
• Worked on databases ranging from 300GB to 5TB and Participated in monthly on-call DBA schedule and attended the conference calls and remediated various issues/tasks which occurred
• Implemented backup for production database. Simulated few possible crucial recovery scenarios using the current available backups to check the effectiveness of the backup plans and also to get a rough estimate of the recovery time involved.
• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup using NETBACKUP.
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, ADDM, Advisories, TKPROF, SQL TRACE, EXPLAIN PLAN for the better performance.
• Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.
• Experience identifying scope and managing complexity of projects
• Maintained day-to-day production support thereafter, check alerts log, activity logs, error logs, RMAN log to capture any possible errors to ensure the databases health
• Converting data files across different platform using RMAN convert, Transportable Tablespace (TTS), Export/Import and Data pump (expdp/impdp).
• Have Hands on working experience in both Application and Production support environment
• Proficient in using Oracle utilities like export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM .
• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE data-guard
• Experience in installing, managing and troubleshooting SQL Server 2016,2014, 2012, 2008R2, 2008.
• Job scheduling using CRONTAB, at and batch utility at the OS level and Shell Scripting for automating DBA tasks.
• Very fluent in creation of Instances, Table spaces, IOT tables/ Partitioned tables/ Indexes, External Tables, Materialized Views, Bitmap Indexes, SQL*Loader, SQL Copy, PLSQL packages, objects, roles etc.
• Proficient in creating and administering users, creating profiles, roles to users granting privileges and administering password for users as desired from administration
• Met with business users and technical subject matter experts to understand and document problems and issues
• Good Experience in performing network configuration and involved in a Client-Server environment using, SQLNET, TNS names, LISTENER, Net Configuration Assistance and other configuration files.
• Experience with new features like Flash-Back Recovery, ASSM, AMM, ASMM, and Recycle Bin
• Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Database refresh from production to QA, development and testing environments
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• 24 X 7 Production & Development database support and administration. contributed to operational debates, helping to identify and address future opportunities and challenges
• Well trained in managing successful relationships which can influence stakeholders and shares knowledge effectively
• Hardworking, result oriented good interpersonal and communication skills.

TECHNICAL SKILLS

Operating systems: Solaris, Linux, Windows XP/2000/NT, UNIX

Databases: ORACLE 8i/9i/11gR1,11gR2, Real Application Cluster, SQL server 2000/2005

Tools: SQL PLUS, SQL*Loader, Export & Import Utility, Data Pump, RMAN, Data Guard 9i/10g, SQL Navigator, Oracle Reports, MS Office, XML Publisher, SSIS,SSRS,SSAS, Golden Gate,TOAD.

Languages: SQL, PL/SQL, Shell Script, Perl, C, C++, Java, HTML, XML, JavaScript

Terminal Emulation: Putty, Telnet, FTP, MobaXterm

PROFESSIONAL EXPERIENCE

Confidential, NewYorkCity NY

Senior Oracle DBA

Responsibilities:

• Installation, configuration, upgradation, Patches and maintenance of oracle database of oracle 10g & Oracle 11g&12c on RHEL.
• Worked on maintenance of Oracle 10g/11g RAC databases on Linux and Configured 2 Node RAC on Grid Infrastructure
• Configured Golden Gate and configured extract and replicate pumps for golden gate replication 11g/12c and troubleshooting issues using report files, Monitor status, lag and Checkpoint with golden gate
• Managed Users and maintained security, populated databases of oracle 10g & oracle 11g on RHEL, Solaris and windows 2003.
• Converted single Instance Databases to RAC databases manually and expertise in troubleshooting RAC issues.
• Provided project, testing, and implementation plans for the applications in the data masking project scope.
• Migrated, upgraded Oracle databases from 9i/10g/11gR1 to 11gR2/12c including the cross platform.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimize and update logical and physical data models to support new and existing projects.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.
• Work with development teams to implement change management for custom code migrated into environments.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF. Performing monthly and annual performance reports for trend analysis and capacity planning.
• Deploying Plug-Ins, Discovering & Monitoring Targets using OEM 13c, Creating Roles and Administrators & Configuring Auditing Framework.
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance
• Performed Data guard switch over to check the standby database is in SYNC with production as per the business requirement and also operated standby database using Data Guard broker.
• Extensively used Flashback for Supporting DML, DDL changes, and handled daily production problems/change requests (DBCRS) with Oracle Patching.
• Perform activities related to the day-to-day administration and maintenance of database systems.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Taking the RMAN incremental and cumulative and scheduling the databases backup using Cron tab.
• Developed backup, restore and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions
• Creating and managing database objects such as tables, indexes, partition tables, views, rebuilding indexes and rewriting the SQL queries to improve the performance
• Took Part in general technical trouble shooting and give consultation to development teams
• Taking Incremental backup & Implemented Point in time recovery using RMAN.
• Implemented and supported Golden Gate replication in production databases.
• Successfully configured and installed Oracle GoldenGate for Schema/Table replication
• Creating and managing database objects such as tables, indexes, and partition tables, views, rebuilding indexes and optimizing the code to improve the performance.
• Configured DDL Replication in GoldenGate to enable DDL Synchronization.
• Troubleshooting databases performance issues & application performance issues
• Use of SQL*Plus to run batches of PL/SQL scripts
• Resolved help desk tickets as assigned and provide 24-hour on-call support for problem analysis and resolution to system problems on a rotational basis.
• Implementing backup procedures using CRON Tab.
• Implemented procedures to detect the poor database performance, collecting required information, root cause analysis, successfully tuned and improved the performance of the database.
• Configuration and implementation of Oracle Streams (Advanced Replication) for high availability.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups. Renaming and resizing databases.
• Monitor Database Performance by scanning the Oracle Data Dictionaries for each day and know the problem SQLs.
• Involved in Configuration and maintenance of Standby databases for High availability using Oracle Data Guard for one of critical application at Enterprise level.
• Created custom services for RAC database for distribution of load across the nodes.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Migrating database changes, reference data changes, menu and form changes through the development life cycle.
• Responsible for granting required privileges and roles to users.
• Working with development teams in maintaining naming standards for newly developed databases objects and assisting in code deployment, migration and testing phases.
• Configured and implemented Oracle 11g ACTIVE DATA GUARD for Database Disaster Recovery by using DATA GUARD
• Migration of the application data from different RDBMS to ORACLE Databases.
• Migration of databases from non-RAC to RAC environments.
• Configuration of Multiple Listeners in the server and Net Service Names for the target databases using TNS names, sql net, Listener.ora.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.
• Provide technical support to application support teams and review the design and code changes before Production deployment to ensure that there are no impact/performance issues on the Production databases at later stages.
• Created DB links across databases and Solved Database connectivity issues by continuously monitoring the status of the listeners and instances. work with application team who deal with different platform

Environment: s: Oracle 11gR2(11.1.0.1,11.1.0.4,12.1.0.1), Troubleshooting DG, Oracle Exadata Database, SQL server analyzer, Windows XP, SQL*Loader, PL/SQL Developer Import/Export, RMAN, import & Export Data pump, Oracle Flashback, RAC, Golden Gate, Data Guard

Confidential - Jersey City, NJ

Senior Oracle DBA

Responsibilities:

• Designs, creates, and maintains databases in a client/server environment.
• Involved in the Disaster Recovery Exercise (DR) and recovered Production Databases with backups from tape (TSM).
• Verify daily, weekly, and archival backup integrity. Run restores and ad-hoc backups as needed. Work with management and system personnel to provide backup configuration.
• Responsible for specifying proper types of files organization, indexing methods, and security procedures.
• Experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Installation, Configuration and Maintenance of RAC (both 10g and 11gr2 (GRID)) and Non-RAC databases including standby databases.
• Experience in migrating databases from Non-ASM to Automatic Storage Management(ASM)
• Migrated 2 TB 5 node RAC database and 5 node physical standby databases from 10.2.0.4 to 11.2.0.2 on NFS storage and, Presented White paper on upgrading 10.2.0.4 databases to 11.2.0.2 to AIG DBA team..s
• Involved in Gathering user requirements, application design, and analysis of hardware requirement to meet business needs
• Creation of users and granting them the required roles and privileges accordingly
• Implementation of high availability solutions with oracle 10g RAC, Physical and Logical Standby Databases
• Install and configure Oracle Golden Gate and Veridata
• Worked on Solving the issues/gaps between the primary and standby databases in data guard environment
• Performing Oracle/DB2/My-SQL DB Refresh from Production to Stage, Quality & Development environments during various stages of UAT development based on Application team's request.
• Implemented Oracle 12c Multi-tenant RAC data base with 2 node cluster and instances using ASM storage.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required involved in tuning Queries stored Procedures by making use of PL/SQL collections and its BULK FETCH and BULK INSERT features to ensure high availability, implemented data guard with maximum availability and performance configuration for 16 production databases
• Performing day to day database administration task like table space usage, checking alerts, database backup logs etc
• Configured ALWAYS ON setup between different Datacenters and on Multi Subnet Cluster.
• Installed and Worked on SQL Server 2012 failover clustering which is built on top of a Windows 2012 server cluster.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Database Security Management involving managing Users, Roles and Privileges Expert in troubleshooting problems. Providing necessary privileges or roles to users as per the requirement.
• Performed database cloning to create Test and Development environments from Production
• Provide expertise in data storage systems. Develop backup and archival policies and procedures.
• Perform administration tasks (installing, maintaining, monitoring, recovering, rebuilding, upgrading, patching and performance tuning).
• Participated in doing schema refresh like taking export of one schema and importing it into another schema using different ways of utility tools like REMAP SCHEMA, REMAP TABLESPACE
• Coordinate the activities related to running production/test/development Application environments. Develop and implement solutions for database sizing/capacity, server requirements and space requirements.
• Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
• Setup Golden gate in RAC environment for near zero down time strategy and for replication purpose logical database design, complex recovery management, SQL coding and optimization techniques, etc.
• Work with development teams to implement change management for custom code migrated into environments.
• Day to day activity of Monitoring maintenance plans, scheduled jobs and Database health check in SQL Server
• Resolve help desk tickets as assigned and provide 24-hour on-call support for problem analysis and resolution to system problems on a rotational basis.

Environment: Linux, oracle 9i/10g/11g/12c databases, RAC, ACFS, Data guard, Oracle RMAN, WINDOWS SERVER, SQL SERVER 2008/2012/2014, Putty, Telnet, FTP,GoldenGate

Confidential

Oracle DBA

Responsibilities:

• Upgraded the Databases from Oracle 10g/11g to 11g and 12c and applied patches according to the client requirement in RAC and NON RAC environments with ASM and Non ASM storage.
• Installed, configured, and managed Oracle on 11g, and 12.1.0.2 multi-tenant, single instance on a Linux and window platform.
• Installed, Created and maintained 2 Node 11g RAC with ASM and created database for production, development and test environment on HP-UX platform.
• Upgraded Oracle databases on CentOS (11.2.0.4 to 12.1.0.2), RHEL (11.1.0.7 to 11.2.0.4), and Windows
• Performance tuning and testing stored procedures, indexes and triggers using SQL server profiler, execution plans and Data Tuning advisor.
• Cloned database for test and development using RMAN, IMP/EXP, and data pump utilities.
• Managed, monitored and optimized the performance of databases on a periodic basis using AWR reports and provided recommendations to developers and project team leads.
• Automated database administration routines in backup and recovery using Recovery Manager (RMAN) as well as using routine IMP/EXP, IMPDP/EXPDP utilities, CRONTAB and DBMS SCHEDULER.
• Extensively worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
• As per SECURITY MANAGEMENT worked in claims database on 11gR2 with 2 node Data guard and Tested Switchover and Failover. Resolved system file corruption.
• Managed database security by creating users, assigning roles, monitoring profiles, and providing privileges for implementation and maintenance of user security on Oracle 10g, 11g and 12c.
• Refreshed development and test database from production using traditional Import/Export, Data Pump Export/Import, and RMAN backups.
• Performed Oracle quarterly PSU and CPUs patches using O-Patch.
• Responsible for implementing a solid RMAN backup strategy that meets the organization's SLA.
• Loaded and transfer data by means of SQL Loader.
• Configured and worked on SSIS tool to develop data integration and workflow solutions
• Moved pluggable databases between the container databases and created pluggable databases from seed databases.
• Worked on (ETL) DATASTAGE and ABINITIO by creating new projects, users, assigning privileges for users on projects, implementing common project settings, moving code by importing and compiling data and worked on unlocking the users and jobs and troubleshooting job design issues
• To ensure high availability, implemented Data Guard with maximum availability and performance configurations for 16 production databases
• Performed cloning using RMAN to set up development and test databases from Production database and Automated the nightly RMAN backups for the Production and some development Databases in Crontab.
• Performed daily incremental backup and full weekly backup using Oracle backup utility RMAN
• Implemented Backup and Recovery Strategies using RMAN and used 11g new feature Recovery advisor to repair data block corruptions & data dictionary corruptions
• Investigating suspicious database activity using Auditing.
• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication
• Write database documentation, including data standards, procedures and definitions.
• Provided remote database support for users using SSH and terminal services
• Implement database security configurations in new production environments, including tablespace encryption, data reduction, and data masking.
• Tune database and SQL statements using tools like Explain Plan and AWR, as well as monitor database performance on a regular basis.
• Worked with Data Warehouse team on problem resolution and implemented change requests. - Performance tuning on Data Warehouse such as Data extraction from production to Data warehouse. Worked with Developers for High frequency data transfer
• Write Shell scripting to manage and automate daily and weekly activities, as well as to automate backup based on backup strategy.
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database and applications issues.

Environment: Windows, RHEL, Oracle 11g, Oracle RAC (11g), Data Guard, RMAN, ASM, SQL Developer, SQL*Plus, FTP, SSIS, PL/SQL, MySQL, Putty, Telnet

Confidential 

Oracle DBA

Responsibilities:

• Responsible for, both manage and support 6 production databases and 15 development/test databases with sizes of databases varying from 50 GB to 550 GB.
• Perform daily administration support for database backups, performance tuning and monitoring
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Worked with Data pump to take the logical backups of databases.
• Worked in performing Point in time recovery using RMAN.
• Resolve help desk tickets as assigned and provide 24-hour on-call support for problem analysis and resolution to system problems on a rotational basis.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.
• Standby database setup via 10g data guard for database Disaster Recovery.
• Administration of databases- Physical and logical structures.
• Export/Import data to/from PROD and Non Production systems as required.
• Expertise in database backup and recovery management (Hot/Cold, Exp/Imp).
• Identifying and resolving resource contention issues and monitoring database performance.
• Troubleshooting based on application team errors
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.
• Monitoring the data loading jobs and tuning the SQL queries.

Environment: Environment: SQL*Loader, RMAN, Data Pump, Export, Import, Putty, FTP, Telnet, Windows Server, Linux, VMware, VirtualBox