SUMMARY

• Systems Engineer - Database Administration & Disaster RecoveryExperience in Capital Markets, Financial, Legal, & Telecommunications
• Enterprise Architecture, Disaster Recovery, Database Administration, Software Development.
• A proven track record managing resources to advance the needs of the enterprise.
• Director of Information Technology, Law Firm, 9 years.
• Database Administrator, Financial, Legal & Telecommunications Industries, 7 years.
• Database Programmer, Telecommunications Industry, 6 years.
• Systems Engineer, Enterprise Storage / Backup Industry, 4 years.
• Software Development Team Leader, Financial Industry, 1 year.

TECHNICAL SKILLS

Software: MS Server 2003 - 2012, Active Directory 2003 – 2012, MS Exchange 2003 – 2010 MS SQL Server 2000, 2005, 2008, DNS, DHCP, Interwoven, Desksite, WorksiteUnix, Solaris, HP/UX, AIX, SVR4, OS X ksh, perl, sed, awk, C, curses, SQL, ESQL/C, 4GL CommVault Galaxy, Informix, Oracle, Sybase, MS Office, Visio, Open Office, Stella Knowledge of Big Data, SAP HANA, ISO 27001, Sans Top 20, ITIL, Six SigmaSQL Server 2012, Windows 2012, MySQL 5.6, MySQL Workbench 6.1, Hyper-V, VMWareAvamar, Zantaz, LanDesk, Linux, IBM DB2/UDB, Illustra and Object Relational DatabasesEncase, Wireshark, C++, Objective C, Perl, Java, Python, DB Networks, Azure, AWS.

Hardware: PC’s, Apple Macs, Dell, HP & Sun servers, Watchguard, iPhone, Android, Blackberry.

PROFESSIONAL EXPERIENCE

Consultant

Confidential

Responsibilities:

• As DBA, maintained the accounting and other databases, implemented MS SQL maintenance plans and tuned the physical structures of database and log files for optimal performance.
• As E-Mail Administrator, maintained Exchange and Blackberry servers, integrated iOS devices.
• As Security Administrator, performed annual risk assessments, defined security protocols in compliance with ISO 27001: 2013, managed anti-malware systems, the firewall, VPN and remote access policies.
• Negotiated telecommunications contracts and implemented new circuits which increased SLAs and cut costs from over $95,000 in 2007 to under $38,000 in 2013.
• In 2014 migrated the accounting system from physical servers to virtual servers in “the Cloud.”
• In 2014 migrated the desktop infrastructure from Windows XP to Windows 7, OS X and Linux.
• In 2011 developed a Server Virtualization plan to migrate the firm's physical servers into a high availability virtualized environment using Server 2008 R2, Exchange 2007, and SQL Server 2008 R2.
• In 2009 developed a Disaster Recovery plan that would give the firm a Restore Point Objective, RPO, of 15 minutes, a Restore Time Objective, RTO, of 2 hours.
• In 2005, upgraded the firm's technology infrastructure, including all servers, workstations, routers, firewalls and software. Spent $485,000, approximately 7.62% below budget.
• Designed and implemented a backup and disaster recovery plan for Cleary Gottleib, a law firm in New York City, which allowed the firm to resume operations in their midtown location on Sept. 12, 2001, despite the loss of access to their Liberty Street offices and data center on Sept. 11, 2001.
• Played a significant role in support of DLJ Investment Banking, a customer and major investor.
• Executed the vendor test suite to certify our product with Informix 9.x UDB.

Database Tuning Engineer

Confidential

Responsibilities:

• Improved efficiency and throughput by performance tuning of the data warehouse.
• Typical queries completed in less than 10 seconds rather than 8 to 12 minutes.
• Backups and other overnight processing time was cut from 8 to 12 hours to less than 2 hours
• Moved the transaction logs from the root dbspace to separate physical disks.
• Increased the logical log size from 3 MB to 50 MB and decreased the number from 60 to 3.
• Increased the physical log size from 50 MB to 100 MB and number from 2 to 3.
• Increased the size and number of buffers and page cleaners
• Reconfigured table and extent sizes, allocating more space per extent, resulting in fewer and larger extents and defragmented tablespaces.
• Configured automatic rebuild of clustered indices to occur at regular time intervals.
• Database Administrator on a portfolio valuation database in Sybase at Fuji Capital Markets, '94 - '95.
• Guaranteed the availability and integrity of portfolio management valuation in New York, London, and Hong Kong.
• Designed, developed and tested backup and restore scripts on a quarterly basis.
• Designed a system to quickly and efficiently verify overnight processing. When implemented:
• Time required to verify overnight processing was cut from 90 minutes to less than 10 minutes.
• Expensive database administration resources were freed for other work.

Team Leader

Confidential

Responsibilities:

• Built a team, quickly and efficiently, to develop a database management system for clearing physical paper covering fixed income securities. The application was implemented using SQL, C, and ProC in Oracle on SCO Unix.
• Reviewed design specifications with developers.
• Interviewed and hired programmers at all levels.
• Mentored junior programmers on the design specs, make, sccs, and the curses library.
• Responsible for interfacing fax, email and databases at the EasyLink Services Lab. Worked in E/SQL C
• Responsible for the design and implementation of several generations of a database application used for lean production in a service environment to guarantee that people were paid the right amount on-time.
• Designed and implemented 2-phase commit algorithms to replicate transactions in different databases.