Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
Dylan Kotkov
Tel. 732-207-9876 E-mail:
kotkov.dylon@gmail.com
Objective:
Sr. Oracle operational
and data warehouse DBA. Oracle database engineer.
Summary:
Over fourteen years of extensive experience in database
administration, designing and development of medium to large scale business
application projects. Worked with OLTP and Data warehouse (DSS) databases.
Rigorous expertise in working with various databases: Oracle, MS SQL Server,
PostgreSQL, MS Access and MySQL on different Operating Systems: Linux, SUN
Solaris, IBM AIX and MS Windows Server. Immense experience in database
architecture and data modeling of Data Management and Business Intelligence
(BI) applications. Experienced in full software development life cycle. Expert
in performance tuning. Closely worked with Business Unit Departments, QA, Development
and System (UNIX, Windows) Administration teams to design, create and maintain databases
with the highest level of reliability, scalability, security and performance. Broad
experience in database upgrading, patching, capacity planning and cross
platform migration.
Expertise in Oracle RMAN, Dataguard, Grid Infrastructure
11g, Oracle Enterprise Manager (OEM), GridControl, Quest Toad, PL/SQL, UNIX
(sh, ksh, bash)/DOS shell scripting and MS SQL Server Mirroring and
Replication.
Excellent analytical, interpersonal and communication
skills.
Technical Expertise:
●
Databases:
Oracle 11gR2/10gR2/9i/8i/8.x/7.x, 11gR2/10g/9i RAC, MS SQL
6.5/7.0/2000/2003/2005, PostgreSQL 7.4.x/8.x, MySQL
●
Operating
Systems: RHEL AS 3.0/4.0/5.0, Oracle Enterprise Linux Server 5.x/6.x, IBM AIX 6.1, openSUSE 11.x, Sun Solaris
2.6/2.7 and 5.8/5.10, Windows Server 2000/2003/2005
●
File
systems: Oracle Cluster File System (OCFS) 1/2, Oracle Automatic Storage
Management (ASM), Network File Systems (NFS).
●
Data
Modelers: Embarcadero ER/Studio 6.5, ERWin3.5.2, Oracle Designer
●
ETL/Replication
Tools: Quest Shareplex, Oracle Gateway
●
Virtualization:
VM Ware Workstation 4.x/5.x/6.x/7.x
●
Tools:
Quest SQL Navigator 3.x/4.x/5.x, Quest Toad 8.x/9.x, Oracle SQL Developer,
Spotlight 3.5/4.0, Net8, Oracle Enterprise Manager (OEM), RMAN, SQL*Net,
SQL*Loader, SQL*Plus, Quest Schema Manager, Oracle Connection Manager, Oracle
Statspack/AWR, MS Office, Visio, vi, Veritas NetBackup 6.5
●
Version
Control Tools: CVS, PVCS.
●
Open Source
tools: NAGIOS (Monitoring), Trac (Issues/Bugs tracking software), DocMGR
(Documentation repository).
●
Languages:
SQL, PL/SQL, Unix shells (sh, ksh, bash), DOS shell, Perl
Certificates:
● Oracle 11g Certified Database Administrator
● Oracle 10g Certified Database Administrator
● Oracle 9i Certified Database Administrator
● Oracle 8i Certified Database Administrator
● Oracle 8
Certified Database Administrator
Employment:
10/2011 – Present
|
The Gymboree Corp.
Sr. Oracle/SQL DBA. Consultant.
|
San Francisco, CA
|
Worked as a member of a DBA team responsible for support
application and 9i, 10gR2 and 11gR2 databases for Retail and eCommerce sides of
business. Converted databases from file system (JFS) to ASM.
●
Analyzed requirements
and followed documentation to achieve the goals.
●
Installed
and configured Oracle 11gR2 Grid Infrastructure and Oracle 11gR2 Software.
●
Performed
database and queries tuning using different tools and features such as Oracle
Enterprise Manager and Active Session History.
●
Converted
24x7 mission critical databases from file system to ASM using RMAN and
Cascading Standby on IBM AIX. Prepared “cook book” from begin till end with all
commands, screenshots and references to the official documentation.
●
Refreshed
and cloned databases/schemas for different business purposes.
●
Enhanced
current monitoring system by identifying poor optimized and highly fragmented
objects using internal Oracle packages and Oracle Segment Advisor capabilities.
●
Developed
number of scripts to perform RMAN backup with Veritas NetBackup. Configured
NetBackup backup polices
●
Supported
database for Oracle Financials. Applied patches according to the requirements.
●
Closely
worked with Development and QA Teams to troubleshoot different issues.
●
Privided
24x7 on-call support.
05/2009 – 07/2011
|
Royal Bank of Scotland
Sr. Oracle DBA/Architect
|
Chicago, IL
|
Worked as a member of a team responsible for design,
development and support of the bank applications. Worked at Transaction Banking
Support department. Immense experienced in designing, configuring and
implementing Real Application 10gR2/11gR2 Clusters. Maintained mission critical
application databases.
●
Analyzed
data workflow, documentation and requirements.
●
Identified
and analyzed possible weaknesses. Performed database tuning of most expensive
database objects/queries.
●
Achieved significant
performance improvement by creating or modifying existing objects. Proposed
different solutions depending on situations such as partitioning, new database
objects, indexing, materialized views, etc.
●
Installed,
patched and cloned databases. Performed regular day-to-day maintenance and
support.
●
Installed
and configured 10gR2/11gR2 GRID database clusters based on NFS, OCFS and ASM
storage.
●
Upgraded
number of databases from 10gR2 to 11gR1 and 11gR2 version.
●
Designed,
created and deployed subsystems for data auditing including Fine-grained Audit
and purging based business requirements.
●
Installed
and configured Oracle Enterprise Manager (OEM) Grid Control. Installed and
configured agents on Oracle and MS SQL Server database servers.
●
Designed
and implemented real-time monitoring system based on NAGIOS. Designed and
created number of UNIX (bash, ksh, sh) and DOS shell scripts for monitoring
activity.
●
Performed
cross platform upgrade and migration from Oracle 10gR2 on Windows to Oracle 11gR2
on Oracle Linux AS 5.0.
●
Developed
number of shell scripts using sh, ksh and bash to monitor and alert different
Operating System and databases statistics such as disk space availability, log
files contents (Oracle Alert logs), file transfers, etc.
●
Modified
and improved current backup and recovery strategy using Oracle RMAN, Standby
and DataGuard.
●
Implemented
data replication in heterogeneous environment between MS SQL Server and Oracle
using Oracle Gateway. Designed and developed ETL and ELT procedures.
04/2007 – 05/2009
|
Bank of America
Oracle SME/Architect
|
Chicago, IL
|
Worked as a SME/Architect and was responsible for data
consolidation, conversion and database transfer from ABN AMRO Bank to Bank of
America. Lead database architect for design, creation, migration of the
databases for Transition Service Agreement between ABN AMRO Bank and Bank of
America.
·
Analyzed
data structure and relationship on different levels and areas of business such
as owned assets: buildings, applications, required software and hardware
including network storages and devices.
●
Actively
interacted with various Business Units, Project Managers, on-site and off-shore
development and support teams.
●
Worked on
data migration between databases on different platforms: Oracle, MS SQL Server,
MySQL and MS Access.
●
Designed
and modeled databases layouts using Embarcadero ER/Studio. Worked on
reverse-engineering modeling.
●
Designed
and implemented backup and recovery strategy using Oracle RMAN, DataGuard and
MS SQL Server mirroring/replication.
●
Developed
Unix (ksh, sh, bash) and DOS scripts to automate backup, initialization and
maintenance tasks.
●
Extensively
used Oracle Enterprise Manager (OEM) to perform various database maintenance and
routines.
●
Patched and
upgraded number of databases from Oracle 9i to 10gR2.
●
Optimized procedures
for efficient data retrieval. Tuned database performance.
●
Worked with
development teams to create new DB objects such as procedures, triggers,
packages, etc. using PL/SQL, SQL*Plus, Quest Toad and Quest SQL Navigator.
●
Cloned and
refreshed databases and schemas for different business and testing purposes.
●
Technical
consulting as application expert. Provided 24x7 database support.
07/2003 – 04/2007
|
ABN AMRO Bank
Oracle DBA
|
Chicago, IL
|
Worked as a member of a team responsible for design,
development and support of the bank applications. Worked at Electronic Support
Services department. Immense experience in designing, configuring and
implementing Real Application Clusters (9i RAC).
●
Analyzed
layout of databases/schemas and their relationship.
●
Performed
database and queries tuning to achieve the maximum performance using Quest
SpotLight, Explain Plan, etc.
●
Installed
and configured 9i RAC database clusters based on NFS and OCFS.
●
Cloned and
refreshed databases for various business and test purposes.
●
Applied
upgrade and security patches due to technical and security reasons.
●
Performed
maintenance and diagnostics tasks using Oracle Enterprise Manager (OEM).
●
Modified
and improved current backup and recovery strategy using Oracle physical Standby
and DataGuard and Network Appliance functionalities. Created number of scripts
to automate this process.
●
Proposed
and implemented Business/Disaster Recovery tests.
●
Performed
upgrade and migration from Oracle 8i on SUN Solaris 2.8 to Oracle 9i RAC on
Linux AS 3.0.
●
Configured
Oracle STATSPACK utility. Prepared detailed STATSPACK reports. Identified and
modified the most cost expensive queries and hot objects. Developed reporting
tool based on STATSPACK information.
●
Developed
number of database objects such as procedures, functions, triggers, indexes,
packages using Quest Toad and Quest SQL Navigator.
●
Developed
number of UNIX (ksh, sh, bash) and DOS scripts to automate reporting and
maintenance tasks.
●
Supported
data warehouse database. Created number of Materialized Views for different
business purposes.
07/2001 – 03/2003
|
E-Research Technology, Inc.
Oracle DBA
|
Bridgewater, NJ
|
Worked as a member of a team responsible for design and
development of EXPeRT system. The system is used by medical companies for
storing electrocardiograms data. It provides clients with ability to enter,
store, review and analyze data and measurements. Worked with medical customer
sensitive information.
●
Collected,
analyzed and documented requirements and functionality based on current
application.
●
Designed
and created new logical and physical database models using ERWin3.5.
●
Installed,
patched and cloned databases. Performed regular database maintenance and
support using Oracle Enterprise Manager (OEM).
●
Created and
updated tables, packages, stored procedures, functions, triggers using Quest
Toad and SQL Navigator.
●
Tuned
database objects and queries using different DB tools: Explain plan tool, Quest
Spotlight.
●
Involved in
to reports design, development and implementation using Crystal Report 8.0/8.5.
Worked on reporting module for the application. Updated, corrected reports and
parameters according to the latest requirements. Tuned, tested and fixed Crystal
Report objects.
●
Developed
procedures and UNIX (sh, ksh, bash) and DOS shell scripts to automate database
operations, database monitoring and data integrity between databases.
●
Reviewed,
compared and tested various Code Control Tools. Prepared detailed report with
description of capabilities, limitations.
●
Performed
installation, integration and test of the Source Code Control tools and
Database Development tools. Wrote detailed description of the integration and
deployment SCC software.
●
Provided 24x7
on-site and on-call database support.
12/2000 – 07/2001
|
U & X Group, Inc.
Oracle DBA
|
Woodbridge, NJ
|
Worked as a member of a team responsible for support and
development inquiry-information system.
●
Analyzed
and documented internal network and database systems.
●
Performed
routine database administration using Oracle Enterprise Manager (OEM).
●
Implemented
Disaster Recover and Business Recovery strategies.
●
Designed,
created and tested new database objects such as tables, packages, procedures,
functions, triggers and constraints using Quest Toad and SQL Navigator.
●
Performed
migration from Oracle 8.0.5 to Oracle 8.1.7
●
Tuned
production database objects and queries using different methods using Explain
Plan and SQL Lab.
●
Designed
and implemented backup and recovery strategy using Recovery Manager (RMAN).
Performed full and incremental database backup.
●
Developed
number of UNIX shell (bash, ksh, sh) scripts for daily Operating System and
database maintenance.
●
Installed
and configured operating systems for database servers such as Sun Solaris and
Linux.
Education:
9/1993 – 6/1997 Moscow
Engineer-Physics Institute (Technical University), Moscow, Russia
BS in Computer Science
9/1997 – 2/1999 Moscow
Engineer-Physics Institute (Technical University), Moscow, Russia
MS in Computer Science
References:
Available upon request
Download Resume Format
0 comments:
Post a Comment