SUMMARY:

• 12.5 years of experience in all phases of SDLC development of Enterprise - level applications including Design, development, implementation and maintenance, data modeling, SQL coding, stored procedure and trigger development, Relational Design, Referential Integrity, Index strategies, SQL Troubleshooting.
• Certified Database Professional and Administrator wif experience in maintenance, security, backup and recovery
• Production DBA experience in Sybase ASE 12.5 and 15, Sybase Replication server 15.2 and MS SQL Server database administration and management.
• Extensive experience in database migration from Sybase ASE 12.5 to Sybase ASE 15
• Extensive experience in Sybase Replication server 15, Sybase SQL anywhere and Sybase IQ.
• Proficient in MS SQL server 2000, MS SQL server 2005 and MS SQL server 2008 database administration and management
• Experience in SQL Server Data Tools (SSDT) and SQL Database Projects
• SQL server administration using Microsoft SQL Server Management Studio, Enterprise Manager and Query Analyzer
• Experience in database performance tuning and optimization in MS SQL server 2012 and Sybase ASE
• Proficient in Oracle 8i, Oracle 9i and Oracle 10g
• T-SQL and PL/SQL programming and development
• Extensive experience in Control-M and Crontab.
• Ability to architect an Enterprise Data Management solution and provide business, governance and technical recommendations
• Extensive experience in Unix Shell scripting in Bourne Shell, Korn Shell and C-shell.
• Experience in SQL Server Business Intelligence Develop Studio.
• Performance tuning of Stored Procedures, triggers and SQLs.
• Strong implementation experience and deep knowledge of data quality and data governance.
• Data Modeling experience using ERwin Data Modeler 7.3.10 and 9.5
• Experience in working wif Visual Source Safe (VSS), PVCS and Subversion(SVN)
• 5 years of experience in IT Management and proven success in team management
• Experienced in onsite and offshore coordination and management
• Experience in developing statement of work (SOW), task orders and request for proposal (RFP)
• Experience in information systems technology, project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning, and tracking of results.
• Act as a liaison between management, clients, and personnel.
• Experience wif Software Development Processes & Models: Agile, Waterfall & Scrum Model.
• Exude confidence and communicate well. My managerial skill, leadership quality and technical skill is asset to any Project Team.
• Good team player wif excellent interpersonal communication skills. Highly motivated and can adapt to work in any new environment. Strong Analytical Skills.

TECHNICAL SKILLS:

Programming: : T-SQL, PL/SQL, C, Power builder, VB .NET.

Scripting: : Shell Scripting, AWK scripting, B-Shell, C-Shell, K-Shell

Frameworks: : .NET 1.1/2.0/3.0/3.5

Database: : Sybase ASE 15, Sybase ASE 12.5, SQL Anywhere 8, Sybase IQ, Sybase Replication Server 15, MS SQL Server 2012/2008/2005/2000, Oracle 8i, Oracle 9i and Oracle 10gReporting: : SQL Server Business Intelligence Develop Studio, Crystal Reports

Version Control: : Subversion (SVN), Visual Source Safe (VSS), Windows PVCS, UNIX PVCS

Operating Systems: : Unix Sun SOLARIS, AIX, Windows 2000/XP/2003/2008

Tools: : ERWin Data Modeler 7.3.10 & 9.5, Sybase Central, Control - M, Crontab,Rapid SQL, DB Artisan, Putty, TOAD, WS FTP, Microsoft SQL Server

Hardware: Solaris 2.5.1 / 2.6 / 7 / 8 sparc 5 / sparc 10 / E250 / E 450 / E3500 /

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NY

Sybase Data Architect

Responsibilities:

• Enterprise Data Architect: Responsible for developingenterprise data strategy.
• Designed and maintained data warehouse system using Sybase IQ 15.2 and 15.4
• Monitor dumps, DBCC, update stats task run to completion.
• Designed and developed scripts for administrative tasks like backups, DR Flip, Access control and tuning.
• Manage Sybase ASE and Sybase IQ database server in both non production and production environment.
• Installed and configured Sybase IQ 16
• Upgraded Sybase IQ 15.2 to Sybase IQ 16

Environment:Sybase IQ 15.2 and 16, Sybase ASE 15.7, Java, EJB, Spring, Shell Scripts, Control - M, Crontab, Aqua Data Studio 14.0, Bitvise, Linux, ERWin Data modeler, Subversion, SAP Business object BI 4.0, Open Pages

Confidential, Tampa, FL

Sybase DBA/Architect

Responsibilities:

• Managed 2 production and 8 non production servers
• Provide 24 X 7 Pager support
• Monitor dumps, DBCC, update stats task run to completion.
• Designed and developed scripts for administrative tasks like backups, DR Flip, Access control and tuning.
• Manage Replication Server for both Sybase to Sybase and Sybase to Oracle
• Using sp sysmon to evaluate server level performance. Tuning configuration and server parameters.
• Monitoring and optimizing database performance.
• Performing Benchmarks and fine tuning Sybase 15 ASE Servers.
• Performance monitoring - Monitoring memory, CPU utilization, disk utilization, locks, deadlocks, runtime of queries.
• Script writing and editing for Sybase related batch jobs.
• Data Modeling using Erwin Data Modeler 7.3.10 & 9.5
• Set-up user groups and accounts for Role based Access Control (RBAC) to facilitate system administration.
• Database Design and Performance Tuning
• Created indexes to help optimize queries and improve performance.
• Fine tuned SQL queries and Stored Procedures to improve performance
• Distributed tables on different devices to reduce disk me/O contention
• Project lead and Onsite coordinator for offshore team

Environment:Sybase 12.5, Sybase 15, Replication Server 15, VB.NET, ASP.NET, XML, MSMQ, MQ Series, Shell Scripts, T-SQL, Control - M, Crontab, Rapid SQL, DB Artisan, Crystal Report, UNIX Solaris, AIX, Sybase Central, ERWin Data modeler, VSS, PVCS, Subversion

Confidential, Oldsmar, FL

MS SQL Server Admin

Responsibilities:

• MS SQL Server 2005 Database administrator
• Provide 24 X 7 Pager support
• Supported production and non production environments
• Monitoring and optimizing database performance.
• Performing Benchmarks and performance tuning of SQL server 2005
• Going through the clients' requirements and coming up wif database design and application architecture.
• Providing consultation on SQL Server to our development teams.
• Installing, configuring, administering and securing Test servers.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Writing code and creating Control-M jobs to automate administration tasks.
• Onsite coordinator for offshore team

Environment:ASP.Net 3.5, C#.Net, Visual Studio 2003, MS SQL Server 2005, Microsoft SQL Server Management Studio, Enterprise Manager, Query Analyzer, Agile (Scrum) methodologies, UNIX and Windows PVCS

Confidential, Oldsmar, FL

SQL Server Administrator

Responsibilities:

• MS SQL Server 2005 Database administrator
• Provide 24 X 7 Pager support
• Supported production and non production environments
• Worked on running update statistics and query optimization, and automated the backup procedure for backing up & restoring the user databases.
• Developed the Shell script for generating the SQL statement for creating the Create database statement wif Alter database statement and setting the database options.
• Responsible for planning and development of enhanced Application life cycle. Study and analysis of current system and business process and integration of new Business enhancements required in the existing system.
• Participated in the design and development of the Confidential international edition website
• Implemented Agile Scrum methodologies for developing the application.
• Developed backup & recovery plan for backing up & restoring the system & user databases.
• Worked wif QA testing group to put the new releases on the Production servers.

Environment:ASP.Net 3.5, C#.Net, Visual Studio 2003, MS SQL Server 2005, Microsoft SQL Server Management Studio, Enterprise Manager, Query Analyzer, Crontab, Control-M, Agile methodologies.

Confidential, Oldsmar, FL

Oracle Developer

Responsibilities:

• Worked in conjunction wif other DBA in Administration of Oracle data servers.
• Development using PL/SQL
• Analysis & design of logical database. Implementation of the relational database from a logical database
• Performed the tuning analysis of the databases & tuned the parameters to improve the performance.
• Created database, users & roles, profiles and managed the rollback segments, table spaces & Indexing.
• Developed the shell script for purging the various logs and archive files & script for creating the database metrics of various in-house projects
• Developed the script for finding out the table space
• Developed the shell scripts for taking the physical & the logical database backups
• Created Control-M jobs for daily batch jobs
• Provided the 24x7 on call Production Support for the project

Environment:UNIX, Solaris, J2EE, WebLogic Server, JAVA, Applet, Shell Scripts, TOAD, Oracle 8i, MS Access, Crontab, Control-M, UNIX and Windows PVCS

Confidential, Oldsmar, FL

System Engineer and Sybase DBA

Responsibilities:

• Worked in capacity of both Application Developer and Sybase DBA
• Going through the client’s requirements and coming up wif database design and application architecture.
• Worked on Sybase ASA and Sybase IQ.
• Monitoring and optimizing database performance by Monitoring memory, CPU utilization, disk utilization, locks, deadlocks, runtime of queries.
• Providing consultation on Sybase to our development teams.
• Designed database & developed SQL queries and stored procedures, table using Sybase ASE.
• Created indexes to help optimize queries and improve performance.
• Fine tuned SQL queries and Stored Procedures to improve performance
• Worked in Client - Server architecture and Application development using PowerBuilder 9.0, C, Shell Script
• Provided 24-7 production support for dis application and database
• Project lead for Application development and Maintenance.
• Migrated Cron jobs to Control-M
• Provided the 24x7 on call Production Support for the project
• Onsite coordinator for 6 member offshore team

Environment:Sybase 12.5, Adaptive Server Anywhere, Sybase IQ, C, Power Builder 7.0, Power Builder 9.0, Shell Scripts, T-SQL, ISQL, Control M, Crontab, Rapid SQL, DB Artisan, SQL Server Business Intelligence Develop Studio, UNIX Solaris