We provide IT Staff Augmentation Services!

Ms Sql Server And Sybase Dba/developer Resume

3.00/5 (Submit Your Rating)

Chicago, IL

SUMMARY

  • I have over 18+ years of IT industry experience, mostly working with Sybase, Sybase IQ, and MS SQL Server as a Data Modeler, Sybase DBA, and MS SQL Server DBA.
  • I have worked as a production DBA and a development DBA.
  • I have excellent skills in Transact SQL and T - SQL.
  • I have done data modeling in both transactional and data warehouses.
  • I have developed stored procedures and triggers.
  • I have done extensive performance tuning on both Sybase and MS SQL Server.

TECHNICAL SKILLS

Hardware/Operating Systems: Linux, Solaris, AIX, HP-UX, Windows NT, Windows Server

Development Languages: C, C++, K Shell, Perl, VB, VC++

DBMS Software: MS SQL Server, SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), MS SQL Server Integration Services (SSIS), Sybase ASE 11.5 - 15.5, Sybase System XI, Sybase IQ 12.x-15.4, Sybase Replication Server, Oracle 8.0-9i, T-SQL, Transact SQL, PL/SQL, SQL-Backtrack, Oracle Enterprise Manager, MS

PROFESSIONAL EXPERIENCE

MS SQL Server and Sybase DBA/Developer

Confidential, Chicago, IL

Responsibilities:

  • Install and configure MS SQL Server, Sybase ASE, Sybase IQ, Sybase Replication Server
  • Perform daily administration of development and production instances/servers
  • Perform upgrades of MS SQL Server and Sybase
  • Perform database backup and recovery of MS SQL Server and Sybase
  • Develop scripts/processes to monitor databases and perform general DBA tasks
  • Perform database tuning and performance optimization on MS SQL Server and Sybase
  • Optimize indices and tuned stored procedures on trade tables
  • Provide 24/7 production support
  • Work with developers to review, tune, and optimize their SQL and stored procedures
  • Interview traders and developers to gather business requirements
  • Develop logical and physical data models based on business requirements
  • Develop and tune stored procedures and triggers
  • Design and built extract, transform, and load (ETL) processes

Environment: MS SQL Server, Sybase 12.5 - 15.5, Sybase IQ 12.7-15.4, Windows Server, Linux, Solaris, SSRS, SSIS, SSAS

Sybase DBA

Confidential, New York

Responsibilities:

  • Install and configure Sybase, Sybase IQ, Sybase Replication Server, and Oracle
  • Perform daily administration of development and production instances/servers
  • Perform Sybase upgrades
  • Design backup and recovery strategies for Sybase and Oracle
  • Perform database backup and recovery Sybase and Oracle
  • Develop Perl and UNIX scripts/processes to monitor databases and perform general DBA tasks
  • Perform database tuning and performance optimization on Sybase and Oracle
  • Optimize indices and tuned stored procedures
  • Provide 24/7 production support
  • Performance Tuning of SQL and Query Optimization
  • Diagnose and troubleshoot system problems
  • Develop data warehouse logical and physical data models
  • Design and built extract, transform, and load (ETL) processes
  • Design and built monitoring and reporting tools for data warehouse

Environment: Sybase ASE 12.5-15.x, Sybase IQ 12.0-12.7, Sybase 11.9.2, Oracle 8.0, Oracle 9i, AIX, HP-UX, Sun Solaris

Sybase DBA

Confidential, CA

Responsibilities:

  • Install and configure Sybase
  • Perform daily administration of development and production instances/servers
  • Perform Sybase upgrades
  • Perform database backup and recovery Sybase and Oracle
  • Develop UNIX scripts/processes to monitor databases and perform general DBA tasks
  • Perform database tuning and performance optimization on Sybas
  • Optimize indices and tuned stored procedures
  • Provide 24/7 production support
  • Performance tuning of SQL and Query Optimization
  • Diagnose and troubleshoot system problems

Environment: Sybase System XI, Sybase ASE 11.5, Sybase 11.9.2, Sun Solaris

We'd love your feedback!