SUMMARY

• Extensive (12 years) experience in Oracle and SQL database administration(Installation, Configuration, implementation, designing, recovery and troubleshooting). Oracle RAC 10g, 11g, 12c Installation and
• Configuration on REDHAT, Linux 4, 5, 6.
• Proficiency in installing, configuring and administeringOracleandSQLServer RDBMS 10g, 11g, 12C andSQLServer. Oracle OEM 11g/12c installation and configuration on REDHAT Linux 4, 6.
• Configured Oracle OEM integration for SQL server management. Real time exposure on implemented and maintained Data guard 9i/10g/11g.

TECHNICAL SKILLS

RDBMS: Oracle RAC 9i/10g/11g & 12c, SQL Server 2005,2008, 2012 .

Operating Systems: Solaris 9/10, Linux RHAT 4/5,6, HP - UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows NT,2000/2003/2005.

High Availability, Tuning and Monitoring Products:

RAC, Golden Gate, SQLreplication snapshot, Dataguard.:

Tools & Utilities: ASM, Data Guard, Grid Control (OEM), Lab128, Spotlight, SSMS, Tkprof, Stats pack, AWR, ADDM, ASSM, Oracle SQL Developer, TOAD, RMAN, Export/Import, Data Pump (expdp/impdp), SQL Loader.

ETL & Reporting Tools: Informatica, Power Center 8.5/8.0,Data Stage6.0, 1.0, Business Objects Xi R26.1, Oracle Data Integrator, SAS, MS Excel.

Backup Tools: VERITAS Netback up, NetApp, TSM, EMC

Programming Languages: SQL, Unix/AWK, C, C++, Asp.Net, XML, HTML, DHTML, Java, T-SQL.

HARDWARE: Sun Fire X 4100, Sun Fire V104, HP Itanium, IBM, Intel.

Application server: Oracle 9i / 10G AS, Forms6i/5i, Fusion, Wed logic

PROFESSIONAL EXPERIENCE

Sr. Database Administrator

Confidential, Orlando, FL

Responsibilities:

• Installed a new oracle RAC 11g environment wif recommend ASM.
• Upgraded multiple databases from Oracle 9i, 10g to 11g and 12c.
• Performed performance troubleshooting for the database slowness
• Configured SQL server database into Oracle OEM.
• Provided support to snapshot replication database in SQL.
• Deploying recovery model and interval - Full, Bulk-logged and Transactional log maintenance.
• Improving query performance by creating database/table partition function and schemes.
• Tuned SQL query for better performance using SQL Profiler.
• Publishing transactional replication on production servers and distributing it to data warehouse and in scaling out to other reporting platforms.
• Involved on new project design and implementation wif development/ETL Team.
• Involved to support a fusion environment setup & configuration.
• Experienced in performing Point-in-Time Recovery wif ASM disk group.
• 24x7 Production database and applications support.
• Involved on annual database SOX/PCI auditing to get completed successfully.
• Installed, configured, and maintained Oracle 10g and 11gR2.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Performed block recovery using RMAN.
• Refresh data from Production to Test databases using RMAN & Data Pump.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Partitioned large tables for better performance and manageability.
• Sql server installation and configuration
• SQL/Oracle Backup failure analyze and fix
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.

Environment: Oracle 10g/11g/12c, RAC, ASM, DG, GC, OEM, Windows 2003, MSSQLServer, T-SQL, Visual Studio.Net 2003, SSIS, SSAS,SQLProfiler.

Database Administrator

Confidential

Responsibilities:

• Oracle RAC 9i/10g/11g installation and configuration on Linux/Aix platforms.
• Upgraded databases/ clusterware from Oracle 9i, 10g to 11g.
• Experienced in performing Point-in-Time Recovery.
• Performed database using physical standy method and Auxiliary method.
• 24x7 Production database and applications support.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Managed the oracle CPU/PSU patch apply
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Performed block recovery using RMAN.
• Moving data between databases using Data Pump.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Partitioned large tables for better performance and manageability.
• Great experience to coordinated wif oracle corporation and IBM team due to performance issues

Environment: PL/SQL,SQL,SQL*Plus,Oracle9i, 10g, 9iAS; Sun Solaris Unix, Linux, Windows XP,OracleForms 10g,OracleStreams,OracleReports 10g,OracleDeveloper

Database Administrator

Confidential

Responsibilities:

• Migrate database from production to beta, test environment using RMAN
• Real Application Clusters monitoring, tuning using OEM (Oracle Enterprise Manager), Statspack, and V$ dynamic views
• Sql server database installation, migration/upgrade
• Iinstalled and configured a SQL 2005 clustered environment wif availability groups.
• Configured and supported replication and log shipping in 2005.
• Setup a snapshot replication environment
• SQL server frame work
• Oracle/Sql database refresh to dev/test environment from production.
• Monitor and Tuning of Database Performance by using various optimization techniques
• Provide database administration on production, testing and development database servers. Creation of database objects like tables, indexes, synonyms and views etc
• Clone/Refresh of Production databases to dev and training environments
• Perform tuning of databases based on analysis of utilities such as TKPROF, EXPLAIN PLAN, etc
• Interacted wif Oracle Support for resolving various critical database issues.
• Installation support for IBM AIX version 5.3 and oracle related OS patches.
• Performed memory level application tuning
• Designed partition and migrated database using exp/imp
• Report sever implementation and tested using RMAN
• Setup and configured Physical standby database
• Database creation and database migration.
• Configured OMS console.
• Installed Sql server 2005 and configured a Snapshot replication mirroring.
• Installed and configured Oracle 9iAS and 10gAS on Linux environment.

Environment: PL/SQL,SQL,SQL*Plus,Oracle8i,9i, 10g, RHEL, AIX, Windows NT/2000, HP UX,TOAD, Grid Control,, OEM,SQLDeveloper, Microsoft management Studio