SUMMARY

• About 7 years of experience as an Oracle DBA in planning, installing, configuring, monitoring and administering Oracle Databases on Unix/Linux/Sun Solaris/HP - UX and WindowsNT/2000 environments.
• Worked as a Postgres DBA/Lead for a period of 6 months.
• Hot and cold backups were taken using RMAN, Used methods like PITR and full/ partial export/import and Data Pump.
• Efficient in SQL query optimization using Explain Plan, Utlbstat/Utlestat, TKPROF reports, gathering statistics, pinning the objects, and running scripts.
• Configured and Maintained Physical Standby Database for High availability.
• Efficient in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Install, Configure and Upgrade different versions (8i, 9i, and 10g) of Oracle Database.Good working experience on User/Schema Management.
• Experience in administering databases using Oracle Enterprise Manager, SQL developer and TOAD.
• Worked on Database Refresh and Cloning.
• Experience in installing, configuring and administering Oracle 10g Real Application Cluster (RAC).
• Oracle Database and SQL tuning.
• Setup Oracle Enterprise Manager (OEM) 9i/(Grid Control) 10g for data monitoring/performance/diagnostics
• Extensive work exposure in UNIX Shell scripting.
• Planned, Implemented and Documented Disaster Recovery Strategies in various production environments using Data Guard.
• Worked on Oracle Business Intelligence and Oracle Warehouse Builder.
• Resolved various issues individually and by opening a TAR with Oracle.
• Helped the users/Application developers on complex SQL queries.
• Have also worked on SQL Server Databases 2005/2008.
• Knowledge of computer and/or network security systems, applications procedures and techniques, ability to provide technical guidance and leadership to professional personnel.
• Highly self-motivated team/individual player with good verbal and writing communication skills.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/XP/Vista, Unix/Linux, Sun Solaris

Programming languages: C, SQL, PL/SQL, Shell Script, T-SQL

Servers/Databases: Oracle (9i, 10g, 11g), SQL Server 2005/2008, Oracle 10g RAC, Postgres

Tools: Toad, SqlPlus, Sql Loader, RMAN, Oracle Enterprise Manager, TKPROF, PUTTY, Vi Editor, Microsoft Access Reports

Others: MS Office suite

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Collierville, TN

Responsibilities:

• Monitoring Oracle Database 11.2.0.1.
• Enforcing and maintaining database constraints to ensure integrity of the database.
• Administering all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Checking the RMAN backup configuration and monitoring the same.
• Oracle Database production support.
• Writing detailed queries for a database centric system.
• Monitoring/House Keeping of environment
• Troubleshooting of database incidents
• Monitoring database availability and conducting health checks
• Resolving connectivity issues
• Login Failure/Password reset issues
• DB Access Requests, Ad-hoc backup requests
• Space issues on database servers
• Backup and recovery monitoring
• Monitoring scheduled DBA jobs
• Reports (Daily, weekly and monthly)
• Documenting and updating knowledge base/CMDBs
• Track the incidents to closure and follow-up with L2 & L3 teams for break fix, RCA and permanent resolution.
• Created database, database links, communicated with the production server through remote access.
• Installed and configured SQL Server 2008.
• Maintained backup schedules, backup scripts.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database
• SQL Server 2005/2008 administration using SSMS.
• Controlled and monitored user access to the database to maintain system security.
• Provided 24x7 on-call support regarding production-related database problems.
• Establish standby/cloned databases via Data Guard for Database Disaster Recovery.
• Worked on the RFP’s (Request for Proposal) for new business.
• Participating proactively in conferences regarding the RFP responses.
• Planning on Oracle Database Architecture/sizing/Capacity Planning.
• Trained newly joined team folks in Oracle Database Administration.
• Undergone PostgreSQL DBA training and also trained other team members on the same.
• PostgreSQL DB Administration - creating roles, databases
• Configuring the PostgreSQL Databases by modifying the configuration and authorization files (postgresql.conf and pg hba).
• Used PostgreSQL Enterprise Manager to perform tasks like creating tables, etc.
• Used pg dump and psql to backup PostgreSQL database instances.

Environment: Oracle 11.2.0.1/10.2.0.5 , SQL Server 2005/2008, Linux, AIX, PostgreSQL 8.4/9.0

Oracle Database Administrator

Confidential, Georgia

Responsibilities:

• Installed and Configured Oracle 11gR2 (11.2.0.1) on SunOS 5.10.
• Performed the Schema Refreshes from Production to Development instances using DataPump.
• Monitoring the Oracle Databases from the Alert Logs.
• Used RMAN and DataPump to perform the backups.
• Created Indexes for different tables for optimal performance.
• Collected statistics and performed SQL Tuning as and when required by the Application Developers.
• Wrote shell scripts to monitor the Database alert logs.
• Tested and Performed backups using hot & cold backups and RMAN, cloning databases using RMAN
• Performed Performance tuning like setting up the memory target parameter on the Database.
• Wrote shell scripts for the Database backups.
• Tablespace and Schema Management.
• Created database links and performed the refresh using DataPump from remote server.
• Resolved DataPump utility corruption issues.
• Generated the Materialized Capabilities using the DBMS MVIEW.EXPLAIN MVIEW utility in order to create the appropriate Materialized Views.
• Resolved user login issues to login on to the Oracle Database Server by setting the environment and the profile file.
• Performed backups at Schema level to support the new Pega Application installations
• Recovered a critical Database from a server crash, resolved issues on corrupted undo tablespace. Received an appreciation email for the whole day issue.

Environment: Oracle 11.2.0.1, Sun Solaris, Putty, SQL Developer

Confidential, California

Responsibilities:

• Installation, configuration and administration of 10g Database on RHEL4.
• Creating and administering databases on RHEL4 for development and testing.
• Resolving user’s day-to-day issues and user management
• Performing Logical backup using export utility and recovering specific object or schema using Import utility.
• Installation, Configuration and deployment of Oracle 10g Real Application Clusters (RAC) with 3 nodes using Automatic Storage Management (ASM).
• Responsible for Day-to-Day Database Operations
• Taking cold backups and ensuring that they are useful for future recoveries.
• Backup and recovery using RMAN/Datapump, managing Undo/Temporary segments.
• Oracle Database cloning and patching.
• Implemented Oracle 10g Dataguard for High Availability. (HA) and maintained stand by database for reporting purposes.
• Gathering statistics using Statspack and AWR Reports regularly to check the Performance
• Creating table spaces, creating data files, helping users in creating database objects, enrolling users, security, backup and recovery.
• Creating / adding redo logs and members. Monitoring the alert log file and monitoring the archive log generations.
• Created database, database links, communicated with the production server through remote access.
• Provided 24x7 on-call support regarding production-related database problems.
• Maintained the RMAN repository database and configured backup policies
• Created and managed database objects like tables, views and indexes. Finding and re-validating invalid database objects database(s).

Environment: Oracle 10.2.0.4, Oracle 10g RAC, ASM, Red Hat Enterprise Linux, Putty, OEM, SQL Loader

Database Analyst/Administrator

Confidential, El Paso, Texas

Responsibilities:

• Monitor and maintain Oracle 11g (11.1.0.7) Database and SQL Server Databases.
• Implementation of the Oracle Business Intelligence (OBIEE) as the preferred enterprise reporting software.
• Maintaining and monitoring the Oracle Warehouse using the Enterprise Manager.
• Used the Oracle Warehouse Builder (OWB) to create/maintain the mappings and views.
• Used the OWBs’ control center to create and schedule the processes to pull data from the SQL database containing the data on different crimes (assaults, robbery etc).
• Configured RMAN for daily hot backups.
• Extensively used OEM for tablespace management and administration
• Created and Managed database objects like tables, views and indexes. Finding and re-validating invalid database objects
• Regular monitoring of Disk/CPU utilization, Performed SQL tuning whenever required.
• Used SQL* Loader to Load data from flat files to database.
• Created and managed stored procedures and triggers, automation of administrative tasks.
• Worked on creating and modifying the ODBC connections whenever required.
• Worked on the MS Access Databases involving creating forms, reports, re-linking the tables using the linked manager and other troubleshooting.
• Designed, developed, modified, tested and deployed Microsoft Access Databases as the front end for the end users integrated with the Microsoft SQL Server as the back end.
• Created a test database on the SQL Server for the i2 testing.
• Used SQL and PL/SQL to extract the desired reports into Excel sheets etc.

Environment: Oracle 11g (11.1.0.7), Oracle Business Intelligence 10.1.3.4.1 , Oracle Warehouse Builder 11.1.0.7, Windows Server, Oracle Enterprise Manager 11g, Putty, SQL Server 2008, MS Access 2003/2007

Database Administrator

Confidential

Responsibilities:

• Installed, Maintained and Administered Oracle Databases v10.2.0.3 and 10.2.0.4 on HP-UX and Windows.
• Maintain and Administer SQL Server Databases on Windows Server VM
• Applied the 10.2.0.4 Patch to Oracle 10.2.0.3 and tested.
• Upgraded Oracle 10.2.0.3 to Oracle 10.2.0.4.
• Upgraded Oracle 10g (10.2.0.4) to 11g (11.1.0.6) for Test and Development servers.
• Moved Oracle Databases between two HP-UX Servers using the Cold Backup.
• Installed Oracle Enterprise Manager Grid Control 10.2.0.5 on Windows Server and configured the same with the other Oracle Databases.
• Created and configured Oracle Enterprise Manager Grid Control Repository Database.
• Monitoring Oracle Databases and SQL Server Databases using Oracle Enterprise Manager and SQL Server management Studio, respectively.
• Administered and Monitored MySQL Databases in the absence of the other DBAs.
• Performing backups and recoveries using RMAN/conventional hot & cold backups.
• Established a Standby database using Data Guard on a test instance and documented.
• Worked on a database for the Dona Ana Sheriff’s Departments DWI Vehicle Forfeiture Program using MS Access as the front end and MS SQL Server 2005 as the backend.
• Guided the users from the Sheriff’s and Legal department on using the Access Database.
• Analyzing and resolving production and development issues related to the Database and its Applications.
• Patch and clone Oracle Databases.
• SGA and PGA instance management, and User, table & index management.
• Perform the Oracle Database Clone on a bi-weekly basis for the PAYROLL database.
• Worked on the Oracle 10g Application Server integration with the SunGard SCT Banner.
• Copying the Production SQL Server Database to the Test Database using the PL/SQL procedures as and when requested by the programmers/testers.
• Created different Oracle Test instances to test and compare different Procurement Card Processing methods.
• Applied patches to the Oracle Enterprise Manager agent on all the Oracle servers.
• Use the SQL Server 2005 export/import feature to transfer data between different SQL Servers.

Environment: Oracle 10.2.03, 10.2.0.4, HP-UX, Toad 8.5.3, Oracle Enterprise Manager Grid Control 10.2.0.5, SQL Server 2005, MS Access 2003/2007, Putty, Oracle Application Server 10g, SunGard Banner.

Oracle DBA/Programmer Analyst

Confidential, Sunnyvale, California

Responsibilities:

• Installed and maintained Oracle 10g (10.2.0.1) on HP-UX.
• Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Installed, configured and maintained the Real Application Cluster (RAC) 10g.
• Applied Patch to upgrade Oracle Application server from 10.2.0.2 to 10.2.2.0.
• Perform Database refresh from production to Staging environment on a weekly basis
• Used RMAN for daily backups and maintain Repository Database.
• Used SQL*Loader to load data into the Oracle Database from flat files
• Wrote Shell scripts to setup notifications and day to day database management
• Regular monitoring of Disk/CPU utilization.
• User/Schema Management-creating users, granting, revoking roles, Space management.
• Monitored Alert Log Files, Listener Log, Redo Log status, rollback segments and trace files for the database
• Scheduled UNIX cron jobs to Monitor and advice of database health.
• Created database, database links, communicated with the production server through remote access.
• Performed Database refresh from production to Staging environment on a weekly basis
• Upgrade RMAN repository database from 9.2.0.5 to 10.2.0.1
• Cloned Oracle databases from production to staging
• Controlled and monitored user access to the database to maintain system security.

Environment: Oracle 10.2.0.1, HP-UX, OEM Grid Control, Putty, 10g RAC, ASM, 10gAS

Oracle Database Administrator (Consultant)

Confidential, Auburn, Washington

Responsibilities:

• Oracle Database Administration maintaining six databases including Production support, Development and Staging instances.
• Provided 24x7 on-call production support whenever needed.
• Created the shell scripts for regular and weekly backups on all the six environments including Production.
• Exclusively used Export utilities for daily backups.
• Table space Maintenance, Storage Parameters maintenance of tables and indexes.
• Performed partial and full Database Refresh using Export/Import.
• Scheduled and modified a good number of Cronjobs for certain requirements like Backups and uploads, and documented them accordingly.
• Restored a Staging Database using the old backups.
• Created Snapshots/Materialized Views in Development database from Stage-Dev Database and documented the same.
• Worked along with developers and QA team on issues like unusable indexes, table privileges and some other change order requests.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files
• Used Oracle Enterprise Manager-Performance Manager to monitor the Databases.
• Had a few opportunities to work on MySQL Databases whenever required.
• Re-Created Test Database using the Oracle DataBase Configuration Assistant (DBCA).
• Used Hints (on Indexes) to optimize SQL queries.
• Extensively used OEM for tablespace management, tuning SGA and PGA
• Monitored the SQL Server in the absence of the SQL server DBA.
• Performed the everyday Data Change Requests on Tables from the Developers and Programmers, resolved day-to-day tickets.
• Uploaded a huge number of excel sheets into the database as requested by account executives, wrote stored procedures to upload/extract data from more than one tables.

Environment: Oracle 9.2.0.8, Sun Solaris OS (version 5.8), Putty, Toad 8.5.3, Oracle Enterprise Manager.

Database Administrator/Programmer Analyst

Confidential, Sunnyvale, California

Responsibilities:

• Installed the Oracle Enterprise Linux OS version 4.
• Installed and configured Oracle Applications (ERP) 11.5.10.2 CPU with Oracle 9i DB.
• Installed, configured and administered Oracle 10g.
• Planned and conducted structured testing of database designs to confirm functionality and performance.
• Configured Flash recovery Area for 10g databases
• Maintained the RMAN repository database and configured backup policies
• Used Export/Import utility for cross platform migration
• Created and managed database objects like tables, views and indexes. Finding and re-validating invalid database objects
• Cloned Oracle Applications using rapid clone.
• Applied regular kernel patches for certain upgrades and bugs.
• Installed, configured and administered 2 node Real Application Cluster (RAC) 10g
• User management and assigning them the desired responsibilities.
• Took regular backups using Cold and Hot backups.
• Used hints for SQL tuning.
• Successfully migrated Oracle 9i Database to SQL Server (MySQL 4.1)
• Administered Oracle Server and Microsoft SQL Server databases.
• Also used Spotlight and SQL guard to monitor the SQL Server.

Environment: Oracle Enterprise Linux 4, Oracle DB 9i/10g, Putty, Oracle Apps 11i