Sybase Dba Resume
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