We provide IT Staff Augmentation Services!

Sybase Dba Resume

3.00/5 (Submit Your Rating)

Washington, DC

Summary of Qualifications

•Over 16years of Database administration experience in Sybase ASE, Sybase IQ, Sybase Replication Server,ORACLE and Microsoft SQL Server

•Certified MS SQL Server DBA and technology specialist

• Extensive experience in database architecture,Data warehouse administration, conversion of data to/from various data sources anddatabase design and modeling.

•Extensive general IT skills covering Unix and various programing languages/scriptings

Specialization
Ø Specialized in all aspects of database design and programming with Sybase Adaptive Server Enterprise, Replication server and Sybase IQ Server and Oracle
Ø Data modeling, Database design, Transact SQL programming and Open Client programming
Ø performance & tuning issues and troubleshooting and security administration
Ø Long-standing experience with Sybase Adaptive Server enterprise (ASE) covering versions 10.x 11.0, 11.5, 11.9, 12.0, 12.5 and 15.0, starting in 1995.
Ø Experience with Sybase IQ database 12.0 and 12.5.Experience with Sybase Replication Server 12.0, 12.5 and 12.6. Experience with Open Client versions 10.x, 11.x, 12.0, 12.5 and 15.0 .
Ø 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 ETL
Ø Experience in Sybase SQL Anywhere and Sybase mobile technology.
Ø Experience in Microsoft SQL Server 2005/SQL Server 2008 database administration.
Ø Experice in Sybase IQ Server(data warehouse)

SKILL SUMMARY


RDBMS

Sybase ASE

Sybase IQ Database

MS SQL Server

Oracle

MS Access

Sybase ASA

Database Tools

Sybase Open Client

Sybase Central

DB Artesian

ER/Win

Cast Work bench

Power Designer

PROGRAMMING LANGUAGES

C/C++

JAVA & BROAD VISION

CLIENT –SERVER

Visual Basic & Power builder

Oracle Developer/2000 &, PL/SQL, SQL

OPERATING SYSTEMS

UNIX

VMS

WINDOWS

Novell Netware

JAVA DATABASE

JDBC, Sybase jConnect, mSQL JDBC Driver, CGI-DB Interface

Shell script & Perl Script

Education:

MS in Computer science

PROFESSIONAL QUALIFICATIONS


Mar 2007 – Till date

Confidential,Washington DC –Sybase DBA

Sybase ASE, Sybase ASA ,Sybase IQ,SQL Server 2005,
Windows 2003
and Shell Script

Responsible for Sybase ASE, Sybase IQ, Sybase Replication server and Microsoft SQL Server database administartion. Primarly responsible for database design, datawarehouse administartion. Monitor disk space, database health checks, database backups and error log scanning. Configure Servers to achieve the best performance and writing automated database monitoring scripts.

Nov 2006 – Mar 07

Confidential,Herndon VA –Sybase DBA

Sybase ASE,Oracle DB Artesian,UNIX
and Shell,PERL Script

Responsible for database administration/maintenance including database servers installation, logical/physical data modeling, 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 databases, Diagnosing system problems, Configuring Adaptive Server to achieve the best performance ,tuning, monitoring the server activity, Writing stored procedure, Replication & scheduling activities and all other database activities.

Writing CRON job scripts for data loading, migration, processing etc., by using c-shell and Perl script and I am very strong in SQL.

Jan. 2000 – Oct 2006

Confidential,Crystal city, VA –Sybase DBA

PC, UNIX, SYBASE ASE, Sybase IQ,SQL ADVANTAGE,SYBASE CENTRAL,DB ARTICIAN ERWIN,& CAST WORK BENCH

Responsible for administering the database maintenance including Sybase SQL server and backup server installation, logical/physical data modeling, 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 databases, Diagnosing system problems, Configuring Adaptive Server to achieve the best performance ,tuning, monitoring the server activity, Writing stored procedure, Replication & scheduling activities and all other database activities.

Writing CRON job scripts for data loading, migration, processing etc., by using c-shell and Perl script and I am very strong in SQL.

Aug 1999 – Dec 99

Confidential,Washington DC –Contractor

Sybase ASE, UNIX, SQL Server

Main Responsible for administering the database maintenance including SQL server installation, Devices creation, database creation, user maintenance, System security, data modeling, designing of the physical and logical database designing, estimating table space management, query optimization, performance tuning, Replication & scheduling activities and building a front end application. Additional tasks included writing stored procedures, triggers & front-end source code development, source code control, and production upgrades and installations.

Apr 1996 –Jul 99

Confidential,AP,India –Employee

PC, UNIX, SYBASE,SQL Server, ERWIN,DB Artisan, VB, PB & PERL

I worked more than 4 years as senior Database Administrator/Project leader/Manager systems. Involved closely in administration (Data center setup, definition, monitoring, and management, Version migration, installations, writing automatic back up procedures, security maintenance, estimating table space, recovery the damaged databases diagnosing the system problems and all other database activities) and application performance tuning efforts (responsible for all server side tuning). Set up and automated administration of whole environment. In addition to involve with developer on front-end code development.

June 1995 – Mar 96

Confidential,Hyderabad, India

PC, SYBASE, Novell NetWare 4.10

Data analyst responsible for the design of the logical and physical database models for a corporate-wide planning system. Analyzed data requirements from application requirements and external data sources. Designed database tables, cross-database transactions, referential integrity triggers, views, and stored procedures. Documented the entire database design

We'd love your feedback!