Summary: Sybase and SQL Server DBA and developer with over 20 years experience creating, maintaining, troubleshooting and monitoring very large, complex Sybase databases on HP UX, Sun Solaris, Windows, and Linux. Experience in troubleshooting, backup and recovery, performance tuning, auditing, and upgrading in multiple platform. Excellent written and verbal communication skills. |
Languages/Programming:SQL, ColdFusion, Javascript, Perl |
Software:Sybase Server 10 -15.x, Embarcadero, SQL Server 2005/2008, Rapid SQL, MS Office, Windows 3.0 thru XP, MacAfee Antivirus, ImageMaker |
Work Experience: |
Confidential Sybase Consultant Contract via Tekshapers/Pomeroy - Database administration on the Sybase and Microsoft SQL Server platforms
- Assumed ownership of database related problems, troubleshooting, root cause analysis and problem resolution
- Restored and cloned refreshes of non-production environments
- Created databases
- Storage management and capacity planning
- Follow change management via existing SDLC process
- Managing users and security
- Managing database objects such as tables, indexes, and views
- Monitored and tuned database performance
- Resolved client and/or connection issues
- Handling replication issues
- Investigate and gather diagnostic data for examining critical database errors.
- Evaluating and testing new database features, working with vendors during installations
- After hours on call support every 4th week
|
Confidential |
Sybase Consultant Contract via Damco Solutions/Genesis10 |
- Database Management Request resolved technical and created complex personalized reports
- HP Management Services Problem, Incident, Change, and Configuration Management
- Data recovery
- 24 x 7 technical support Sybase on-call on rotation
- Replication -- server maintenance and recovery
- Audit Management Team Provide patch reviews and Admin List quarterly , Backup and Exceptional Security monthly , Other audits that require change management
- Business Continuity BCP disaster recovery
- C shell scripts to create and automate analytical reports
- Analyzed error logs for Sybase
- Priority 1 Active member of problems that is crucial and root cause analysis
- Coordinated with multiple teams and Sybase Support staff to resolve data corruption that lasted seven days non-stop
- Veritas Netbackup Backup and recovery of several databases
- Data mining and warehousing of VLDB very large database
- Proof Of Concept Sybase Open Client, Open Server, Adaptive Server Enterprise, Replication Server, Replication Agent, Software Development Kit on multiple platform, PowerBuilder, PowerDesigner, and SQLAnywhere
- Operating System: HP-UX Itanium 11.23 and 11.31, Linux, and Windows
|
Confidential |
Lead Database Engineer |
- Sybase DBA over multiple versions of Adaptive Server Enterprise up to ASE 15.0.3 Responsible for creating, maintaining troubleshooting and tuning 80 Sybase servers to ensure 24/7/365 availability. Optimized databases, stored procedures and queries.
- Developed various databases for financial data warehousing fundamental warehouse to hold 20 years of financial history , completed end-to-end application to monitor, view, update, alerts, and notification for Operation Staff to use. Back-end Sybase ASE 15.0.3, ColdFusion 4.5 Server, and Dreamweaver to complete the project.
- Installed and configured SQL Server 2005 on Windows 2003 Server and SQL Server 2008 R2 on Windows 2008 Server.
- Install, setup, and configure mirroring on a very complex network with multiple firewalls.
- Upgraded ASE 11.0.3, 12.x, 15.x on multiple Operating Systems
- Automated backup/recovery using IBM TIVOLI.
- Responsible for capacity planning and management for space, memory, processors and backup media.
- Performed data collection and analysis. Filtered data and provided it to clients with complete data integrity by following established security processes and procedures.
- Performed an maintained hierarchical user login and permissions within multiple Sybase Servers
- Responsible for backup and recovery processes and procedures to ensure business continuity.
- Obtained and maintained other position vacated and their responsibilities.
- Performed analysis, recommendation, upgrade, and installation of various software
- Supervised data migration between O/S platform from multiple providers
- Designed and deployed monitoring tools with email notification capability via ColdFusion web forms
- Operating System: Windows, Linux, SCO, and SunOs
|
Confidential Technical Support - Responsible for providing high-level database support to assigned clients, including, E-Trade and the U.S. Air Force. Would monitor databases, and work closely with clients to troubleshoot and resolve any issues
- Supported ASE 10 11.5
- Operating System: SunOs, SCO, HP-UX, IBM, Windows
|