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 & 16.x; 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, SAP HANA Support SQL Database, MVS Database, PC and Notebooks, Application Development, SQL Builder, HipLink, MQSeries and Upgrades, Platinum, Tivoli Case tools and heterogeneous replication.

PROFESSIONAL EXPERIENCE:

Confidential, Leesburg, VA

Sybase, SQLServer DBA

Environment: Sybase ASE 12.5-16.0, 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.
• Heterogeneous and non-heterogeneous systems using SAP Sybase Replication Server. HANA SAP and Sybase Replication Server system and describe the individual technology components Sybase architecture for both heterogeneous and non-heterogeneous systems:
• PostgreSQL Data Modelling (Logical / Physical) Tableau BI reporting Strong programming experience in SQL, TSQL, PL/SQL, Complex Stored Procedures, Triggers.

Confidential, Irwindale, CA

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

Responsibilities:

• SQL Server DBA, production support. 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

Sybase ASE Application, Smartstream Financial Application

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, Sybase ASE - 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

Confidential, Burbank, CA

Senior Database Administrator

Environment: Oracle 10g, Sybase ASE - 12.5 & 15, MS SQL Server & DB2, NT, HP-UX, System XI Client / Server NT, SUN SOLARIS (Veritas Volume Manager, NetBackup), System XI Client / Server

Responsibilities:

• Task included Production Support, Performance Tune and Upgrade Sybase Server versions (11.9 - 12.5), Upgrade Sybase Replication Server and Backup Server versions (11.9 - 12.5), Informatica Application, Install Oracle version (8i), Install MSSQL Server, Database Data Modeling (Erwin, Power Design), Database Relational DB Design, Install DB2 UDB, Implement Backup, Recovery cron jobs, develop tablespace and recovery plan replication from Sybase to DB2 via Direct Connect, Client/Server Testing, Visual Basic application on Access Database, Production Support Microsoft SQL Server, Operating Systems: NT, Unix on Sun (Veritas Volume Manager, NetBackup) and Unix on HP, Coordinate system implementation, Internet Systems Process Modeling, Feasibility Assessments, Technical Software Specifications, Object Oriented Analysis Project Management, Technical Writer/Instructional Design Documentation, Technical Writing, Client/Server Testing, Confidential performance/intergration
• Interviewing employees at all levels within the organization and participating in meetings to discuss projects and milestones.
• Participates in meetings/team activities to identify project goals and ensure guidelines detailed by the Project Management Office, prepare project implementation steps and document appropriately System
• Development Process including requirement gathering and testing, identification, design, development and Implementation of systems related projects, Documentation of new implementation using Platinum and Tivoli Case tools, editing using the awk Programming Language and Stream editing (sed) Shell scripting.
• Create and Automate Shell scripts for Implementation and maintenance.