SUMMARY:

20 years experience as IT Business Data analyst supporting different databases including Oracle, SQL Server, DB2 and Sybase. Commensurate experience to Lead Projects and Project Management (PMP), Development & Design, Sybase Replication server, SAP S/4 Hana, Oracle RAC, UNIX administration, batch processing, performance tuning, upgrades, optimization, tools and scripting.

TECHNICAL SKILLS:

Hardware: HP UX 9000/817 & HCL Series, Sun SPARC, PC - XT/ Confidential, IBM/Compaq/Dell Servers

Operating System: MICROSOFT, UNIX, HP-UX, IBM AIX, Sun Solaris

Software Tools: Erwin 3.x, Power designer 10.0/9.5, PowerBuilder 12.5, Business Objects, SQL Backtrack 4.5, Veritas Netbackup 4.0, Veritas Volume Manager 3.5, Embarcadero Performance Center 1.7.6, DB-Artisan 4.02, ARC Serve 2.0 and Sybase 12.5/12.0/11.9/11.5/11.0.2 & Oracle 7.0/7.1/7.2/7.3/8.0 , 8i/9i database monitoring tools. SAP ECC 6.0, R/3, Netweaver, Basis/SD/CRM 7.0 and Microsoft Project, Visio, Office

Languages: JAVA, J2EE, EJB, C++ Confidential -SQL, PL/SQL, PERL, SYB PERL, Shell scripting

Web Technologies: Java, IIS, JavaScript and Fulcrum.

RDBMS: Sybase ASE 11.9.2, 12.5 & Sybase Replication Server 12.5, Sybase ASIQ 12.4, Oracle 8i/9i/10g, MS SQL Server 6.5/7.0/ 2000/2005/2008/2012 /2014 , MySQL.DB2 and Teradata 15.0

PROFESSIONAL EXPERIENCE:

Confidential, New York

HealthCare Business/Data Analyst

Responsibilities:

• Automate support jobs using GUI using Windows.Net and Java. Reduce human errors and turnaround time for production moves.
• Sybase Replication Server Health, Latency, System Administration, Performance and Tuning.
• Assist Engineering team to maintain Shell, Perl and SQL scripts to perform day-to-day DBA activities
• Expertise in User Management, Capacity Space Management, Backup Management and Maintenance tasks
• Monitor and Recommend Application performance improvements with Sybase and SQL Server
• Liaison with Business, Application and Primary Technical teams to support business continuity.
• Experience with Microsoft SQL Server. Trace, SQL Profiler, DMV tables.
• Use Remedy for Incident Management and Change Management and Control-M for Job Scheduling.
• Schedule DBCC, Index Rebuild, Update Statistics and Database Backups as Maintenance Jobs.
• Working Knowledge of Sybase IQ and Oracle Database Administration
• Self-motivated Disciplined and Organized Team Lead and asset to any organization and team.
• Proven Written and Verbal Communication Skills to complete different projects within budget and schedule.
• Upgrade ASE from 15.0 to 16.0 and SQL Server 2008 to 2012 and 2014.
• Worked on Amazon Web Services (AWS) for cloud products and services.

Environnent: Sybase ASE 16.0/15.x/12.5, Réplication Server and IQ. SQL Server 2005/2008/2012/2014. Oracle 11g. Facets 5.x

Confidential, Pittsburgh, PA

Sybase and MS SQL Server Database Administrator and Business Analyst

Responsibilities:

• Maintain and upgrade Facets 4.41 to Facets 4.71 on Sybase ASE 15.0
• Shell Scripting to support day to day DBA activities and complex application tasks.
• Support SQL Server 2005 Databases in Facets and Legacy applications.
• Upgrade SQL Server 2000 to SQL Server 2005 and migrate DTS packages to SSIS package.
• Build, Deploy and Maintain SSIS Packages on development, QA and Production Servers
• Setup procedures to track and resolve DBA On-call issues with primary and backup DBA schedule
• Resolve and Close team HPSD tickets and Support Software Life Cycle.
• Schedule team meetings and meetings with other application support teams.
• Enforce Password Policy and automate password resets and expiration for audit requirements
• Complete Help Desk Tickets, Application Configuration Deployments assigned to DBA per SLA
• Proficient with SQL Agent, SQL Profiler, tuning and performance of application query and server.
• Working knowledge of JAVA, J2EE, SSRS, ASP.NET and Powershell.
• Maintain High availability solutions with SQL Server Replication, Clustering and Log Shipping.
• Expert in Confidential -SQL coding for database administration and application programming

Environnent: SQL Server 2000/2005/2008/2012 , SSIS, Sybase ASE 15.x/12.5

Confidential, Middletown, NJ

Database Consultant

Responsibilities:

• Download all software from subscribenet and install and maintain SYSAM 2.0.
• Install and Upgrade all Sybase ASE Server on 12.5 32-bit to 12.5 64-bit for Dev, uat, and production.
• Measure Replication Latency and Troubleshoot Replication performance problems.
• Organize or Participate in weekly team meetings with DBA’s and application groups.
• Schedule monthly production release for Sybase and Oracle tasks.
• Schedule Production Changes using Change Management System.
• Upgrade server to 15.0.3 using dump and load and in-place methods.
• Assign tasks. Mentor, Appraise and Guide team members to perform DBA activities.
• Write SQL*Loader control files for importing and exporting data to and from Oracle instances.
• As part of Oracle upgrade from 9i to 10g, Upgrade Sybase Direct Connect to Oracle from 12.5 to 12.5.1.
• Execute developer requests to create new database and database objects in Sybase, Oracle and SQL Server.
• Create and Maintain Shell Scripts and Perl Scripts and use MDA tables for monitoring
• Schedule Backups and DBCC using in-house backup programs.
• On call rotation and production support of Oracle 9i/10g and MS SQL Server 2005.

Environment: Sybase ASE 15.0/12.5, Sybase Repserver 15.0/12.5, IQ 12.4 Oracle 10g/9i, Oracle SQL*Net, SQL*Plus, SQL*Loader.

Confidential, Reston, VA

Sybase Database Administrator and Consultant

Responsibilities:

• Upgrade UNIX and Perl wrappers for Sybase rs subcmp from version 10.0.4 to 12.5 for Sybase warm standby and adhoc replication. This involves updating the weekly executing shell script to send e-mails to customers upon finding discreprencies and sending e-mail to customers on weekly basis to find out differences between primary and contingency and primary and reporting servers.
• Implementing the upgraded wrappers on all clusters and execute cluster wise, server wise database wise, server wise and table wise reports
• Install and Setup Replication on production, contingency, acceptance and development databases.
• Jil or convert jobs on crontab to autosys.
• Create databases and Perform database restores using sqlbacktrack and veritas netbackup.
• Use Services Online and Remedy Change Request System for scheduling and processing application changes in Development, Acceptance and Production environments.
• Document the How To and Procedures. Interviewing and recommending suitable candidates for open DBA positions.
• Install and Setup ASE 15.0, Repserver 15.0, OpenSwitch 15.0 for mutual aware or automatic failover setup.

Environment: Sybase ASE 15.0/12.5, Sybase Repserver 15.0/12.5, Veritas Netbackup 5.6, OpenSwitch 15.0

Confidential, Moorestown, NJ

Sybase Database Administrator - Associate Project Manager

Responsibilities:

• I was managing offshore DBA’s, assigning tasks and co-coordinating on daily basis.
• Coding in PERL and Shell Scripts. The scripts used were to collect Baseline objects for every release, check replication Latency and metrics information collection. Develop, Covert and maintain Perl and Shell Scripts.
• Supporting developers in code promotion from Development to QA and QAProd.
• Working on implementing projects with business analysts.
• Mentoring Offshore DBA in preparing documentation. Secondary assistance to on-call DBA routine.
• Using Erwin as data modeling tool to design and engineer specific modules.
• Convert some databases from Microsoft Access to Sybase using Microsoft SQL Server DTS.
• Schedule and complete Database Change Requests, Login Requests and Releases.
• Create server report and space management plan for all the databases.
• Promote weekly changes and monthly releases to productions from development and QA.
• Support Sybase Replication server topology, servers and requirements.
• Setup and Support Oracle RAC server on 10 G as part of on-call rotation
• Evaluate ASE 12.5.3 and 15.0 to find upgrade path for the servers Confidential PHH.
• Resolving clarify tickets relating to pending tasks. Using Autosys job scheduling tool.
• Upgrade and use new features of ASE 12.5 namely cache partitioning, cache binding, benefits from dynamic memory allocation and locking schemes.
• Approving change request for production changes as change lead and participating in team/application meetings.
• Performing and scheduling maintenance tasks including update statistics, reorgs and index rebuild.
• Performing and monitor database growth requirements namely segment, devices, database, server installments and replication systems.

Environment: Sybase ASE 12.5, REP 12.0, MS SQL Server 2000, Oracle 9i/10g, Autosys 4.0, Sun 2.9 and Linux 5.0

Confidential, Chicago, IL

Sybase Database Administrator

Responsibilities:

• Write development specifications and code stored procedures, triggers, rules, constraint and defaults to support the design.
• Develop scripts to support database default and log segments thresholds, CPU and memory utilization and assist production support dba’s.
• Use Sybase high availability system using coordination module, openswitch and warm standby replication system. Design the document manual for Sybase warm standby application for failover.
• Coding, testing, implement perl, awk and korn shell to support start, stop and status scripts of installing the status media.
• Baseline the development and integration environment using Sun v480, v120 servers.
• Use Clearcase version control system and ddts for version control and building software builds and update change controls.
• Install and setup ASE, replication server and replication definitions.
• Code-review and implementing SQL modules and shell scripts.
• Author the service manual sections and chapters dealing with database replication functionality and troubleshooting.

Environment: Sybase Power Designer 10.0/9.5, Sun Solaris 2.9, Sybase ASE 12.5, Sybase Replication Server 12.5, Sybase Open Switch and Coordination Module 12.0.

Confidential, Columbus, OH

DBA & System administrator

Responsibilities:

• Support multiple Sybase 12.0 databases.
• Performance monitoring of Sybase applications using Performance center, db-artisan and Unix shell scripts.
• Interact with developers for implementing SQL modules and Batch processes
• Developing and implementing batch processes and shell scripts for applications.
• Administer Veritas NetBackup to backup Sybase database and file system backups.
• Implementing a failover cluster system for our Sybase servers using HP Service guard and Sybase transaction logging.
• Upgrade Sybase and HP to 64-bit application and servers.
• Create devices and user table spaces to support database growth requirements of existing and new applications
• Planning and Document applications and enhancements as per customer needs and management approval.
• Document disaster recovery and Sybase and Oracle database backup procedures

Environment: HP UX 11i, Veritas Netbackup 4.0, Sybase ASE 12.0, Oracle 8i.