SUMMARY

• 24 years of experience as a Sybase ASE, IQ, Replication and Microsoft SQL Server DBA working mainly within financial organizations.
• Lead senior DBA roles focused on applying standards and stability initiatives on the Sybase and Microsoft SQL Server platforms.
• Performed installations and upgrades of Sybase 12.x & 15.x versions which includes in - place upgrades, new installations, replication setup, cross platform migrations and DR.
• Experience with Sybase Replication Server set up and upgrades.
• Experience in building, maintaining and upgrading MSSQL server various versions.
• Develop scripts, stored procedures for maintenance, monitoring, and troubleshooting.
• Performance tuning on Sybase and server optimization using Optdiag, DBCC’s, MDA and other Sybase native tools. SQL procedure and query optimization and tuning.
• Performance tuning and MSSQL database optimization though DMA, Profiler.
• Set up and maintain data warehousing database with Sybase IQ simplex/multiplex.
• Documented key procedures for Replication setup, disaster recovery, configuring database consistency checks, Replication and key troubleshooting techniques of runtime errors specific to the environments.
• Automation and reporting on Sybase and SQL Server.
• Provide support for troubleshooting, database project lifecycles, and database solutions.
• Sybase and DB2 to Postgres (EDB on premise & AWS Aurora/RDS Postgres) migration.
• Sybase to MariaDB migration on AWS ECD platform.
• Project and BAU support on Postgres and MySQL database servers including upgrades and Master/Slave replication setup on MySQL.
• Oncall support on Sybase, Microsoft SQL Server, Oracle and other supported platforms including Postgres & MySQL on the AWS cloud platform.
• Writing Chef Cookbooks for automation of supported database platforms. Chef Manage and Automate administration.

TECHNICAL SKILLS

Platforms: Unix HP-UX, Sun Solaris, AIX, Linux, Veritas clustering, Windows 2000/2003/2008 & R2, 2012, Windows cluster, AWS Cloud Platform

Tools: BMC Remedy, ServiceNow, Autosys, Infoman, Netop, RIB, ControlM, Chef Automation, Jira

Database Platforms: Sybase ASE, Microsoft SQL Server, Postgres, MySQL, MariaDB

Data Warehouse: Sybase IQ

Replication: Sybase Replication Server 15.7, 15.x, 12.x, Microsoft SQL Server Replication, MySQL Replication

Replication Connectors: Enterprise Data Confidential, DirectConnect, Repagent

Database Tools: DB Artisan, Sybase Central, CAST, IWatch, BMC Patrol, Nimsoft, Ispirer, SQLines, CHEF, Artifactory

PROFESSIONAL EXPERIENCE

Confidential

Senior Sybase/Microsoft SQL Server, AWS RDS Database Administrator

Responsibilities:

• Led a team of senior SQL Server DBA's in implementation of Stability, Standardization and Reporting initiatives on SQL Server.
• Sybase ASE, Replication, IQ, MS SQL Server, installation, maintenance, upgrades, troubleshooting and advised clients on projects. Setup security/access control.
• Develop UNIX/Windows shell scripts and stored procedures for DBA maintenance jobs, troubleshooting, and monitoring and schedule via Autosys.
• Troubleshooting and performance tuning on Sybase and SQL Server.
• Participated in completion of various migration projects for ASE/IQ/SQL servers.
• Support of production database systems to ensure high availability, resilience, integrity, security, disaster recovery and performance required by business systems
• Provision of assistance to development teams in the design, development, testing, tuning and implementation of database applications.

Confidential

Senior Database Administrator

Responsibilities:

• Definition of standards, setup & configuration of database servers and client software.
• Provide support for Sybase ASE, Repserver, MSSQL, Replication & High Availability, including setup, maintenance, upgrades, troubleshooting, performance and tuning.
• Security and access control, apply code fixes and releases
• Setup backup and recovery of all data held within databases, including HA & DR.
• Overnight / weekend support of production database systems to ensure availability, resilience, integrity, security and performance required by business systems
• Provision of assistance to development teams in the design, development, testing, tuning and implementation of database applications.

Confidential

Sybase Team Lead/Senior Database Administrator

Responsibilities:

• Responsible for leading a team of DBA's in India who provide follow the sun support for Confidential UK.
• Definition of standards relating to the setup & configuration of database servers and client components
• Sybase ASE, Replication & IQ / MS SQL Server - installation and maintenance of server and client environments.
• Develop and setup & schedule maintenance jobs scheduled. Provide support for - Sybase ASE, Repserver & IQ / MSSQL including DTS, Replication & SQL Server 2000 High Availability. Plan and implement dataserver upgrades.
• Overnight / weekend support of production database systems to ensure availability, resilience, integrity, security and performance required by business systems
• Development of infrastructure and investigation of 3rd party products required to provide production, uat and development service support.

Confidential

Database Administrator

Responsibilities:

• Support for Sybase ASE on UNIX & Windows and MS SQL Server systems including overnight and weekend support. Plan, implement and support Sybase & SQL replication.
• Installing, configuring Sybase and SQL Server on new servers & performing upgrades.
• Develop backup & recovery procedures and disaster recovery procedures for Sybase and SQL Server databases.
• Develop and apply database housekeeping procedures for Sybase databases.
• Apply Schema and change releases to databases.
• Providing technical assistance to Development and Application Management teams.
• Investigate and aid in resolving performance issues.
• Develop and maintain DBA housekeeping procedures for all Microsoft SQL Server systems.