SUMMARY

• Over 10 years of experience in System Analysis, Design, Development and Administration on Oracle 9i/10g/11g/12c Database.
• Upgraded the Databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.3 to 12.1.0.0 and applied patches according to the client requirement.
• Around 3 years of experience in MS SQL SERVER 2012/2008R 2/2008//2005/2000 Database
• Administration and Development in Windows environment.
• Around 2 years of experience in Oracle 11g Database Administration
• Around 2 years of experience in PostgreSQL 9.4 Database Administration
• Good experience in setting up and administration of SQL Server, PostgreSQL and Oracle databases in
• AWS environment
• Awell - organized, goal-oriented, highly motivatedandeffective team leader/member with excellent analytical, troubleshooting, and problem solving Skills.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Good experience in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager functionality using TSQL Scripts and Batches
• Experience in Installation, Configuration, up gradation and Maintenance of Oracle Databases.
• Installed, Upgraded and Maintained Oracle RDBMS on Linux, UNIX & Windows platforms.
• ACHIEVED High Availability, Scalability and Performance by determining the Cluster architecture choosing the best MPP RAC servers and hardware configuring the raw devices for Oracle RAC.
• Installed and Monitored Oracle 11g/10 g RAC software and experienced on Performance Tuning on RAC.
• Implemented advanced features of Oracle 11g/10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Experience in Performance tuning, Application tuning and Query Optimization using Oracle supported tools such as EXPLAIN PLAN, TKPROF, AUTOTRACE, etc.
• Expertise in creating primary database storage structures (Table spaces) and primary objects (Tables, Views and Indexes).
• Hands on experience with tools like SQL*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM), and TOAD.
• Hands on Experience in Space Management, Capacity Planning.
• Creating Users, Roles and Profiles, Privilege management with role-based security.
• Backup of database Logical and Physical (hot and cold) using Backup script procedures and also using RMAN.
• Experience in Auditing and Capacity Planning, Configuring & Managing Hot Standby Databases (Data Guard).
• Handling Tools such as Toad, SSH, SQL Navigator, and OEM.
• Ability to work under extremely tight deadlines and can maintain focus on objectives and processes and troubleshooting, implementation and development skills.
• 24x7 production database support.
• Keep abreast of current and emerging technologies to maintain skills levels necessary to provide quality service to customers.
• Proficient in documenting the processes.
• Good communication and Interpersonal skills.
• Commitment to team work concepts.
• Effectively handle multiple tasks simultaneously and have ability to acquire and apply knowledge rapidly.
• Co-ordination with Oracle Corporation for technical support, new products and releases, technical discussion/support.
• Experience in using tools likeSQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance, Idera Diagnostic Manager
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c
• Amazon Web Services;As a passionate advocate of AWS within Gracenote, I migrated my department from a physical data centre environment to AWS. I also designed, built, and deployed a multitude applications

TECHNICAL SKILLS

Operating Systems: Linux, UNIX, Sun Solaris, AIX 4.2, HP-UX 11i.

Hardware Platform: Windows, HP-UNIX server, RHEL-AS 2.1.

Languages: SQL, PL/SQL, C, Bash & Korn Scripting, PERL Scripting.

Tools: /Utilities SQL, Import/Export, Import/Export data-pump, RMAN, SQL*LOADERAWR, STATSPACK, iSQL*PLUS, TOAD, ERWIN, Procedure-BuilderSQL*PLUS, Enterprise Manager Grid Control and Database ControlKnowledge of Oracle Internet Application Server, DBCA, OUI, WorkingKnowledge of Data Guard.

DBMS Tech: Oracle 9i, 10g, 11gRAC,12c,12c OEM

CLOUD Technologies: AWS \ RDS \ EC2

Microsoft tools:: Microsoft Office and Excel 2016/2010/2007/2003/2000

PROFESSIONAL EXPERIENCE:

Confidential, Vienna VA

Sr Database Administrator

Responsibilities:

• Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Installation, Configuration and Administration of Oracle RAC 11g/12c Databases on Oracle Enterprise Linux.
• Worked on Grid control Oracle Enterprise Manager 13c (OEM)
• Installation, Upgradation, Configuration and Troubleshooting GoldenGate 12c software.
• Configured GoldenGate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.
• Install, configure and support uni-directional Oracle-to-Oracle replicated environments utilizing Golden Gate for reporting.
• Using the GolgenGate Process to masking the sensitive data for reporting.
• Masking the Critical Sensitive data using Oracle Masking process and Implement the fully automation of masking process using EMCLI tool.
• Applying the PSU patch every quarterly for every Prod and Lower environment in the database and Yearly on Cluster using Rolling Fashion.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible.
• Reorganized tables and indexes within databases when needed.
• Creating the 12c multitenant cluster database for new application and provide the end to end support to configure the application to connect 12c database.
• Administer all WebLogic servers, domains, clusters in all environments: Production and non-Production
• Design and implement Oracle Fusion Middleware components for systems integration on WebLogic 11g and OAS 10g platforms
• Integrated Oracle Access Manager 11g, OID 10g/11g on WebLogic 11g with OHS 11g web server
• Implement, Maintain, and Troubleshoot WebLogic SSL/LDAP integration with SSO (OSSO 11g)
• Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.
• Installed and configured Golden Gate JAgent to work with OEM GoldenGate Plugin.
• Performed Schema level and Table level data refreshes from Production to Development environments using Datapump EXPDP/IMPDP.
• Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.
• Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.
• Monitoring the availability of system, listener, database, alter log file, trace file.
• Experienced in working and monitoring the databases by using Oracle Enterprise Manager (OEM).
• Supporting both production and development activities.
• Creating of databases for Testing, Development and Production.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Setup of Standby database for faster disaster recovery and Data Guard setup for high availability.
• Written PERL and UNIX shell scripts for digitization the process.
• Load balancing, databases/schema/table re-organization for faster performance.
• Performing Capacity planning and evaluations with regular Maintenance cycles.
• Installation of Oracle version 10g on Linux.
• Applying patches whenever required.
• Migration of Database from 9.2.0.6 and to 10.2.0.2 using DBCA and Performed Validation tests.
• Extensively used SQL server BCP utility and IMPORT/EXPORT to load the database from text files received from different applications Continuous Performance Monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, STATSPACK etc.
• Monitoring and Troubleshooting of Database Replication issues using Shareplex Tool.
• Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Tablespaces and allocation tables to different Tablespaces.
• Performance Tuning of Oracle Database Objects.
• Taking periodic Backup of the database and the software using RMAN.
• Handling Database storage, Reading Alert. Log and User trace Files and Diagnosing the Problem, Scheduling jobs through Oracle job Scheduler.
• SQL Tuning for Performance of Objects.
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, for Health Check of Databases and for Analyzing of Tables and Rebuilding of Indexes, Scripts for Cold Backups, Script to check Oracle errors in alert log file and Send Mails.

Environment: Oracle 10g, SQL SERVER, Oracle RAC on Linux, Toad, RMAN, SQL*Plus, SQLPL/SQL, SQL*LOADER, Oracle OEM, Import/Export.

Confidential, NY

Sr. Oracle Database Administrator

Responsibilities:

• Implemented 100TB of Backup system for Exadata databases machine and Exalogic Elastic cloud computing servers & VDI environment involving Oracle ZFS 7420 storage systems and HP Data protector 6.11.
• Patched 11g Grid Infrastructure & RAC databases on Exadata Database Machines.
• Patched Oracle Exadata Machine 11g R2 Grid Infrastructure and RAC databases. Involved in Exadata switch patching and cell storage.
• Configured Oracle Grid monitoring system for Exadata database machine & Exalogic on separate network.
• Implemented Oracle Virtual Machine virtualization 2 node cluster on HP Blade G470c servers for different needs.
• Implemented Database Listeners on infiniband network from Exadata Machine to Exalogic Machine.
• Worked on Scan listeners for 11g grid infrastructure.
• Administering Cell Storage servers for Exadata Database Machines.
• Extensively Administered Oracle Apps r12, 11.5.10 e-business applications on RAC.
• Upgraded Oracle APPLICATION 11.5.9 to 11.5.10.
• Patched, Cloned and administered Oracle Apps 11i with ad utilities (ADADMIN, ADPATCH, ADCTRL, and ADMERGE).
• Solved issues related to Concurrent Manager on oracle apps 11i.
• Provided installation, configuration support of Oracle RAC9i, 10g, 11g RAC databases from building server to installing databases.
• Involved in upgrading Oracle9i to Oracle10g database
• Configure workflow notifications, printers, and form servlets in Oracle financial applications.
• Cloned 2-tier, 3-tier eBusiness suite application from production to test environment.
• Involved heavily in different kind of cloning requirements. Restoring databases in same cluster system and different cluster system to other database.
• Worked extensively on HP data protector and managed system wide backups. Configured backup polices for oracle databases and system wide backups.
• Involved in patching 10g ASM instances and CPU patching for RAC instances and single instances.
• Performed 10.2.0.3 Oracle RAC Cluster ware upgrade to 10.2.0.4. Upgraded 10.2.0.2. databases to 10.2.0.4

Environment: SQL Developer, TOAD, Spot Light, VMS Server

Confidential, Reston, VA

Sr. Oracle Database Administrator.

Responsibilities:

• Upgrading Oracle Golden gate 11.1.1.0 to 11.2.1.0.1
• Installing Oracle Golden Gate for EBS Reporting Databases
• Oracle and SQL server Database Capture using Oracle Golden Gate 11g
• Data Extract, Conversion and Load using Golden Gate
• Configuring Extract Parameters for Golden Gate EXTORA, RMTHOST, RMTTRAIL
• Configuring Replicate Parameters ASSUMETARGETDEF, REPOR, DISCARDFILE
• Creating GLOBALS for Golden Gate and Adding database checking points.
• Migrated the data from old storage to a new EMC INVISTA Storage to minimize downtime and provide High Availability.
• Migrated data on different Oracle versions of 9i and 10g, 11g and on different operating systems of AIX/Sun Solaris/Linux.
• Migrated data from File System/Non - ASM to ASM storage.
• Migrated data from ASM disks to ASM disks by using Rebalancing techniques.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 5
• Production databases and few development databases.
• Recovered data files from block corruption using RMAN.
• Reduced production outages by implementing best practices of patch management, purge/archival, code
• Optimization and applied rolling patches such as PSU and CPU on RAC after testing on DEV, QA and Staging.
• Taking backup of databases using RMAN.
• Used tools like export/import and data pump export/import.
• Involved in export and import of database objects in order to copy them from one database to another &for backup the tables.
• Created a physical standby for Disaster Recovery (DATA GUARD).
• Experienced writing UNIX scripts and troubleshooting issues.
• Upgraded Real Application Cluster (RAC) from Oracle 9i to Oracle 10g on HP-UX.
• Used tools like TOAD, SSH.
• Involved in Database Tuning for the performance of databases.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as TKProf, STATSPACK, Explain plan and SQL*Trace.
• Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between two oracle servers.

Environment: Oracle 9i/10g/11g, Oracle RAC/ASM on AIX/Sun Solaris/Linux/WIN, Oracle Golden Gate 11g (11.2.1.0 and 11.1.1.), Toad, SSH, RMAN, SQL*Plus, SQL, Import/Export.

Confidential, Richmond VA

Sr. Oracle Database Administrator.

Responsibilities:

• Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Experienced in working and monitoring the databases by using Oracle Enterprise Manager (OEM).
• Supporting both production and development activities.
• Creating of databases for Testing, Development and Production.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Setup of Standby database for faster disaster recovery and Data Guard setup for high availability.
• Written PERL and UNIX shell scripts for digitization the process.
• Load balancing, databases/schema/table re-organization for faster performance.
• Performing Capacity planning and evaluations with regular Maintenance cycles.
• Installation of Oracle version 10g on Linux.
• Applying patches whenever required.
• Migration of Database from 9.2.0.6 and to 10.2.0.2 using DBCA and Performed Validation tests.
• Upgraded from SQL SERVER 2000 to SQL SERVER 2005.
• Created and scheduled the packages using SQL server DTS packages.
• Extensively used SQL server BCP utility and IMPORT/EXPORT to load the database from text files received from different applications Continuous Performance Monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, STATSPACK etc.
• Monitoring and Troubleshooting of Database Replication issues using Shareplex Tool.
• Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Tablespaces and allocation tables to different Tablespaces.
• Performance Tuning of Oracle Database Objects.
• Taking periodic Backup of the database and the software using RMAN.
• Handling Database storage, Reading Alert. Log and User trace Files and Diagnosing the Problem, Scheduling jobs through Oracle job Scheduler.
• SQL Tuning for Performance of Objects.
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, for Health Check of Databases and for Analyzing of Tables and Rebuilding of Indexes, Scripts for Cold Backups, Script to check Oracle errors in alert log file and Send Mails.

Environment: Oracle 10g, SQL SERVER, Oracle RAC on Linux, Toad, RMAN, SQL*Plus, SQLPL/SQL, SQL*LOADER, Oracle OEM, Import/Export.

Confidential

Oracle DBA

Responsibilities:

• Working closely with functional and development teams, involved in migrating of data from legacy system
• Configuring the Printer (Style, Driver, Type) compatible to the reports
• Applying Patches/Patchsets/Mini-packs on database using Adpatch
• Monitoring the Database Growth and providing proactive Space Management for database of 50+ GB
• Designing the Backup Strategy, Testing Strategy, Taking Backup (Cold/Hot), Maintaining Backup and Archived files on tapes and Restoring / Recovering the database as and when required
• Configuring the Production Database to be in ARCHIVELOG Mode with mirrored Control, Redo Log files
• Developed Shell Scripts
• Refreshing the Development and Test instances (in NOARCHIVELOG Mode) with Production
• Data stage Administration and Support
• Validate / Schedule / Run / Monitor Jobs using Datastage Scheduler.
• Cloning Oracle 11i Instance for development and testing purpose.
• Create and maintain custom responsibilities and menus.
• Designed and maintained schemas involving creating tables and indexes with scripts,
• Creating triggers, and creating procedures.
• Used the oracle NET8 Configuration Assistant to establish network sessions between client and server machines using host names and local names methods. (Configuration of TNSNAMES.ORA and LISTENER.ORA).
• Responsible for troubleshooting of the connectivity problems for end- users by configuring tnsnames.ora, listener.ora and sqlnet.ora files.
• Allocating system storage and planning future storage requirements for the database system.
• Maintain database security, user roles and access profiles, involved in taking cold and hot backups.
• Daily monitoring and checking the Background Dump File (alert SID Logs) and User Dump Files for errors.

Environnent: Oracle Applications 11i, Oracle 9i, Linux, HP-UX

Confidential

Oracle Database Administrator

Responsibilities:

• Installed 9i, 8i, database on Windows 2000 and SUN SOLARIS.
• Backup of database using RMAN
• Wrote control files for SQL * loader to load data into data warehouse.
• Provided database related services to their development and QA environments.
• Was actively involved in constant site enhancements along with developers - code and data push between different servers and testing and moving to production.
• Logical and Physical backup procedures.
• Data exports from production and staging databases.
• Tuned SQL queries to pull data from data warehouse tables.
• Tuned production database performances and was instrumental in SQL tuning that improved application response.
• Run oracle stats pack to tune the databases.
• Wrote SQL scripts for DB monitoring, and online backups.
• Implemented database related security measures that proved very effective.
• Implemented Oracle Replication to enable database fail over in case of system or database crash.
• Backup and recovery using cold, hot and export methods.
• Wrote database triggers, functions and procedure by using PL/SQL.
• Automated a no. of database related jobs.
• Set multiple destinations for archives redo logs for safety.

Environment: Oracle 9i, UNIX-AIX 4.2, Window 2000.