SUMMARY

A qualified and clearable Oracle Database 11g/10g/9i DBA with more than 10 years managing and working with leading edge projects that require experience on diverse OLTP and Big Data environments. Yaw is a good team player with proven expertise in IT training and education as well as experience in Programming, Linux Administration, Oracle Database Administration, ASM Setup, Oracle RAC 10g/11g, and Data Guard implementation for real time disaster Recovery; he is skilled in leading other DBAs in database projects. Yaw also has experience leveraging COTS and GOTS products for large organizations in both the private and government sectors. He is highly exposed to Big Data environments and has excellent skills in upgrade and migrations, applying quarterly patches etc. Yaw is versatile in establishing client relationships for understanding their business processes, user tasks & goals; analyzing and defining requirements to ensure efficient and cost - saving technological solutions to meet and exceed client needs. Yaw is experienced in automating database creation through Oracle response files and through Linux shell scripts; he is versed in oracle management tools and utilities like Oracle Enterprise Manager Grid, asmca, srvctl and crsctl. Yaw’s performance tuning techniques comprises of savvy usage of indexes, tablespace compression, I/O minimizations through hardware RAID and other load balancing techniques. Yaw is well exposed to Oracle Engineered Systems like ODA (Oracle Data Appliance) and has experience leveraging such systems to meet challenging and evolving client data needs.

TECHNICAL SKILLS

• SQL Language
• Linux Shell Scripting
• PL/SQL
• MySQL/PostgreSQL Database
• Oracle Data Guard
• Perl Scripting
• Windows OS
• Oracle ASM
• Exposed to Greenplum, Netezza and Hadoop
• Linux LAN/WAN Networking
• Object Oriented Programming (OOP) Concepts
• GNU/Linux OS - Red Hat and Debian
• C++, C and Java
• TCP/IP Networking

PROFESSIONAL EXPERIENCE

Confidential,VA

Lead Oracle Database Administrator

• Lead the development of custom shell scripts for monitoring specific databases for the United States Citizenship and Immigration Services under the Department of Homeland Security
• Led in the automation of database security audits conducted by the Security Team at SAIC. This effort cut database security auditing time by over 50% and relieved several hours of routine DBA and security staff work.
• Build SOPs and implement Oracle migrations to 11gR2; migration activities touch the Oracle Clusterware, Automatic Storage Management layer and other Operating System areas.
• Support Oracle related deployment effort for the USCIS Electronic Immigration System project (ELIS). Support activities include performance tuning exercises, backup and recovery, RAC installations and upgrades, patching, replication and disaster recovery, scripting, data loading, and data reporting.
• Provide support to DBAs on how to use and maintain customer scripts developed for database housekeeping tasks (Backup and Recovery, Shutdown maintenance work etc).

Confidential, Alexandria, VA

Lead Oracle Database Administrator/Linux Instructor

• Led DBAs in migrating various Oracle versions from Windows to the Linux platform
• Evaluated and provided technical recommendations on business continuity solutions for the MSRB Data Management teams; evaluated replication solutions like GoldenGate and Streams.
• Led DBAs in automating various manual routines like DB backup and recovery, data pump activities; overall helped relieve DBA time by over 30%.
• Designed and implemented custom data change tracking routines for all Database systems at the MSRB; Database auditing is now at the highest at the MSRB. All DB changes are tracked and reported to upper management through savvy custom reports.
• Trained the MSRB technical staff on the Linux platform; this includes developers, operations staff, middle management and DBAs for the whole organization.
• Advised the MSRB on database management techniques, strategies and best practices; documented and trained DBAs on my accepted recommendations.
• Provided technical leadership in evaluating Oracle Data Appliance through on-site Proof-of-Concept exercises

Confidential, Mclean, VA

Senior Oracle Database Administrator

• Installed and configured Oracle 11g R1 RAC using NetApp & NFS for storage, conducted bi-weekly cold backups using Linux lvm snapshot and NetApp snapshot for disaster recovery to offsite location
• Configured Oracle database server to connect to non-Oracle systems like Hadoop, MS SQL server and MySQL databases in a fully heterogeneous environment
• Upgraded Oracle 11gR1 to 11gR2
• Performed disaster recovery and provided recommendations to senior management for implementation
• Performed database performance tuning activities using tools like ADDM reports and SQL tuning advisors
• Supported research efforts in Oracle replication technologies like Data Guard
• Automated database administration routines, e.g. backup and recovery, data pump export/import activities, schema refresh from different sources, creation and disk usage monitoring
• Designed and implemented Oracle user audit collection and led the DBA team by architecting data flows to the presentation tiers for senior management
• Analyzed database research results and documented findings
• Supported Oracle research work conducted at various airline partners through Mitre’s aviation initiatives
• Supported research efforts with very large databases like AsterData, Greenplum and Teradata

Confidential, Bowie, MD

Part-time Technical Instructor

• Trained students in UNIX and LINUX platforms administration
• Trained students in installing and configuring Oracle ASM and the Oracle RAC stack
• Assisted in writing technical manuals for on-site Linux Administrators
• Assisted in developing training material for interns
• Designed and maintained student mail, SSH Jumpbox and web servers
• Assisted in building and maintaining the Chaveran cloud through various virtualizations
• Installed and configured Red Hat file servers and other Linux appliances
• Installed and configured Linux firewalls for client using iptables and bind
• Developed hardware requirements specification and assisted in other sizing activities

Technical Consultant/Oracle Developer

• Assisted clients in problem identification, in database system architecture problems, in software specifications writing, in software implementation, in testing, and in deployment
• Technical Highlights:
• FDIC THINQ-to-Saba data migration technical lead with a high risk clearance. Led in the design and implementation of FDIC’s data migration effort from THINQ to Saba.
• Supported Yum Brands in architectural designs of their data migration processes
• Assisted in data migration for Enbridge Gas Distribution based in Canada
• Served as technical lead for a Saba engagement at Northrop Grumman Corporation. Supported client in Saba installations and in Oracle data migration
• Supported ATK in their Oracle performance tuning efforts using explain plans, AWR and ADDM reports
• Mentored junior consultants through Saba’s employee mentorship program.

Confidential, Greenbelt, MD

Database Administrator/Developer

• Assisted in the development of backend database stored procedures needed by middle tiers
• Worked extensively with classic ASP and Access reporting tools like pivot tables
• Conducted demos and training sessions needed to use released products
• Worked with content management systems like Drupal and Mambo
• Assisted with web development projects using PHP
• Developed a database application for tracking web logs
• Helped create frontend interfaces for controlling applications
• Extensively dealt with schema design and data modeling using tools like Oracle Data Modeler
• Conducted demos and trained personnel in using this visual basic application

Confidential, Maryland

Linux/Network Administrator

• Supported student network setup and assisted in network problem shooting
• Assisted with network deployment and troubleshooting
• Configured student private routers and other network devices
• Trained students in using network resources on campus
• Worked on a team to help students install Linux workstations