PROFESSIONAL SUMMARY:

• Having 13+ years of experience in RDBMS in IT Industry as a Sybase ASE& REP & IQ / MS SQL Database Administrator Expertise in Configuration, Installation, and Trouble Shooting Backup & Recovery on UNIX/Solaris and AIX & Linux environments.
• Expertise in Configuration, Installation, Migration and Trouble Shooting, Backup & Recovery on all Window & UNIX environments (Sun, AIX & Linux).
• Over 5+ years of MSSQL DBA Support of MS SQL Servers for Production, QA and Development servers.
• Sybase ASE&IQ upgrade/installation/a nd create Simplex & Multiplex environments; and fixed daily issues/ or maintenance.
• Specialized in all aspects of DATABASE DESIGN and development with Sybase (ASE, IQ) and MSSQL database servers.
• Experience DB Migration & integration From Sun Solaris to AIX, Linux and Window servers.
• Experience wrote/troubleshoot SQL code for stored procedure, functions, view and triggers.
• Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
• Performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
• Extensive experience in migration and conversion of data to/from various data sources. Extensive general IT skills covering UNIX shell scripts, PERL scripts, CORN Jobs and various programming languages. Extensive experience in ETL and Data warehouse.
• Experience in troubleshooting the database and server issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard etc...
• Experience MS SQL & Sybase server VMWARE and WSFC Clustering configuration and support.
• Have good experience with partitioned tables and indexes, creating Filegroups using SQL Server 2012.Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Experience Redhat Linux Exposure to Cloud and virtual Application environments.
• Experience in Query optimization and tuning skills, analysis and troubleshooting interactions between databases, operating systems and applications with regard to performance and resources usage
• Extensive experience in Sizing of Databases and reviewing estimates. Over EIGHT Years’ experience in IT industry as a PDBA/SDBA and production support personnel. Over 5+ Year MSSQL (2005, 2008, 2012) Production Support DBA with development & performance tuning activity/task.

TECHNICAL SKILLS:

RDBMS: Sybase ASE 12.5.x/15.7 SP137 & 16 Database Administration Sybase IQ 15.4 /16 SPX/MPX Administration Sybase Replication Server 12.6/15.5/15.7 Administration Microsoft SQL Server 2005, 2008, 2012.

Operating Systems: SUN Solaris, AIX, RHEL 7.1, HPUX, Windows NT 7 & 8

Software: BMC - Patrol,Autosys,Bladelogic,Control-M,doubletake,SQLBacktrack/TSM/dsmc,Tivoli,DBArtisan,RapidSQL, aseisq,ignite, Erwin ERX, SQL Navigator.

Languages: C, UNIX Shell & Perl Scripting, PowerShell PowerBuilder, Visual Basic, HTML.

Reports: Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Irving, Texas

Sybase DBA

Responsibilities:

• Database Performance optimizations
• Database Health check/Proactive Monitoring, Perform database environment capacity planning.
• Leading highly complex data modeling, mapping, integration, and capacity planning efforts, Develop, implement and maintain automation efficiencies using scripting languages (PERL, KornShell) in a UNIX environment
• Maintains responsibility for analysis of Sybase / SQL code and development where changes are necessary. Tunes queries / stored procedures, indexes, and other database elements.
• Plan and design database changes necessary for data conversion, tool configuration, data refresh or migration or other initiatives related to large application development project.
• Troubleshooting errors or production problems involving databases to determine causes and proposed solutions.
• Monitored, analyzed, and optimized Sybase TSQL stored procedures and views
• Review daily/weekly database monitoring report and inform to Application team if any Action require,

Confidential

Responsibilities:

• Working as a PDBA/SDBA to support the SYBASE ASE/REP servers as well ORACLE daily Application support
• Installing /Upgrade & configuring Sybase ASE/REP to 15.7 sp135/137.
• VMware Sybase installation on sun spark machine with Sybase ASE 15.7 sp135 version
• Conducted database design review and made suggestions for performance improvement for critical tier 1 application, for large databases.

Confidential, New Jersey

Responsibilities:

• Providing L2/L3 & on-call (24/7) for Sybase (ASE/REP/IQ) & MSSQL Servers DBA support (for all incident calls). This involved working with Application Support team and Operations team to resolve the incident Request Tickets for All the environments including PROD/DR/UAT.
• Cross platform migration from Sun Solaris to Linux; IQ replication RTL from ASE to IQ installation.
• Sybase IQ database migration from 15.4 to 16
• Built a new Linux Sybase IQ16 SP08 SRDF VLDB multiplex.
• Tuned Linux OS kernel parameter tuning for ASE and IQ
• Sybase IQ upgrade on Simplex environments and taking care daily issues/ or maintenance.
• Sybase IQ upgrade /installation/create Simplex & Multiplex environments and taking care daily issues/ or maintenance.
• Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Building New Data servers Sybase (ASE, REP, and IQ) as per the application requirements.
• Sybase ASE Upgrade on 15.7 (SP131 & SP135 & SP137) & ASE 16; Upgrade IQ 15.4 to 16.
• MS SQL installation and upgrade from 20 service pack and troubleshoot for daily production support issues.
• Taking-care of backup & recovery and DR test plan with different data centers.
• New configuration and resource allocations as per the application requirement & consumption.
• Troubleshooting daily maintenance job failures like (dbcc, update statistics, reindex /reorg rebuild) etc…
• Working with Application team to tune their daily / weekly batches which are having the performance issues.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Confidential, Irving, Texas

Responsibilities:

• Performed benchmark which compared performance of Sybase ASE v12.5.4 and Sybase 15.0.3 ESD#4.5 and 15.5 and Subsequent incremental configuration changes as precursor to Sybase upgrade for Tier-1 OLTP Applications.
• Installing /Upgrade & configuring Sybase ASE/REP/IQ 15.0.3 & 15.7 & 15.4 in AIX & Linux.
• VTM Upgrade & configuring Sybase 15.0.3 to 15.5 /15.7 in All AIX & Linux and Sun Solaris environments.
• VMware Sybase installation on version 15.5 & 15.7,cluster fail-over and fail-back
• Capacity planning for the new applications.
• Upgraded SQL Server 2000 to SQL 2005 server for high volume processing databases on a clustered environment.
• Sybase IQ 15.4 Simplex & Multiplex support and fixed / worked on performance issues.
• Conducted database design review and made suggestions for performance improvement for critical tier 1 application, for large databases.
• Optimized poorly tuned stored procedures, improvement ranged in tens of percent to orders of Magnitude against very large databases.
• Maintained high availability of databases using Database Mirroring and Log Shipping.
• Performed DBCC utilities and fixed data corruption in application databases.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Reviewed current data server configurations and made suggestions for performance improvements.
• Installation and the configuration of the SQLbacktrack (BMC tool) for the critical servers
• Created maintenance (update statistics, reorg, Dbcc) scripts for large databases cut time required to perform by order of magnitude.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Backing up master & system databases and restoring them when necessary.

Confidential

Primary Skills: Sybase (ASE, REP, IQ) /MS SQL DBA & Developer

Responsibilities:

• Worked with PDBA DBA group to build new Sybase & MS SQL servers for development, UAT and production environments.
• Database Migration, objects partitioning, modified stored procedures which were having performance issues.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Oracle PL/SQL development and database migration.
• Troubleshooting locking and deadlock issues and informed and advised to application team for the tuning.
• Tune / update the stored procedures ; database integration and split data in partitions
• Minimized database recovery time by determining, testing and implementing backup/recovery strategy and plan for each databases.
• Worked on Log Shipping, Replication to restore Database backup.
• Installed unix scripts to establish dynamic performance monitoring, database troubleshooting and resource contentions resolution.
• Wrote scripts for taking backups and DBCCS, reorg rebuild, update statistics, transaction log dumps, error log checking, thresholds etc.
• Other DBA activities performed were creation of servers/dbs, logical/physical design of database, upgrading servers, preparing server information reports, working on performance benchmarking, server renaming, other daily server monitoring activities, etc.
• Evaluated SQL*Backtrack for all features like logical/incremental backup, object level backup/recovery etc.
• Resource Management and Configuration server level Parameters.

Confidential

Primary Skills: Sybase/ORACLE & MS SQL Developer, UNIX scripting, crystal report

Responsibilities:

• Wrote stored procedure and indexing, view, trigger and row by row manipulation via cursor.
• Carried out some BCP activities for large tables in order of 400 million rows using views to split data based on date time columns
• Tuned over 50 stored procedures and created appropriate indexes where necessary.
• Dropped clustered indexes on huge tables having 12 million rows due to deferred updates on it and not using any range queries. Replaced the clustered index by unique non-clustered indexes
• Shell/Perl scripting and major utilities for monitoring.

Confidential

Sybase & MS SQL Developer

Responsibilities:

• Provide on call 24 by 7 production support for OLTP and DSS databases.
• Wrote T-SQL scripts to deploy all newly created indexes and store procedure code files over to QA and UAT for testing.
• Data modeler and developer assigned to the Regulatory-CSE Data Warehouse.
• Wrote many stored procedures for daily & monthly crystal reports with PLSQL & Tsql
• For better performance, Optimized poorly tuned queries and stored procedures for Application .
• Developed new stored procedures for data movement and reporting.
• Rewrote key data warehouse loading procedures to improve performance and implement data range versus data point maintenance.
• Developed and tested storage strategies and disaster-recovery plan for large manufacturing company’s operational database, delivering solution that guaranteed recovery performance and high availability
• Configured server parameters such as ‘network packet size’, ‘max memory’, ‘I/O polling process count’ to improve over all server performance.
• Responsible for QA and production releases.
• Implemented index rebuild and update statistics weekly maintenance jobs.
• Developed scripts for database maintenance including backup, restore, and database consistency checking and index recreation.