Yuri Shilman
Los Altos, CA 94024
Phone: (415) 827-0787
E-mail: [Send email using form at bottom]
Website: http://shilman.8m.com
______________________________________________________________________________
Objective
To obtain a position as an Oracle DBA using my knowledge and personal
creativity
Computer Skills
Database: Oracle 10g,9i, 8i, 8.x, 7.x
Operating Systems: Linux, AIX 4/5, Solaris 2.x, Windows NT/9.x/2000/XP, OS X
Languages: PL/SQL, SQL, ASP.NET C#, HTML, C, C++, Basic, Pascal, Assembly
Language (MIPS RISC architecture)
Hardware: Compaq Proliant DL380, DL 580, Sun E450, Sun E3500
Web Server: IIS, BEA Weblogic
Software:
o Oracle Monitoring: OEM, Quest I/Watch, Quest SpotLight , BMC Patrol, Veritas
Precise
o Oracle Development: SQL*Navigator, Toad, ER-Win, SQL*PLUS
o Oracle Backup/Recovery: RMAN with Legato Networker
o Internet: Internet Explorer, Netscape Navigator
o Others: Telnet, Vi editor, CRON job scheduler, FTP, MS Office, Microsoft
Visual Studio 2003, ASP.NET Web Matrix, Weblogic
Summary of Qualifications
Experienced working as an Oracle (8i/9i/10g) DBA in Unix/Windows environments
Experienced upgrading Oracle databases from 8i to 9i to 10g
Experienced working in a 24/7-support role
Experienced supporting an OLTP and Data Warehouse databases (over 3 TB in
size)
Experienced writing PL/SQL (Packages, Stored Procedures, Functions, and
Triggers)
SQL Tuning using Explain Plan/TKPROF
Creative problem solving and trouble shooting skills
Experienced writing UNIX shell scripts
Experienced with ER Data Modeling using ER-Win, Logical and Physical database
design, query optimization, concurrency control, security and integrity
enforcement, debugging and testing of Oracle databases
Patching and upgrading the Oracle software
Backup and recovery via RMAN
Enhance existing DB monitoring systems
Effectively communicated technical information to end-users
Good communication and problem solving skills
Experience with SOX implementation in the Oracle world
B.S. in Computer Science
Experience
Jan 2007 open eMeter, San Mateo, CA
Senior Oracle DBA
Automation of the Oracle software installation (9i and 10g on Linux and
Windows)
Semi-automation of the software upgrades for eMeter (database side only)
24x7 support
Automation of database creations
Configuration of Oracle database initialization parameters
Working with programmers to suggest more efficient usage of the database
Installation and automation of the RMAN backups
Automated monitoring and maintenance tasks by writing scripts (PL/SQL and/or
shell scripting)
Implement features in Oracle and outside of Oracle that maximize database
uptime and performance
Integrate/collaborate with application development and support teams on IS&T
projects
Production Oracle/Metalink support of eMeter clients
May 2008 August 2008 Siterra, SanFrancisco, CA
Lead Senior Oracle DBA(consultant)
Automated the monitoring (shell scripts via cron) of the Oracle Production
databases on Linux
Installed and Upgraded the 9i Oracle databases to 10g on Linux and on Windows
Lead the 24x7 Production support of databases that totaled to over 1.5 Tb in
size
Took part in design and implementation of the replication process via Oracle
Streams
Tuned the nightly data replication batch process that changed the run time
from over 12 hours down to 5 hours
Configured Oracle database initialization parameters to make the databases to
run at their best
Worked with the architects to fix the performance bottlenecks
Took part in physical and logical design of the databases that ended up to
boost the overall performance
Installed and automated the RMAN backups
Implement features in Oracle and outside of Oracle that maximize database
uptime and performance
Mentored other DBA staff
Worked with Oracle via Metalink to troubleshoot issues
May 2006 Jan 2007 Biz360, San Mateo, CA
Senior Oracle DBA
24x7 production support
Monitoring disk space, CPU and memory usage
Configuration of Oracle database initialization parameters
Working with programmers to suggest more efficient usage of the database
Responsible for trouble shooting the performance issues on the application
backend & databases
Responsible for loading data to Oracle databases from files
Backup and recovery via RMAN/hot backups
Automated monitoring and maintenance tasks by writing scripts (PL/SQL and/or
shell scripting)
Implement features in Oracle and outside of Oracle that maximize database
uptime and performance
Integrate/collaborate with application development and support teams on IS&T
projects
Maintain the uptime and availability of 2 primary databases and 2 standby
databases running Oracle 8i/9i on Solaris/Linux
June 2004 May 2006 Apple Computers, Cupertino, CA
Senior Oracle DBA
24x7 production support on rotating schedule
Monitoring disk space, performance and data loading applications
Configuration of Oracle database initialization parameters
Coordinate with developers to develop and tune SQL queries and procedures
Responsible for trouble shooting the performance issues on the application
backend & databases
Responsible for loading data to Oracle databases from files
Backup and recovery via RMAN
Responsible for writing database-monitoring scripts
Act as a project leader for critical, time driven, visible projects
Integrate/collaborate with application development and support teams on IS&T
projects
Oversee activities performed by less experienced DBA's for quality and
consistency
July 2000 April 2004 CharlesSchwab & Co. , San Francisco, CA
Senior Oracle DBA
Troubleshooting any issues related to production, dev and qa databases (24/7
support type)
Responsible for configuring & tuning Oracle system parameters and PL/SQL
scripts
Monitoring/Analyzing/Optimizing system performance
Updating/Adding/Removing users (UNIX/Oracle)
Assigned/modified user's privileges (UNIX/Oracle)
Monitoring/Checking database connections
Assist in managing and implementing schema level upgrades
Maintain archived data on tape (Legato Networker)
Install/configure/monitor the Weblogic server
Resource for DB developers
May 1999 June 2000 MillwardBrown Interactive , San Francisco, CA
Data Warehouse DBA/ PL/SQL Developer
Responsible for the back-end (Oracle 8) development of the BrandImpact
- Optimized query performance
- Resolved production problems
- Provided timely follow-ups on production problem reports
Responsible for configuring & tuning Oracle system parameters and PL/SQL
scripts
Responsible for design, development and testing of the company's data
warehouse and operational databases
- Populated a data warehouse as well as moved data out for reporting purposes
- Migrated data from testing to production environments, and evaluated the
process
September 1996 May 1999 Efficient Computing, San Francisco, CA
Database Developer/Network Administrator
Developed and implemented the back end of Relational Database Management
System to enable customers timely retrievals of critical information used for
business decisions.
Designed Oracle 7.3 database to track payroll, hardware and maintenance
requirements at Stanford Facilities Operations.
Moved the extracted 10-year-old historical data which consisted of several
million rows into the desktop databases (Paradox 7) to determine the best tables
format for Oracle
- Performed analysis, design, development, and testing for purposes of data
conversions
- Developed algorithms for filtering data
- Created and sized Oracle tables
- Created views, triggers, indexes
- Developed and coded applications in PL/SQL
NT User Account administration and security management at San Francisco State
Universitys Plant Operations and Capital Planning Divisions San Francisco, CA
- Designed, implemented, monitored, administered and troubleshooted networks,
both software and hardware
- Troubleshooted hardware /software problem (PC/Macintosh/laptops)
- Performed server backups, created/modified network accounts
Education
2005 Oracle Data warehouse DBA, Oracle, San Francisco, CA
2000 - Oracle for Database Administrators, UC Berkley Extension, San
Francisco, CA
1994-1999 BS in Computer Science, San Francisco State University, San
Francisco, CA
1998-1999 Introduction to Oracle: SQL, SQL*Plus and PL/SQL, Oracle
Corporation, SFSU
1992-1993 Graduate, John OConnell High School of Technology San Francisco,
CA
Personal
I'm a very self-motivated person who loves a challenge. I am a problem solver,
organized, flexible, patient and can handle significant pressure. I possess
strong analysis skills in order to analyze customer environments and quickly
learn new technologies and technical environments. I am able to work extremely
quickly to both analyze the customer environment, and to develop the appropriate
programs. I am personable enough to interface with a variety of internal staff
and client technical staff. I really enjoy taking an idea and turning it into
reality. I think my strong technical background; coupled with my communication
skills are a unique combination in today's market. Users need a technical person
they can talk to -- and I enjoy being that person.
|