SUMMARY:

Over 8+ years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, migration and documentation.

TECHNICAL SKILLS:

Technical skills: Unix, AIX 4.3, AIX 5.3, Red Hat Linux, RHEL 3, RHEL 4, RHEL 5, Fedora,Ubuntu,Solaris10,9,8, HP - UX. Windows (NT 4, 2000/2003 Prof/AdvServer, XP Professional)

Databases Skills: Oracle 10g/11gR2, Oracle 11g/10g RAC/9i/8i, Exadata V1/V2/X22/X28, Microsoft SQL Server 2005, 2008

Tools Oracle Enterprise Manager: (OEM), Oracle Performance pack, TOAD, Office 2000/XP, Oracle Operating systems 9i Developer suite 9.0.2, Oracle 11, SQL developer, TIVOLI, ERWIN

Performance Tuning: Grid control, AWR, ADDM, ASH report, SQL performance analyzer (SPA), SQL Optimizer, STATSPACK, DB Artisan and OS Watcher.

Oracle Utility: RMAN, RCONFIG, 12cOEM, Export/Import, Data Pump, SQL*Loader, DGMGRL, ASMCMD.

Storage Technologies: Oracle ASM, veritas Netback.

WORK HISTORY:

Confidential, Washington, DC

Oracle Database Admin

Responsibilities:

• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non - Production environment, Creation Duplicate Databases using RMAN Backups.
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standby databases for high availability and disaster recovery.
• Implementation of High Availability solutions with Oracle 12c,11g RAC,10g RAC, Standby Database (Active Data Guard), Replication.
• Responsible for Installation of RAC and Managing RAC Environment efficiently
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c
• WebLogic performance tuning and upgrade to 12c and 11g
• Implemented Monitoring Templates and Incident Rule notifications using OEM 12C for database alerting.
• Worked extensively on 12C OEM and configured DB alerts for DBA
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.
• Supported functional data warehouse projects.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications Work on different versions of Databases with OEM Grid control to maintain the database effectively.
• Configured different levels of replication such as DDL replication, DML replication for table level, schema level, database level using Golden Gate.
• Implemented classic Golden gate replication as well as integrated replication. Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints and Tkprof. SQL, PL/SQL and UNIX shell scripting.
• Monitored the Applications and database using OEM and OAM.
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Built 4 node RAC 10gr2 Standby database and set up DG Broker
• Setup of High Availability of the database using RAC, Standby, Data guard.
• DBA activities such as configuring Grid events, Regular Backup's, Replication, Tuning, and troubleshooting performance issues.
• Maintain, upgrade, troubleshoot all enterprise oracle and SQL server databases
• Install and Configure OracleFusion Applications 11.1.5 on Exalogic/Exadata -- setup and Maintain system and configurations.
• Advanced Backup and Recovery using Oracle RMAN software; used offline/online for recovery in a production environment via Kornshell scripting.
• Provide development and production support related to database
• Perform other regular DBA activities including space management and performance monitoring.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Design, development, testing, performance tuning, deployment, and support in Data warehouse system
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance Bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM
• Upgrade and Migration of Databases from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.

Environment: ORACLE,SQL*Plus,OEM/12c,Exadata V1/V2/X2-2/X2-8, PL/SQL, Oracle 11g/10g,RAC, Microsoft SQL Server 2005 & 2008,DB2, Golden gate, Shell scripting, Red Hat Linux 5,Solaris 10,Unix, VCS, Oracle Enterprise Manager, Data guard, ASM, PL/SQL, RMAN, Toad.

Confidential

Unix/Linux Systems Administrator

Responsibilities:

• Evaluated, tested, installed and modified networks and stand alone PC's, work station systems and applications.
• Evaluated and test vendor supplied software packages to determine compatibility with existing systems, and use suitable for organizational need.
• Enter commands into PC or network to place new applications in production status and upgrade existing applications (Patches). Maintained Active Directory/Exchange servers
• Installed, maintained, and coordinated the use of employee's or customer's Local Area or Wide Area Network (LAN/WAN) on Unix/linux base servers.
• Active Directory and Exchange 2008/ Cisco servers/routers 2600-3300 series Firewall/Sidewinder/Barracuda Spam filter, DMZ layer configuration in relation to security and other protocols and services in a Windows XP/Vista/07 environment.
• Evaluated hardware, and software, including peripheral output, and telecommunications equipment.
• Enforced security procedures including intrusion test. Troubleshoot and resolve computer problems, implemented and coordinated network policies, procedures and standards.
• Responsible for maintaining complex network of 21+ users of the Credit Union. support of fundamental technologies such as DNS, SFTP and FTP, SMTP, SNMP, LDAP, SSL, SSH, TCP, UDP, IP, RAID, TFTP, BOOTP, DHCP, Kerberos, and Confidential and CIFS. scheduled backups and downtime with all users.
• Maintain data files and control procedures for a system of networked PC's that are linked to a host server.
• I was also responsible for systems security and data integrity.
• Assigned passwords and monitored use of resources. Back up files as required.
• Brought the Firewalls up to date through hardware refreshes.

Confidential, Fairfax, VA

Senior Information Technologist

Responsibilities:

• Assisted in the design and configuration the Lan/Wan infrastructure, consisting of multiple T1 and T3 lines, Cisco routers/ Cisco switches, Load balancers, Dell and Sun servers.
• Assisted in the design of Internet connectivity infrastructure for meeting bandwidth requirements.
• This involved negotiating with ISPs, switching from T1 to Flexible T3 lines and configuring/replacing existing Cisco 1605 series routers with Cisco 3640 routers.
• Optimized performance of the WAN network consisting of cisco 45/55/6500 switches by configuring VLANs.
• Worked with Cisco catalyst switches 5xxx, 4xxx, 29xx, 19xx, and RMS and Cisco Routers 7500, 7200, 4000, 3600, 2600, 2500 series.
• Implemented the Checkpoint Firewall4.1 to protect authenticate local-net and DMZ.
• Managed the VLAN on the switches and VPN on the firewall, and provided network diagram using Visio, Excel and Word

Confidential

Telecommunications Specialist

Responsibilities:

• Installed, troubleshoot, repaired, tested, and maintained telecommunication and IT equipment for Department of Defense (“DoD”) Projects.
• Kept equipment and materials that included Fiber Optics, Voice and Data lines Splicing tools, Punch down tools, ISDN Connections, Patch Panels, jacks, and Lantek tools that are associated with the testing from end to end (Cables included 25-pair to 200-pairs).
• Conducted all work done at the Pentagon involving both Fiber Optics and Copper and was involved in the transition from the PBX system to the VOIP using the Nortel phone system, which include setting and configuring phone systems. Installed video conferencing equipment including Cat5,Cat6,fiber optics, Video racks, Monitors, and all end to end connections.
• Coordinated and executed all jobs, including government red phones, per customers’ requests, and reviewed system specifications, configurations, test procedures and documentation to verify proper functionality, standardization, and compliance with DoD instructions for the certification of IT systems.
• Designed, documented, developed, modified, tested, installed, implemented, and supported existing systems and new applications computer software DoD systems.
• Coordinated and provided technical guidance and direction for interoperability certification and assessment to IT Systems and DoD systems.

Confidential

Support Engineer

Responsibilities:

• Coordinate and execute all jobs, including Government Red Phones
• Coordinate many job project that included the insulation of both Fiber optics, ST,SC,MTRJ,LC,FC end terminations, Patch cords, Twisted pair CAT3,4,5,6 and ABF, also single to12 strand fusion splicing.
• Terminations also included testing from end to end using various testing equipment

Confidential

Computer Operator

Responsibilities:

• Operated and monitored computer equipment and performed routine tasks to maintain computer equipment and their peripherals.
• Observed and managed the equipment/error messages display monitor to detect faulty output or machine stoppage.
• Initiated any tape processing, reel to reel or tape cartridge; assisted users with telephone or in person request such as rebooting terminals remotely using Pc Anywhere.
• Reset user passwords and removed lockouts on user’s accounts, also monitor web sites via PC anywhere.
• Monitored and processed all print jobs for IPL systems, backed up systems such as: IBMOS/390, Cisco Routers, Jes2, MVS/JCL, ESA Unix/COM, VPS, VTAM, CICS, TSO, GWT, and setting initiators on a weekly basis.
• Oracle 8i internship 20 hrs a wee