We provide IT Staff Augmentation Services!

Sr. Database Specialist/dba Resume Profile

5.00/5 (Submit Your Rating)

West Chester, PA

Hire Now

SKILLS

  • Oracle installs, maintenance, debug Database backups using rman, export, import
  • Database design and modeling Implement DR setup and drills
  • ETL loading development Migrations leading to vendor cost savings
  • Job runs scheduling design and development Performance tuning capacity monitoring
  • Experienced at all levels full cycle SDLC Problem solving and production support

SUMMARY

More than 12 years of experience in Oracle Database Administration comprised of planning, building, installing, testing, tuning, maintaining, backups and support. More than 7 additional years of experience as a Database Architect with a background of data modeling, schema construction and ETL development. Performs work in all levels of the SDLC and applied to Data Warehouses, Data Marts, OLTP transactions, time dependent and real time databases.

Work experience

Confidential

Sr. Database Specialist/DBA

  • DB lead of many phases of SDLC steps for risk hedging for ING/U.S. multi-billion dollar assets
  • DBA lead in converting interface from VAR to in-house grid saving 1,000,000 a year
  • DBA lead in migrating DB from old servers to newer servers saving 800,000 a year
  • Debug and optimize db, schedule shell script to bring down of production incidents ten-fold
  • Mentor 8 new-hire ETL developers, production support personnel and dba's
  • Responsible 24/7 for 4 Prod, 4 QA, 8 Dev databases for initial 3 years meeting all SLA's
  • Create logical, physical, DDL, backups, tuning, replication, DR, monitoring and maintenance
  • Maintain MS SQL Server using Enterprise Manager and Sybase Client

Confidential

Database Administrator

  • Develop Data warehouse for multi-million dollar international Sales database
  • Create model and design and ETL load scripts with PL/SQL, Unix shell scripts, TOAD

Confidential

Oracle DBA/Architect Contractor

  • Create a database for county's 200,000 land parcels and all land records
  • Automate land document retrieval system allowing fee income of 200,000/year
  • Create web served Forms and for county employees to department standards
  • Create logical models, physical designs and mappings for 5 OLTP data warehouse db's
  • Create, tune, debug, maintain and migrate backups, users, applications and security
  • Install, patch, maintain and migrate 8i to 9i db and OAS to IAS web servers and apps

Confidential

Oracle DBA Contractor

  • Construct Costa Rica's first automated voter registration's OLTP database
  • Construct and tune database interface to handle 1000's of simultaneous DML connections
  • Database administration of users and applications, installation, tuning and optimization

Confidential

Oracle Data Warehouse Designer, DBA Analyst Contractor

  • Create company's Sales Data Warehouse handling 5.7 billion/year and 500 affiliates
  • Lead in major segments of requirement derivation, data modeling, designing and ETL
  • Interfaced with Business Analyst Department and International data suppliers
  • Monitored Prod system and reports supporting 600 end users, and trained operators

SYSTEMS AND Languages

Databases:

Oracle 11g/10g/9i/8, SQL Server

Operating System:

HP-Unix, DEC-ALPHA Unix servers, Sun, Linux, AIX, Windows

Database: ModelingTools:

Erwin, Oracle Designer, Oracle Warehouse Builder

Database Backup Tools:

Rman, Export/Import, HP Omni

Tuning Tools:

AWR/Statspack, ADDM, TKPRF/Trace Analyzer, OEM, metalink, SQL Loader

Database Dev Tools:

Toad, Sql Developer, Oracle Form Reports

Database Loading: :Tools:

Informatica, Oracle Loader, Autosys

Computer Languages:

SQL, PL/SQL, Korn, Perl, C, C , C , Pro C, XML, Java, ODBC, RPC

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship