SUMMARY:

• Database Administration with Sybase ASE 4 - 15.7 with replication SYBASE IQ, MSSQL 2000-2016,ORACLE, MySQL - Unix Administration tasks and shell scripts
• DATABASE performance tuning, stored procedures, queries Security analysis, planning, implementation, testing Shell scripting Unix/Windows Software development (C++, VC, Delphi)
• Business and Scientific application development Web design and database integration Mathematical modeling

TECHNICAL SKILLS:

Databases: SYBASE ASE CE/Replication 4.9-15.7, MSSQL,DB2,ORACLE,MySQL

Computers: SUN-Solaris,HP9000,AIX, DEC-VAX/VMS, IBM mainframe

Operating Systems: UNIX/LINUX, AIX, VMS, IBM,Windows XP/NT/Vista

Languages: Delphi, MS Visual C++, PASCAL,FORTRAN, Assembler, COBOL

Scripting: Unix shells (korn/bourne/c), Perl,Java

DB TOOLS: DBArtisan, BMC Patrol,Sybase Central, ErWin, Power designer SQL Backtrack, Veritas, HP OpenView tools, Autosys .

4GL: Powerbuilder, UNIFACE, Visual Basic, C#, .NET

EXPERIENCE:

Sr. DBA/Sr. Software Engineer

Confidential

Responsibilities:

• Provided 24x7 PRODUCTION /DEV support for Sybase ASE, IQ, Replication, MSSQL Oracle on rotating schedule
• Sybase ASE 15.7 installation, upgrade and configuration
• Sybase Migration from ASE 15.03 to 15.7, upgrade, configuration
• Creating and tuning SQL queries and stored procedures
• Sybase Replication Server installation, configuration, troubleshooting
• Sybase ASE, IQ, Oracle monitoring, problem resolution, customer support
• Providing developers support, coding standards, code review, advise
• Created Linux shell scripts to support DBA infrastructure
• Created system stored procedures to support DBA infrastructure
• Participated in creating backup and disaster recovery strategy plans and implementations
• Enterprise MIGRATION from Sybase/Oracle to MSSQL platform

Confidential

Sr. Sybase DBA

Responsibilities:

• Sybase ASE Cluster 15.7 installation, upgrade and configuration
• MS SQL 2005 - 2012 installation, upgrade and configuration
• MySQL 5.6 installation, upgrade and configuration
• Sybase Replication Server Installation. Upgrade and configuration
• Sybase ASE / MS SQL/MySQL monitoring, problem resolution, customer support
• Providing developers support (roles, user groups, recompiling SP and SQL
• Sybase ASE / MS SQL/MySQL performance tuning
• Created Linux shell scripts to support DBA infrastructure
• Created system stored procedures to support DBA infrastructure
• Participated in creating backup and disaster recovery strategy plans and implementations
• Provided performance analysis and tuning for Sybase/MSSQL/MySql servers
• Provided 24x7 support for Sybase ASE Cluster with Replication on rotating schedule
• Provided 24x7 support for MSSQL servers with Replication on rotating schedule
• Communicated with SAP Sybase support to resolve unusual technical problems
• Investigated and Resolved any unusual problems with Sybase ASE and MS SQL
• Performed Sybase and MS SQL database migration between versions and platforms
• DBA team lead

Confidential

Sr. Sybase DBA./ MS SQL DBA

Responsibilities:

• Sybase serves (ASE) installation, upgrade and configuration (v.11.9 - 15.x)
• MS SQL 2000 - 2005 installation, upgrade and configuration
• Sybase ASE / MS SQL monitoring, problem resolution, customer support
• Sybase ASE / MS SQL developers support (roles, user groups, recompiling SP and SQL
• Sybase ASE / MS SQL performance tuning (Both system configuration and SQL)
• Created unix shell scripts to support DBA infrastructure
• Created system stored procedures to support DBA infrastructure
• Participated in creating backup and disaster recovery strategy plans and implementations
• Participated in Work Excellence program and classes
• Provided 24x7 support for Sybase ASE and MS SQL servers on rotating schedule
• Investigated and Resolved any unusual problems with Sybase ASE and MS SQL
• Performed Sybase and MS SQL database migration between versions
• Developed UNIX shell scripts and stored procedures to support database migration

Confidential

Sr. DBA Sybase, MS SQL /Unix admin

Responsibilities:

• As Sr. DBA provided 24x7 production support Investigated and resolved production issues, coordinated DBA/unix admin support group
• Designed, implemented, supported monitoring environment and reports(korn shell scripts)
• Designed ASE/Unix performance matrix .
• Analyzed performance reports (korn shell scripts)
• Installed and configured Sybase ASE (12.5-15.0), MS SQL servers Participated in Replication environment design, installation and configuration. Set up the Replication Server monitoring unix shell scripts. Investigated, analyze and fixed Replication Server problems.
• Estimated database space requirements,
• Designed and implemented backup-recovery plan, set up backup jobs via crontab Autosys,
• Veritas Installed and configured the performance monitoring software (SQL Power sniffer, Symantec Insight)
• Installed, configured and supported (via scripts and stored procedures) Sybase mda tables (mon*)
• Analyzed production ASE/Unix performance issues that becomes the base of re-building efforts.
• Helped Unix administrators to configure hardware, network, memory for best production performance.
• Participated in re-building production environment (unix+ASE) .Performance increased by 300%
• Installed/configured the development, testing and staging ASEs and MS SQL servers
• Participated in setting up the deployment process all the way from development to production.
• Participated in designing the database security(access) strategy.
• Implemented/supported database security(access) strategy.
• Participated in creating SQL design and development standards.
• Provided development support by helping fine tune stored procs, triggers, queries and find correct indexes.
• Helped developers to create Unix /Perl shell scripts.
• Perl scripts that are using Sybperl.
• Helped database architects to design new database schemas for best performance and low cost support.
• Helped UNIX administrators to install correct development software.
• Helped business analysts to migrate data from Sybase ASE HP to Sybase ASE NT and MS SQL servers
• As a DBA group leader motivated directed and helped fellow DBAs to create a stable unified infrastructure, fast problem resolution and effective customer/developers support

Confidential

Sr. Analyst/Production support

Responsibilities:

• Provided production support for Sybase/Unix based application Fine tuned stored procedures.
• Changed according to business requirements.
• Analyzed index usages for performance boosting
• Created and fixed business unix shell scripts.
• Supported, troubleshooted IBM MQ series applications.
• Supported, fixed IBM based COBOL applications.
• Supported, troubleshooted, fixed Internet base (HTML/PHP) applications. Supported MS SQL servers

Confidential, WI

Sr. DBA. SYBASE/MS SQL/Oracle

Responsibilities:

• Provided 24x7 Sybase/MS SQL/ORACLE database support
• Provided support for Sybase Replication Servers
• Developed unix shell scripts supporting DBA tasks (backups, reporting, monitoring)
• Developed Perl scripts for Sybase ASE performance analysis Investigated, analyzed and resolved production issues with databases, connections, scheduled jobs
• Provided support for SQL developers by analyzing and resolving database issues.
• Supported database access security, user logins and object access.
• Participated in BMC Patrol installation, configuration and implementation. Supported Autosys scheduled jobs. Configuration, analyzing and fixing problems.