Oracle DBA
Resume:
KENNETH CHANDO Tel: 919-***-****/919-***-**** E-mail: *************@*****.***
PROFILE
• Seasoned Information Systems (IS) leader with over 10 years of experience and a solid track record of concurrently managing, with quantifiable results, multiple cross-functional projects
• Rich hybrid of process improvement, leadership, and database support skills
• Lateral thinker; adapts and thrives in dynamic, fast-paced, and challenging environments
• Multilingual - English, French, and Spanish (basic level)
KEY COMPETENCIES
• High Emotional Intelligence
• SQL Optimization
• Project Management
• Service Delivery Optimization
• Knowledge Management
• Oracle Data Pump
• Agile/Scrum/Lean Six Sigma Methodology
• High Availability (HA) and Disaster Recovery (DR)
• Risk Management
• Oracle Recovery Manager
EDUCATION AND PROFESSIONAL TRAINING
• A.A.S, Networking and Information Systems, Durham Technical Community College, NC 2011
• BS Business Management, University of Buea, Cameroon, 2004
CERTIFICATIONS AND PROFESSIONAL TRAINING
• Cisco Certified Network Associate (CCNA): In-progress
• Network (A+): In-progress
• Oracle10g Database Administration Workshop I & II, Durham, NC, 2009
• Oracle 11gR2 RAC and DR, Charlotte, 2011
TECHNICAL PROFICIENCIES
• Databases: Oracle11gR2/10g/9i, SQL Server & MS Access
• Database Tools: OEM - Oracle Grid Control; Recovery Manager (RMAN), ASM, RAC (srvctl), ERwin, TOAD, Dataguard (dgmgrl), DataPump, xceedium,Remedy 8.x, HPSA, IDERA DM
• Methodologies: IE, DM, Structured Analysis/Design, Lean Six Sigma
• Data Models: ERD, FCO-IM, Logical/Physical
• Operating System : UNIX (AIX/HP), Red Hat Linux, Windows Server 2008/2012
• Hardware: IBM AIX pSeries with the 47 GHz PowerPC_POWER7, Sun Fire V880, all HP/UX and Solaris architectures, TSM, EMC Data Storage devices
• Languages: PL/SQL, SQL, T-SQL, Java, HTML, XML, C#, C++, Base SAS,Shell Scripting
EMPLOYMENT HISTORY
Hewlette-Packard Enterprise Raleigh NC 04/2015 - Present
Oracle DBA
Set up and respond to database system monitoring in development
Set up and respond to database system monitoring in production and pre-production
Communicate O/S resource usage and parameter/kernel settings to System DBA and AD DBA
Monitor System disk I/O, performance system monitoring, contention prevention and provide recommendations for improvements
Backup and recovery of prod/pre-prod databases
Scheduled backups (e.g. daily) of development environments
Restore non-production database and database environment files from backups at AD DBA request
Restore pre-production and production databases and database environment from backups at System DBA request
Oncall support of development databases and DBMS environments
Oncall support of production and pre-production databases and DBMS environments
DBMS Software Support
Create file systems/partitions required for the DBMS software, system database files and application database files
Determine directory structure to be used by the DBMS software and the database data files
Overall responsibility for DBMS software installation, patch application, and upgrades on database servers and clusters, to include DBMS client software on managed servers (no desktop installs)
Modify any DBMS installation parameters
Perform installation functions that require operating system “ROOT” and/or “Super User” authority.
Install O/S patches and products required to support DBMS, APP, or 3rd party software. installation and upgrades
Overall responsibility for OS or hardware related patch application, and upgrades on servers and clusters
Responsibility for the installation of 3rd party Application products (NOT requiring root/super user). (including non DBMS products produced by Database Vendors)
Responsibility for the installation of 3rd party Application products (requiring root/super user). Requires documentation provided by the Application Support Team (including non DBMS products produced by Database Vendors)
Responsibility for the Configuration of 3rd party Application products using documentation provided by the Application Support Team (including non DBMS products produced by Database Vendors)
Monitor System and respond to Database and RDBMS software (e.g. oracle home) File system Utilization issues
Primary interface for problems or shortcomings in the DBMS that require interaction with the product vendor
Escalation of problems to DBMS vendor Technical Support
Coordinate and implement system DBMS software changes
Provide MS SQL Database Support
Chevron Corporation Cary, NC 11/2012-11/2014
Oracle DBA
• Provided database support for three (3) production Oracle10.2.0.5, 11.2.0.2, and 11.2.0.3 two-node RAC and single instance DG databases running on IBM AIX pSeries servers; the largest and smallest of the production databases were 1.8 TB and 0.7 TB, respectively.
• Periodically applied PSU on and upgraded project & support path databases from10.2.0.3 to 10.2.0.5 and eventually to 11.2.0.2/3
• Used RMAN and Data Pump extensively for backup, recovery and refreshes (cloning)
• Leveraged TOAD and OEM heavily for administrative, monitoring, scheduling, and query (SQL) optimization tasks
• Migrated objects/schemas between environments using Data Pump export and import
• Participated in the high level design (HLD) and low level design (LLD) of oracle-related projects.
• SME on FLASHBACK, partitioning and advanced compression
Fox Corporations Raleigh, NC 11/2010 - 11/2012
Jr. Oracle DBA
• Managed all aspects (performance optimization, backup, restore, recovery, refreshes, code migration, etc.) for News Division development, test, and production oracle 10.2.0.5 databases running on Sun Fire V880 servers
• Reviewed and revised backup and DR plan; scheduled physical backups using RMAN and logical backups using Data Pump
• Migrated code between environments as part of the change management process
• Heavily utilized DBArtisan for analysis, scripting, reporting, monitoring and tuning tasks
• Monitored and traced poor performing reports for tuning opportunities and worked closely with developers to optimized them
• Interfaced regularly with Production DBA team to either escalate or de-escalate database issues
British Telecom Corporation Raleigh, NC 10/2009 - 01/2010
Network/IT Support Analyst
• Managed user accounts, network access and file permissions using Ubuntu commands
• Installed newly built and imaged desktops/laptops on user's office space
• Troubleshoot and resolved network related issues over the phone, remotely via WebEx or by physical presence at the workstation.
BizTek Computer Services Raleigh, NC 01/2008 - 09/2009
PC/Desktop Support Technician
• Cloned hard disks using Symantec Ghost application; recovered data from bad sectors using Easy Recovery software
• Maintained hardware and software; upgraded Windows O/S to latest service packs
• Added new computers to work groups and deployed server applications to client machines
Lexis-Nexis Corporation Woodbridge, VA 01/2007 - 12/2007
Server Installer/Application Support
• Performed enterprise data backup on SQL server using HandyBackup tool
• Installed MS IIS 6.0/DNS/SMTP/NNTP/ASP.NET 2.0 Framework/SQL 2005 Advance Express
• Rolled out core JURIS/JURISSUITE 2.0.2406.172 from servers to client machines
• Configured Deployment Manager to run on client and server machines
• Performed on call rotations as needed
Pomeroy IT Solutions Raleigh, NC 07/2006 - 12/2006
Network/PC Technician
• Installed and configured VOIP Phones, PCs, ATM, UPSs, printers, scanners, FSO, Teller Lines
• Citrix/Radia, Margo, download from Server via TCP
REFERENCES
Available upon request
Contact this candidate