Database Administation
- Responsible for Database Administration (Sybase ASE12.5.x, 12.0.x, 11.x, SQL Server & DB2) support, implementation, configuration, security, monitoring, backups, performance tuning and best practices
- Responsible Sybase Replication Server (12.6, 12.1) support, installing, configuring, troubleshooting & failover
- Responsible implementation of SQL Server 2005 and setting up mirroring & logshipping
- Responsible for Replication, Failover & Application Disaster Recovery support
- Control privileges and permissions to database users
- Monitor and improve database performance and capacity
- Perform software installations/upgrades which require database installation and/or upgrades
- Performed data modeling (physical & logical)
- Participate in the quality improvement process
- Developed T-SQL code, stored procedures, triggers and views
- Develop test plans to ensure quality assurance and performance integrity of information systems
- Performed testing, troubleshooting and analysis
- Responsible Data Migration and Data Conversion for internal and 3rd party applications
- Made recommendations that helped streamline the release process and reduce implementation time by 2 hours
- Developed requirements, design, standards & documentation
- Set up bi-directional replication & High Availability
- Provided 24/7 on-call production database support