Oracle Database Administrator Resume
SUMMARY
- 8 years of cross - platform experience in information technology, including analyzing, designing, installing, maintaining, and repairing hardware, software, peripherals, and networks
- 1 Year of experience as an Oracle Database Administrator with extensive knowledge of Oracle Enterprise Manager 12c, 11g, 10g, Secure CRT and Main Frame/DB2
- Leverage all the DBA tools and DBA developed procedures to monitor, tune and optimize database and application performance
- 4 Years of networking experience in designing, planning and implementing network solutions
- Extensive knowledge of multiple ticketing tools such as Eagle, Peregrim, iCAD, iVapp, iGo, DTI, DTI Express and Eagle
- Exceptional oral and written communications skills and ability to work independently, with minimal supervision in a fast-paced high profile multi-tasked production environment
TECHNICAL SKILLS
Networking Skills: LAN/WAN, WEP/WPN, TCP/IP, DNS, DHCP, Windows OS, Linux, Ubuntu, Routers, Switches, Remote Access, VPN, Incident Manager, Printers, Antivirus
Oracle Database Administrator Skills: Oracle Enterprise Manager 10g, 11g, 12c, OIDI, SQL/PL SQL, SecureCRT, EIS Service Catalog, Data Loader, PPM, DB2 Main Frame, DDL
Application Skills: HP Service Manager, Service Now, Eagle, Peregrine, iCAD, iVapp, iGo, iVapp, iGo, DTI, DTI Express, vRepair, STOrC, CPE, COFFEE, Norton, McAfee, BitDefinder, Disk Imaging, TeamViewer, Outlook 14, Lotus Notes 8.5, Microsoft Office Suite
PROFESSIONAL EXPERIENCE
Confidential
Oracle Database Administrator
Responsibilities:
- Experience with Oracle SQL syntax and query tuning and Oracle Data Definition Language
- Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management for Production, Development, and PA Environments
- Worked independently to identify database problems using tools such as OEM (Oracle Enterprise Manager), SecureCRT, Sqlplus, TSO Mainframe, and Oracle alerts, QMF (Query Monitoring Facility); took corrective action when needed and worked with Database Engineering & Ops team using established escalation procedures
- Implemented application DDL, DML scripts as requested/approved/scheduled
- Designed /troubleshot SQL code (stored procedures, functions, tables, views, triggers, indexes, constraints)
- Worked with DB2/Mainframe doing Refresh of multiple environments
- Worked closely with internal support (Database Engineering & Ops team, PA Ops team, Application Development Teams) to identify, resolve or coordinate the resolution of database incidents
- Analyzed services to determine if they are running properly or if they are causing any system-related problems ( tablespace checks, CPU utilization, alert logs)
- Identified database performance issues and bottlenecks, serve as escalation point for problem resolution, and drive recovery through root cause investigation
- Refracted existing databases for changing requirements and application needs
- Monitored jobs in DB2/Main Frame that have failed if necessary
- Documented database scripts, triggers, stored procedures & processes
- Updated database structure as requested/approved/scheduled
- Acted as a Liaison between external resources and internal resources for database projects
- Participated in meetings in the development of standards and procedures affecting database management, design and maintenance
- Understand the implementation process of Change Management
- Communicated effectively with Project Leaders and team members in IT Department
Confidential
Hardware Refresh Analyst
Responsibilities:
- Led 20 Techs in the Window 7 Upgrade Project for Confidential
- Upgraded more than 5,000 Laptops to Windows 7 Enterprise
- Created spreadsheets and tickets that harbored more than 7,000 records using Excel and Eagle ticketing system
- Help Troubleshoot issues with Laptops pertaining to the upgrade
- Handled more than 50 call on a daily basis in regards to Windows 7 Upgrade
- Expert with Windows Remote Assistance, Remote Desktop, VNC, Angry IP, and Angry IP 3.0
- Extensive experience with Eagle and Peregrim ticketing systems
- Extensive knowledge of Microsoft Outlook
- Comprehensive knowledge of Microsoft Office Suite
Confidential
Tech Rep
Responsibilities:
- Handled more than 35 calls on a daily basis pertaining to Internet, cable television, phone, various applications, hardware, and connectivity
- Worked with ticketing systems such as iCAD, iVapp and iGo
- Extensive knowledge of test tools such as DTI, DTIx, STOrC, CPE, and vRepair
- Helped reset and usernames and passwords for the customers when necessary
- Regularly perform hardware and software maintenance and upgrades
Confidential
Geek Squad Agent
Responsibilities:
- Saved more than 2000 dollars in returns by helping customers choose products that related to their lifestyle
- Handled more than 30 calls on a daily basis pertaining to Internet, cable television, phone, and various applications, hardware, and connectivity
- Experience with Microsoft Outlook 2010
- Resolved Windows XP/Vista and basic Apple iOS and Internet connectivity issues utilizing the knowledge of computer hardware diagnostics
- Worked with Norton Symantec Ghost for creating backup Images
- Performed computer-related installations for Windows XP, Windows Vista, Apple Mac OS, configurations and technical support (service/repair issues)