Sql Server Oracle

Anthony Nicoletti

[pic]

** ***** ****** *********, *.J. 07506

973-***-**** (H) - 201-***-**** (C) ******@***.***

SUMMARY

Accomplished Senior Database Administrator with over 12 years experience. A

strategic member of a global data center operations team with mixed

computing environments including Windows 2003/2008 Server, AIX PSeries and

LINUX RH 5. Solid reputation for productivity, complex problem resolution

and professionalism. Excellent communication and documentation skills.

Experienced with Oracle 8i thru 11g and SQL Server 2000 and 2005.

PROFESSIONAL

EXPERIENCE

API Systems, Inc. Denville, N.J.

09/2010-Present

A short-term project for Emergency Medical Associates to implement an

Oracle backend infrastructure; 10g databases, RMAN backups, data pump

exports, Oracle patches, Security, documentation and performance tuning for

development,

QA and production.

Database Administrator - Responsible for all areas of database

administration for Oracle 10g on Windows 2003 server. Proven expertise in

database upgrades and patches, configuring RMAN backups, proactive

performance tuning, security and managing database refreshes. Build solid

relationships with key organizational areas.

. Successfully built an Oracle 10.2.0.1.0 development and QA

environment and patched to 10.2.0.4.0.

. Implemented an RMAN full and incremental backup strategy in the

production environment utilizing

the DBMS_SCHEDULER engine allowing the EMA applications to go

live with 24/7 operations.

. Setup, configured and scheduled Oracle data pump exports in all

Oracle environments using the Oracle

supplied DBMS_SCHEDULER for complete management and

control.

. Took advantage of Oracle OEM, AWR, ASH reports and advisors for

creating a proactive performance

tuning environment for all Oracle 10g databases using

DBCONSOLE.

. Successfully configured a single-sign-on environment with the

Oracle database and Active Directory.

. Supplied (SOP) documentation for all new ORACLE database

processes including but not limited to;

Installations, RMAN backups, Data Pump exports, database

patching, Security and performance tuning.

Covanta Energy Group, Inc. Fairfield, N.J.

01/2007-07/2010

Database Administrator - Responsible for all areas of database

administration for Oracle 9i, 10g, 11g and SQL Server 2000 and 2005 on

Windows 2003/2008 and LINUX RH5 platforms. Proven expertise in database

upgrades and patches, configuring RMAN backups, proactive performance

tuning and managing database refreshes. Build solid relationships with key

organizational areas, understood the company business policies and work

closely with Oracle and Microsoft vendors. Oracle/SQL Server support was

70%/30%.

ORACLE:

. Successfully managed the Oracle 10g database upgrade for the

Peoplesoft and Maximo initiatives while meeting all target dates.

. Responsible for setting up 24/7 operations for all Covanta major

ERP's on Oracle using RMAN backups providing high availability for

32 global sites.

. Implemented RMAN hot backups (full and incremental) using Oracle

10g database control and dbms_scheduler for complete management and

control.

. Installed replication using materialized views in DMS for all

remote PC Scale (24) sites creating a zero

loss tolerance service level agreement.

. Took advantage of the Oracle OEM, AWR, ASH reports and ADVISORS

for creating proactive

performance tuning of all Oracle 10g databases using

DBCONSOLE and GRID CONTROL.

. Installed and configured Oracle 10g Grid Control on Windows 2003

server to provide end-to-end server

and database monitoring for Oracle and SQL Server.

. Created (SOP) documentation for all SQL Server database processes

that were provided to the remote

DBA group for assistance. (ie.. rebuilds, refreshes).

SQL SERVER:

. Establish and maintain physical database environment on multiple

instances of a SQL Server 2005

Cluster creating a zero loss tolerance service level

agreement.

. Maintained full responsibility for creating and managing 10 SQL

Server 2000 and 2005 instances,

staging 100 databases across multiple environments

eliminating increases in the IT resource budget.

. Worked with end users and application support staff with design,

implementation and migration of

SQL Server objects including stored procedures,

triggers, views and scripts across multiple instances.

. Performed the design, testing and implementation of backup,

fragmentation and log shrinking

maintenance jobs for SQL Server 2000 and 2005

instances.

. Implemented SSMS for complete database management and SQL

Profiler for tracing and query

performance trends.

. Created (SOP) documentation for all SQL Server database processes

that were provided to the remote DBA

group for assistance. (ie.. rebuilds, refreshes).

Medco Health Solutions Franklin Lakes, N.J.

12/2005 - 01/2007

Oracle Database Administrator - Responsible for all areas of Oracle 8i and

9i database administration on

Unix AIX Pseries and Windows 2003 Server platforms. Proven expertise in

proactive performance tuning and managing database refreshes. Build solid

relationships with key organizational areas, understood the company

business policies

and work closely with the Oracle vendor. Oracle support was 100%.

. Responsible for researching, reviewing the major database

monitoring technologies with a final

implementation of Grid Control 10g used for complete

server and database monitoring.

. Successfully implemented Oracle 9i Data Guard standby database in

TEST environment to fulfill the

high availability architecture.

. Created backup strategy using BMC SQL Backtrack (v3.4, 5.3)

software.

. Joined On-Call (pager) rotation schedule in systems group of 4.

. Maintained database management responsibility for the major (1.5

TB) application and Oracle partitioning.

. Responsible for managing the current CRON environment for 3 major

applications.

Oracle Corporation, Manhattan, N.Y. / Iselin, N.J.

12/2000 - 07/2005

Principal Instructor / DBA - Responsible for all areas of Oracle 8i and 9i

database administration training.

. Joined as Staff Instructor and promoted twice to attain Principal

Instructor status.

. Provide 8i, 9i, 10g training for Administration 1 including but

not limited to:

- Complete database administration including

security and database networking.

- Object reorgs, space utilization, storage

and index maintenance.

. Provide 8i, 9i, 10g training for Administration 11 including user-

Managed backup, restore, and recovery and Recovery Manager (RMAN)

backup, restore, and recovery.

. Provide 9i, 10g training for performance Tuning using a variety

of tools. (Grid Control, OEM, v$ views).

. Provide 10g training of Oracle 10g: Grid control installation and

administration.

. Installation and administration of Oracle Application Server 10g

(9.0.4).

Ogden Energy Group, Inc., Fairfield, N.J.

07/1998 - 12/2000

Support Center Coordinator - Providing PC/LAN technical support for 1500

local and remote employees.

. Provided PC and LAN technical support for 1500 employees.

. Co-ordinate special projects, rollouts, fixes, and installations

for 28 facilities.

. Selected as system admin for Citrix, Outlook, and UUNET dial-up

networking

. Wrote and implemented software training documentation utilized by

28 facilities in 15 states.

EDUCATION AND CERTIFICATIONS

Data Center Support, Management Information Systems

The Chubb Institute Parsippany, New Jersey

Chubb Honors Program Member (GPA 3.8)

OCP, Oracle Certified Professional (Versions 8i / 9i / 10g)

Comprehensive experience with diverse hardware, software, and operating

systems.

Contact this candidate