Vikram Arcot
Alpharetta
Summary
Seeking a position as AWS and Azure Cloud Certified Architect and/or DevOps Engineer with over 20 years experience working as Database Administrator and Program Manager. Expertise and experience building and providing 24x7 support to business-critical application and databases. Designing and automating highly resilient, secure, high performance and cost optimized cloud solutions using AWS and Azure.
Overview
27
27
years of professional experience
1
1
Certification
Work History
Lead SAP Sybase DBA/ Microsoft SQL Solutions Architect
E*Trade by Morgan Stanley
Alpharetta
12.2023 - Current
- Plan, Create and Share OneNote Documentation with team to provide 24x7x365 DBA support.
- Use scheduling tools like Linux Crontab, Broadcom Autosys and BMC Control-M.
- Use monitoring tools like Big Panda, Quest FogLight and Microsoft SSRS.
- Use existing scripts and develop new scripts and maintain in BitBucket version control system.
- Read existing and Write new Confluence KBA pages for 24x7 DB Operations and support.
- Perform Database Refresh using PowerShell and Unix Shell and Database Deployments using Jenkins.
- Participate in Daily and Weekly Team meetings and cross training sessions using Microsoft Teams.
- Review Quarterly team performance to ensure Client Delivery.
- Prepare and Schedule monthly DBA team rotation to provide DBA support.
- Automate daily DBA task using scripting for create login, data pull, production changes.
- Prepare Start-of-Day (SOD) at 8AM and End-of-Day (EOD) report at 11 PM and submit it to client.
- Work in shift rotation from 2PM to midnight and turnover to HCL offshore after midnight.
- Make or request Presentations and record using Microsoft Teams.
- Troubleshoot Database restore failures for Sybase and SQL Server.
- Environment: SAP Sybase 15.7/16.0, Microsoft SQL Server 2016/2019/2022, Oracle 19c and PostGreSQL 16.
Senior SAP Sybase DBA/ Microsoft Azure Cloud Solutions Architect
Certified Solutions, India/USA
07.2019 - 11.2023
- Undergo training for SAP Basis, SAP ABAP, SAP Simple Finance and SAP Simple Logistics.
- Undergo training for Azure AZ-104 Admin, AZ-204 Dev, AZ-305Architect, AZ-400 Devops.
- Designed and built cloud service models including Infrastructure-as-a-Service, Platform-as-a-Service, and Software-as-a-Service.
- Design, Deploy and Maintain Azure VMs, VNETS, subnets, NSGs, NICSs and load balancers.
- Setup Azure Virtual Appliances (VMs) to meet security requirements as software-based appliance functions (firewall, WAN optimization and intrusion detections).
- Support applications on Azure SQL Databases and Azure SQL Data warehouse.
- Conduct training on SAP Sybase and SAP Basis administration.
- Conduct training on Azure Administration.
- Environment: SAP Sybase, SAP ECC, Microsoft SQL Server, AWS and Azure cloud.
Senior Sybase/SQL Server DBA
Fidelis Care New York
Buffalo
01.2019 - 06.2019
- I worked as Database Program manager doing the following hands-on projects for Fidelis Care.
- Provide 24x7x365 DBA support applications on production, quality, and development.
- Migrate 25-30 Sybase ASE servers to Microsoft Azure SQL Servers.
- Expertise in User Management, Capacity Space Management, Backup Management and Maintenance tasks.
- Monitor and Recommend Application performance improvements with Sybase and SQL Server.
- Upgrade ASE from 15.0 to 16.0 and SQL Server 2008 to 2014 and 2016.
- Participate in change management meetings and execute weekly production moves.
- Schedule DBCC, Reorg, Index Rebuild, Update Statistics and Database Backups as Maintenance Jobs.
- Working Knowledge of AWS, SQL Azure, Sybase IQ and Oracle Database Administration.
- Self-motivated Disciplined and Organized Team Lead and asset to any organization and team.
- Proven Written and Verbal Communication Skills to complete projects within budget and schedule.
- Support and Maintain replication and migration scripts and scheduled jobs.
- Use DMVs. sp_whoisactive and sp_Blitz to performance tune slow running queries.
- Schedule daily and weekly database maintenance jobs and automated backups.
- Environnent : Sybase ASE 16.0/15.x/12.5, Réplication Server and IQ. SQL Server 2005/2008/2012/2014.
Oracle DBA/ SAP Basis DBA
Xerox Business Services
Secaucus
07.2015 - 12.2017
- Company Overview: (Full Time)
- I worked as Database Program manager doing the following hands-on projects for Xerox.
- Provide 24x7x365 SAP Sybase and SAP Hana DBA support.
- Support day-to-day Sybase administration tasks.
- Monitor and Recommend Application performance improvements with Sybase 15.7 server.
- Participate in change management meetings and execute weekly production moves.
- Send Email and Pager alerts on Oracle jobs which need immediate DBA attention.
- Working Knowledge of AWS, SQL Azure, SAP Basis and Oracle Database Administration.
- Perform Oracle data refresh using RMAN, data pump, export/import and transportable tablespaces.
- Maintain SOP Documentation for all Sybase, Oracle and SAP Basis Administration tasks.
- Upgrade Oracle 12.2.0.1 to Oracle 19c in the weekend maintenance window.
- (Full Time)
- Environnent : SAP Sybase 16/15.7, SAP HANA 2.0, Oracle 12C/19C/21C.
Database Administrator Consultant
Credit Suisse\Software Guidance
Raleigh
01.2013 - 05.2015
- I worked as Global DBA in Production Services to support Sybase 15.x and 12.x, Oracle 11g/12c and Microsoft SQL Server 2005 and 2008.
- Sybase Replication Server Health, Latency, System Administration, Performance and Tuning.
- Assist Engineering team to maintain Shell, Perl and SQL scripts to perform day-to-day DBA activities.
- Expertise in User Management, Capacity Space Management, Backup Management and Maintenance tasks.
- Use sysmon and MDA tables to monitor and tune Sybase performance.
- Using shell scripts to perform upgrades, scan errorlog, monitor space usage and replication health latency.
- Liaison with Business, Application and Primary Technical teams to support business continuity.
- Experience with Microsoft SQL Server. Trace, SQL Profiler, DMV tables.
- Use Remedy for Incident Management and Change Management and Control-M for Job Scheduling.
- Provide 24X7 Production Database Support for Sybase and SQL Server Application Databases.
- Experience working on Sybase IQ and Oracle Database Administration.
- Environnent : Sybase ASE /15.x/12.5, Réplication Server. SQL Server 2005/2008/2012/2014. Oracle 11g/12c.
MS SQL Server Database Administrator
United Health Group
Pittsburgh
04.2009 - 12.2012
- Company Overview: (Full Time)
- At UHG, I was responsible for the following duties on Sybase and SQL Server.
- Maintain and upgrade Facets 4.41 to Facets 4.71 on Sybase ASE 15.0.
- Shell Scripting to support day to day DBA activities and complex application tasks.
- Support SQL Server 2005 Databases in Facets and Legacy applications.
- Upgrade SQL Server 2000 to SQL Server 2005 and migrate DTS packages to SSIS package.
- Build, Deploy and Maintain SSIS Packages on development, QA and Production Servers.
- Setup procedures to track and resolve DBA On-call issues with primary and backup DBA schedule.
- Schedule team meetings and meetings with other application support teams.
- Complete Help Desk Tickets, Application Configuration Deployments assigned to DBA per SLA.
- Proficient with SQL Agent, SQL Profiler, tuning and performance of application query and server.
- Maintain High availability solutions with SQL Server Replication, Clustering and Log Shipping.
- Expert in T-SQL coding for database administration and application programming.
- (Full Time)
- Environnent : SQL Server 2000/2005/2008/2012, SSIS, Sybase ASE 15.x/12.5, Oracle 11g/12c.
Database Consultant
AT&T
Middletown
11.2006 - 04.2009
- At AT&T Middletown, I was responsible for the following duties.
- Download all software from subscribenet and install and maintain SYSAM 2.0.
- Install and Upgrade all Sybase ASE Server on 12.5 32-bit to 12.5 64-bit for Dev, uat, and production.
- Measure Replication Latency and Troubleshoot Replication performance problems.
- Organize or Participate in weekly team meetings with DBA’s and application groups.
- Schedule Production Changes using Change Management System.
- Upgrade server to 15.0.3 using dump and load and in-place methods.
- Write SQL
- Loader control files for importing and exporting data to and from Oracle instances.
- As part of Oracle upgrade from 9i to 10g, Upgrade Sybase Direct Connect to Oracle from 12.5 to 12.5.1.
- Execute developer requests to create new database and database objects in Sybase, Oracle and SQL Server.
- Create and Maintain Shell Scripts and Perl Scripts and use MDA tables for monitoring.
- Schedule Backups and DBCC using in-house backup programs.
- On call rotation and production support of Oracle 9i/10g and MS SQL Server 2005.
- Environment: SQL Server 2008, Sybase ASE 15.0/12.5, Sybase Repserver 15.0/12.5, IQ 12.4.
Sybase Database Administrator and Consultant
Fanniemae
Reston
12.2005 - 10.2006
- At Fanniemae, my role was to support two clusters and perform daily database activities.
- Following were my tasks and duties in the project: Upgrade UNIX and Perl wrappers for Sybase rs_subcmp from version 10.0.4 to 12.5 for Sybase warm standby and adhoc replication.
- This involves updating the weekly executing shell script to send e-mails to customers upon finding discrepancies and sending e-mail to customers on weekly basis to find out differences between primary and contingency and primary and reporting servers.
- Implementing the upgraded wrappers on all clusters and execute cluster wise, server wise database wise, server wise and table wise reports.
- Install and Setup Replication on production, contingency, acceptance and development databases.
- Jil or convert jobs on crontab to autosys.
- Create databases and Perform database restores using sqlbacktrack and veritas netbackup.
- Use Services Online and Remedy Change Request System for scheduling and processing application changes in Development, Acceptance and Production environments.
- Document the How To and Procedures.
- Interviewing and recommending suitable candidates for open DBA positions.
- Install and Setup ASE 15.0, Repserver 15.0, OpenSwitch 15.0 for mutual aware or automatic failover setup.
- Environment: Sybase ASE 15.0/12.5, Sybase Repserver 15.0/12.5, Veritas Netbackup 5.6, OpenSwitch 15.0.
Sybase Database Administrator - Associate Project Manager
PHH Mortgage
Moorestown
09.2004 - 11.2005
- Company Overview: Cognizant Technologies
- At Cendant Mortgage – As a DBA and consultant in Data Architecture I was involved in Sybase production support and managing offshore model.
- Following were my accomplishments, role and responsibilities in the project: I was managing offshore DBA’s, assigning tasks and co-coordinating on daily basis.
- Coding in PERL and Shell Scripts. The scripts used were to collect Baseline objects for every release, check replication Latency and metrics information collection.
- Develop, Covert and maintain Perl and Shell Scripts.
- Supporting developers in code promotion from Development to QA and QAProd.
- Working on implementing projects with business analysts.
- Mentoring Offshore DBA in preparing documentation.
- Secondary assistance to on-call DBA routine.
- Using Erwin as data modeling tool to design and engineer specific modules.
- Convert some databases from Microsoft Access to Sybase using Microsoft SQL Server DTS.
- Schedule and complete Database Change Requests, Login Requests and Releases.
- Enforce Password Policy and automate password resets and expiration for audit requirements.
- Create server report and space management plan for all the databases.
- Promote weekly changes and monthly releases to productions from development and QA.
- Support Sybase Replication server topology, servers and requirements.
- Setup and Support Oracle RAC server on 10 G as part of on-call rotation.
- Evaluate ASE 12.5.3 and 15.0 to find upgrade path for the servers at PHH.
- Resolving clarify tickets relating to pending tasks.
- Using Autosys job scheduling tool.
- Upgrade and use new features of ASE 12.5 namely cache partitioning, cache binding, benefits from dynamic memory allocation and locking schemes.
- Approving change request for production changes as change lead and participating in team/application meetings.
- Performing and scheduling maintenance tasks including update statistics, reorgs and index rebuild.
- Performing and monitor database growth requirements namely segment, devices, database, server installments and replication systems.
- Cognizant Technologies
- Environment: Sybase ASE 12.5, REP 12.0, MS SQL Server 2000, Oracle 9i/10g, Autosys 4.0, Sun 2.9 and Linux 5.0.
Sybase Database Administrator
GE Medical Systems
Chicago
09.2003 - 08.2004
- At GE Medical Systems – Chicago, IL (GEMS) developed modules for Picture Archive Communication systems PACS, using Sybase 12.5.1 and Sybase replication server 12.5.0.
- I was responsible for design testing and coding software release.
- Write development specifications and code stored procedures, triggers, rules, constraint and defaults to support the design.
- Develop scripts to support database default and log segments thresholds, CPU and memory utilization and assist production support dba’s.
- Use Sybase high availability system using coordination module, openswitch and warm standby replication system.
- Design the document manual for Sybase warm standby application for failover.
- Coding, testing, implement perl, awk and korn shell to support start, stop and status scripts of installing the status media.
- Baseline the development and integration environment using Sun v480, v120 servers.
- Use Clearcase version control system and ddts for version control and building software builds and update change controls.
- Install and setup ASE, replication server and replication definitions.
- Code-review and implementing SQL modules and shell scripts.
- Author the service manual sections and chapters dealing with database replication functionality and troubleshooting.
- Environment: Sybase Power Designer 10.0/9.5, Sun Solaris 2.9, Sybase ASE 12.5, Sybase Replication Server 12.5, Sybase Open Switch and Coordination Module 12.0.
CAMBRIDGE SYSTEMS
Chantilly
10.1998 - 02.2002
- I had worked on several DBA projects for Cambridge Systems at Lockheed Martin, MD, AT&T OH and Digital Commerce VA.
- Perform Full life cycle Design and Development and Production Support using Sybase, MS SQL Server and Oracle.
- Learn and implement new technology and tools to support database administration tasks.
- Environment: Sybase ASE 12.5, Sybase Replication Server 12.5, Microsoft SQL Server 6.5, Oracle 8i.
Education
Advanced Diploma - Information Systems
National Institute of Information Technology
Hyderabad, India01.1996
Bachelors of Science - Computer Science
A V College of Arts, Science and Commerce
Hyderabad, India01.1995
Skills
- AWS & Azure Architect
- Administration, Development & DevOps
- Microsoft SQL Server
- SAP Sybase ASE & Replication
- Oracle
- Performance and Tunning
- Python, Boto3 Automation
- PowerShell, Unix Shell Scripting
- T-SQL, PL/SQL
- C, C, Java,NET
- Linux, Unix, Microsoft Windows
- Microsoft Office, Project, Visio
- Power Designer, DB Artisan, Veritas NetBackup
- Power BI, SSMS, SSIS, SSRS
- SAP ECC, SAP HANA & SAP ABAP
- Program Management
Certification
- 2004, Sybase Certified Adaptive Server 12.5 Administrator
- 2003, Brainbench Certified Sybase & Oracle DBA, Transcript ID 186320
- 2010, Microsoft Certified IT Professional MCITP and MCTS: Database Administrator 2008
- 2012, Project Management Institute –PMI Certified
- 2020, Microsoft Certified Azure Administrator (AZ-104), Microsoft Certified Trainer (MCT)
- 2025 AWS Certified Solutions Architect Associate (SAA-C03)
Skills Profile
AWS and Azure Architecture, Administration, Development, DevOps, Microsoft SQL Server 2016, 2014, 2012, 2008, 2005, 2000, 6.5, SAP Sybase ASE versions 16.0, 15.7, 15.0, 12.5, 11.9.2, 11.5.1, 10.0.1, 4.9.0, Oracle 9i, 10g, 11g, 12c, 19c, 21c, SAP Hana 2.0, Python, PowerShell, Unix Shell, T-SQL, PL/SQL, C, C++, Java, .NET, Boto3, Linux, Unix, Microsoft Windows, Microsoft Office, Project, Visio, Power Designer, DB Artisan, Veritas NetBackup, SSMS, SSIS, SSRS, SAP ECC
Training
- Sybase Passport and SyberLearning ASE, Replication and IQ
- SAP Basis, SD and CRM Training and Partner with AMBSTech.com and Certified Solutions
- PMP Training Pittsburgh, PA with PMSimplify.com
Other Information
- Active member of International Sybase User Group www.isug.org
- LinkedIn Profile: https://www.linkedin.com/in/vikram-arcot
Personal Information
Citizenship: US Citizen
Timeline
Lead SAP Sybase DBA/ Microsoft SQL Solutions Architect
E*Trade by Morgan Stanley
12.2023 - Current
Senior SAP Sybase DBA/ Microsoft Azure Cloud Solutions Architect
Certified Solutions, India/USA
07.2019 - 11.2023
Senior Sybase/SQL Server DBA
Fidelis Care New York
01.2019 - 06.2019
Oracle DBA/ SAP Basis DBA
Xerox Business Services
07.2015 - 12.2017
Database Administrator Consultant
Credit Suisse\Software Guidance
01.2013 - 05.2015
MS SQL Server Database Administrator
United Health Group
04.2009 - 12.2012
Database Consultant
AT&T
11.2006 - 04.2009
Sybase Database Administrator and Consultant
Fanniemae
12.2005 - 10.2006
Sybase Database Administrator - Associate Project Manager
PHH Mortgage
09.2004 - 11.2005
Sybase Database Administrator
GE Medical Systems
09.2003 - 08.2004
CAMBRIDGE SYSTEMS
10.1998 - 02.2002
Advanced Diploma - Information Systems
National Institute of Information Technology
Bachelors of Science - Computer Science
A V College of Arts, Science and Commerce
Similar Profiles
Kristin AndersonKristin Anderson
Executive Platinum Relationship Manager, Executive Services at E*TRADE FROM MORGAN STANLEYExecutive Platinum Relationship Manager, Executive Services at E*TRADE FROM MORGAN STANLEY
Andres GraciaAndres Gracia
Fraud Prevention Representative at E*Trade by Morgan StanleyFraud Prevention Representative at E*Trade by Morgan Stanley
Alyssa BarnickAlyssa Barnick
Fraud Operations Analyst at E*TRADE from Morgan StanleyFraud Operations Analyst at E*TRADE from Morgan Stanley