SUMMARY:

• Sybase Database Consultant with experience in the administration, programming, development, implementation and analysis of applications on multiple database platforms like Sybase, Oracle, MS SQL and UDB DB2.
• Utilized PowerBuilder 12.x to create executable from mainframe. Pbl. Developed Sybase application tuning, connectivity and SQL procedures along with SQL server programming, analysis and design, systems development, or system administration.
• Assisted the development teams in the design and development of production, test, and development Sybase IQ, enterprise Sybase (12.5.3), (15) &(16) and Oracle (9.2.0.1), (11g) & (12c) and MSSQL Servers and databases(2008), (2012). (2014) & (2016).
• 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.
• Performed production support, performance tuning and upgradation of Sybase Server versions (11.9 - 12.5), Upgraded Sybase Replication Server and Backup Server versions (11.9 - 12.5), Informatica Application, Installed Oracle version (8i), Install MSSQL Server, Database Data Modeling (Erwin, Power Design), Database Relational DB Design, Install DB2 UDB, Implement Backup, Recovery cron jobs.
• 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.
• Migrated to Sybase ASE, IQ 15.5 from 12.6 in a multiplex environment involving 3 readers and a writer with migrating shell scripts, complex stored procedures/triggers.

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 DBA, Developer

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

Responsibilities:

• 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.
• Sybase, Oracle, SQLServer, MVS Mainframe, Amazon Hadoop

Confidential, Irwindale, CA

Sybase DBA, Developer

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

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

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.

Oracle DBA

Confidential, CA

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.

Sybase ASE DBA, Sybase Replication DBA

Confidential, Greenwood Village, CO

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

Sybase IQ DBA

Confidential, Colorado Springs, CO

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.