OBJECTIVE:

To obtain a position of Oracle DBA for operations. Collaborative, plan and execute with key stake holders to provide innovative solutions and opportunities for the organization to be successful.

PROFESSIONAL SUMMARY:

• 8+ years of experience in IT as Oracle database administrator.
• Expertise in creation of Oracle Database 9i, 10g, and 11g and upgrading to 12c on Red - Hat Linux, HP UX,Sun Solaris, IBM AIX and Windows environment.
• Professional experience in Oracle Installation, administration, performance tuning, Configuration, Upgradation, Migration and Maintenance of thedatabase on most flavors of UNIX namely Sun Solaris, AIX, HP-UX, Linux and also on Windows with proven ability at Server side & Client side responsibilities.
• Excellent experience with Oracle RAC (Real Application Cluster) 11gR2 and 10gR2 with ASM.
• Experience with Oracle Backup and Recovery (Cold backup / Hot backup / RMAN/ Ad-hoc backup).
• Establish Backup policy using RMAN. Also managed Backup, Restore using Data Pump.
• Expertise in performing Database/Schema/Table level refresh using traditional Export and Import with IMP/EXP, IMPDP/EXPDP and Recoveries using RMAN and conventional methods.
• Experience in Database Patching, Cloning.
• Maintained Databases by evaluating high availability options and disaster recovery plans to implement 10g, 11gOracle RAC and Data Guard according to business requirements.
• Experience in configuring the physical/logical standby databases with different protection modes.
• Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.
• Experience in implementing database design/planning and capacity planning, data modeling tools like Erwin.
• Expertize in implementing Change ManagementProcess and upgraded the Oracledatabase to higher version, ensuring stable database environment.
• Experience with WebLogic application servers and application authentication configuration.
• Experience installing/maintaining/tuning databases that support OBIEE and Oracle Business Intelligence Application software.
• Excellent knowledge of memory architecture (SGA/PGA/UGA).
• Experience in configuration of ASM for RAC and NON- RAC environments.
• Proficient on Oracle- RDMS concepts, SQL, and PL/SQL, T-SQL, Stored Procedures, Triggers, Functions, Views.
• Experience on EXADATA, Oracle Application Express(APEX),Amazon RDS and AWS (Cloud Service).
• Experience monitoringOracle RDBMS using Grid Control and via scripts.
• Experience in ConstructingCatalog databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.
• Experience with the administration and support of the Oracle SIEBEL environment (excluding experience in maintaining the user interface), Oracle Business Intelligence Publisher (BIP) and Oracle Enterprise Data Quality (EDQ).
• Experience with MS SQL Server 2005, 2008 (SSIS, SSRS), DB2, MongoDB, Cassandra,Post gres, Sybase .
• Experience with use of ODBCfor connecting Oracle databases to SQL Server databases.
• Experience in creating Golden Gate architecture,design and definitions.
• Experience with Oracle Golden Gate replication & CDC setup in various modes like: unidirectional, Bidirectional, Peer-to-Peer, etc.
• Experience in change replication, Initial load techniques with backup and recovery.
• Expertise in implementing Security at the database level, user level and the data level using Auditing.
• Good Knowledgeof enterprise data architecture principles.
• Excellent knowledge of networking (e.g., LAN/WAN).
• Experience onLarge Scale Data Mart, Data warehousing tools like Informatica including ETL process.
• Generating and Analyzing AWR, ADDMReports for troubleshooting performance issues. Extensively used Explain Plan, TKPROF and SQL Trace.
• Strong knowledge on deployment of SSIS packages and SSRS reports.
• Extensive experience in supporting multiple production databases running 24 x 7 mission-critical OLTP applications demanding high availability and increased performance.
• Experience in on-call support and 24x7 DBA for production environment and providing solutions to developer/user requests.
• Experience with setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
• Worked with Partitioned Tables and sub-partitions as per the requirement of the Applications to improve performance and data management.
• Experienced in database reorganization, regularly for removing row migrations and fragmentation using export and import utilities. Taking care of tablespace related issues like increasing the storage parameter values, resizing the data-files, adding new data files.

TECHNICAL SKILLS:

Languages: SQL, Unix/LinuxShell Scripting, Perl, Korn,DML, DDL, PL/SQL.

Databases: Oracle 11g/10g/9i, MS SQL Server 2000/2005, MS Access, MySQL, DB2, Sybase, Informix,Netezza, mongo DB, Cassandra, Hadoop, Spectral.

Operating Systems: Red Hat Linux, Sun Solaris,HP-UX, Windows.

Oracle Tools & Other Utilities: OEM Grid Control, SQL Loader, Golden Gate,APEX, EXADATA,Data Guard, Oracle internals,AWR, BDA CVS, Redshift, Ignite,Tkprof, Export/Import, Data Pump, AD Utilities, Quest TOAD,MS Office.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g to 11gR2 on Linux and also upgraded from Oracle11g.
• Involved in maintaining SLA requirementsby the team members to deliver quality solution adhering to SLA’s.
• Looking into day-to-day activities of Production database, Monitoring its growth and performance.
• Created, monitored and maintained Oracle database with necessary control files, initialization parameters.
• Enrolling new application users based on the requests and grants appropriate roles and privileges.
• Configuring RMAN Cold/Hot backups for the databases using OEM.
• Configuring and Maintaining standby databases.
• Worked withbusiness users and cross functional stake holders to define and document requirements.
• Build Data Guard to ensure high availability, data protection and disaster recovery.
• Identify patch dependencies requirement of Oracle.
• Golden Gate installation, configuration and troubleshooting various GG issues.
• Replicate & migrated databases using oracle Golden gate & implement RMAN database backup solution using LiteSpeed compression.
• Work with Oracle support to resolve issues on the oracle databases and oracle tools used by development teams.
• Oracle Golden Gate installation, upgrade, setup, monitoring, performance tuning, and troubleshooting.
• Experience in Golden Gate change replication, Initial load techniques with backup and recovery.
• Performing Golden Gate re-instantiation and taking necessary actions when replicates abed.
• Created RDS instances on AWS and migrated data using DataPump.
• Configured RDS database for backups, patches and maintenance.
• Installing Grid Infrastructure and Database software in single/Multi-nodes environment.
• Used 11g OEM Grid Control/12c OEM (Oracle Enterprise Manager) Cloud Control for Monitoring Databases, Troubleshooting OEM agent issues.
• Implemented Change management process and upgrading databases to higher versions,provided security user management by granting Privileges,Roles,Profiling, access control .
• Implemented security at user level, database(table, row & column) level.
• Worked on writing T-SQL queries and tuning them from better performance.
• Regularly involved with planning and scheduling Backups, Database Recovery, and LogicalBackups.
• Worked on creating, tracking, and reporting test cases.
• Interacted with clients, network, hardware and system operation teams to resolve problems related with application& database systems.
• Monitoring DB performance and tuning when required.
• Migrating databases from Non-ASM to ASM.
• Developed procedures for synchronization between different database environments.
• Worked on code Installations, setting Encryption, PL/SQL scripts, stored procedures, views, triggers.
• Closely worked with Oracle on Exadata tuning, patching.
• Performing Schema/Database refreshes using exp/imp, and expdp/impdp.
• Monitoring various scripts and alert log files to ensure that Data Guard, and the database are healthy.
• Cloning databases for testing/reporting purpose.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Confidential, Frisco, Texas

Senior Oracle DBA

Responsibilities:

• Creating databases in single node/Multi-node environments.
• Performed Installation, Configuration, and Monitoring of Oracle 12C, on AIX, Linux, UNIX and Windows environments.
• Supported Security User management, Privileges, Roles, Auditing, Profiling, and Authentication.
• Resolved space management issues whenever required.
• Backup database using user managed (Hot/Cold/Export) backups.
• Developed RMAN Backups, Data Pump, and disaster recovery management policies.
• Regularly Monitored of Database alert logs on Day-to-Day Basis .
• Interacting with teams on resolving issue related to system database access.
• Performed policies on data confidentiality, integrity, availability, based on Access controls for Access to Data at the database level.
• Performed various routine DBA tasks like tablespace Management, Alert Logs Undo-tablespaces, and temporary tablespace, etc.
• Transported the tablespace from the production database to development database for the usage of developers.
• Periodic Exports and Imports to reorganize the database and to move database from one to another Oracle database.
• Installed Cluster ware (10g/11g) software, creating ASM instances, creating databases.
• M onitoring of the database space, and space management.
• Worked on designing of physical database and their definitions using data modeling tools such as oracle designer or Erwin.
• Handled regular cleaning of theunwanted table from the database after confirmation from developers’ team and freeing the extra space.
• Export-Import for thetable, schema and Logical Backup, and planed refresh.
• Created Logical Storage Structures as per requirement.
• Creating new users, granting privileges etc.
• Build and configure physical standby database using Data Guard.
• Monitoring various scripts and alert log files to ensure high availability, and checking the health of the databases.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Worked on complex SQL queries, PL/SQL store procedure and triggers.
• Worked with development team in creating PL/SQL, Stored Procedures, Triggers, views,constraints and cursors.
• Worked on debugging issues reported by users. Analyzed complex PL/SQL packages.
• Worked with MS-SQL server.
• Experience in installing, managing, configuring backups for MS SQL server databases.
• Worked on refreshing MS SQL Server Dev database from production environment.
• Worked on SSIS packages and corresponding SSRS reports.
• Configured Oracle Net for Connection to the Servers (listener.ora) and at client side using (tnsnames.ora).
• Performed SQL and PL/SQL tuning Oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
• Rebuilding the indexes, shrinking the fragmented tables.

Confidential, Pittsburgh, PA

Oracle DB

Responsibilities:

• Supported and maintained Oracle 10g/11g.
• Created databases for Production, Development and ITG environments.
• Configured databases and monitored of all the databases using Oracle Enterprise Manager (OEM) 10g grid control.
• Production support for Oracle databases is10g/11g.
• Created scripts for the regular daily monitoring of the databases.
• Worked on Tickets to troubleshoot Oracle database related issues and also TSS upload & download issues.
• Provided security user management by granting Privileges,Roles,Profiling, access control.
• Creating objects like tablespaces, tables, indexes, synonyms, views.
• Created PL/SQL scripts to complete User activities triggered from front end.
• Created PL/SQL scripts to extract the data from the Database into simple flat text files using UTL FILE package.
• Regularly involved withDatabase Recovery, and LogicalBackups.
• Performing table refresh, schema refresh, database refresh.
• Performing logical backups using EXP/EXPDP, and importing using IMP/IMPDP whenever required.
• Rebuilding indexes for faster access which reduce disk I/O.
• Performed database optimization, query optimization and error control when needed.
• Upgrading and patching the 9i/10g databases.
• Configuring hot/RMAN backups and Recovery procedures for databases.
• Performed logical backup using export/import and data pump utilities.
• Creating Users and assigning and revoking privileges to the Users depending on user requests.
• Supported development teams in implementing database objects.
• Troubleshooting database connectivity from any client.
• Generating AWR, ADDM reports for analyzing the database performance.
• Restored & recovered some of the show site databases when they got corrupted.
• Perform Backups and Recovery, maintain 24 hours uptime for the database.

Confidential

Oracle DBA.

Responsibilities:

• Performed many new database installs.
• Creating database links, materialized views.
• Creating objects like tablespaces, tables, indexes, and views.
• Configuring listener.ora, tnsnames.ora files for remote connectivity.
• Performing table refresh, schema refresh, database refresh.
• Performing logical backups using EXP/EXPDP, and importing using IMP/IMPDP whenever required.
• Configuring hot/RMAN backups for databases.
• Documented the Backup and Recovery procedures.
• Creating Users and Assigning privileges to the Users.
• Securing the database from unauthorized users.
• Installed, migrated, configured and Oracle 11g databases in various environments.
• Supported development teams on design and implement different database objects.
• Provided full technical support to various application teams before the databases go to production.
• Troubleshooting database connectivity from clients.
• Performing cloning of database.
• Generating AWR, ADDM reports for analyzing the database performance.

Confidential

Oracle DBA

Responsibilities:

• Looking into day-to-day activities of Production/development/test databases, Monitoring its growth and performance.
• Created, monitored, and maintained Oracle database with necessary control files, initialization parameters.
• Supported and maintained Oracle 9i/10g.
• Resolved space management issues whenever required.
• Created users and roles for privilege management.
• Taking backups for database using user managed (Hot/Cold/Export, RMAN) backups.
• Export-Import for table moving and Logical Backup.
• Created logical Storage Structures (table spaces) as per requirement.
• Regularly Monitored Database alert logs on Day-to-Day Basis.
• Periodic Exports and Imports to reorganize the database and to refresh schema from one to another Oracle database.
• Generating AWR, ADDM reports for analyzing the database performance.