Mandar Sawant

• Executed installation, configuration, and migration of Sybase ASE servers.

Upgraded Sybase from legacy versions to latest versions while applying critical patches.

Migrated Sybase databases from Solaris and AIX to Linux platforms using cross-platform dump and load methods.

Optimized database performance through query tuning and server adjustments.

Troubleshot slowness issues in database and replication servers, ensuring rapid resolution.

Collaborated with application team to enhance inefficient queries for improved performance.

Managed release of database scripts into production environments effectively.

Implemented industry-standard high availability and disaster recovery technologies.

• Performed installation, configuration, and migration of Sybase ASE servers across platforms.
• Upgraded Sybase from legacy versions to latest releases while applying necessary patches.
• Migrated Sybase databases from Solaris and AIX environments to Linux platforms.
• Executed database performance tuning through query optimization and server adjustments.
• Troubleshot database and replication server slowness to enhance system reliability.
• Advised application team on optimizing inefficient queries for improved performance.
• Collaborated with clients to address new requirements and resolve issues promptly.
• Managed release of database scripts into production environments efficiently.

• Company Overview: Citibank, N. A. is the primary U.S. banking subsidiary of financial services multinational Citigroup. Citibank was founded in 1812 as the City Bank of New York, and later became First National City Bank of New York.
• Performing installation, configuration, and migration of Sybase ASE servers
• Sybase up-gradation from old version to latest version and apply patches.
• Experience in migrating Sybase from Solaris, AIX to Linux platform (Cross platform dump and Load)
• Strong database performance tuning skills - query optimization and server tuning
• Troubleshoot database server and Replication server slowness.
• Give suggestion to application team to fine-tune the inefficient queries.
• Liaise with clients for any new requirements and problems.
• Release management for database scripts into production environment
• Database Design, Database Administration, Database Performance Tuning and Optimization
• Understanding and implementing of industry standard High Availability and DR technologies
• Experience with providing 24x7 production on-call support on rotation basis.
• Experience in setting up Sybase Warm standby and MSA data replication to support business functionality.
• Client: Citi Bank (North Americas region)
• Environment: Sybase ASE 15.7 and 16, Rep Server 15

• Provided 24/7 support for production servers, ensuring high availability and performance.
• Managed Adaptive, backup, and replication servers to maintain optimal operational integrity.
• Troubleshot daily production and non-production issues, minimizing downtime.
• Monitored memory, CPU utilization, and file systems to ensure system stability.
• Created new databases and initialized disk devices upon request.
• Optimized query performance by analyzing server health and reviewing execution plans.
• Handled disk space alerts and managed database growth proactively.
• Actively participated in disaster recovery tests to validate resilience procedures.

• Maintained production and development servers, ensuring 24x7 database availability for end-users and developers.
• Troubleshot database issues promptly to minimize downtime.
• Established and enforced backup and recovery policies and procedures.
• Administered Sybase ASE systems, including user permissions and management activities.
• Conducted weekend maintenance tasks, including index rebuilds and statistics updates.
• Performed weekly audits of Sybase ASE logins to ensure security compliance.
• Managed data integrity and availability for end-users through proactive maintenance.
• Resolved replication issues by managing REP-AGENTS and verifying source-target discrepancies.