Ms Sql Server And Sybase Dba/developer Resume
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