Oracle Database Admin Resume
2.00/5 (Submit Your Rating)
Washington, DC
SUMMARY:
- Over 5+ 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.
- Production DBA Support for 11Gg/10g RAC Multi Node configs.
- High Level Evaluation and Performance Tuning, Load Balance and TAF Failover, Scan Listner, RMAN, Dataguard DR Plan with Dataguard and different DB Performance Tuning with latest 11g/10g Grid Tools and Technologies for Production Full Life Cycle support.
- Develop highlevel DB Performance Reports with Recommendations for future RAC Capacity Planning works. Worked on all document process, related to all regular DBA activities.
- Config., Setup, Design, Install & Implementation of Oracle 10g Grid/10g RAC, ASM,TAF,RMAN / 11g/10g RAC (Real Application Clusters) multiple RAC Node Configuration works, 9i Oracle RAC Installation and Configuration for High Perforamnce and High Availability with latest Cluster Technology.
- Develop 9i to 10g/11g RAC upgrade Roadmap with recommendations for different Production envs. 24/7 Support for Critical Production databases with Datawarehouse DBA, RMAN, Oracle Streams, Golden Gate, Dataguard, 11g Grid etc.
- And Migration, Upgradation works of all critical Production Databases from 8.x/9i to 11g and 10g RAC/Non - Rac/10g RAC and 9i/9i RAC on different OS platforms (HP-UX, Linux 4.x/3.x A.S., Sun Solaris Unix, AIX, Windows). Setup Oracle Golden Gate Tools, Support Replication env., RMAN Backup and Recovery configuration with Veritas Net Backup.
WORK HISTORY:
Confidential, Washington, DC
Oracle Database Admin
Responsibilities:
- Performed CORE DBA tasks such as Database Administration on Oracle 9i, 10g and 11g environments, performance tuning, Schema creation, maintenance, and troubleshooting.
- Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity of the company database.
- Implemented data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, backups, replication, and other distributed data issues over a highly volume Terabyte Database. Setup and manage RAC environments for our customers.
- Identify, monitor, recommend, and implement changes to database applications ensuring satisfactory end-user response time with reliable database connectivity * Implement physical database changes, testing, and performance tuning.
- Prepared and/or review database activity, progress, and performance reports
- Maintain Oracle SQL and PL/SQL scripts, Unix Shell Scripts, debugging and tuning
- Implement Production Control and Change Management
- Ability to pro-actively understand and manage end user/customer expectations
- Provided best practices on new technologies and implementations
- Provided expertise and made recommendations for physical database design, architecture, testing, performance tuning, and implementation of Oracle DB
- Performance issues (track and trend overall database performance and database area, index, and drive performance).
- Recommending application code changes (processing strategies, queries, use of RDBMS features)
- Great experience applying patches and performing DB Migrations.
- Plan and Design Backup/Recovery solutions using shell scripts and RMANactivating and Re-building Standby Databases both Physical and Logical Supported by DATAGUARD
- Experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup Implemented RMAN backup. .
- Ensure that the database software infrastructure is in place and up to date to support other infrastructure components (e.g., operating system and hardware) and application development.
- Maintain more than 25 databases in-house for development/QA and 6 PROD databases for our customers.
- Develop and Support Strategy to provide Remote DBA Services
Environment: Oracle 10g and 11gr2, Linux, HP, AIX, SUN Solaris, Windows, PL/SQL. RMAN, RAC, Dataguard (Standby), Grid Control (OEM)
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 SMB 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
