SUMMARY

• Over Twenty years of strong experience in DBA support (24x7), Production support, maintenance, project management, software design, development, programming and implementation.
• Strong experience in Sybase Adaptive Server Enterprise (ASE 16/15.x/ 12.5/12.0/11.9.2/11.0/10.0 ), Replication server 12.5/12.6/15. x, Sybase IQ 12.7/15.4/16 and Oracle 6/8/9/10G/11G, MS SQL Server 2008r 2/2012/2016/2017 (Replication),Autosys, Oracle GoldenGate, Power Builder 6.5, Data warehouse: Ardent Data stage 3.5 (Star Schema), Informatica, Sea get Crystal Reports 7.0, Brio Queries, SAP/BW R3, Actuate e - Reporting, APT, DWB, DB Library etc.

TECHNICAL SKILLS

• SAP-SYBASE SERVER / ASE (10/11.0.1/11.9.2/12.0/12.5/15/16 ), SAP-Sybase Replication server (12.x/15) SAP-Sybase IQ (12.7/15.4/16 ), POWERBUILDER (4/5/6.5), UNIX Shell Scripts (Csh, PERL, ksh), Oracle 10i/11g, MS SQL server 2008r 2/2012/2016/2017 , PostGRESQL, Brio Queries
• Data warehouse: Ardent Datastage 3.5 (ETL) / Informatica 6.1, Seaget Crystal Reports 7.0, APT, DWB, DB - Lib. SQL Loader, exp and imp, C, Actuate e - Reporting. AUTOSYS - Support Scape, BW SAP/R3, DFD: VISIO, Autosys .
• Data Modeling and Architect: Power Designer, S-Designer, ESSABASE, Axiom - Controller View.
• Rapid SQL, DB Artisan, Proactive Whitesands, Desktop DBA, Sybase Central, Bradmark Surveillance, SolarWinds, SQLbacktrack, SQL Advantage, Cost workbench (SQL Builder), Sybase Server Manager, SQL Commander, TOAD,SSMS,SQL developer etc

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Engineer

Responsibilities:

• Installation, configuration, management and production/dev/uat support of SAP-ASE 12.5.x, 15.x,16.0
• Installation, management and production/dev/uat support ofSAP- Replication 12.6 and 15.6/15.7
• Installation, management and production support of SAP IQ 15.4 /IQ 16
• Upgrade ASE from 15.5 to 16. Replication Server upgrade 15.6 to 15.7. (in place / across the host)
• Experience of building Warm standby, MSA, Table level, HVAR and Real Time Loading in IQ, ECDA and Direct connect for Sybase to SQL server replication
• Monitoring of Sybase error log for all Data Server
• Monitoring of Replication Server
• Monitoring databases threads on Replication Server
• Responsible for performance & tuning ASE Sybase/Replication servers
• Backup and recovery for all ASE Sybase/IQ, MS SQL servers databases
• Responsibility to monitor and setup MS SQL server (2008r2/2012) replication (Transaction/Merge)
• Monitor and setup of log shipping and database mirroring for MS SQL, Sybase and IQ
• Creating and Maintaining user databases, multiple tempdb, sybsecurity
• Creating and managing Adaptive Server login accounts
• Granting roles and permissions to Adaptive Server users
• Managing and monitoring the use of disk space, memory, and connections
• Backing up and restoring user and system databases
• Designing and Recommending Database Security Policy.
• Configure multiple tempdb
• Diagnosing system problems & troubleshooting
• Configuring Adaptive Server to achieve the best performance
• Establishing Disaster Recovery procedures, DBA runbook, Discovery Document
• Data Architect (Data Modeling - > Logical - Physical Database Design)
• Assisting Application DBA (Store procedure/trigger/t-SQL/View etc.)
• Automate monitoring and alerting by scheduling errorlog / logspace/database capaciting/ Long running process monitoring and alerting scripts
• Automate and analyze proactively database maintenance activity (DBCC/Update stat/reorg etc.)
• Performance-tuning SQL Server, Database level, Query level to achieve the best performance.
• Creating sysmons reports on regular basis using shell script and cron jobs
• Create scripts to monitor processes in Sybase and to highlight blocking and long running processes
• Implementation of backup and recovery for production databases
• Monitoring of Sybase error log for all Data Server
• Monitoring databases threads on Replication Server
• Troubleshooting performance issues & fine tuning complex quires
• Rebuilding/reorg of table and Indexes
• Setting thresholds to Monitor data and log space, maintaining multiple databases
• Checking the database health by running DBCC/Checkstorage commands periodically
• Use of Sybase tools like Sybase central for server monitoring Determination of Monitoring the growth of various objects over a period of time using threshold procedures
• Creating jobs to automate repetitive tasks by writing cronjobs, shell scripts etc.
• Trained and mentored junior DBA’s and Developers
• Sybase to Oracle migration (Data migration using GodenGate // T-SQL to plsql conversion)

Sybase IQ DBA

Responsibilities:

• Sybase IQ installation, configuration, Setting up ODBC,Open Client, Configuration
• IQ server upgrade from 15.4 to IQ16
• Monitoring and alerting Message errorlog/serverlog
• Creating Databases and managing DBspaces,Setting up database options.
• User Administration and Security
• Creating table,view and indexes,procedures,export,import of data
• Loading data from files,remote server and across tables and exporting data .
• Performance and Tunning, Monitoring and Troubleshooting
• Maintance Activity (sp iqcheckdb/defragmentaion/re-indexing etc)
• Backup (Full/Incremental/Incremental-since-full/Virtual) and Recovery,Log shipping,mirroring

MS SQL Server DBA

Confidential

Responsibilities:

• Install and configure new SQL Servers (Active-Passive Clustering/Always On)
• SQL Server merge, snapshot and transactional replication (Multiple Publishers )
• Setting up log shipping and database mirroring
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
• Configure SQL Server monitoring utilities to minimize false alarms
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
• Each week, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each
• Design indexes for existing applications, choosing when to add or remove indexes
• When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
• Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc)

Confidential

Senior Sybase DBA

Responsibilities:

• Installation, configuration, management and production/dev/uat support of ASE 12.5.x, 15.x,16.0
• Installation, management and production/dev/uat support of Replication 12.6 and 15.2
• Installation, management and production support of IQ 15.4 /IQ 16
• Upgrade ASE from 15.5 to 16. Replication upgrade 15.6 to 15.7. (in place / across the host)
• Experience of building Warm standby, MSA, Table level, HVAR and Real Time Loading in IQ
• Monitoring of Sybase error log for all Data Server
• Monitoring of Replication Server
• Monitoring databases threads on Replication Server
• Responsible for performance & tuning ASE Sybase/Replication servers
• Backup and recovery for all ASE Sybase/IQ, MS SQL servers databases
• Responsibility to monitor and setup MS SQL server (2008r2/2012) replication (Transaction/Merge)
• Monitor and setup of log shipping and database mirroring for MS SQL, Sybase and IQ
• Creating and Maintaining user databases, multiple tempdb, sybsecurity
• Creating and managing Adaptive Server login accounts
• Granting roles and permissions to Adaptive Server users
• Managing and monitoring the use of disk space, memory, and connections
• Backing up and restoring user and system databases
• Designing and Recommending Database Security Policy.
• Configure multiple tempdb
• Diagnosing system problems & troubleshooting
• Configuring Adaptive Server to achieve the best performance
• Establishing Disaster Recovery procedures, DBA runbook, Discovery Document
• Data Architect (Data Modeling - > Logical – Physical Database Design)
• Assisting Application DBA (Store procedure/trigger/t-SQL/View etc.)
• Automate monitoring and alerting by scheduling errorlog / logspace/database capaciting/ Long running process monitoring and alerting scripts
• Automate and analyze proactively database maintenance activity (DBCC/Update stat/reorg etc.)
• Performance-tuning SQL Server, Database level, Query level to achieve the best performance.
• Creating sysmons reports on regular basis using shell script and cron jobs
• Create scripts to monitor processes in Sybase and to highlight blocking and long running processes
• Implementation of backup and recovery for production databases
• Monitoring of Sybase error log for all Data Server
• Monitoring databases threads on Replication Server
• Troubleshooting performance issues & fine tuning quires
• Rebuilding/reorg of table and Indexes
• Setting thresholds to Monitor data and log space, maintaining multiple databases
• Checking the database health by running DBCC/Checkstorage commands periodically
• Use of Sybase tools like Sybase central for server monitoring Determination of Monitoring the growth of various objects over a period of time using threshold procedures
• Creating jobs to automate repetitive tasks by writing cronjobs, shell scripts etc.
• Trained and mentored junior DBA’s and Developers