PROFESSIONAL EXPERIENCE

Confidential

Contract Database Administrator

• The ISM department at IBM hosts 'shared' and 'dedicated' instances of Maximo for dozens of customers. Support includes setup, customization, management, and support of both the shared and dedicated database installations at IBM and customer hosting environments.
• Support 10 - 15 dedicated Maximo 6.x and 7.x database installations for several large commercial and municipal accounts using DB2 V9.5 and V9.7
• Support production, UAT, and DEV environments.
• Responsible for performance analysis and optimization of database.
• Support includes: data loads, schema updates, application implementation, Qrep replication setup and troubleshooting, backup/restore, performance analysis and tuning.
• Responsible for database implementation of IBM's Global Dispatch Maximo installation on P7 hardware. Instance is used to host over 20K users and includes Qrep for reporting instances, as well as HADR for HA.
• Tasked with knowledge transfer and training of new team members.
• Implemented Optim Archiving tool to assist in data archiving and pruning.

Confidential

Senior Database Administrator

Confidential Group Interactive is the online subsidiary of Media News Group and is responsible for all online content for over 100 daily and specialty newspapers, such as The Denver Post, Confidential

• Served as Production and Development DBA for blog and CMS application databases using DB2 v8/9, MySQL v5, and MS SQL server 2008.
• Tasks included logical design, stored procedure writing, performance tuning, and disaster recovery.
• Supported approximately 10 MySQL databases used as back-end to newspaper site blogs.
• Mysql environment was v5 clustered on RHEL 5 with approximately 500 gigs of data.
• Created multiple stored procedures to summarize large tables used for environment performance monitoring.
• Responsible for the management, tuning, maintenance, and expansion of the main production DB2 databases, which contain all online content for over 100 online papers, journals, and magazines.
• Responsible for all DB2 database migrations from v 9.1 to v9.5 and to 9.7.
• Responsible for Knowledge transfer and cross training of DBA peer on DB2 and Mysql.
• Jointly responsible for internal corporate MS SQL 2000/2005/2008 Enterprise Edition databases used for HR and accounting. Databases are data repositories for the J.D Edwards application.

Confidential

Contract Development Database Administrator

• IBM Global Service provides database support services to external 'commercial' accounts as well as internal departments and organizations throughout IBM global organization.
• Assisted in logical and physical database design and implementation on multiple database platforms including MySQL v4/5, DB2 v8/9, and DB2 on Z/OS.
• Assigned to support DEV, TEST, and USER ACCEPTANCE environments for major health insurance provider, environments included Mysql and DB2 v8/9.
• Assigned as primary DBA on project to implement the first DB2 HADR installation in our environment. HADR configured database to be used to support Websphere Process Server databases.
• Worked with testing group to prove HADR in test environment, and refine the HADR installation Cookbook prior to production implementation.
• Worked on a 25 - 30 member team of database administrators
• Responsible for all change control and problem ticket creation and resolution for assigned databases.
• Worked closely with Application Developers, Project Managers, and Customer Representatives to ensure 24 by 7 database and application availability and customer satisfaction.

Confidential

Senior Development/Production Database Administrator

• Card Commerce International provides value added services to the financial industry. It processes over 350 million credit card transactions per month, providing Risk Analysis and transaction matching services to large merchant banks, and loyalty service providers.
• Responsible for multiple DB2 production databases, and several internal application Mysql v4 and Postgresql databases.
• Lead initiative to migrate production database from DB2 for AS/400 to a DB2 UDB v.8 database environment on Linux.
• Debugged and implemented stored procedures in support of customer database application initiatives.
• Worked with developers on implementing database designs and objects, as well as change control.
• Developed company technical operations manual, which addressed all areas of network, database, user, software, and system security procedures and practices.
• Developed and documented corporate data security procedures, incident response, disaster recovery, and backup strategy plans.

Confidential

• IT Consultant Confidential Associates is a private IT consulting company that provides IT services to small chemical distributors. Services included general corporate network administration, specialized software implementation, and consulting.
• Maintained client's CRM SalesLogix using MS SQL server 7 on the backend.
• Developed methods to sync data between AS/400 DB2 and MS SQL server.
• Setup and administered Windows NT 4.0 and Windows 2000 based networks.
• Responsible for programming customizations to SalesLogix CRM allowing for product integration with existing AS/400.

Independent IT Consultant

Confidential

• Setup and administered several small business networks using Linux/Samba and Windows Operating Systems.
• Configured Unix Systems for T1 and DSL Internet connectivity with IP Masquerading, Ipchains firewalling, Sendmail, FTP, DNS, Apache, OpenSSH, IMAP, and other protocols.
• Performed remote and onsite administration, log monitoring, and backup, using various UNIX tools.

GENERAL SKILLS

• Database: Expert level proficiency in performance monitoring and tuning of DB2 ESE v.6, v.7,v.8, v9.1, v9.5, v9.7 installations. MySQL and Postgresql installation and management. Relational data modeling theory and techniques. Installation, migration and configuration, physical and logical database design of multiple Database and server platforms. Multi and single node parallel database configuration, user management, security, stored procedures, XML Extender, replication, backup and recovery. Microsoft SQL Sever administration proficiency.
• OS: Setup and configuration of AIX 4/5 and multiple Linux distributions. Working knowledge and proficiency in Microsoft domain networks. Microsoft server and workstation proficiency. Working knowledge of Solaris and various flavors of BSD, IBM OS/4000.
• Networking: Most common networking protocols, Network and System security theory and implementation, TCP/IP, Frame relay, 3DES IPSEC, routing, HSRP, DS3, T1, ISDN, IP Global/Static NAT.