SUMMARY:

• Expert Database Administrator with 25+ years of computing experience. Extensive expertise in DBA Administration, UNIX shell scripting and automation of DBA processes. Leader and problem - solver skilled in conceptualizing, developing and implementing projects. Excellent communication, customer service and interpersonal skills. Strong independent initiator and team player. Willing to travel and/or relocate.
• Setup and configured GoldenGate.
• Replication from Oracle to Confidential - Single Direction
• Replication from Oracle to Oracle - Bi-Directional
• Setup and configured a failover environments using Confidential ASE 15 / 15 .5 / 15.7 using Replication 15 / 15 .5 / 15.7. Replicating from Primary to Secondary to DR server using MSA or Warm Standby.
• Installing and Maintenance on Vertica Databases Environments
• Versions 4.x, 5.x, 6.x, 7.x
• Installing and Maintenance on MongoDB Environments
• Setup and configured OpenSwitch 15 for seamless failover of Confidential from PROD to DR
• Worked with SOX compliance requests and retrofitted older servers to be SOX Compliant for Confidential Servers.
• Created standard Confidential install scripts to be used by all DBA’s within group to enforce company standards and consistency when creating new servers.
• Currently working in a Confidential Standard’s group within the Company to improve the Confidential environments and the migration of all old server environments to use the new standards set up by this group.
• Developed a errorlog script to find all relevant errors and send alerts for:
• Confidential
• Golden Gate
• Vertica
• Launched Confidential . in 2001 and developed a strong relationship with key clients, Confidential, Citi Group.
• Saved Confidential $1+ million through the elimination of SQL Backtrack by designing and installing unix scripts that use Confidential Data Compression & Stripes for database backups & restores.
• Designed, developed and installed a web based application for the 20+ Confidential DBAs to do database backup and/or restores on the same unix server and across other unix servers with security.
• Set up Confidential 15.0 Redundant License server, which has 3 unix servers for failover.
• Recognized for expertise in the installation of Confidential ASE, Replication Server, Control-SA, Control-M, Confidential 15 License Server and Administration tools.

TECHNICAL SKILLS:DBA Experience: 20 years

Operating Systems: UNIX, SunOS, Linux Redhat, AIX, HP-UX, NCR 25 years Windows XP, NT, Vista 25 years

Programming Languages: Strong UNIX Shell Scripts (sh, ksh, csh) 23 years HTML 7 years

Software: Confidential ASE 25 years, Version 12.5.x / 15.x / 15.5 / 15.7 / 15.7.1 ,  Confidential OpenSwitch, Version 15.0.1 1 years, Confidential Replication 11 years, Version 12.5 / 12.6 / 15.0. x / 15.5 / 15.6 / 15.7 ,  Confidential IQ 15.x / 16.x 3 years, Microsoft Sql Server 2005/2008/R2/2012 6 years, DB Artisan 15 years, Oracle GoldenGate 3 years, Vertica Database by HP 5.x, 6.x, 7.x 5 years, Mongo DB 2.x 6 months, Cassandra 6 months, Surveillance DB by Bradmark 4 years

Software Other:  Remedy DBA Administration 5 years, SQL Backtrack 10 years, Lawson Financials 2 years, Control-M DBA Administration 7 years, Control-SA DBA Administration 1 year

PROFESSIONAL EXPERIENCE:

Confidential, Texas

Sr. DBA Consultant

Responsibilities:

• Working with and installing Oracle GoldenGate between Oracle and Confidential .

• Written monitoring script for GoldenGate to monitor connection status and lag times for the connections on the source and replicated servers.
• Working on Vertica Database Environments.
• Hardware migrations
• Setting up New Servers and Builds
• Adding additional Nodes to the cluster
• VBR DR sync, keeping PROD and DR servers in sync using VBR
• VBR backups to SAN Disk
• Setting up Monitoring of Database Environment
• Working with MongoDB Database Environments.
• Lead initiatives to automate manual processes, saving the client time and money, examples include:
• Worked on a project that used Confidential ASE 15.0, Openswitch 15.0 and Confidential Replication 15.6. This project was a failover environment without VCS and also used a DR server. The environment used replication from a Primary server to a Secondary server to keep the data in-sync and used openswitch to move the user connections from primary to secondary servers to DR if necessary. The Production data was also replicated to the DR server at another site.
• Worked on and implemented auditing on servers to track user activity. Setup thresholds to archive the audit data into audit archive database.
• New System builds and upgrade from 12.5.4 to Confidential 15.0.3,15.5 and 15.7 for all environments.
• New System builds and upgrade from 12.5.4 to Confidential Replication 15.0.3,15.5 and 15.7 for all environments.
• Doing Upgrades for cross Platform Upgrades and migrations for Confidential ASE Servers.
• Upgrade Confidential Replication servers to 15.6 and 15.7.
• Working with AD teams, developers and support teams.
• Support for Production support servers and being Oncall
• Installed Confidential Tivoli agent on all PROD and DR servers for Monitoring of Confidential and errorlog files for ASE Server, Backup Server and Replication Server.
• Installed and configured Nagios to send alerts from Confidential Servers (ASE and Replication)
• Setup and worked with MDA Tables in Confidential 15.x servers.
• Working on Microsoft SQL Server 2005, 2008, 2008 R2 and 2012, add log shipping, server mirroring and general Maintenance.
• Working on Vertica database as DBA, admin and doing Installs and trouble shooting on Vertica.
• Installing, setup and configured Surveillance DB Monitoring by Bradmark within our group.
• Perform necessary maintenance and updates, including:
• Oversee maintenance and working on 95 production servers, 95 DR Servers, 93 UAT, development servers and 21 replication servers.
• Perform daily Confidential DBA maintenance work, including dbcc’s, statistics, database backups, new installs & server upgrades.
• Setup of Replication from Confidential to Oracle using Confidential Replication and DCO connections.
• Table level replication
• MSA level replication
• Helped with database design, performance monitoring and tuning, capacity planning, database backup and recovery and Unix shell scripting.
• Worked with Power Designer to re-engineer the databases to get database schema’s

Confidential, Tarpon Springs, Florida 

Sr. DBA Consultant

Responsibilities:

• Perform as Confidential Development and Production DBA for a number of Servers, also a Confidential DBA for 3rd-party software, such as Remedy, Control-M, Control-SA and Junior Unix SA.

Confidential, Jacksonville, Florida

Responsibilities:

• Worked on a 4 month conversion project for this client. We had to convert from Confidential 11.9.2 to

• Confidential 15.0.1 and a cross platform migration from HP Unix to Linux running Redhat Enterprise.
• Setup and configuration of new Linux Confidential ASE Servers 15.0.2
• Setup of conversion scripts for cross platform migration.
• Setup of Confidential SYSAM 2 license server.

Confidential, Oldsmar, Florida

Responsibilities:

• Lead initiatives to automate manual processes, saving the client time and money, examples include:

• Installed a warm standby system for Remedy using Confidential 12.5.3 and Confidential Replication 12.6, giving the system near continuous availability using shell scripts to do the switch from third server.
• Installed a warm standby system for Control-M using Confidential 12.5.4 and Confidential Replication 12.6, also to enable near continuous availability using shell scripts to do the switch from third server.
• Create a report web site that Control-M users can execute static reports based apon certain options being selected by the users.
• Increase security measures for the client, including:
• Converted DBA & Web scripts from using “rsh” & “rcp” over to “scp” & “ssh,” creating shared public keys.
• Perform necessary maintenance and updates, including:
• Oversee maintenance on 9 production servers, 30 development servers and 2 replication servers.
• Update all Confidential License Keys for Confidential 15 & Power Designer 12.0.
• Perform daily Confidential DBA maintenance work, including dbcc’s, statistics & server upgrades.

Confidential, Tampa, Florida

Sr. Confidential DBA Consultant

Responsibilities:

• Served as Confidential Development and Production DBA and Junior Unix SA.

Confidential, Oldsmar, Florida

Responsibilities:

• Took the initiative to write the shell scripts necessary to eliminate SQL Backtrack once Confidential 12.5 arrived, saving the client millions in maintenance fees and eliminating over 100 SQL Backtrack servers.

• Managed 10 production Confidential servers & 7 development Confidential servers sized from 20 Mb to 32 GB.
• Designed and wrote scripts to collect a wide range of information, including database size, number of users and space usage per server.
• Created installation scripts for the installation of Confidential software and for client stored procedures.

Confidential, Parsippany, New Jersey 

Sr. Confidential DBA

Responsibilities:

• Installed, maintained and monitored Confidential servers; provided client support and upgraded servers.

Confidential, Newark, New Jersey

Responsibilities:

• Oversaw 5 production Confidential servers & 3 development Confidential servers ranging from 87 Mb to 58 GB.

• Supported clients through move from SUN Unix platform to HP-UX Unix platform.
• Assisted in data conversion from Confidential to Oracle after the company transitioned databases.

Confidential, White Plains, New York

Responsibilities:

• Oversaw all DBA functions for Confidential System 11 databases, Confidential SQL Server and Replication Server, including upgrades, troubleshooting and performance tuning.

• Managed 4 Confidential databases across 3 servers on Sun Solaris and Windows NT platforms.
• Tuned the performance of Confidential System 10 & 11 databases using Data Caching, segments, changing indexes, fill factor SQL queries and table partitioning.

Confidential, Atlanta, Georgia

Sr. Confidential DBA

Responsibilities:

• Handled all aspects of Confidential database and WebSQL client support.

Confidential, Atlanta, Georgia 

Responsibilities:

• Installed and configured Confidential and WebSQL and monitored the performance of Confidential database.

• Used WebSQL to solve connectivity problems between websites and Confidential servers.
• Solved client hardware and database performance problems.

Confidential

Sr. Support Engineer 

Responsibilities:

• Provided pre-sales support to several Confidential clients, including client orientation, product installation & configuration and database creation.

• Installed hardware and diagnosed all operating system problems and performance issues.

Jr. Support Engineer & System Administrator

Confidential

Responsibilities:

• Supported sales staff with technical questions, answered help desk inquiries and conducted training.

• Installed software for clients, helped with hardware and designed client backup strategies.
• Specialized in the installation and configuration of the OMNI SQL SERVER product range and different access modules.