PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential

Responsibilities:

• Supported DB2 LUW 9.5 and 10.5 at the Confidential .
• Provided support for the process to upgrade DB2 LUW to 10.5, including developing and testing the upgrade process, providing database support for customers and colleagues pertaining to upgrade, and providing supporting documentation.
• Backed up and restored DB2 databases as directed.
• Troubleshooted problems with DB2 databases and implemented solutions.
• Evaluated and provided integration support for tools to provide monitoring, operation, and performance support for DB2 LUW, including Confidential Performance Manager and SolarWinds.
• Wrote and modified scripts to support DB2 database administration.
• Wrote documentation to support DB2 database administration.

Database Engineer

Confidential

Responsibilities:

• Supported DB2 LUW 9.7 and 10.1 as a product at Confidential .
• Created build specifications for DB2 LUW environments, taking into account database usage, processing capacity, storage capacity both volatile and otherwise, and other factors.
• Diagnosed functional, operational, and performance problems with DB2 LUW and gave advice accordingly.
• Engineered and oversaw software and processes pertaining to Database Controls, using Guardium, DB2 LUW, Unix shell scripting and other tools.
• Developed queries, reports, custom tables, custom domains, and other Guardium objects. Developed Unix shell scripts.
• Monitored database activity for privileged users using a SQL Server platform with input from Guardium reports and other sources.
• Author requirement specifications, solution specifications, standard operating procedures, and other documentation for Database controls and for other purposes.
• Tested database traffic capture for Hadoop using Guardium and using native auditing.

Database Administrator

Confidential

Responsibilities:

• Oversaw the migration of DB2 LUW database environments, versions 9.1 and 9.5 and 9.7 from a data center.
• Wrote a migration guide and checklist for DB2 environments and followed the checklist for the replication migration and for the production migration.
• Troubleshot issues with replicated environments before the go live in Georgia and with production environments after the go live in Georgia.
• Wrote a DB2 database inventory and a Disaster Recovery checklist for each DB2 environment and maintained them in source control, and performed the DB2 tasks for the first in - house disaster recovery exercise, following the checklist.
• Wrote maintenance and monitoring Unix shell scripts for DB2 databases.
• Maintained DB2 environments on an ongoing basis, including periodically inspecting operational logs.

Private Database Developer

Confidential

Responsibilities:

• Conceived, defined and refined language and method to develop applications using normalized algorithms and processes, breaking complex routines down into simple units of processing that relate to other units of processing the way data relate to other data in relational databases.

Database Administrator

Confidential, McLean, VA

Responsibilities:

• Provided technical support for DB2 UDB Version 8 distributed databases, production and nonproduction, used by in-house and third-party applications, during normal operation and during installs and upgrades, mostly single partition, some multiple partition.
• Monitored UDB databases for events that might affect operation or performance, routinely and in response to outstanding issues.
• Deployed and troubleshot scripts composed by data analysts to create and modify data objects, in accordance with a change control process using Remedy and Clearcase.
• Tuned the performance of databases by analyzing query performance, by optimizing the number and composition of indexes, by tuning instance and database configuration parameters, and by REORGing tables and updating table statistics.
• Used and maintained standard operating procedures for creating and maintaining DB2 UDB databases and instances and for upgrading DB2 UDB for particular instances.
• Created and maintained Unix/AIX scripts to automate certain database deployment and maintenance tasks, including to reassert user and group permissions and to monitor databases.

Database Administrator

Confidential, Reston, VA

Responsibilities:

• Installed DB2 version 7 and 8 on many servers and clients, both AIX and Windows; created, configured and tested databases on multiple instances, ensuring connectivity among clients and servers.
• Debugged and maintained installation scripts and database/data object creation scripts.
• Diagnosed and solved operational problems with DB2 at instance and database levels.
• Troubleshooted issues with applications using DB2, whether the problem was with DB2 or the application, including SAP.
• Provided technical advice regarding database performance, application development and database object definitions.

Database Consultant

Confidential , Fairfax, VA

Responsibilities:

• Provided on-site DB2 UDB Version 7 database conversion service and advice to client.
• Installed DB2 UDB ESE onto Sun Solaris and Windows 2000 and configured it for network access.
• Helped convert tables and indexes to DB2 using ERWin.
• Converted table spaces (with new bufferpools), triggers, stored procedures, grant privilege statements and insert statements to DB2.
• Converted Unix (Korn shell on Solaris) database installation scripts for Oracle to work with DB2 data definition and insertion statements using DB2's interactive prompt.
• Wrote supplementary DB2 documentation for installation and configuration.
• Offered DB2 advice to client as requested.

Database Consultant

Confidential

Responsibilities:

• Provided DB2 Database consulting services to Confidential business partners and customers, including development and database administration.
• Performed database conversions to DB2, mostly from Oracle, including tables, indexes, triggers, user-defined functions and stored procedures.
• Troubleshooted installation and operation of DB2 at client sites.
• Assisted clients in converting Java applications to use DB2.
• Wrote DB2 supplemental documentation for internal use and for client use.
• Provided technical advice to clients and to colleagues.

Database Developer

Confidential, Herndon, VA

Responsibilities:

• Performed application development for Confidential 's Web Banking product.
• Wrote design specifications detailing database changes and program behavior.
• Implemented designs using C and embedded DB2/SQL.
• Unit-tested changes using Netscape Navigator as necessary.
• Provided development and user support for bill payment applications in Powerbuilder, including for billing and for exception processing.
• Troubleshooted defects reported by testers and end users, including code fixes as neccessary.
• Provided cross-training to developers assigned to the financial institution simulation module.