SUMMARY:

• Systems Analyst Systems engineer database administrator Programmer Applications IntegratorCOTS Systems Software Integration Hardware & Software Technologies
• Coding, Testing & Documentation
• Server Setup & Maintenance
• Development of full application database backends including tablesstored procedures, triggers, queriesand functions
• Database Applications
• Graphical User Interface (GUI)
• Software & Web Applications
• UNIX and NT Client - server Application Design
• UNIX Command Line Processing & UNIX Shell Scripting
• Object-oriented Programming
• Relational Databases
• Create Prototypes & Design
• User Interface Screens & Database Tables
• High-level technical supporter, system administrator, and application designer with proven history of producing complex applications on time and within budget. Strong communications skills.
• Analytical thinker with the ability to identify a problem; evaluate solutions; and determine the best course of action to meet stated objectives. Managed first-level support calls for NT applications, LAN access, voicemail calls, and software and hardware installations. Converted Access databases from Windows 98 to 2000 and created and populated new tables, queries, and forms.
• In 16+ years of working with Sybase and SQL Server, was responsible for the creation of 500+ stored procedures, several dozen hard-coded queries used in the application code for numerous client-server database applications.
• Only full-time Sybase database administrator for the 2nd largest travel management company of more than 50k employees world-wide. Subject matter expert (SME) for system security.
• Considerable knowledge of design, administration, and performance tuning of MySQL. Also experienced at designing databases and tuning queries for PostgreSQL and SQLite.
• Managed complete testing of new enhancements for the Army’s Web Application Training Resource Management System (TRMS), providing database administration support to production and development databases and servers.
• Wrote most if not all scripts in several flavors of UNIX shell scripting to handle all database performance and management tasks in all previous positions.
• Listen intently and accurately to assess customers’ professional service needs and design, deliver, evaluate, and administer customized software packages. Analyze system requirements and extract information from customers to ensure detailed understanding of needs. Provide end-user support.

TECHNICAL PROFICIENCIES:

Applications and systems programming: C/C++ / Application Technical Support using Remedy / UNIX (Solaris 2.7/2.8) - (SUNOS - 5.0/6.0) - (HPUX - 10/11) - (Sparc DEC) - (AIX) / Windows 95, 98, 2000, NT / MYSQL Community Server 5.0 and greater / Sybase (Adaptive Server 10-15.0 & Sybase Server Anywhere 12) / Microsoft SQLServer (Version 7.0 & 2000 & 2005 & 2008) Oracle (Oracle 8 Server RDBMS) Informix (System 11) MYSQL / Sybase Replication Server 12-15.0 / Netscape and Apache Web Server Administration, PERL 5, KSH, CSH;

Languages/Tools: Microsoft Visual C++, Visual Basic, Borland Turbo C, Turbo Pascal, PVCS Configuration Builder, PVCS Version Manager, eXceed, NFS Maestro, Unix C/C++, PERL;

Middleware: Dec Message Q, TCPIP, MQ Series;

Software: Microsoft Office Suite, Select Enterprise Professional (Object Modeling Tool) VI, VISIO, Lotus Notes, Netscape, Remedy, CyberSafe Challenger, Infomaker, ODBC drivers, Purify, Quantify, CORBA, Tuxedo, BRIO, WebTrends, XML, XSL, UNIX Shell Scripting.

PROFESSIONAL EXPERIENCE:

Confidential

System Enginner

Responsibilities:

• Averaged 55 to 75 hours per week performing High-level Operations Support for Center of Medicare & Medicaid Services APS application. APS stands for Advanced Provider Screening. A Turning Point Global Solution Application web-based GUI front-end, with Oracle Database backend solution that serves as a central point of collection-repository information that to help CMS Approval Specialists to approve doctors and health care entities & organizations for Medicare reimbursement.
• Responsible for the weekly / monthly Data loading, Data processing, and Report Processing of 3rd Party Exclusion lists into the APS backend system in order to generate necessary Alerts for the CMS Approval Specialists when doctors doctors and health care entities & organizations should be denied based on specific criteria.
• High-level Support provided when there are issues with the Advanced Provider Screening application either on the web-based GUI front-end or Oracle Database backend solution that the APS Helpdesk cannot resolve themselves.
• Supported the APS Testing team in the execution of their APS test cases for each consecutive quarterly release of APS.
• Provided database query results per request of the APS Development team, APS Data Analysis and APS Requirements team thereby gaining specific internal knowledge of APS Database Architecture.
• Operations Team partly responsible for the verification of data results from APS as compared to other health care data federal / state-wide respositories.

Confidential

System Database Administrator

Responsibilities:

• Only full-time Sybase database administrator for the 2nd largest travel management company of more than 50k employees world-wide. My database admin manager looks to me as SME for anything Sybase related with my relative 16 years of Sybase database management. Served as both production database administrator, not a development database administrator responsible for performance tuning, query optimization, and database development of stored procedures and triggers.
• Product evaluator for choice of Confidential Sybase DB Performance. Performance Management & Performance Tuning used by the Sybase database team in terms of the configuration of 4-tier architect from GUI to Middleware to UNIX Backend to Production database. Main Lead for retirement of data for both Confidential Navigant Eagle and Customer Service applications when both applications were retired when Confidential Navigant was bought by Confidential 4-5 years ago. Sybase database architect for the Confidential Navigant Eagle and Customer Service applications - used for airline booking systems.

Confidential

SQL Server Database Administrator

Responsibilities:

• Performed general production and development SQL Server database administration thru supporting 3 other SQL Server Front End GUI applications relating to customer satisfaction and comments. Performed work of performance tuning, query optimization, and database development of stored procedures and triggers.
• Involved in two database conversions from Sybase to SQL Server for these SQL Server Front End GUI applications relating to customer satisfaction and comments.

Confidential

MYSQL Database Administrator

Responsibilities:

• Optimized MySQL queries, managed load balancing, iptable firewalls, caching, replication and backups to create a redundant, highly scalable application for Carlson E-card application for 2-3 years.
• Used Expertise of UNIX Command Line in determination of resolution of various Carlson Sybase performance and data issues thru error checking, file scanning, and script resolution.

Confidential

Security Manager

Responsibilities:

• Subject Matter Expert for database security questions for regular IT Audits for the Matrix M&G database.
• Lead Sybase database administrator for the Matrix M&G application - suite of applications dealing with hotel-customer financial information for military and government agencies.
• Confidential mandated all managers of M&G financial information have to be US citizens, so all support from 3rd party architects in Canada had to be transferred to Carlson as the client company.

Confidential

Database developer - Architect

Responsibilities:

• Responsible for database login security for the Confidential HARP Production database. Patch manager responsible for HARP production rollout release. Responsible for shutting down & restarting DB. Responsible for DB shutdowns for quarterly UNIX patches being applied to all UNIX Host Servers holding the physical production & non-production databases for Matrix and HARP.
• Accountable for enchancements / additions from the database perspective for Confidential HARP & Matrix monthly releases including the generation of new stored procedures, update, insert, delete triggers, and the creation of new application tables
• Worked with numerous Confidential HARP & Matrix developers from a functional perspective giving me their specifications for the database requirements for Confidential applications, then given the charge to fully develop the whole Sybase or SQL Server database requisites for Confidential applications.

Confidential

Applications Analysis & Systems Tester / SQL Server Database Specialist & System Administrator

Responsibilities:

• Managed complete testing of new enhancements for the Army’s Web Application Training Resource Management System (TRMS) including individual component and full-system testing, providing DBA support to production and development databases and servers.
• Responsible for creation for all SQL Server database backend components for necessary enchancements or applications for TRMS website applications - including the creation of 300 stored procedures over a 2 year period.

Technology: Microsoft SQL Server, Windows NT, Windows 2000, XML, and Webtrends

Confidential, Fairfax, VA

Software Engineer & Technical Support Specialist

Responsibilities:

• Taught a basic Sybase System 12 database and Sybase Replication Server course to junior database

Technology: Sybase, Microsoft Access, Windows NT, and Windows 98

Confidential, Ashburn, VA

Production & Development Sybase & SQL Database Administrator & Systems Tester

Responsibilities:

• Performed back-up and recovery procedures on server databases using a remote backup server. Carried-out disaster recovery procedures. Controlled user access to Sybase and SQL Server databases. Served as technical consultant to resolve database, GUI or backend problems.
• Involved in full database design of two Worldcom Customer Billing Applications from full system design to database application rollout

Technology: Remedy, Sybase ASE & ASA, SQL Server, SunOS, Sun Solaris, HP-UX, OS