Senior Database Administrator Resume Washington - Hire IT People

SUMMARY

To obtain a long - term database administration position that will utilize my knowledge and experience on database administration, data warehouse administration and application development
More than 10 years of proven development record to succeed in all endeavors from high traffic on-line transaction processing (OLTP) database to 30 terabyte on-line transaction processing (OLAP) data warehouse on UNIX platforms
More than 10 year experience with high accomplishment on database and data warehouse administration, database design, data warehousing and performance optimization in Oracle, Informix, MySQL, DB2 UDB and SQL Server.
Extensive experience on object oriented (Java), procedure (C) and scripting (Shell/Perl) programming

PROFESSIONAL EXPERIENCE

Confidential, Washington

Senior Database Administrator

Responsibilities:

Provide Oracle 9i/10g/11g/11gR2 production database administration services that ensure 100% database availability
Conduct user, space, backup management as well as restore on need base
Lead the project of database replication and implement GoldenGate replication with success that replaces physical standby database and materialized views
Play a primary in writing and enhance monitoring shell/perl script tools of RMAN backup, database health monitoring and database replication
Successfully setup and support Oracle Internet Directory (Oracle LDAP) 10
Support and tune oracle database replication tools Shareplex in oracle active-active environment
Successfully upgrade/migrate Oracle database from 9i/10g on Solaris and to 11g on AIX
Provide database logical design, space management and application/SQL performance tuning services in Oracle 8i, 9i, 10g and 11g environment
Design, implement and migrate Perccona MySQL databases from local system to virtualization and cloud computing environment of Amazon Web Service environment
Design and implement database environment to resolve MySQL query performance issue and replication lags
Write shell scripts to utilize Percona applications and toolkits to backup and monitoring multiple MySQL databases
Recommend and force database change procedure to minimize database modification procedure and ensure 100% availability of MySQL database
Write wrapper shell scripts of Percona database monitoring, modification and backup tools to conduct database monitoring, modification and backup to ensure database consistency and high availability
Support enterprise databases of DB2 UDB 9.x and SQL Server 2005 thru 2012

Confidential, Arizona

Senior Database Administrator

Responsibilities:

Provide primary Informix database administration services. Install and configure Informix IDS 10 and 11 database client and server; Upgrade Informix IDS database from version 10 to 11.50; Make schema change and user management; Conduct database space management; Backup and restore database using onbar; Perform tuning and continuous data replication (CDR)
Administrate Oracle 9i/10g/11g databases. Install and configure Oracle 9i/10g/11g database with Data Guard on Linux, AIX and HP-UX; Backup and Recovery using RMAN; Apply patches; Conduct database/SQL tuning and capacity planning; Clone schema using data pump; Install and configure Oracle Grid Control 10g and 11g
Lead effort of DB2 Connect pilot. Install, configure and maintain DB2 Connect on AIX 5.3 to allow access to federated Informix data source for DB2 clients on Windows, AIX and z/OS
Work with development team to troubleshoot and enhance data warehousing applications on a 35 Terabyte Informix XPS data warehouse
Provide web application administration support of IBM WebSphere 5/6 on AIX 5.3
Create, manage and support Microsoft SQL Server 2005 databases

Senior Programmer Analyst

Confidential

Responsibilities:

Single-handedly design and develop a set of Perl/Java/Shell scripts high-performance data integration tools for a 35 Terabytes data warehouse running on Informix XPS and HP-UX. The applications extract, transform and load (ETL) data from OLTP database, fix length files and delimited flat files to data warehouse
Lead design and implementation of Ascential DataStage ETL application to extract, transform and load credit card transaction data from database and file systems to database systems
Develop Java/J2EE ecommerce products which interact with an Informix database that allows the display and modification of data to the end user; Implement the application using Apache STRUTS, JSP, Servlet and JDBC
Designed and implemented Java Applet/Application to allow users interacting with company core systems
Created shell scripts ETL application to synchronize databases of company core systems
Successfully ported company core application of C++/HP-UX from 32-bit platform to 64-bit system

We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

WashingtoN

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship