SUMMARY

• Ardent, successful DBA with 10+ years of experience in Information Technology industry
• Proficient in handling Sybase, Oracle, and SQL databases
• Experienced in installing and upgrading Sybase, Oracle, and SQL databases from older to newer versions
• Adept in migrating Sybase database from 12.5.x version to 15.5
• Maintained replication environment without any outage
• Experienced in analyzing query plans, managing indexes and locks, and troubleshooting deadlocks
• Experienced in recovery of databases in Oracle, SQL, and Sybase during decisive times
• Competent to tune SQL, Sybase, and Oracle databases to facilitate fast queries and reports
• Experienced in point - in time recovery of databases
• Experienced in migration of Sybase databases to SQL server databases
• Well-versed in recreating the Sybase database with all data intact using bcp utility
• Proficient in troubleshooting issues like database corruption in Sybase databases
• Experienced in creating and debugging stored procedures and triggers in Sybase and SQL databases
• Proficient in maintaining Oracle 8i, 9i, and 10g databases for various applications
• Expertise in creating Unix scripts to schedule Oracle database maintenance jobs
• Efficient in handling scripts using SQL loader and SQL*Plus applications
• Acquaintance with third party tools like TOAD and DBArtisan
• Experience in maintaining backup and recovery of Oracle database using SQL backtrack tool
• Implemented log shipping method of replication in SQL server
• Managed MIS application and delighted entrepreneurs by generating reports using Power Builder complying with their specifications. Also generated data with Ad-hoc queries using Transact-SQL
• Well-versed in VB codes and EXCEL Macro
• Expertise in analysis, design, and development of interactive and classical reports in a major financial software (Tally)

TECHNICAL SKILLS

Operating Systems: Microsoft Windows, Sun Solaris, IBM-AIX, UNIX, LINUX

Languages: Visual Basic, UNIX Shell Scripting

Databases: Oracle 8i, 9i, and 10g, Sybase 12.5.x, MSSQL 7, SQL Server 2000/2005

Tools: Sybase Central, iSQL, SQL Advantage, bcp Power BuilderSQL backtrack, TOAD, DBArtisan, SQL*Plus, SQL Loader, EXPSQL Query Analyzer, Enterprise Manager

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Senior Database Administrator

Responsibilities:

• Provided 24/7 database support for the application Mail-Order Rx
• Installed and upgraded Sybase ASE
• Created databases and outlined backup strategies for varied databases
• Fine-tuned server performance
• Expertise in security administration by creating users with appropriate roles
• Created and managed database objects like Tables, Views, Indexes, Sequences, and Synonyms
• Troubleshot challenging issues
• Refined long-running SQL queries to cut down execution time, ease database load, and improve scalability
• Consistent monitoring of daily and transaction backups helped in easy restoration of data during database crash
• Expertise in point-in time recovery of databases
• Framed Shell scripts to schedule database maintenance jobs
• Maintained Sybase replication database environment
• Experienced in refreshing databases in test environment catering to client’s specifications
• Migrated Sybase databases from 12.5.4 to 15.5
• Checked the increased rate of latency in replication databases when necessary
• Designed table-specific replication environments tailored to business needs
• Maintained multiple temporary databases

Environment: Sybase ASE 12.5.4, Sybase ASE 15.5, Sybase Central, SQL Advantage, bcp, DBArtisan, AIX, Sybase replication 12.6

Confidential, Smyrna, TN

Senior Database Administrator

Responsibilities:

• Supported 24/7 applications related to finance domain (Lease Pack and View star document processing)
• Installed and upgraded Sybase ASE, Oracle, and SQL databases
• Succeeded in 24/7 support for Sybase, Oracle, and SQL databases
• Designed system architecture for varied databases
• Created databases and outlined backup strategies for varied databases
• Developed automated scripts for checking ASE availability, database backup, and DBCC
• Monitored server performance and transaction log growth consistently
• Expertise in security administration by creating users with appropriate roles
• Experienced in refreshing test database with production database using automated scripts
• Involved in recovery of master/user databases and master device in SQL and Sybase during decisive times
• Created and managed database objects like Tables, Views, Indexes, Sequences, and Synonyms
• Tuned SQL, Sybase, and Oracle databases by examining current workloads and hardware and making improvements on a regular basis to facilitate fast queries and reports
• Troubleshot challenging issues
• Refined long-running SQL queries to cut down execution time, ease database load, and improve scalability
• Monitoring backups constantly helped in easy restoration of data during database crash
• Expertise in point-in time recovery of databases
• Maintained Oracle 8i, 9i, and 10g databases for various applications
• Tuned SQL queries using DBMS statistics in Oracle
• Experienced In refreshing databases using Oracle Export/Import utility
• Succeeded in upgrading Oracle databases from older versions to 11g
• Created Unix scripts to schedule Oracle database maintenance jobs
• Implemented log shipping method of replication in SQL server
• Experienced in refreshing databases in test environment catering to client’s specifications

Environment: Sybase 12.5.3, Sybase Central, SQL Advantage, bcp, Oracle 8i/9i/10g/11g, EXP, IMP, Toad, DBArtisan, SQL Backtrack, SQL Server 2000/2005/2008 , MSSQL 7, iSQL, SQL Query Analyzer, Enterprise Manager, Excel Macro, Visual Basic, Unix, Sun Solaris, Windows

Confidential

Database Administrator

Responsibilities:

• Migrated databases from Sybase System 11.x to ASE 12.5.3
• Worked as an OnCall DBA providing 24/7 support for Sybase database
• Recommended design for the system architecture
• Worked on installing and configuring Sybase ASE 12.x and Sybase IQ
• Created user databases and devised backup strategies
• Experienced In refreshing databases using Oracle Export/Import utility
• Succeeded in creating users and administering security policies
• Optimized performance analysis and tuning
• Scheduled log checks and DBCCs
• Created and managed database objects like Tables, Views, Indexes, Sequences, and Synonyms
• Experienced in maintaining table space allocations
• Expertise in point-in time recovery of ASE 12.5.x database
• Recreated the database with all data intact using bcp utility
• Managed MIS application and delighted entrepreneurs by generating reports using Power Builder complying with their specifications. Also generated data with Ad-hoc queries using Transact-SQL.
• Proficient in troubleshooting issues like database corruption and query performance problems
• Developed an online charging system for VAS subscription and downloads
• Handled varied applications that support the prepaid billing system

Environment: Sybase 12.5.3, Sybase 11.x, Power Builder, iSQL, Sybase central, Oracle 8i/9i, Toad, SQL Server 2000, Visual Basic, Unix, Windows

Confidential

Senior Programmer

Responsibilities:

• Installed and configured Sybase ASE 11.x
• Created databases and developed backup strategies
• Created users and appropriate security policies
• Improved query performance
• Structured databases and designed modules for Payroll Application
• Had written VB codes for diverse applications
• Monitored SQL production databases in client’s place
• Expertise in analysis, design, and development of interactive and classical reports in Tally Definition Language
• Customized tables and screens

Environment: Sybase 11.x, isql, Sybase central, Visual Basic, Windows, Tally Software

Confidential

Programmer

Responsibilities:

• Involved in analysis, design, development, and testing of classical, interactive reports. Also customized the fields, tables, screens, and menus. Dealt with applications like bug tracking, leave application, and employee tracking.
• Developed and maintained SQL databases
• Customized Accounting and Production Control and Office Automation and Production Planning software catering to client’s specifications

Environment: Visual Basic, iSQL, SQL Server 2000, Windows