Senior Database Administrator Resume Austin, TX - Hire IT People

SUMMARY

IT professional with over 14 years of experience in database design and administration, project development, and business intelligence solutions.
Skilled in quickly mastering new technologies, software products, and industries.
Experienced in complete application development including planning, design, implementation, testing, deployment, and end - user support. Enjoys finding solutions to “impossible” problems.
Highly regarded by end-users for addressing problems on a non-technical level. Very strong SQL background, specializing in performance, data warehousing and client support.

TECHNICAL SKILLS

SQL, pg/PLSQL, and Transact-SQL
Microsoft SQL Server 7.0 and 2000
PostgreSQL
Database Administration
Data modeling, Data warehousing, and OLAP techniques
Linux (Gentoo, Ubuntu, and Red Hat Enterprise with 2.4 and 2.6 kernels, both 32- and 64-bit versions)
Perl and Python
SAS
Business Objects reporting tools
Data Stage ETL tools
Clarion database RAD tools
IBM DB2 and AS/400
Apache 1.3 and Apache 2

PROFESSIONAL EXPERIENCE

Confidential - Austin, TX

Senior Database Administrator

Responsibilities:

Extensive work with PostgreSQL databases running on Intel and AMD Red Hat Linux servers in all environments from development to production. Provided support on a 24-hour on-call basis.
Developed and implemented log shipping-style “warm” replication from primary site to multiple secondary sites in order to minimize downtime in case of failure of primary site databases.
Massive optimization campaign of existing application queries and application logic resulting in more than an order of magnitude in performance gains. Configured and deployed 64-bit AMD Opteron servers to provide additional performance. Many improvements made to take advantage of PostgreSQL-specific internals.
Proven track record for troubleshooting production problems across all areas of expertise.
Trained and supervised additional database administration staff.

Confidential - Wilmington, DE

Senior Database Analyst

Responsibilities:

Responsible for all Microsoft SQL Server 2000 servers in the Data Coordination Center (DCC). Performed all database administration tasks on these servers including design, data loading, backup, performance tuning, security management and basic server maintenance.
Created a set of tools in Data Transformation Services and SQL to scrub data from disparate sources and convert to a standard format suitable for end-user analysis.
Designed the Data Definition Plan (DDP)—a standard set of forms for analysts to complete in which to get a limited data set from the DCC databases for further analysis.

Confidential - Wilmington, DE

Data Acquisition Developer

Responsibilities:

Responsible for data acquisition and business intelligence for Data Management department.
Evaluated and implemented software solutions for ETL (data movement), complex query and analysis, and data access/reporting.
Coordinated with off-site personnel to maintain remote servers for Data Stage, Business Objects, and SAS (via Windows NT Terminal Server).
Designed and implemented reports using Business Objects running out of a MS-SQL Server data repository.
Assisted the Database Administrator in maintaining Microsoft SQL Server 7.0 and IBM DB2 databases.
Conducted internal SAS training classes and coordinated the deployment of the web-based version of Business Objects.

Confidential - Athens, GA

Information Specialist

Responsibilities:

Designed, implemented, and administered databases for production data for poultry processing plants. Databases were stored using a Clarion/TopSpeed proprietary format.
Converted an MS-Access operational system for collecting and reporting production data for poultry plants.
Implemented an automated ETL interface between operational system and ABC Technologies’ Oros activity-based costing software.
Assisted in the design and implementation of cost models.
Created Oros OLAP multidimensional databases and reports for use with Cognos tools.
Implemented and administered a Citrix WinFrame terminal server for operational and cost model systems.
Designed and deployed reports on operational and cost model data.

Confidential - Athens, GA

Computer Services Specialist

Responsibilities:

Designed, implemented, and administered MS-DOS and Windows-based database systems for various departmental needs. Databases were stored using a Clarion/TopSpeed proprietary format. Also maintained hardware and software on departmental network
Duties ranged from maintaining a homegrown accounting and budgeting package to repairing and installing PC hardware.

Confidential - Athens, GA

Programmer II/III

Responsibilities:

Created and maintained programs on IBM Mainframe systems using SQL, IMS, Mark IV and NATURAL over DB2 and IMS databases.