Consultant Resume Stamford, CT - Hire IT People

SUMMARY:

Oracle Certified Professional DBA with ten years Oracle DBA experience.
Resolved long - standing problems in production environments using trouble-shooting skills based on intuitive understanding of IT fundamentals.
Achieved significant efficiencies by redesigning database access and making configuration changes for existing production systems.

TECHNICAL SKILLS:

Technology and Tools: Maximum Availability Architecture (MAA), RAC, Data Guard, ASM, RMAN, OEM, Partitioning, Statistics Management, Data Pump, Materialized Views, Globalization, Loader, OWI, AWR, ASH, ADDM, Optimizer Hints, Explain Plan, tkprof, SQL, PL/SQL, Unix, shell scripts, Windows

PROFESSIONAL EXPERIENCE:

Consultant

Confidential

Responsibilities:

Provided senior DBA expertise in a process-oriented team environment supporting 20 applications using Oracle 11g/10g/9i on Solaris, Linux, and AIX.
Reviewed SQL execution plan history data to successfully diagnose and resolve critical incident involving sudden performance deterioration.
Responsible for migrations to 11g/10g, and configuring new builds for production.

Confidential

Responsibilities:

Provided senior DBA/architect expertise to developers and end-users for data warehouse applications: BAATS, BAATS-CM, and BASIS.
Recognized twice by client managers for tuning improvements and responsive support.
Migrated BASIS to Maximum Availability Architecture using two node RAC with two node Physical Data Guard.
Responsible for upgrades, CPU patches, schema refreshes, DR exercises, performance tuning, and trouble-shooting.
Coordinated efforts of off-shore DBAs for emergency response and off-hours tasks.

Confidential

Responsibilities:

Provided senior operations DBA/architect expertise to the CityTime project supporting 28,000 users and 80 databases in a 24x7 production environment. Developed strategic solutions for physical database configuration, performance tuning, trouble-shooting, and database monitoring.
Created metrics to proactively monitor production DB performance and hardware capacity utilization to pre-empt bottle-necks.
Monitored incremental rollouts and identified application design improvements and responsible groups on 250 person project covering OLTP and data warehousing applications.
Consistently resolved critical performance issues by making DB configuration changes, and identifying database access improvements.
Installed DB software, created/upgraded/migrated databases, and applied patches.
Developed & implemented backup & recover policies using RMAN, VCS, Exp/Imp, and Data Pump.
Assisted developers in tuning complex SQL statements and PL/SQL procedures for real-time etl.
Managed NYC Law Dept implementation of CityTime application. Achieved significant performance improvements by adjusting memory structures and identifying client infrastructure bottlenecks.
Successfully performed complete recovery of production database from failure of three disks.

(Oracle 9i/10g/11g, Solaris 10, Windows, RMAN, VCS, Streams, OEM, RAC, ASM, Data Guard, Korn scripts, SQL, PL/SQL, Statspack, OWI, AWR, ASH, ADDM, SQL*Navigator, Remedy, ClearQuest, Clearcase).

Confidential

Responsibilities:

Tuned top 100 SQL queries for a PeopleSoft HR data warehouse for Verizon Wireless using Explain Plan, Optimizer Hints, & tkprof.
Provided business development and pre-sales technical support to Confidential ; managed etl process development and remote DB monitoring service.

Confidential, Stamford, CT/New York City

Senior Oracle DBA

Responsibilities:

Provided Oracle DBA support for development & production environments for GE FGIC and Confidential . Assisted application developers with performance tuning issues for trading and back-office applications. Developed Unix shell scripts, SQL scripts, and PL/SQL procedures, functions, and triggers.
Managed remote Oracle database monitoring services for GE Capital & Ryan Partnership using 3-tier OEM infrastructure. Conducted quarterly disaster recovery drills for each monitored database. Wrote Service Level Agreements and won new business. Routinely achieved 100 percent uptime.
Led effort to migrate two 8i databases to UTF8 character set.

Confidential, Annandale, VA

Consultant

Responsibilities:

Oracle 8/8i, Server Manager, OEM, DBA Studio, Pro*C/C, PL/SQL, SQL, SQL*Loader, Imp/Exp, SQL*Plus, Solaris 2.5, Windows NT/98/95.
Oracle 7.3, HP-UX, SQLDBA, Pro*C, PL/SQL, SQL*Forms.
Participated in physical database design for an Oracle Parallel Server (pre-cursor to RAC) implementation on a 12 node AIX based SP/2 machine.
Provided Oracle DBA, performance tuning, and ESQL(C, Cobol) expertise. Reviewed kernel parameters, table design, and ESQL code for optimization. Reduced CPU time requirements by 80 percent by identifying repetitive parsing of a SQL statement in an ESQL program. Developed ESQL/C/COBOL programs using dynamic SQL method 4. (Oracle v6, Cyber NOS/VE, Unix)
In-house (90 to 92) Developed Oracle productivity tools (Pro*C code generator, SQL*Forms documentation utility) using C. Ported products from MS-DOS to Unix and VAX VMS.

We provide IT Staff Augmentation Services!

Consultant Resume

Stamford, CT

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship