We provide IT Staff Augmentation Services!

Database Administrator Resume

3.00/5 (Submit Your Rating)

SUMMARY
An accomplished, deeply driven, Database Administrator with successful 17 year track record of success in designing and implementing database solutions that improves business functionality. Posses diversified technical background in multi-RDBMS environment. Proven ability to implement technologies that decrease cost, increase performance and positively affect the bottom line. Handle multiple assignments simultaneously and co-ordinate deliverables with key stakeholders in cross-functional groups. Implemented processes that resulted in annualized cost savings to IT department.

Technical Expertise

RDBMS:

Sybase 12.5.3, ASE 15.0, Oracle 9i/10G/11G, MS SQL Server 2000/2005/2008R2

Replication Technology:

Sybase Replication Server, Oracle Dataguard, Oracle Goldengate, SQL Server Database mirroring, SQL Server Logshipping and Replication

Languages:

Perl 5.0, PHP, C, C++, Java, Pascal, COBOL, Visual Basic, Assembly 8085/8086

Systems:

Linux, IBM AIX, HP_UX, SUN Solaris, Windows

Tools:

Visio, VMware, Veritas Cluster Server, Unix Shell-Programming, Windows PowerShell, SQL-Monitor, DB-artisan (8.0), S-Designer, ER-Win 3.5.2, Clearcase, Tivoli

Professional Experience Confidential, Oct 2006 to Present Marlborough, MA and Merrimack, NH

Principal Database Administrator, Tech lead
Fidelity Investments is one of the largest financial companies. As a lead DBA, I oversee design, implementaion and maintenance of multi-RDBMS Database environment in Define Benefits and Asset Managment divisions. I support Sybase, Oracle and SQL Server databases. I also support replication using various technologies - Sybase replication, Oracle dataguard, Goldengate, SQL Server database mirroring and logshipping. Perform upgrades; apply patches to the databases running on Solaris, AIX and LINUX platform.

  • Leading SQL Server 2008R2 High Availablity Clustering project for Equity Trade Floor databases
  • Setup Oracle Goldengate replication in Oracle source and target
  • Worked on designing and implementation of secondary site for Sybase Replication server.
  • Setup of Sybase replication in Hetrogenous environment – Sybase to Oracle
  • Performed database servers migration between various data-centers.
  • Led design and implementation of DR capabilty for Production Environment. Fine tunned DR strategy by introducing new RDBMS specific features, thus cutting in overall time.
  • Implemented Sybase MDA, for better monitoring of system.
  • Automated manual Environment refresh Processes. Received several Accolades.
  • Co-ordination between on-site and off-shore system support team.
  • Supported Schema change planning and execution in Production Environment.
  • Query Optimization & Index Management, Data-Modelling for Scalability.
  • Server and Application Performance Tuning.
  • Sybase 12.5 Replication server implementation, replication from production to Reporting and DR environment.
  • Participate in bi-annual Disaster Recovery testing.
  • Worked on Sybase IQ for Proof of concept
  • Provide 24x7 DBA support for the production environments
IBM Global Services July 2003 to Oct 2006 Confidential,MA Senior Database Administrator
  • Support DBA work for multiple accounts at IBM Global Services. These accounts include – John Hancock, IBT (now part of State Street Bank), Pearson Education, NiSource and Williams.
  • Built/Upgraded Sybase, Oracle and MS SQL Servers based on the accounts requirements.
  • Migrated critical Sybase application running on NT to UNIX in a short period of time. Fine tuned its performance. Received commendation from customer - IBT, Boston.
  • Support application releases through systest, staging and in production.
  • Tuning of the data server configurations and SQL queries to enhance the performance.
  • Worked as a Project Manager and DBA.
  • Participated in the DR test at client’s offsite location.
  • Responsible for handling day-to-day Oracle, Sybase and Informix business as usual requests.
  • 24x7 DBA support for the production environments for various IBM accounts
  • Wrote best of breed scripts, so they can be easily ported at any of the IBM accounts
Confidential,Financials Mar 2001 to July 2003 Boston MA

Senior Database Adminstrator

  • Performed DBA related tasks like – built/upgraded Sybase and Oracle database servers for development, systest, staging and production
  • Fine tuning of data server configurations and SQL queries to enhance their performance.
  • Worked as a Project Manager and DBA during applications migration. Arranged weekly meetings with various team members. Manage implementation plans using Microsoft project.
  • Worked on company’s annual offsite DR testing. Implemented/documented new process for quickly and efficiently recovering from Database Disaster.
  • Worked on Sybase Veritas Cluster Server (VCS) model and set up BCP site.
  • 24x7 DBA support for the production environments

Confidential,Aug 1995 to Feb 2001

Malden MA

Consultant Database Administrator and Performance Tuning Analyst
Worked at following Clients:

Fidelity Investments, MA – Database Administrator (Mar 1998 – Feb 2001)
    • Responsible for Installing, upgrading Sybase and SQL Servers 2000.
    • Provided problem resolution on all supported systems.
    • Developed database-monitoring system using CGI-Perl on Internet Information Server.
    • Confidential,IL - Database Administrator (Aug 1997 – Feb 1998)
    • Responsible for administering the database activities for the \'NxTracs\', an option clearing system.
    • Performed system evaluation for the CORBA compliant Object Database Management System viz., Object Store 4.0.2, Versant and Persistence Services.
    • Confidential,IL - Performance and Tuning Analyst (Feb 1997 – Jul 1997)
    • Responsible for tuning the Decision Support System for its performance and optimization.
    • Optimized the database objects - index, query and stored procedure.
    • Confidential,IL - Performance and Tuning Analyst (Sep 1996 – Jan 1997)
  • Analysis of new and existing applications in terms of the data server and OS configuration.
  • Developed the test scripts in Perl/Shell/SQL to check the usage pattern of various resources for their load and performance. The list includes - CPU, I/O, Network loads and Memory usage.
  • Used Load Runner tool to simulate the production load and capacity-planning of the system
    • Confidential,IL - Database Developer (Aug 1995 – Sep 1996)
  • Responsible for developing the Personal Benefit (401K) module of the \'Human Resources Development\' application.
  • Wrote stored procedures, Perl and SQR scripts. Involved in tuning of its VRU System.

Confidential,Apr 1994 to Feb 1995

India

Senior Database Programmer

  • Designed and developed Purchase Order module of the \'Inventory Management System using Sybase.
  • Developed front-end application using Sybase-APT workbench and C-language.

Confidential,Jul 1993 to Apr 1994

India

Programmer

  • Developed an On-line Inventory Management System for an outlet store.
Education
  • Masters in Computer Science
  • Bachelors in Computer Science

We'd love your feedback!