Database Administration Resume Profile
SUMMARY
Experienced DBA with strong communication skills and a varied skill set in mainframe and distributed technologies. Quickly adapts to rapidly changing situations. Able to effectively manage multiple, highly visible projects while successfully meeting targeted timelines. Related areas of expertise are:
- ADABAS/Natural
- Replication
- MS SQL Server
- DB2
- Project management
- Change management
- Incident management
PROFESSIONAL EXPERIENCE
Confidential
Performed installation, maintenance and production database support for ADABAS upgraded ADABAS replicator software in support of mainframe-to-distributed replication. Performed production database support for a variety of MS SQL Server-based applications. Installed, customized and upgraded SQL Server. Established mirroring and log shipping where required. Recently received Learning Tree training towards SQL Server DBA Certified Professional certificate, including classes covering MS SQL Server and Windows Server 2008. Provided 24x7 on-call support for ADABAS/Natural, MS SQL Server and Sybase platforms as part of an on-call rotation.
Confidential
Consultant Database Administration
In support of the Lehman Brothers wind-down at Barclays Capital, provided data to accounting entities. Data sources included ADABAS, DB2 and Sybase. Also documented processes by which data could be extracted from database backups at minimal cost. Provided off-hour on-call support for the trading application. Applied software fixes when necessary.
Confidential
- Managed the mainframe disaster recovery team. Committed to all aspects of system recovery. Planned, executed and documented three tests per year. Annual department budget of 5 million. Gave management presentations on present configurations and future directions. Provided proof of results to internal and external audit teams. Coordinated efforts with the firm's business continuity team. Additional responsibilities included a wide variety of infrastructure projects, including operating system upgrade coordination, telecommunications configuration improvements and data center migration.
- Coordinated testing with 43 application teams that ensured that tests were conducted properly and in 100 compliance with audit requirements.
Confidential
- Liaised with business users, providing them with test objectives, scope of test, support during testing, problem determination and resolution, issue tracking, and post test follow-ups, root cause analysis and post mortems.
- Implemented auto-callout software Communicator NxT that uses web- and phone-based activation to notify IT stakeholders of a mainframe emergency declaration. Also created procedural documentation and directed the creation of conference bridges as part of the methodology. Performed testing of this process, successfully reaching 20 key individuals, including senior vice presidents and managing directors, within 12 minutes of activation.
- Managed key aspects of the Firm's mainframe outsourcing switch from one major international service provider to another. This migration resulted in savings of 25 million in the first year of the contract, as well as vast improvements in system availability, stability and recoverability. The migration was completed in six months, well ahead of the vendor's original projection of 12 months to completion.
- Arranged for distributed database management system DBMS availability at the disaster recovery facility to allow more thorough testing of mainframe applications that access data remotely.
- Acted as liaison between mainframe services and a variety of technology areas to ensure coordination of change implementations.
Confidential
- Performed production database support, with responsibilities for DB2 systems, DB2 applications, mainframe-to-distributed replication, and ADABAS/Natural environments.
- Performed SMP/E software upgrades as part of the DB2 version 6 upgrade
- Improved methodology of software upgrades by organizing the SMP/E environment
- Coordinated implementation of WLM-managed stored procedures, positioning the DB2 environment for successful upgrade to DB2 version 6. Coordination included advising user community, technical research, and policy development.
- Established, coordinated and chaired regular DB2 team roundtable discussions between DB2 system team and DB2 application support team to improve team communication and maintain focus on important projects
Confidential
- Managed a team of 4 DBAs supporting a highly available, highly critical international securities trading platform with a global development community located in UK, Tokyo, India, Hong Kong and US.
- Acted as the database team's resource coordination and project planning focal of the European Monitory Union EMU currency implementation. Traveled to the firm's offices in UK five times over six months to work closely with the London-based IT staff, including the 12/31/98 1/1/99 overnight go-live of the EMU. Leadership role in this project resulted in promotion to vice president.
- Successfully led team's Y2K preparedness efforts, ensuring a smooth transition into the year 2000. This included resource coordination as well as project planning and tracking.