Oracle Sql Server
Resume:
Michael Sukenik, PE, OCP
Brooklyn, New York Telephone: 917-***-****
E-mail: **************@*****.***
____________________________________________________________________________
_________________
DESCRIPTION:
Oracle Certified Database Administrator with broad knowledge and over
fourteen years of extensive experience as an Oracle DBA on Linux, UNIX, and
Windows O.S. platforms. Design, installation, and configuration experience
with High Availability solutions, such as Oracle RAC, RMAN, Database
Streams, Advanced Replication, Data Guard, ASM, OCFS2, Partitioning.
Microsoft SQL Server DBA experience. PeopleSoft Financials and HRMS
applications administration experience. Capable to quickly adapt to a
unique situation working as part of an integrated team and/or as an
independent contributor.
OBJECTIVE:
Oracle DBA Position.
EXPERIENCE:
Oracle Database Releases: 8i, 9i, 10g, 11.1, 11.2
Oracle Database Tools: Enterprise Manager, SQL Developer, SQL*Loader, SQL
Data Modeler
Database Languages: SQL, PL/SQL, UNIX/Linux Bourne/Korn/Bash
Shells
UNIX/Linux Utilities: Topas, Top, Vmstat, Iostat, Netstat, Sar
MS SQL Server Releases: 2000, 2005
2009 - Present Superior Design International, Inc. / New York Life
Insurance Company
New
York, New York
Oracle DBA Consultant
Provide Oracle database administration and development
services for production and development web based
applications environments. The responsibilities are focused
on providing comprehensive solutions in planning, designing,
developing, installing, configuring, performance tuning,
backup and recovery of Oracle software and databases.
Collaborating with applications development team and
providing the team with SQL and PL/SQL guidelines.
Accomplishments:
. Install and configure Oracle v. 11.1.0.6 and v. 11.2.0.1
64-bit software and databases on Oracle Enterprise Linux
v. 5.1 and v. 5.5 O.S. platforms.
. Perform installation and configuration for Oracle v.
11.2.0.1 XML Database.
. Install and configure Oracle Active Data Guard.
. Configure Oracle Advanced Security, including the
tablespaces level Transparent Data Encryption.
. Improve Oracle database performance by restructuring
Large Binary Objects (LOBs) using the new v. 11g
SECUREFILE options.
. Optimize query and backup performance by implementing
Oracle Advanced Compression.
. Write and schedule Oracle RMAN backups, and DataPump
database exports.
. Optimize Oracle SQL statements inside the PHP
application scripts.
Ongoing tasks:
. Writing Oracle Database Installation, Configuration,
Development, and Administration documentation for the
financial applications implementation.
. Providing Oracle databases performance monitoring and
tuning.
. Providing Oracle Best Practices guidance to the
development team.
2002 - 2009 Maimonides Medical Center
Brooklyn, New York
Oracle DBA
Perform a full range of Oracle database administration for various
applications. Responsibilities are focused on providing
Oracle technical leadership, as well as required performance
and availability of daily operations, including the
following:
. Installing, configuring, and upgrading Oracle RDBMS
software.
. Capacity planning and designing database architecture.
. Creating, configuring, and optimizing Oracle databases.
. Managing database structure and storage allocation.
. Tuning and troubleshooting databases for optimal
performance.
. Upgrading databases, and installing database patches.
. Setting up and managing High Availability database
solutions.
. Writing UNIX/Linux shell scripts for the database
processes automation and optimization.
. Developing SQL and PL/SQL scripts for new and existing
projects.
. Setting up and administering database security.
. Establishing database backup and recovery procedures.
. Testing database recovery for various failure scenarios
and planning disaster recovery.
. Performing general UNIX/Linux system administration
tasks, such as setting permissions, managing file systems
and users, verifying system performance.
. Writing database Best Practices documentation.
. Cooperating with management on meeting and exceeding the
targeted priorities and goals.
. Collaborating with support and development teams in
achieving the desired results.
. Providing the necessary training, mentoring, and
Oracle leadership to project team members.
Accomplishments:
. Installed and configured Oracle RDBMS v. 11.1.0.6 RAC on
two-node Linux cluster.
. Performed layout for Oracle Clusterware Registry, and
Voting Disks.
. Installed and configured OCFS2, Oracle Clusterware, and
Oracle RAC on Linux.
. Implemented SAN disks partitioning on EMC CLARiiON Disk
Arrays and Storage system.
. Configured AWR and ADDM tools for databases automatic
performance diagnostic.
. Installed and configured Oracle RDBMS v. 10.2.0.4 with
ASM on UNIX.
. Evaluated PeopleSoft v. 9.0 / PeopleTools v. 8.49 for the
upcoming upgrade.
. Accomplished installation, configuration, and upgrade to
PeopleTools v. 8.22.16 for PeopleSoft v. 8 SP3 Financial
Applications.
. Upgraded Oracle databases from v. 9.2.0.8 to v. 10.2.0.4.
. Accomplished MS SQL Server to Oracle database migration.
. Configured Oracle Advanced Security, including tablespace
Transparent Data Encryption (TDE) with Hardware Security
Module (HSM) TDE master key protection.
. Installed and configured Oracle Database Vault for data
security and privacy enforcement.
. Implemented Oracle database data masking and backup
encryption.
. Installed and configured Oracle RDBMS v. 11.1.0.6 on
Windows servers.
. Created and configured Oracle Data Guard physical standby
database.
. Wrote and scheduled nightly RMAN incremental backup
scripts.
. Wrote emergency handling SQL scripts for production
systems pick loading conditions.
. Installed and configured Oracle v. 9.2 production and
test databases on UNIX AIX servers.
. Configured, customized, and automated Oracle Statspack
performance gathering scripts.
. Installed and configured three and four tier environments
for various PeopleSoft Fincancials and HRMS applications
with Oracle databases on UNIX and Windows servers.
. Accomplished Oracle databases upgrade and migration from
v. 8.1.7 to v. 9.2.0.3.
. Performed PeopleTools v. 8.44.09 installation,
configuration, and upgrade.
. Fulfilled DBA reguirements for PeopleSoft HRMS v. 8.8 SP2
Upgrade.
. Installed and configured SQL Server 2005 clustered
databases.
. Developed SQL Server 2005 backup strategy and setup
databases backups.
. Configured SQL Server 2005 data replication.
. Implemented SQL Server 2005 databases auto restore and
CHECKDB nightly procedures.
. Installed and configured Oracle RDBMS v. 9.2.0.2 on new
UNIX servers.
2000 - 2002 Insignia Financial Group Inc.
New York, New York
Oracle DBA
Provided Oracle database administration for production and
development operations of various applications on UNIX Sun
Solaris O.S platform.
. Accomplished installation and configuration of Oracle
8.1.7 / PeopleSoft 7.5, with AutoSys job scheduling
system, 3-tier production environment on Unix Solaris
with Veritas Cluster Server .
. Managed database structure and storage allocation, backup
and recovery, performance tuning, upgrades and security.
. Developed UNIX shell scripting for implementing
automation of repetitive processes.
. Actively participated in meetings with development and
support teams on projects implementation and problems
resolution.
. Worked with application developers and users on system
improvements.
1997 - 2000 NYC Department Of Sanitation
New York, New York
Oracle DBA
Performed Oracle database administration for the New
York City Treatment Facilities
Computerized System. The system allows monitoring,
modifying, and analyzing
Water Chemistry data to support 24x7 Leachate Treatment
Plant operations.
Responsibilities included:
. Controlling and monitoring user sessions and database
access.
. Creating database objects: tables, views, indexes,
synonyms, stored procedures,
triggers.
. Managing physical and logical database structure and
storage allocation.
. Monitoring and optimizing database performance.
. Troubleshooting, backup and recovery.
. Participating in meetings with users on determining
system requirements.
1995 - 1997 Wall Street Business Solutions, INC.
New York, New York
Programmer - Analyst
Participated in design and development of Mortgage
Settlement System for the major banking company. The
system allowed keeping track of rates, PMIs, broker fees,
appraisal, searching information based on different
criteria, and producing various reports. Responsibilities
included gathering of system specifications, functional
decomposition, design of tables. Used PowerBuilder 5.0 /
Oracle 7.1 to create stored procedures, triggers, and
modules for searching and modifying data.
1994 - 1995 VN Engineers, INC.
Boston, Massachusetts
Transportation Analyst
Implemented maintenance and protection of traffic estimates
for the Central Artery/Tunnel Project in the city of Boston.
Produced design, research, and cost analysis of road
structures. Performed on-site investigation and
determination of existing conditions. Participated in
installation and configuration of AutoCAD 12, Computer Aided
Design and Drafting System, for the project.
1992 - 1993 NYU - Poly
Research Assistant
Brooklyn, New York
Participated in geotechnical experiments on stress behavior
of composite materials. Wrote a FORTRAN program that
performed calculations of the data received from the analog-
to-digital converter.
EDUCATION:
Oracle Database 11g: RAC Administration Oracle University
New York, NY
Oracle 10g DBA New Features Oracle University
New York, NY
Clustering High Availability on Windows Server HP Corp.
New York, NY
Oracle 8 DBA Xincon Technology School
New York, NY
BS in EE with minor in CS NYU - Poly
Brooklyn, NY
BS / MS in CE Tashkent State
University Tashkent, USSR
PROFESSIONAL CERTIFICATION AND LICENSURE:
Oracle Certified DBA (versions 7, 8, 8i, 9i, 10g)
New York, NY
Professional Engineer
New York, NY
REFERENCES: Available upon request.
Contact this candidate