SUMMARY

• Overall 8 years of experience in which 5 years of experience in Oracle Database Analysis, designing and Administration using Oracle 10g, 11gR1 and 11gR2 on UNIX and Linux under 24x 7 environments.
• 3 years of experience as Network Administrator in designing, capacity planning, upgrade/maintenance & implementing internet works using Cisco.
• Tuned the databases and SQL code for performance using TKProf, OEM SQL profile, and SQL tuning sets, Explain Plans and AWR and ADDM reports.
• Managed datafiles, control file, redo log files and archived log files.
• Experience in Data Modeling and Database Management.
• Upgraded previous versions of Oracle 10g to 11gR1and 11gR2.
• Experience and sound knowledge of Oracle networking, configuring TNSnames, Dedicated and Shared Servers.
• Excellent understanding of memory structures and processes that make up an Oracle Instance Oracle databases Security Champion, implemented database security at various levels.
• Implemented Sarbanes Oxley (SOX) recommendations at multiple levels to make the applications SOX compliant.
• Experience in implementing TDE and SQLNET encryption.
• Planned and implemented Backup Recovery Strategies using RMAN and User - Managed scripts.
• Configured Oracle Golden Gate for replications.
• Good understanding of the UNIX/Linux/Windows and SAN storage environment for Database Administration.
• Provided troubleshooting and technical support to applications and database users.
• Good experience of 5-Node RAC administration and configuration.
• Excellent understanding of Data Guard for TAF (Transparent Application Failover).
• Expert Level Knowledge about TCP/IP and OSI models.
• In-depth expertise in the analysis, implementation, troubleshooting & documentation of LAN/WAN architecture and good experience on IP services.
• Installing, configuring and troubleshooting of network devices like Cisco Routers and Switches.
• Expert level knowledge of implementing static and dynamic routing protocols such as RIP, EIGRP, OSPF and BGP.
• Knowledge of implementing and troubleshooting complex layer 2 technologies such as VLAN Trunks, VTP, Ether channel, STP, RSTP.
• Good team player and excellent communication skills and the ability to work on multiple projects.
• Efficient and organized to prioritize and manage multiple tasks.
• Proven ability to work efficiently both independently and team environment.

TECHNICAL SKILLS

• Oracle Database administration (10g 11g)
• Performance Tuning
• Security Administration
• Disaster Recovery Solutions
• Real Application Clusters (RAC)
• Database Design
• Recovery Manager (RMAN)
• Oracle Enterprise Manager (OEM)
• Standby Database Solutions
• Oracle Golden Gate
• PL/SQL
• Windows NT
• SQL Server 2005/2008
• SQL Developer
• SQL* Loader
• Cisco Switches/ Routers.
• Routing/ Switching Protocols
• LAN/WAN Technologies.
• Cisco CLI
• Device Manager.
• Linux (OEL 5 OEL 6 Red Hat 5)
• UNIX (Sun Solaris IBM AIX HP)
• Windows Server 2003/XP
• VMware

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, Minnetonka - MN

Environment: Oracle Database 10g/11g, Linux, Windows XP, SQL*Plus, Toad, SQL Developer, VSM Ticketing Tool

Responsibilities:

• Installed and configured Oracle software.
• Upgraded Database from 10g to 11g using expdp/impdp utilities and Oracle provided scripts.
• Applied Quarterly Oracle security patches (CPUs) using OPatch and runInstaller.
• Cloned Production Database to build dev and test environments.
• Created Tables, Indexes, Procedures, Function, Views and Packages
• Wrote shell scripts to automate Database administration tasks, cron jobs like RMAN backup scripts, report scripts, file load scripts etc.
• Perform daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, CPU / Memory usages (Mmon), Alert Log monitoring and backup monitoring.
• Created and analyzed AWR/ASH/ADDM reports for performance and troubleshooting.
• Scheduled job using oracle scheduler and dbms job
• Performed Hot and cold backup using Scripts. Performed database cloning, refreshed dev. Databases from production data.
• Monitored Database performance and critical alerts using OEM grid control and custom scripts including tablespaces usage, locking, and listeners/database down alerts, high CPU /memory usages and created blackouts for database maintenance windows.
• Managed listeners and oracle agents for their availability and performance.
• Managed tablespaces, segments, including creating tables, indexes, IOTs, external tables, partitions and constraints.
• Implemented Oracle Advanced Security Transparent Data Encryption (TDE) to encrypt sensitive application data on storage media.
• Identified top SQLs and tuned them by using SQL Advisor, explain plans and trace files.
• Performed database recoveries in disaster scenarios, recovered databases using hot and cold backup by applying archive logs.
• Data migration and data loading using exp/imp, data pump and SQL Loader.
• Provided rotating on call production support on a 24x7 basis.
• Filed different SR and worked with Oracle Support using metalink.

Database Administrator

Confidential, Minneapolis - MN

Environment: Oracle Database 10g, SQL Server 2000/2005, Linux (Red Hat), Windows Server 2003, SQL*Plus, OEM/Grid Control 10.2.0.5, Toad, Citrix, Remedy 7

Responsibilities:

• Installed oracle software on Linux and Windows environments.
• Created Databases, Instances and database objects.
• Upgraded oracle 9i databases to 10g using scripts, export/import utilities.
• Performed database cloning, refreshed dev. Databases from production data.
• Implemented oracle auditing to monitor user activities and database usage.
• Monitored Database performance and critical alerts using OEM grid control and custom scripts including tablespaces usage, locking, and listeners/database down alerts, high CPU /memory usages and created blackouts for database maintenance windows.
• Setup and administered a 5-node 10g RAC system on ASM for database files.
• Installed Oracle Quarterly Critical Security patches and upgrade software patch sets.
• Managed Tablespaces /segments, including creating tables, indexes, IOTs, clusters, external tables, partitions and constraints.
• Identified top SQLs and tuned them by using sql advisor, explain plans and trace files.
• Performed database recoveries in disaster scenarios, recovered databases using hot and cold backup by applying archive logs.
• Managed database replications to refresh data from remote databases using secure db links.
• Scheduled cron jobs to manage database tasks.
• Provided 24x7 database supports to resolve production issues.
• Data migration and data loading using exp/imp, data pump and sql loader.
• Created and analyzed AWR/ASH/ADDM reports for performance and troubleshooting.
• Configured and implemented Oracle Golden Gate replication.
• Scheduled job using oracle 10g scheduler and dbms job
• Created and managed users/roles for database security issues.
• Performed Hot and cold backup using Scripts.
• Wrote shell scripts to automate Database administration tasks.
• Resolved client connection issues using JDBC thin clients/ SQLPLUS etc.
• Installed SQL Server 2005 on Windows server 2003.
• Ran SQL Server 2005 upgrade Advisor to analyze the upgrade issues and Upgraded sql server 2000 to SQL Server 2005.
• Performed SQL Server management tasks including creating tables, managing file groups/files, indexes, views, index views, replications, integration services and snapshots.
• Created new login/users and managed their access levels, fixed orphan users.
• Investigated and resolved database connectivity/performance issues.
• Used SQL profiler to implement auditing at different levels.
• Used ITSM for ITIL process to follow strict change control process and for incident resolution.
• Filed different service requests with Oracle Support using Metalink.

Oracle Database Administrator

Confidential, Atlanta - GA

Environment: Oracle 9i/10g, SQL Server 2005, VMware, Windows Server 2003, Linux (Red Hat 4), SQL* Plus

Responsibilities:

• Gathered and Documented the Business/system requirements.
• Analyzed the requirements and designed the Database Model using MS Visio.
• Normalized database tables to third normal form.
• Installed oracle 10g Database on windows Server 2003 and Linux (Red Hat) using DBCA and scripts
• Created Database objects like tables, views, indexes, procedures and packages.
• Loaded data using SQL*Loader conventional and direct method.
• Implemented Database Security by creating and modifying database users, roles, and assigning object and system level privileges.
• Configured Oracle Network using Oracle Net Manager.
• Planned and implemented Oracle hot and cold backup and recovery strategy using RMAN and UNIX scripts.
• Created and analyzed AWR/ASH/ADDM reports for Database tuning and troubleshooting.
• Tuned database SQL queries for reports.
• Planed database growth and changes (capacity planning).
• Developed web interface Application for Database using Oracle Application Express (APEX).
• Migrated Databases from Windows to Linux environment using Export, Import Utilities.
• Upgraded databases from Oracle 9i to 10g using oracle upgrade scripts
• Migrated data from SQL Server to Oracle Database and vice versa using SQL Server link and ODBC connections
• Created custom database queries (ad hoc) and reports.

Database Administrator

Confidential, Farmingham - Massachusetts

Environment: Oracle 9i, SQL Server 2000, Windows 2K/XP, Linux (Red Hat 4), SQL *Plus, PL/SQL, MS Access

Responsibilities:

• Created Database manually using scripts.
• Created logical objects (Tables, Indexes, Views, Triggers etc)
• Created Database Security by giving users different level of permissions.
• Ran Explain Plan and tuned SQL code for better performance.
• Used SQL trace and TKPROF to assist the SQL tuning.
• Installed and managed SQL Server 2000 on Windows.
• Performed SQL Server management tasks including creating tables, managing file groups/files, indexes, views, index views, replications, integration services and snapshots.
• Assisted database users with routine operations.
• Planned and implemented backup and recovery of the Oracle databases.
• Oracle installation, patching, testing procedures and upgrading.
• Designed and developed database application in MS Access and Visual Basic.
• Handled daily production problems/change requests.

Network Administrator

Confidential, Calgary - AB

Environment: Cisco 2900, 3700, 4000, 5000, 6500 series switches, Cisco 1600, 2500, 2600, 3600, 7200 series routers, RADIUS, UNIX servers.

Responsibilities:

• Installed and configured various routers like 800, 1600, 2500, 2600, 3600 and 7200, along with Cisco switches including 2900, 5000, 6500 and Implementation of V-LAN.
• Installed and configured several policies using the different technologies like HSRP, STP, VTP, VLAN, 802.1Q Trunking, load balancing, redundant routing and QoS.
• Implemented various routing protocols such as RIP, IGRP, BGP, OSPF, EIGRP and implementing Policy Based Routing, Distribution List, Route-map and Re-distribution of Routes.
• Troubleshoot Windows 2000 Servers and streamlining the user policy.
• Managing User accounts using Active Directory
• Responsible for administering several UNIX servers, both Linux / x86 as well as SunOS SPARC systems key to the smooth operation of the company. Services maintained include mail (send mail), web (apache), DNS (bind), authentication (RADIUS, TACACS+), FTP, TFTP, and system monitoring software.
• Network Assessment and Documentation (including technical, operational, and economic assessment).

Network Administrator

Confidential

Environment: Cisco 6509, 3524, 3548, 3550 switches, VLANS, DNS, WINS, DHCP.

Responsibilities:

• Involved in designing complex multi-layer/multi-site network design and implemented Cisco routers and layer 3 switches.
• Ground up configuration of numerous Cisco switches: 6509, 3524, 3548, and 3550.
• Created, modified, deleted, and managed user domain and email accounts.
• Setup, configured, and maintained Windows 2000 servers, including: Active Directory, DHCP, DNS, and WINS.
• Configured, deployed, troubleshoot, repaired, and upgraded of Windows 2000 desktops.
• Analyzed PC/LAN problems and took corrective action or escalated to appropriate person/group.
• Participated in on-call rotation to help solving LAN user problems off hours.