Sr. Dba/sr. Software Engineer Resume
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.