SUMMARY:

• Twenty plus years of solid Sybase Database Administration and related programming experience, over seven years of Unix experience that includes Solaris, HP - UX, and AIX, over five years of experience with Sybase Replication and related activities, over three years of Oracle Database Administration, design/data modeling, over two years of experience with Mainframe related programming that includes DB2, over 4 years of UDB DB2 and Hands on experience with People Soft, over seven years of MSSQL Server on NT.
• Maintained, installed and upgraded Sybase Database, Sybase Replication Servers and Sybase IQ Database Servers, Setup disaster recovery procedures and XML Order Documents and SQL.
• Conducted performance and tuning on Sybase database system using internal and external database and system tools.

TECHNICAL SKILLS:

Database: Oracle 8x,9x,10x and 11g, Sybase IQ, DB2 UDB, DB2 for MVS, SQL Plus & PL/SQL Crystal Reports, IMS, DBCC Driver, Sybase and ASE 10, 11, 11.3.x, 11.5.x, 11.9.2, 12.0.x, & 15x; Sybase Replication Server 11.0 & 11.5.1,12.0.x, & 15x; MS SQL Server 6.5 & 7.0, Sybase, SQL Anywhere, Access and SQL language

OS: MVS, HPUX, SUN SOLARIS 2.6/5.6, AIX, DOS, Windows 2000, UNIX, OS/2, Novell, and Windows NT Professional

Languages: C, C++, VISUAL BASIC, COBOL, Power Builder 5.0, 6.5 & 7.0, UNIX shell scripting, Perl.

Tools: DB Artisan, Erwin, ER Studio, Power Designer, SQL Backtrack, Tivoli, And Clear Case, Informatica V8.6, PowerBuilder 12.0,11.X,10.X, 9.X, 8.X

Support SQL: Database, MVS Database, PC and Notebooks, Application Development, SQL Builder, HipLink, MQSeries and Upgrades, Platinum and Tivoli Case tools

PROFESSIONAL EXPERIENCE:

Confidential, Leesburg, VA

Sybase, SQLServer DBA

Environment: Sybase ASE 12.5-15.5, Sybase replication, SQL server2016

Responsibilities:

• Sybase DBA, Developer.
• SQL Server DBA, production support.
• Application support.
• Sybase Database administrator.
• Sybase Server performance Tune Sybase application tuning, connectivity and SQL procedures.
• Sybase to SQL Server Migration SQL server programming, analysis and design, systems development, or system administration.
• Experience with SSIS and proficient using XML.

Confidential, Irwindale, CA

Environment: Sybase ASE 12.5-15.5, Sybase replication Server 15.7, SQL server, DB2 10.5 for z/OS

Responsibilities:

• DB2 Mainframe application support.
• Oracle Database administrator.
• PowerBuilder 12 to create executable from mainframe . pbl Sybase Development application tuning, connectivity and SQL procedures..
• Engineer for monthly new code release on CSS/CWO Mainframe application.
• Hadoop Amazon Distribute and synchronize data across geographies to multiple systems using replication SQL server programming, analysis and design, systems development, or system administration.
• Oracle applications, including Peoplesoft to Host computer communications, in a network environment.
• Programming in SQL, Basic, C, or C++ and Unix shell scripting.
• Experience with SSIS and proficient using XML.

Confidential, Monrovia, CA

Environment: Sybase ASE 12.5, SQL server

Responsibilities:

• Migrate Sybase Databases to Oracle.
• Troubleshoot and Maintain Sybase ASE Internal Procedures.
• Create DTS job in SQL server. Configure SmartStream Jobs. Maintaining ticket queue.
• Providing support for Database administrator.
• Supporting Application Data.
• Supporting Database Data.

Confidential, Glendale, CA

Sybase ASE DBA, Hadoop

Environment: Sybase ASE 15

Responsibilities:

• Install Sybase ASE IQ on a multi-terabyte system.
• Install AWS (Amazon Wed Services cloud computing).
• Configure AWS EMR(Elastic MapReduce).
• Installing Hadoop while implemented within Amazon.
• Providing support for AWS Data Pipeline.

Confidential, CA

Oracle DBA

Environment: Oracle 11g

Responsibilities:

• Installation and Support of Oracle11g. Configuring Oracle Active Data Guard, Oracle Advanced Compression, Oracle Advanced Security, Oracle Database Vault, Oracle Data Mining, Oracle In-Memory Database Cache, Oracle Label Security, Oracle OLAP, Oracle Partitioning.
• Installing Oracle RAC One Node, Oracle Real Application Clusters, Oracle Real Application Testing, Oracle Spatial, Oracle Total Recall, Providing support for Oracle Database management Pack, Oracle Change Management Pack, Oracle Configuration Management Pack, Oracle Data Masking Pack, Oracle Diagnostic Pack.
• Spatial Administer Oracle spatial schema that prescribes the storage, syntax, and semantics of supported geometric data types, spatial indexing system and Operators, functions, and procedures for performing area-of-interest queries, spatial join queries, 1 and other spatial analysis operations.

Confidential, Greenwood Village, CO

Sybase ASE DBA, Sybase Replication DBA

Environment: Sybase ASE 15, Sybase Replication 15

Responsibilities:

• Installed Sybase ASE 15 and Replication Server 15.
• Tuned and maintained high security.
• Database administration function and production support Automate maintenance index statistics and reorgs.
• Applied Hadoop to Sybase IQ data warehouse infrastructure for analyzing large data sets, simplifying the most common big data analysis and analytic use cases.
• Introduced plans for increased deployment using SAS Hadoop.
• Implemented a powerful SAS Analytics implementation using Hadoop to take advantage of its distributed processing capabilities and helped effectively deployments taking very large data collections -- from simple, regular data to complex, unstructured data -- and process it quickly

Confidential, Colorado Springs, CO

Sybase IQ DBA

Environment: Sybase ASE, IQ12.5 & 15, HP & Linux, PowerBuilder 11.0

Responsibilities:

• Instrumental in Migrating to Sybase ASE, IQ 15.5 from 12.6 in a multiplex environment involving 3 readers and a writer.
• Migrated shell scripts, complex stored procedures/triggers.
• Designed new database platforms using power design.
• IQ query plans and stored procedures, canned- as well as ad-hoc queries for migration and set up create Index statements to match new ad-hoc and prepared queries.
• Document existing IQ environment and recommend changes to be made for a new IQ Multiplexed environment along with logical and physical design recommendations for same.
• Built and supported a Multiplexed development environment. Troubleshooting IQ performance problems on an HP/Linus 64bit platform and making recommendations for both UNIX level tuning changes as well as IQ changes.

Confidential, Roseville, CA

Oracle DBA, Sybase IQ DBA

Environment: Oracle 11g, Sybase ASE - 12.5 & 15, Replication 12, PowerBuilder 11.0, 10.X, 9.X, 8.X

Responsibilities:

• Assisted in providing expertise to the development teams in the design and development of production, test, and development Sybase IQ, enterprise Sybase (12.5.3) & (15) and Oracle (9.2.0.1) & (11g) Servers and databases.
• Provided production level Management while supporting current Mapping between XML and SQL and all three basic ways to store XML data in SQL, for which we use the terms element storage, document storage, and hybrid storage.
• Proactively evaluated physical and logical design of databases to keep up with the dynamic and growing business needs in an e-commerce environment.
• Responsible for Leading in the design of logical and physical databases.
• Support and Identifying architectural issues and propose alternative solutions and providing data access using Informatica V8.6 and other methods for business objects utilizing the latest server technologies. Developed databases to support server based applications using UNIX shell script and Perl scripts. Other responsibilities included designing maintenance plans, Evaluating and monitor databases to resolve performance issues, determine resource consumption estimates and recommend system upgrades, Interpret business requirements to develop data entity structures and star schemas