SUMMARY:

More than 12 years of DBA experience in Sybase/MS SQL/MySQL/Oracle with strong technical expertise in Unix/Linux/Windows NT operating system. Also has database stored procedure, SSIS/DTS and Unix shell Perl script programming and UNIX/Linux system administrator experience

TECHNICAL SKILL:

Databases: MS SQL, Sybase, Oracle, MySQL Informix, DB2

Operating Systems: Windows NT, Unix Solaris & Linux(Redhat/Suse)

Software: Dbartisan, Rapid SQL, Erwin

Languages: T - SQL,PL-SQL C++, HTML, Korn shell, C shell, Perl, VB/Java Script, Python

EMPLOYMENT HISTORY:

Confidential, New York, NY

Senior Database engineer (Sybase, MS SQL)

Responsibilities:

• Experience in installation, configuration and migration with both Sybase and MS-SQL database platforms
• Assist developer/QA/Customer support teams to solve issues, answered questions, tuned performance, performed troubleshooting.
• In charge of Database schema change/Release on QA/Production.
• Pr ovide 24/7 on call production support on rotation basis
• Carry out maintenance jobs including weekly update statistics and monthly rebuilt indexes.
• Install/Configure database Server, Backup Server PC client with relevant software, EBF/patches.
• Manage customer data content base on client contract.
• Prepare SQL/shell script for release /maintenance/fixing issue and schedule job on weekend. work on fixed income data distribution for Confidential corp, derivs.muni,bank loan, new cmo, pricing build client racks/entitle data contact and assist 1st line support for installation at client. develop script to check row-count on contact weekly and fix it if not match designing, building, and supporting the components of business intelligence services such as ETL processes, data warehousing, and analytics reporting tools
• Responsible for all aspects of database administration including requirements gathering, database management systems (DBMS) architecture design, DBMS installation and configuration, performance monitoring and tuning, database security, data back-up, recovery, planning, and capacity planning.
• Develops and automates ETL processes that involve error and reconciliation handling utilizing
• Microsoft SQL Server Integration Services (SSIS)
• Establishes documentation for procedures and processes required to maintain the integrity and operation

Confidential, Oceanport, NJ

QA Engineer (Sybase, MySQL, Oracle, DB2, MS SQL)

Responsibilities:

• Install/Configure Sybase, MySQL, Oracle RDBMS with relevant software patches on UNIX,,Linux and Windows
• Install/configure/partition Operating system such as UNIX (Solaris),Linux(Redhat,Suse),Windows Servers
• Prepare testing environment including OS/hardware, client machines, LAN, router. maintain servers including add/remove users, DNS(NIS+),service pack, firewall setup, software installation, daily backup.
• Maintenance Web page for testing information with IIS web servers.
• Design test case for software function, data protection, and data recover performance and stress testing
• Tracked and managed the testing progress
• Created detail modification request (report bug found) and work with software
• Developer to track down and solve the problem found. develop the code for automation testing using Python

Confidential, New York, NY

Sybase Database/MS SQL Administrator

Responsibilities:

• Install/Configure Adaptive Server, Backup Server and Replication Server, with relevant software, EBF/patches.
• Perform Database Performance tuning (data/log devices size, procedure cache, data cache, buffer pool, cache bindings, tempdb, partition table, index...) manage / troubleshoot Sybase Replication servers
• Was on 24 x 7 Production DBA Support
• Wrote Korn shell script to automatically perform DBA routine tasks fed data and generated nightly report for clients
• And checked all the systems with notification.
• Monitored Database server performance. carried out daily DBA routine jobs such as adding/removing users, creating databases, tables, and indexes, compiling store procedures and triggers, backing up and recovering, and checking database consistency
• Assisted with projects relating to Database administration and cooperated with other IT teams based on project requirements.
• Installed and configured MS SQL Server 6.5/7/2000/2005 with relevant software, patches
• Configured log shipping database between MS SQL servers in US
• Created/Designed DTS package in MS SQL server for system integration project.
• Configured SQL Server Agent to send notifications to operators with respect to jobs, event, and performance conditions.
• Implemented replication ( snapshot, transactional, merge), configuring publication, pull subscription, push subscription.
• Created and configured SQL server virtual server on failover cluster.
• Used SQL profiler, system monitor and showplan to investigate performance problems.
• Managed access and server permissions.

Confidential, New York, NY

SQL Developer and Unix/Linux System Administrator

Responsibilities:

• Installed and configured Unix Solaris 7,8,9,10/Linux Redhat 2.1 Servers with patches.
• Created Raid file system, Resolving UFS File System Inconsistencies, Setting Up and Configuring NIS Service.
• Scheduled System Tasks, Monitoring System Performance, Adding or Removing a Software Package,.
• Shut Down and Booted Systems, Upgraded firmware.
• Perform Troubleshooting on Software Problems, File Access Problems, Software Package Problems
• Replaced hardware ( RAM, HDD…..)
• SQL Developer carried out Database Performance tuning (data/log devices size, procedure cache, data cache, buffer pool, cache bindings, tempdb, partition table, index...)
• Monitored system resource usage (disk, CPU, memory, IO) carried out troubleshooting database log full, process locking, data/log segment full, tempdb full….
• Carried out daily DBA routine jobs such as add user, created databases, tables, and indexes, compiled store procedures and triggers, backup and recovery….
• Performed nightly Database backups. Executed Database Consistency Checks and updated table statistics on a weekly basis. Reviewed and confirmed all Logs produced by nightly and daily jobs
• Provided technical support for development team and client support team
• Stored Procedure, Triggers, T-SQL DTS programming for system integration project.
• Migrated database among Oracle, Sybase, MS SQL for client's database
• Wrote Korn shell script to automatically perform the DBA routine tasks.
• Wrote script to synchronize data for client's database problems.
• Reviewed, tested, and implemented script. provided technical consulting related to databases.