Sybase/sql Server Architect Resume
Acton, MA
TECHNICAL SKILLS:
Skills: Sybase 11.5,12.0,12.5; Sybase Replication Server 12.0, 12.6; Microsoft SQL Server 7.0, 2000; Oracle9i; Full Text Server (verity )
Systems: Sun Solaris 5.8 HP - UX 10.20, 11.0 AIX 4.3.3, 5.1 Windows 2000 Windows 2003 Windows XP
Tools: DBArtisan ERStudio BMC Patrol Sybase Central Zero Imact ProActive DBA
PROFESSIONAL EXPERIENCE:
SYBASE/SQL Server Architect
Confidential, Acton, MA
Responsibilities:
- Manage multiple tasks simultaneously, work well under pressure, attention to deadlines, focus on customer satisfaction
- Provide performance tuning for Sybase and Microsoft SQL Servers
- Provide code reviews and diagnose performance problems in applications
- Build,configure and tune Sybase ASE and Sybase Replication Servers (12.6) on AIXSun Solaris and HP environments
- Implement best practices for Maintenance, Backup and Recovery
- Was part of implementation VCS cluster.
- Document operational procedures, workflows and problem resolutions
- Provide to team members
SYBASE Independent Contractor
Confidential, Merrimack, NH
Responsibilities:
- Perform migration for Sybase 12.5.3 64 - bit server and Sybase
- Replication Server 12.5 from Sun Solaris 5.8 to AIX 5.1
- This includes but not limited to
- Install, Configure, Tune Sybase ASE on new AIX machines Migrate 45+ databases on Development, QA, ITF and Production
- Servers
- Identify and resolve any issues that come up before and during migration
- Migrate and modify to fit new AIX environment maintenance scripts and cron jobs
- Provide knowledge transfer and to members of the DBA group
DBA GROUP Manager
Confidential - Boston, MA
Responsibilities:
- Manage dba team providing task assignment and guidance to the dba s
- Manage multiple tasks simultaneously, work well under pressure, attention to deadlines, focus on customer satisfaction
- Provide timely and effective functional, technical, and operational support to product end users in the fast - paced atmosphere of Wall Street.
- Implementation of Industry best practices for server and data center perations.
- Document operational procedures and workflows.
- Maximize time to properly manage workload.
- Provide to end user groups
- Provide Production DBA support for 230 clients through remote connections
- This includes but not limited to Installs, upgrades and maintenance for
- Eze castle trading applications ( TC, Tradewinds, EzeConnect(Fix)Watch Tower, PMC and etc.)
- Maintenance and administration of production database servers
- Perform code reviews before implementing changes on production
- Perform backup and recovery for clients databases
- Performance monitoring, optimization and business continuity planning for clients production servers
SENIOR DATABASE ADMINISTRATOR
Confidential - Boston, Mass
Responsibilities:
- This includes but not limited to providing task assignment to the dba’s and guidance to the developers for Production and Development Activities, interactions with internal and external vendors and partners.
- Generate Business reports
- Extract payroll data and send it to ADP
- Support 7x24 mission critical Web-based Home-grown Aplication
- Test and Implementation new Software Releases
- Apply latest EBF’s for Sybase ASE
- Develop procedures and tools to improve and automate DBA function
- This includes but not limited to Determining Storage, memory and CPU needs and data lay out
- Install, configure and tune Sybase ASE and Full Text Server (verity EFTS )
SENIOR DATABASE ADMINISTRATOR
Confidential
Responsibilities:
- This includes but not limited to providing task assignment and guidance to the dba s for Production and Development Activities, interactions with internal and external vendors and partners.
- Support 7x24 mission critical Customer Service Application Clarify
- This entails Sybase, Microsoft SQL Server and Oracle production and development support; Sybase Replication Server environment
- Assisting Clarify Development group, analyzing their database needs and providing timely database support.
- Develop procedures and tools to improve and automate DBA function
- Implementation of all the backup, disaster recovery, and monitoring procedures, troubleshooting, ongoing support and performance tuning, maintaining optimal storage, memory and CPU configurations
- Successful Application, Sybase and Microsoft SQL Server upgrades
- Successful Implementation of Replication Server in Production environment
- Played Key role in Decision Making, Design and Implementation of Production and UAT infrastructures
- This includes but not limited to Determining Storage, memory and CPU needs, data lay out on EMC’s Symmetrix
- Implementing reporting server using BCV (TimeFinder) and SRDF link - EMC’s Symmetrix Utilities
- Install, configure and tune Sybase ASE and Replication Server environment
SENIOR DATABASE ADMINISTRATOR
Confidential
Responsibilities:
- Constant interaction with multiple development projects in analyzing their database needs and providing timely database support.
- This entails both Logical and Physical Database design,
- Support the database design Deploying all the test and production Sybase databases Implementation of all the backup, recovery, and monitoring procedures, ongoing support and performance tuning (application and database) in a Solaris (UNIX) environment.
- Develop procedures and tools to improve and automate DBA function Successful upgrade Production servers
- Configure the new Disaster Recovery infrastructure for production environment
- Develop and automate procedure to fall over disaster recovery environment from production site.
- Configure Omni SQL Server
SYSTEMS ANALYST
Confidential
Responsibilities:
- Configure and maintain UNIX relational databases (Sybase, Oracle)
- Monitor and manage database performance, integrity and structure
- Work with both internal and vendor personnel to resolve database problems
- Develop procedures and tools to improve and automate DBA functions
- Logical and physical database design to support interchange architecture, product development ( financial and securities related applications )
- Applications consultation and regarding database utilization
- Create database objects
- Create and maintain database documentation
- Evaluate database administration
COMPUTER SPECIALIST
Confidential
Responsibilities:
- Provide technical assistance to visiting scientists in using software packages such as PROS/IRAF in UNIX and X - Windows environment.
- Data Base Administrator for Sybase databases.
- Administrator for Einstein database on Sybase platform.
- Convert ASCII data files to data base using SQL for Einstein database.
- Perform systems and database backups and retrievals of data from all types of media.
- Assist in production of newsletter and documents for publishing using FrameMaker.
- Develop and implement methods of organizing and distributing astrophysical data.
- Develop UNIX shell scripts in X Windows environment to increase the speed of data extraction for scientists.
- Write programs in C to handle unusual formats and correct problems in data.
- Perform precision measurements in astrophotography.