Information Technology Sql Server

Arkesh Tripathi

*** ********* ***

Edison, NJ ***20

Phone: 732-***-****

Email: *******@*******.***

A highly qualified Information Technology professional with outstanding technology skills and a proven track record as, subject matter expertise (SME) & very large database design/migration/administration/data warehouse design/heterogenous database migration/cross database product replication seeks a senior level DBA position in a challenging SMAC (social media, Mobile, Analytics, Cloud) based IT/IS environment.

SUMMARY OF QUALIFICATIONS

Over 37 years’ experience in Information Technology with exposure to big data and cloud-based technologies

Excellent background in relational and no sql databases including Server deployment, In memory databases, Oracle, SQL Server, Sybase, Informix, UniData, DB2, Mariadb, SAP, Postgres, Cloud SQL, GCP, SSAS and SSRS, replication and database migration, user privileges and permissions, sql rollouts, upgrades, Custom scripting for CDC & SSIS, structured and unstructured data mappings, always on availability group, oracle RAC and troubleshooting with database vendor support, Performance tune queries, Security Master, Pricing Data Feed support, Analytics, VDI, Server Virtualization, SAP FICO and SAP MM/WM, Informatica, Tidal, Cognos, Trading System Desk Support, DMZ Data Replication, server migration including sql to SAP FICO, oracle to SQL server, Sybase to DB2 replication, Qlikview reporting, Capacity planning, DB Health

Proven track record as Senior DBA supporting large, Database Migration, mission-critical, 24/7 production systems, hire/fire Database Administrators, DBA Project Management, Issue Tracking, SOX compliance reporting, DevOps via Delphix cloning sql server and Sybase databases

Proven expert in designing databases, ETL and fine tuning very large databases for optimum performance. Worked with NoSQL MongoDB, HBase, Metamorph Index, Inverted Index, timeport schema, etc. for text data

Excellent understanding of SQL and refining SQL statements for best performance

In-depth knowledge of database internals and processes

Excellent communication and presentation skills, contract negotiation, vendor management, product licensing

Team builder with excellent motivational abilities. Leader with vision

TECHNOLOGY SUMMARY

Products:

SAP FICO and MM/WM, Informatica, IBM Informix I4GL, Radis, SAP ERP, SAP on DB2

Databases:

MS-SQL Server, Oracle, Sybase, DB2, SAP, Informix, IBM Uni Data, DB2, MariaDb, Postgres, Neo4J

Hardware:

VM, HP, SUN, IBM, RS 6000, Dec Alpha, Vax

Operating Systems:

Windows 2019, 2016,2012, JCL, CICS, Linux, Unix, SAP Hana, SAP ABAP

Languages:

Shell scripting, ESQL/C, SQL, PL/SQL, Python, XML, T-SQL, Power Shell

Pricing Systems:

Risk, Tap Master, AC Invest, Xenomorph, Security Master, SharePoint

Pricing Data Feed:

Bloomberg Back Office, Bloomberg per Security, FTID FTS, GMI Futures and Options, Reuters Data Scope, S&P Isid Plus and Crosswalk, S&P Index, NSCC Domestic Folio, BPS Bond Schedules, Reuters Fundamentals, Reuters Estimates

Trading Systems:

Helix, ION, PRYSM, GMI, Risk, RiskVal, Algorithmic, Leo Stream, BNA - Asset Management, ullink, Global-1, Martini, Algorithmic, SIFMA Testing

VDI Support:

VDI - Virtual Desktop Interface, vCenter, Varonis, CommVault

Monitoring:

Zenoss, Idera Change Management, Idera Diagnostic Server, SOX Reporting

Replication:

MS SQL Server Replication, Sybase to IBM DB@ replication, Replication to DMZ

Technologies:

GraphQL API, Neo4j Library, QlikView, Service Now, PeopleSoft, Web Services, SOAP, Java, XML, SharePoint, Tfs, Jira, SSIS, SSRS, DWR, DWM, Hadoop, snowflake, DB2

Tools:

Erwin, Idera, Spotlight, BMC Patrol, DbArtisian, HP-Open view, EDI, Cyrano, Autosys, Control-M, Tidal, Visio, Crystal Enterprise, IIS, Cyrano workbench, Confluence, Redgate SQL Compare, Data Compare, DB2 DBA Cockpit, etc.

Other:

VMware, Remedy, MS Office, Direct Connect, MDI Gateway, Apache

CERTIFICATION

Microsoft SQL Server Database Administration

Microsoft SQL Server, Analysis Service Performance and Tuning

Sybase Database Administration

Oracle Database Administration

Linux/Sun Solaris System Administration

IBM UDB, Informix Database Administrator

Informatica Advanced system Administration

RDBMS concepts

C5MI, Senior Software Engineer

Nov 2024 – Current

Responsible for performing application configuration in the SAP S/4 Hana system and providing functional specifications, test data, test cases for relevant ABAP developments. Resolved design issues related to costing

due to structure master data.

Fidelity Investments, Senior Database Engineer

Dec 2022 – Aug 2024

As a Senior DB Engineer and Administrator working on Agency Landing and Fixed Income security finance processor modernization project for Fidelity Investment. Analyze and Setting up sandbox environment for FIS – Global One scripting for automated new server deployment, Global One Day end processing, new securities pricing, lender and broker setup, Repo GoSOS CI/MQ process setup, Unidata Housekeeping, G1 SSL setup, adding users, installing Unidata and restore and upgrade current Database, install and configure IBM MQ, uDeploy, Java, Python, Oracle client, GCI server, SSRS, SSAS, GraphQL API, handled DBA work for neo4j Graph database on AWS, Used Procedural and declarative CQL for matching patterns, create node/relationship, retrieve all the nodes in the database., merging, set to add or update properties to new or existing nodes/relationship, used apt-get to install, created Neo4j RPM Repository, query routing, data sharding and Neo4j Library, U2ODBC, MS SQL Server, MS Azure, DevOps, Control M, IntelliJ, Git, JenkinsCore, shell scripting, continuous testing setup, restore Oracle 19c databases via Delphix appliance daily for testing, AWS RDS, G1 loan booking lifecycle, trouble shooting and testing new issues post upgrade and report to FIS vendor, Implement Unidata file system replication, SB client and Global One explorer installation, Performance Tune Linux and database parameters, verify and update new associate on-boarding, attend scrum meetings, Jira, planning for sprint, Documentation etc.

Mizuho Securities, Senior Database Administrator

Mar 2006 – Nov 2022

As a senior DBA maintained MS SQL Server in Google Cloud Platform and Azure servers, Google cloud DB Migration service (DMS), Oracle expdb & impdb, Compute engine, Cloud SQL, gcloud command tool, SAP on DB2, SAP Hana, Oracle 12c-19c, Oracle RAC, Cloud SQL, Always On, In memory database, Radis, Data Encryption, DMZ replication, migrations from Oracle to SQL, SQL to SAP FICO, Sybase to sql and IBM Uni Data, Oracle to SQL, Risk Server Support, Fixed Income Trading desk support, Security Master maintenance, Data mappings with various vendor data feeds from Bloomberg/Reuters/IsidPlus/NSCC etc., Pricing data warehouse support, cube data processing, mdx query processing, Fixed Income Uni data database server maintenance, udb file system database replication, dba staff hiring/firing, vendor contract negotiation and management, product licensing, sox reporting, VDI support, server virtualization, product evaluation and recommendation, system integration, problem management, database monitoring and troubleshooting using Zenoss, Idera Change Management, Idera Diagnostic Server, Hadoop, snowflake migration, SSIS Data transformation and migration, database recovery, etc. Implemented centralized price data feed via Tap Master, integration of security master database to various trading system, Global-1 & Martini trading system implementation and support, ION trading system implementation and support, ION & Anvil trading system support, Assentore application support, KESTRAL trading system support, CODA accounting system support, design disaster recovery for replication, trouble shoot replication problems, database performance tuning, data modeling, define database development standards and conventions, Database auditing, SOX compliance, plan/schedule/implement/co-ordinate with user groups for various system activities, logical model creation and physical model implementation, schema compares for various test/qa/production implementations, odbc administration, build dba infrastructure being 1st DBA in company, Rolling window data Storage, 2014 extended memory, domain to no-domain replication, BI, Power Shell, python, database cloning via Delhix replication and always on, manage daily work flow with IPSoft - team in India etc.

Environment: Windows, MS SQL Server, Azure, Google Cloud Platform, Terraform, Linux, Oracle, IBM Unidata, DB2, Postgres, Mariadb, Cloud SQL, DMS, gcloud, QlikView, Analytics, Mobile support, Red Gate, Embarcadero, SSIS, SSAS, SSRS, BI, Always On, Mirroring, SQL Profiler, Phyton, Cloning, Log Shipping, IBM UDB 7.1.2, etc.

Moody’s Investor Services, Lead Sybase Replication/ETL Administrator

Jan 2005 – Feb 2006

As a Sybase Replication DBA/ETL Admin. maintained Sybase replication servers 12.5/12.6, ETL administration for Informatica 7.1.2, Database design for provisioning/consumer application, used straw man architecture 6.0 to redesign ratings_lite, sfg, raterel, bridge, nRDE etc databases, create/maintain replication maps, design disaster recovery for replication, trouble shoot replication problems, database performance tuning,, data modeling, define ETL development standards and conventions, support for ETL mappings & transformation, created LPAR’s for logical UNIX architecture for IBM P570 machine cluster, Sybase auditing, data clensing, helped SOX compliance team, did data warehouse design and implementation, created database standards for proxy table usage, plan/schedule/implement/co-ordinate with user groups for various system activities, logical model creation and physical model implementation for various data marts, operational data marts, dynamic data marts, schema compares for various test/qa/production implementations, multi-byte character set implementation, odbc administration, etc.

Environment: IBM, Compaq, AIX 5.3, Windows 2000, Informatica 7.1.2, Sybase SQL Server 12.5, Replication server 12.5/12.6, Informatica Power Center, Informatica Designer, etc.

NMatrix, Sr. Database Administrator/Developer

Aug 2003 – Dec 2004

As a Senior DBA developed scripts, xml queries, build Sybase/Oracle and Texis servers, designed and implemented various database standards, sybase-oracle replication, investigated application and server related issues, monitoring, performance tuning, EBF upgrades, migrations etc. Worked on various projects including eDataMatrix, Documatrix, e-Bots, nTegrity, nSyndicator, smartForms, nAlerts, etc. The projects were based on UPIKM [Universal programming interface to knowledge Management] SQL based database technology. The real time knowledge management documents imaging and management system uses six sigma principles for Wall Street clients. Clients include SEC, MetLife, UBS Warburg, Davis Polk, Jones Day, Skaddden, Arps, and Slate etc. Object oriented Software is based on Informix/Sybase/ Oracle/MS-SQL and Texis [Text Search database] using metamorphic inverted index search algorithms. User can completely customize structures, field values, coding forms, reports, tool bars etc. Software handles over 300 electronic file types including documents, html, pdf’s, graphics, e-mail, outlook, lotus notes, Netscape, etc and very large volume of data/images.

Environment: Sun, Compaq, Solaris 2.8, Windows 2000, Informix, Sybase SQL Server 12.5, Oracle 9.2, Texis 4.01, EMC, VERITAS etc.

Bank of New York, Sr. Database Administrator /Developer

May 2003 – Jul 2003

As a Senior DBA, did SQL Server 7 to 2000 migration of 300 GB + size data warehouse, developed NT scripts for partitioned view to achieve maximum server performance, performance tuned 400+ stored procs, Changes to primary key/Indexing, Server tuning, running DBCC’s, update statistics, COM/DCOM, ADO, XML, VBA, DHTML support, snapshot & push replication, Jaywalk software deployment using SourceSafe etc.

Environment: MS SQL Server 2000, Sun Enterprise, Compaq, Solaris 2.x, Windows 2000, Sybase SQL Server 12.5, EMC, VERITAS etc.

Credit Suisse First Boston (CSFB), Sr. Database Administrator

Mar 2001 – Jan 2003

As a Senior DBA, did production support, build Sybase and Sybase Replication servers 12.5, 12, 11.X, SQL server 2000/7/6, Informix 9/7, Oracle 9/8 servers. Worked on various projects including equity financing and pricing data warehousing, equity lifeboat, agora trading system, fixed income-based securities, global finance, spider, syndesk, global equity finance warehouse, agency landing, global data warehouse, DACS Reuters feed, IRP, Global fixed income, Charles River and several other front offices and back-office systems. Fine-tuned SQL queries to deliver optimum system performance, trouble shooted server problems, did hotline support and 7x24 night support, developed and maintained global complex Sybase and Microsoft replication environments, reorganized tables, and indexes, monitored growth and storage, maintained and installed software. Migrated Sybase 11.9 server to oracle 8.1.6 and Sybase server 11.9 to Informix servers 9.2 using CAST workbench and ERWIN reverse engineering tools. Upgraded Sybase servers to Sybase 11.9 & 12.x and MS-SQL server 7 to MS-SQL 2000 Omni server. To meet the firm’s 1.5 M cost saving initiative migrated jobs from Autosys to control-m. Migrated Sybase servers into BCP environment. Defined and implemented Enterprise Backup Strategy combining hot, cold and logical backups. Implemented SQL BackTrack. Supported development teams and helped them with logical, physical data models and coding issues. Applied patches and customizations. Maintained a complete track of all patches and customizations to help deliver smooth migration path in future. Monitored Operating System Performance including CPU utilization, I/O and memory management. Fine-tuned databases after monitoring locks/latches, contention, redo log switches, rollback segments, temporary segments, checkpoint frequency, etc. Developed processes that helped reduce overall upgrade time by 40% for spider release. Implemented various auditing standards for Sybase. performed HA and Node fail over system tests of environment. Applied all patches and customizations. Maintained a complete track of all patches and customization for migration from Development to QA to Production environment. Was responsible for 150+ Sybase and ms-SQL servers and 200+ Informix instances. Trained team of ten FTSS DBA team for 7x24 production support. Installed/evaluated Crystal Enterprise/Report/Analysis tools for developers under w2k.

Environment: Sun Enterprise 10000/4500/3500, Compaq, Solaris 2.x, Windows 2000/NT, Sybase SQL Server 12.5/12/11.9.X/11.5 & Rep Server 12.5/11.5/11.0, MS SQL Server 2000/7/6, Informix 9,Oracle 9/8, Crystal Enterprise/Report/Analysis, EMC, VERITAS etc.

Lehman Bros., Sr. Database Administrator

Oct 2000 – Mar 2001

Provided database administration support to over 100 plus Sybase/MS SQL-Server/Oracle database instances on various strategic computing environments (Sun Enterprise 10000/4500/3500Alpha, Veritas, EMC, HP H50/HP-UX, NT 4, Compaq). DBA support included installation and configuration, Replication, installation of server upgrades, implementation of database backup/recovery methods, establishing import/export processes, performing database and application-level tuning, managing space utilization, establishing corporate wide database standards, and designing data models.

Environment: Sun Enterprise 10000/4500/3500, Sybase SQL Server 12/11.9.2/11.5.1 and Replication Server 12.0, Oracle 8.1.6, MS SQL Server 7, Replication Server Manager, EMC, Veritas etc.

Weiss, Peck & Greer Investment, Sr. Database Administrator

Feb 2000 – Sep 2000

As Sr. Sybase/Oracle DBA for WPG, did Production support, built Sybase SQL Servers 12 & 11.9.2, Rep Server 12.0, performance tuning, built MS SQL servers, Supported oracle - Isis application, upgrade Sybase servers from 11.0.3 to 11.9.2, supported e-commerce application, Installed, upgraded and supported BPS advantage, Portia and Charles river trading systems, trouble shooted replication and data server problems, did performance capacity management, performance tuned various data servers, Solaris, etc. Applied performance-tuning techniques to enhance data retrieval and upgraded database from Oracle V6.0 to V7.1.

Environment: Sun Enterprise 4500/3500, Sybase SQL Server 12/11.9.2/11.5.1 and Replication Server 12.0, Oracle 8I, MS SQL Server 7.0, Replication Server Manager, appworx, crts, portia, Isis, notrix

MetLife, Senior Database Administrator

Oct 1999 – Jan 2000

Did Production support, built Sybase SQL Servers 11.9.2, Rep Server 11.5, Maintained and trouble shoot DB2 Rep Agent. Supported user groups and fixed stored procedures, trouble shooted replication and data server problems, Infra-structure planning, performance tuned data server, rep servers, digital UNIX, etc.

Environment: DEC Alpha 8000 Servers, Digital Unix 4.2, Sybase SQL Server 11.9.2/11.5.1 and Replication Server 11.5.1/11.0.3, Replication Server Manager, DB2 LTM Rep Agent, MVS, DB2, Direct Connect, Omni Connect, MDI gateway, DB Artisan, etc.

Alliance Capital, Sr. Replication DBA

May 1999 – Sep 1999

Developed 400 + scripts including Replication Bulk-Materialization and monitoring scripts, trouble shooted replication and data server problems, Performance Tuning, Infrastructure planning and installed Disaster Recovery sites. Production support, built Sybase Servers 11.9.2/11.5.1, Replication Server 11.5.1/11.0.3, developed SRDF scripts etc. Trained entire DBA team for Sybase Replication.

Environment: SUN Sparc Ultra Enterprise Servers, Sun-Sparc Ultra Servers, Sybase SQL Server 119.2/11.5.1 and Replication Server 11.5.1/11.0.3, Replication Server Manager, DataLib, sysmon etc.

Lehman Bros., Senior Database Administrator

June 1995 – Apr 1999

Did 7x24 production database support, built Sybase Servers 11.x and replication servers 11.x/10.x, built Informix On-line 9.22/7.x/5.x servers, built Illustra database 3.x, trouble shooted database problems, OS problems etc., Setup and maintained global Sybase database replication between NY/LONDON/Tokyo/Frankfurt sites, designed and implemented replication to sync data into global database for Summit application to help users get global view of data, supported Replication between Sybase/IBM DB2 databases, performance tuned and maintained heterogeneous production, staging and development servers, maintained FDI (Fast Data Interchange) with replication, Converted Sybase System 11.0.3 & 4.9.2 databases to Informix Server 9.22/7.21 including Sybase stored procs, schema, data, triggers etc using Erwin Forward and Reverse Engineering datamart tools, Solaris and Sun OS performance tuning, Infra-structure planning, performed server based Risk Analysis, Introduced Client-Server architecture for Informix in the firm, logical and physical Database design, trained people in Informix Technology, did disaster Recovery planning and implemented servers, installed warm backups, recovered databases, Archive/Restore planning etc.

Environment: SUN Sparc 4500/4000/3000/2000/1000/20,Sybase SQL Server 11.X/10/4.9.X and Replication Server, Informix on-line 9.22/7.x/5.x, SQL/C, T-SQL, DbLib, CtLib, SQL Server Manager, DbArtisan, Cyrano Workbench, SA Companion, Sybase Sqlmon, Erwin Open for ModelMart, Veritas, ODS, HTML, WWW, ISQL/ESQL-C/DbAccess, FDI, DbMaint, Moira etc.

EDUCATION & TRAINING

1982, Bachelor of Science (B.S.) Mathematics major, Gujarat University, India

1984, Post Graduate Diploma in Materials Management, Gujarat University

1985, Post Graduate Diploma in Computer Science, Gujarat University, India

1987, Post Graduate Diploma in Systems Management, Bombay University, India

REFERENCES Available upon request

Contact this candidate