PROFESSIONAL SUMMARY

An Oracle Certified Associate – Database Administrator with over 8 years of experience in handling Production and Development Databases. Worked on wide range of projects ranging from implementations, architecture, development, upgrades, conversion, integration, customizations, security, testing and production support. Extensive experience in Database Backup and Recovery, Database Programming using SQL/PL/SQL and SQL Server Administration

• Over 8 years of IT experience in Administration of Oracle 11g, 10g and MS SQL Server
• Installed and Configured Oracle Database 10g and Oracle 9i Database on HP UNIX RISC server.
• Experienced of the Oracle Golden-Gate installation, configuration, pumping and replication processes, debugging issues such as abend.
• Extensive experience in working with Oracle 11g version including upgrades, creation, backup and recovery and Standby database on Linux and Windows Environment.
• Extensive Experience in installing, configuring, patching, upgrading and administering Terabyte Oracle Databases on Oracle 10g
• Experience in manual backup and automated backup scheduling (crontab)
• Experience in managing Physical Database Structures - Control Files, Redo Log Files, Archive Log files, Parameter Files, Data Files.
• Experience in managing Logical Database Structures – Tablespace, Extents, Segments, Tables, and Data blocks, Partition Tables, Indexes, Views, Materialized Views, Users and Roles.
• Extensive experience in oracle utilities – EXPORT, IMPORT, SQL*LOADER.
• Extensive experience in maintaining Disaster Recovery (DR) Sites with physical Standby Databases.
• Significant experience with RAC, ASM, DataGuard.
• Experience in managing Database Using OEM.
• Proven ability to quickly learn new technology and apply them to business solutions.
• Experience using Oracle backup utility RMAN to implement Oracle Backup.
• Engaged in numerous DR (Disaster Recovery) strategies and implementation.
• Experience in SQL Server administration which includes Installation, Upgrades, migration, performance tuning, database backup and recovery, backup strategy & recovery.
• Tuning of SQL Statements and generation of EXPLAIN PLAN, AWR report.

TECHNICAL EXPERIENCE

Programming C, C++, SQL, PL/SQL and JAVA
Mark up Languages HTML/XHTML/CSS
Packages MS Office Suite, Adobe Photoshop, Rational Rose, Visual Basic
Database: Oracle 9i/10g/11g and Microsoft SQL Server 2005, Oracle Golden Gate
Repository database
Software/Tools: Oracle Golden Gate 10x, TOAD 7.x/9.x, Oracle Enterprise Manager
(OEM), Recovery Manager (RMAN), Grid Control, RAC, Datapump, AWR, ADDM, Microsoft Office 2000/2003/2007
Operating Systems: Win 98/2000/XP/VISTA/7, Win NT/Server 2003/Server 2008, UNIX Sun Solaris 10/SPARC 10, Linux Redhat 5,HP-UX 11, Suse Linux 2.6.5,

PROFESSIONAL EXPERIENCE

Confidential, New York Jan '11 to Current Oracle Database Administrator

• Work in a team environment where providing support of 30 instances for Oracle 9.2.0.8, 10.2.0.3 and 6 nodes RAC on ASM on Windows environment.
• Daily and intraday monitoring of database health includes availability, reliability, performance, capacity planning, server clustering, replications, and connectivity, with timely production issue remediation.
• Performance tuning includes indexing, compression, drive distribution, load-balancing, replication
  Setup and maintain accounts, access levels, and security, with monthly/quarterly security auditing of terminated/non-current users.
• Translate technical database issues, requirements, limitations and parameters for management and staff, and understand business work processes and business impact.
• Coordinate with and provide support for applications programmers, system programmers, users, administrators, and IT personnel where databases are concerned.
• Develop and maintain build standards and procedures for the database environment.
• Providing consultation support to development teams and systems administrators.
• Providing consultation and development support for the physical database design for database applications in production and development environments.
• Providing consultation support for logical database design for database applications in production and development environments.
• Responsible for monitoring physical capacity.
• Monitoring informational/error logs for messages specific to system operation (share responsibility for monitoring with Systems Administration and Production Control
• Providing database device configuration data (hardware and software) for systems administration, such as disk usage, memory, etc.
• Performing database modification function against production applications, such as altering table support for non-production status applications as requested.
• Created a standby database on 10gR2.
• Set up, configured and managed standby database on ASM
• Recovered database per requests.
• Add new database onto 6 nodes RAC using ASM.
• Monitoring databases and backup daily.
• Use ASMCMD to delete archive logs weekly in the prod, test/dev environment.
• Deploying scripts to dev/test/prod successfully.
• Create database using dbca and netca to create listener.
• Rotating 24x7 on-call responsibilities.
• Troubleshoot oracle errors using Metalink and any other resource available

Environment / Software/Tools: Oracle Golden Gate 10x, Oracle Golden Gate Veridata v2x/3.0, TOAD 7.x/9.x, F-secure, Oracle Enterprise Manager (OEM), Recovery Manager (RMAN), Grid Control, RAC, ERStudio 7.5, Linux Redhat 5, HP-UX 11, SQL, PL/SQL, UNIX shell.

Confidential, New Jersey Nov '09 to Dec ’10
Oracle Database Administrator

Responsibilities:

• 24X7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation and Configurations of Oracle 9i, 10g, and 11g RAC on Linux.
• Working With Automatic Storage Management (ASM) ENVIRONMENTS.
• Proactive database monitoring using 10g grid monitoring tool.
• SQL tuning using stats pack and explain plan, tkprof.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Installation, Configuration and Maintenance of Stand by database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading from Oracle development and production databases 9i to 10g & 11g.
• Applied patches to Oracle Databases.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implementing Hot, Cold and Logical backup plans.
• Management of schemas, objects partitioning the tables & indexes.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform all other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Standby.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Active participation in Production maintenance.

Environment / Software/Tools: Linux 4.0, Windows 2003, Streams, Golden Gate ASM, Oracle 11g/10g/9i RAC, MySQL, SQL*Plus, Grid Control, TOAD.

Confidential, Maryland Mar '08 to Dec ’09
Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle RAC, ASM and non-RAC database on Solaris, HP-UX, Linux, Extensive experience with RMAN, DataGuard and database tuning.
• Extensive experience with RMAN, DataGuard and database tuning.
• Creating tablespaces and database files based on the OFA model. Implemented physical database design after sizing tables and indexes and creating tablespaces. Setting privileges, indexes, user logins, password (security).
• Locally managed tablespaces were used which track all extent information in the tablespace itself. This results in improved performance as it eliminates recursive operations and reliance on data dictionary.
• Performed SQL tuning by using Explain Plan.
• Making structural changes to the databases when database design changes are to be implemented.
• Implementation and maintenance of read only snapshots and snapshot logs.
• Refreshing development/test database from production using Export/Import. This is done so that the latest data is available in the development/test database.
• Developing UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, Unix error messages, checking for errors in alert logs and trace files, etc.
• Loading the database with SQL*Loader.
  To improve the performance by Using the Hints ,Indexes ,Explain Plan , SQL Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data
  Performing the logical and physical structure of tables ,indexes, modeling ,normalization and foreign key constraints
• Database maintaining including backups ,recovery ,imports/exports
• Monitoring the database daily activities
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL
• Installed and configured RMAN.
• Installation, setup and configuration of Data guard.
• Cloning databases using scripts as well as RMAN.
• Creating new databases, configuring backups and maintaining
• Taking Hot and Cold Backups, Logical backups (Export) on specified databases.
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting in csh, ksh (KORN) for automating startup/shutdown of databases, getting system alerts etc.
• Deciding the naming conventions of data file, redo log files, tablespaces, and segments.
• Generating the STATSPACK reports.
• Did SQL tuning and Instance tuning.
• Creating new tablespaces, tables, indexes, synonyms, procedures, functions etc..
• Worked on Replicated databases
• Clone/refresh the databases for users to generate reports.

• Efficiently led and performed installation, configuration and administration of Oracle Servers including oracle 11g and 10g with Clusterware, ASM, RAC, and DataGuard solutions on Unix
  servers, and standalone databases on Windows servers.
• Backup and Recovery. Setting up and testing the backup and recovery strategies.
• Implementation of Oracle Standby Database using DataGuard in oracle 10g.
• Backup and Recovery of Oracle 11g Database using RMAN.
• Implementation of standby Database on Windows Server 2003 on Oracle 11g Database.
• Work as Team Leader for Handling the Team of 6 members.
• Oracle Database and SQL tuning using EXPLAIN PLAN, TKPROF etc.
• Diagnose and troubleshoot Database problems and failures.
• Establish Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Management of Backup and Recovery Using OEM.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Monitoring of database for growth and performance.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Setting up and maintaining user accounts and profiles.

Environment / Software/Tools: Oracle 10g, HP Unix, Export/Import, RMAN, EXPLAIN PLAN, SQL, PL/SQL, and Windows NT/2000/2008.Oracle 9i, Windows Server 2003, Hot backup and cold backup, OEM, PLSQL.

Confidential, New York Feb '07 to Nov’08
Database Administrator

Responsibilities:

• Installed and Configured Oracle Database 10g and Oracle 9i Database on HP Unix RISC server
• Interacting with development team and estimate database size and space requirements.
• RMAN Implementation with or without recovery catalog.
• Implemented DataGuard and configuring Listener and TNS for it. Configured standby with data guard and backup with RMAN. Clone test instance to support development.
• Management of Backup and Recovery Using OEM.
• Migration of database using Export/Import.
• Database upgrade using patches (Manual Upgrade).
• 24 * 7 telephonic supports to client & Junior DBA.
• Creation of tablespaces, UNDO tablespaces users and granting/revoking roles to them.
• User management issues involving control user access to resource and Information by allocating proper privileges.
• Tuning of SQL Statements and generation of EXPLAIN PLAN, AWR report.
• Attending weekly Turn meeting, understanding Developer/user request. Ensuring weekly backup is successful.
• Shell scripting and programming in PL and SQL, cron jobs for database operation, and database security.

Environment / Software/Tools: Oracle 10.2.0.5, Linux 5.x, RMAN, AWR, PL/SQL, TOAD, SQL Profile,, Windows 2003, PLSQL.

Confidential, New Jersey Sep '05 to Dec ’06
SQL Database Administrator

Responsibilities:

• Installed MS SQL Server 2000 and 2005, Performed Database Design and created User Database
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, triggers & maintained Referential Integrity.
• Maintained and created replications (Transactional and Snapshot).
• Scheduled backups and performed restore operations for system test data depends on testers’ requirement.
• Involved in disaster recovery procedures for production servers in 24*7 environments.
• Created DTS Packages to upload test data from Text files. Text files use to come from those locations where caller application is not used.
• Performed Data migration (import & export BCP) from Text to SQL Server. Data transfer using BCP and DTS.
• Performed Oracle Data Migration to SQL Server through DTS Packages.
• Performed SQL Server 2000 Data Migrating to SQL Server 2005.
• Performed query tuning and reduced response time 60%.
• Managed Disk space, memory and User connections.
• Performed Database Integrity Checks, updated Database Statistics and performed re-indexing.
• Performed query plans and made sure each and every query is using appropriate indexes.
• Used DBCC checks and fixed data corruption in Application databases.
• Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best.
• Exposure in analysis services and reporting services.

Environment/ Software/Tools: SQL Server 2000/2005, Crystal Reports 8.0, ERWIN, Windows 2000/2003

Confidential, Nov '03 to Sep ’05
SQL Database Administrator

Responsibilities:

• SQL Server 2000 installation& configuration.
• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Worked on migration and maintenance of data using various utilities like DTS, EXPORT, IMPORT and ATTACH/DETACH Data Migration tools.
• Created & maintained databases, table spaces, users, tables, indexes, stored procedures, roles, profiles and other schema objects.
• Experience working with production and 24 x 7 on call environments.
• Monitoring, maintain other servers through VPN.
• Migrating from Oracle to SQL Server.
• Maintained a warm standby SQL Server using Log shipping.
• Involved in SQL Server disaster recovery procedures. Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Worked as a team member in setting up the Fail over Clustering Architecture for SQL Server databases for mission critical applications.
• Monitored Databases for Dead Lock, Capturing long running SQL queries, used HINTS for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Worked in tuning the database and server performance. Worked with Profiler to trace and tune the database.
• Performance Monitoring using SQL Profiler.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations.
• Dropped and recreated the indexes on tables for performance improvements.
• Upgraded experience from SQL 7.0 to 2000. Installed and Configured SQL 2000 on WINDOWS 2000 system.

Environment/ Software/Tools: SQL Server 7.0, 2000, Postures, WINDOWS 2000, NT 4, ASP.NET, C#, UNIX, EXCEL, WORD, Active/Passive, NT Clustered Servers.

EDUCATION

Masters in Computer Science
Bachelors in Computer Science

CERTIFICATION

Oracle 10g Certified Associate OCA-Database Administrator from Oracle Corporation
Oracle 10g Certified Professional OCP-Database Administrator from Oracle Configuration