TECHNICAL SUMMARY:

• Over 10 years of total IT experience with SQL Server2005/2008/2012, Sybase ASE,IQ, Replication Server/SQL Server/Oracle/Teradata Server Development/Administration, Java, Asp.net.
• Extensive expertise in performance tuning for maintaining indexes, block processes and slow performance and configuring the Sybase Adaptive Enterprise Servers and experienced in supporting 24X7 production systems.
• Expertise in backup and recovery, T-SQL programming, Sybase ASE security and directory services option, building ETL solutions using SSAS, SSRS and SSIS packages.
• Experienced in setting up auditing and capacitive planning, Data Modeling Logical and Physical design of databases , normalization and building referential integrity constraints.
• Experience in creating multidimensional data model and creating SSAS Cubes, SQL Profiler, execution plan, performance monitor and DBCC commands, Replication snapshot, merge and transactional.
• Good knowledge in log shipping and mirroring and clustering concepts.
• Experienced in administrating, maintaining, configuring and monitoring of database on Sybase Adaptive Server Enterprise/IQ/SQL Server.
• Experienced in table recovery and repair in case of corruption, running database consistency checks and fixing the bugs.
• Strong expertise in T-Sql, PL/SQL.
• Experienced with planning and testing disaster recovery and fail-over tests.
• Have extensive knowledge in Web Technologies such as HTML,AJAX, DHTML, XML and XSLT.
• Good knowledge in Operating System fundamentals.
• Excellent communication, problem solving and interpersonal skills.
• Self-motivated team player with an ability to adapt in different environment quickly.

TECHNICAL SKILLS:

EXPERIENCE:

Confidential

Senior Database Administrator

• Responsible for migration of ASE 12x to 15.5/15.7x, IQ 12.7 to 15.2, SQL server 2005 to SQL server 2012, created data warehouse models and building reports using TSQL.
• Actively involved in Database Design, giving consultation to development/business teams and worked in troubleshooting performance issues.
• Created E1/E2/E3 databases instances and maintained their standards, automated code release process for all the modules in the repository.
• Worked on developing a backup and recovery plan using EMC technologies, recovering the suspect databases up to the point of failure.
• Created a watch script that will monitor the server and bring up the server without on call DBA support in case of failure.
• Completed end to end installation of electronic password vault in order to maintain high level security for application ID's, audit database, SQL profiler and MDA tables on the database side.
• Automated index rebuild, stat update, performance recommendation to the business.
• Created reports for business using Shell and Perl scripting.
• Created an automated load script for business so they need not worry about data types and index selection and automated code release for E1/E2/E3 environment.
• Worked on table level archive and exception reports for both ware house and production tables, script automation for IQ/ASE/SQL servers.
• Setup database recovery plan and automated for both SQL server and Sybase IQ/ASE.
• Created home grown tool in Sybase ASE for monitoring and controlling the entire database like Sybase IQ/ASE, Oracle and Teradata.
• Installed and maintaining oracle RAC server on the cluster.
• Prompt response to incidents on production system and troubleshooting of hardware and software issues therefore minimize the impact on customers and revenue.
• Created roles, users and separate security schema based on the schema definition.
• Taking regular backup of transaction logs and databases.
• Performing weekly maintenance of dbcc, drop and recreating index jobs on production servers.
• Installed Hadoop clusters on the environment.
• Created cubes for business enhancements using SSAS.
• Designed reporting solution using SQL Server Reporting Services SSRS .
• Created drill through, drill down, sub reports in SSRS.
• Create report subscription, scheduling in SSRS.
• Currently, leading both onshore and offshore DBA team.
• Won the Best innovation award.

Environment: Solaris 2.9/10, SQL Server 20012 R2,Sybase ASE 15, DB2 , SYBASE Adaptive Server Enterprise 12.5.3/15.0/15.7, SYBASE Replication Server 12.5/12.6/15.7,Sybase IQ 12.5/15.4, Oracle 11.0.2, DBArtisan 8x, WINDOWS NT, Exceed X-Windows.

Confidential

Database Administrator

• Maintained, installed and administered databases on Sybase Adaptive Server Enterprise 12.0/12.5 and 12.0 and Oracle 8x/9x.
• Monitored database server performance and reviewed database maintenance plans.
• Mirroring of devices was done to recover important database due to suspect on primary database or when primary DB was not loaded.
• Monitored Sybase data servers and replication server for performance.
• Configured, and monitored the Sybase to achieve the best performance.
• Worked with third party tools like DBArtisan.
• Devised and implemented backup strategies for Sybase OLTP databases.
• Designed and developed table structures, transact - SQL stored procedures and triggered to implement business rules.
• Created and altered user databases, setting up user accounts, granting permissions, monitoring server activities and fine tuning.

Environment: Linux, SUN Solaris 2.8, SYBASE ASE 12.5, SYBASE Replication Server 12.5, Oracle 9x, Putty, Hummingbird, WINDOWS NT

Confidential

Software Engineer

• Administered and maintained databases on Sybase Adaptive Server Enterprise 12.0 on Sun Solaris 2.8
• Configured and monitored the server to achieve the best performance.
• Designed and developed table structures, transact SQL, stored procedures and triggers to implement business rules.
• Monitored Sybase data servers and replication server for performance.
• Created and altered user databases, setting up user accounts, granting permissions, monitoring server activities and fine tuning.
• Monitored availability of the server, checking for free space using threshold procedures.
• Took regular backups of transaction logs and database.
• Analyzed and resolved the root causes for the deadlocks occurring in production system.
• Scanned error message for checking consistency and fixing them.
• Devised and implemented backup strategies for Sybase OLTP databases.
• Applied patches for Sybase ASE server.
• Updated the statistics.

Environment: Sybase Adaptive server enterprise 11.5.x, SUN Solaris 2.8/2.7,IBM AIX, WINDOWS NT

Confidential

Software Programmer

• Developed Visual basic and Java code for local vendor application.
• Given guidance for a lot of undergraduate students.
• Conducted various training program for students regarding Java and Visual basic programming language.

Environment: Java, Oracle and visual basic 6.0