SUMMARY:

• Over 25 plus years of experience in Database Management and Administration, Database Engineering, Data Architect, Design, Big Data for fortune 500 companies as Lead
• Extensive experience in Capacity Planning, Database Infrastructure Planning and Architecture
• Manage and Mentor Confidential Dba Team across multiple continents
• Extensive experience in performance tuning of the database
• Extensive experience in General DBA task ( Backup and Recovery, HA/DR, Configuration etc ..)
• Extensive experience in Database migration.
• Designed and Managed database servers that are both OLTP and DSS
• Extensive experience in Replication Server System and Database Clustering.
• Extensive experience in Database modeling and Data warehousing.
• Strong experience in writing Stored procedure, triggers, Query Analysis, query optimization
• Strong experience in MongoDB, Oracle and MS SQL Server Administrator
• Good Knowledge of Enterprise Infrastructure: SAN, Networks, Hosts, Power7/Linux/Solari
• Good programming experience in T - SQL, Ksh,, Csh, Perl C, C++ Clear Case

TECHNICAL SKILLS:

RDBMS: MONGODB 3.2 SAP (Sybase) ASE (10/11/12/15/15.5/157/16 ), ASE CE, REP SRV 12.x/11.x/15x, SAP HANA, IQ 12.7, MSSQL SRV 7.0/6.0, Oracle 8.x./9i

Hardware: IBM Power 7, HP 9000, Sun Sparc 3000/4000/6500/6800, Sun fire 240/480, NCR 3550

OS: IBM Aix 7.x, Linux 4.0/5.0, Solaris 8/2.x, Confidential &T Unix 4.0.3, HP-UX 11, IRIX 6.5, NT 4/5

Languages: C, C++, Perl, PowerBuilder 4.0/3.0, T-SQL, KSH, CSH, Assembly

Tools: Proactive Dba, DBArtisan, Power designer, DB Patrol, SQL Monitor, SQL Backtrack, EDBA, ClearCase, AutoSys, RCS, Veritas Volume Manager, Visual Sleek, CAST, Erwin, Eclipse, Informatica.

PROFESSIONAL EXPERIENCE:

Confidential

VP (DBA)

Responsibilities:

• Strategy & Planning: Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers .
• Lead Project on Database security which includes Sybase Encryption and Password policy and Ldap Implementation
• Primary for Reporting for Business Analytics using SQL queries and Tableau and Developing new feature for the same and running reports using Autosys
• Create models for new database development and/or changes to existing ones and performed Design review

Confidential, NewYork, NY

Team Lead DBA

Responsibilities:

• Managed Multi Tera byte Complex Financial System (OLTP) in virtualized Environment.
• Advising Senior technical Management for capacity planning and coordinating Function database design
• Project Lead for migrating Mongodb from 2.4 to 3.2 which includes repset.
• Architecting New Infrastructure to cope with increasing data volumes and providing reliable platform.
• Designed Strategies to implement IMDB, Compression for better performance for Business Analytics.
• Database tuning, Performance monitoring and Query optimization .
• Developed and Implemented strategies, processes for Database Migration.
• Managing Dba Team across multiple continents
• Lead on migrating SYBASE ASE from 15.7 to 16.0 .
• Designed and Developed policies, procedures and controls for Database security including encryption.
• Performed all Dba task ( 24/7 Support, Backup and Recovery strategies, Adding patch, troubleshooting, Configuration, D/R, Capacity Planning etc )
• Implemented Semantic partitioning for better performance and reducing down time
• Lead conversion databases from ASE SMP to ASE Cluster on IBM Power P7 .
• Providing technical assistance to Operations, Applications, Business clients to resolve production schedules or problems
• Providing mentorship and coaching to team members and development team.
• Coordinating with QA/Deployment for deploying releases to production servers.
• Implementation and support of proactive dba monitor for database servers
• Building Rep Server, Rep Agents for Warm standby and tuning performance
• Evaluated SAP ( Sybase IQ ) and SAP Hana for infrastructure upgrade .

Confidential, Basking Ridge, NJ

Sr Sybase DBA/Data Architect

Responsibilities:

• In charge of Confidential production support team that managed databases 24/7
• Designed and implemented backup and recovery procedure for all servers
• Performed Moving of Database from file system to Raw partition
• Installation of new ASE servers and Developed QA environment
• Developing standards for user and security Management
• Developed change manager process for production releases
• Developed and Implemented database schema synchronization using Embarcardo change manager
• Developed Data dictionary for New schema as well as for existing schema.
• Designed and implemented logical and physical Data modelling using power designer tool.
• Designed and developed data life cycle and archival procedure for data from database.
• Designed and implemented infrastructure expansion for further database growth.
• Converting data from iso 1 to utf8 character sets.
• Setting up version control for database schema using eclipse.
• Evaluating Multi site availability feature of replication server .
• Supported application using informatica, power center tool, power analyzer, ETL
• Involved in database conversion project from data from 32 bit to 64 bit.
• Involved in Managing Sybase IQ
• ASE 12.5.4, Linux 4.0, Rep srv 12.6, Solaris 9, K-sh, Informatica, power design, Sybase IQ 12.7, Db Artisan, Eclipse

Confidential, New york, NY

Senior Sybase/Oracle/Unix sys admin

Responsibilities:

• Performed Dba tasks; Troubleshooting, Performance Tuning. 24/7 Support, Installation etc…
• Managing production Releases for Sybase, Oracle, Unix, Backup and recovery .
• Involved in network management and configuring network connectivity
• Adding/removing memory card and hard disk,, Security Management, Jumping the unix Box
• Configuring Frame buffer, Installing video card . Installing solaris 8/9. Installed Linux Box
• ASE12.5.3, Solaris 8/9, Oracle 8, Veritas Volume Manager, Linux 3.0,Ksh

Confidential, Sacramento, CA

Senior Replication Administrator

Responsibilities:

• In charge of Replication design and performance, troubleshooting for Confidential system.
• Involved in designing, developing, testing of HA system using M/C Service Guard
• Closely interacting with development, test and production teams, and guiding them as well.
• Built Rep Server, managing replication tables, managing subscription, managing routes, managing database connection, function strings, bidirectional and implementing Security for Rep system like SSH and GPG

Confidential, MD

Senior Database Administrator

Responsibilities:

• In charge of performance tuning of Earth Observatory System for NASA.
• Designing, developing, testing, tuning of Data Warehouse database
• Extensively using Dimension Modeling, Data Partitioning feature of DWH
• Writing stored procedure, spatial query (SQS), Perl Script and maintaining it in ClearCase
• Tuning Query, Query Optimization, creating engine class, tuning memory, tempdbs

Confidential

Principal Consultant

Responsibilities:

• Team Lead for managing Mission Critical Database system that includes production, web and open server. Tuning db system by Optimizing caches, adding named cache, creating engine class, disk striping etc
• Maintained and managed, performance tuning, configuring, server built, troubleshooting, monitoring, and coordinating production releases of mission critical system for Sybase and Oracle
• Providing 24/7support for trading floor systems such as Mortgage based systems, short - term, Finance, Commercial Paper, Government High Yield, Investment Banking, Treasury systems.
• Emergency DBA work ( resolving corruption, database recovery, applying patches etc ..)
• Analyzed and Rebuilt Indexes, Ran Update statistics, Performed Query Optimization, Writing Stored procedure, triggers, Bcp performance etc
• Performed review of functional, system and program specification for FACET D.W.H Application
• Performed Code Review for Readability, Maintainability, Performance, and Modularity
• Analyzed and Designed data for interfacing application for customization of data
• Data Modeling, Normalization, Generating E-R Diagram, DFD and setting standards
• Managed the version control for the stored procedure, triggers, tables in ClearCase
• Worked on CIS (proxy) table to communicate between secured Sybase servers
• Managed and moved Oracle database from one platform to another
• Managed and maintained data warehousing project using Sybase
• Involved in Sybase Security feature to audit event like logins, server boot ops, RPC calls, accesses to database objects, and actions performed by a specific user with a particular role activities
• Developed a migration plan, performed Reverse engineering and capacity planning for database migration.
• Planned and executed of relocating more than 300 ASE production Servers Replication Servers, Open Servers, SQL Backtrack in Solaris environment as part of Data center move .
• Project planning, Coordinating with Application, Sysadmin, Backup teams, Scheduling of critical processes
• Designed and Managed Backup and recovery strategy for database system for different platforms .
• Installed SQL Backtrack for backups and used DB Verifier to perform DBCC
• Writing extensive Shell, Perl programs for automation and streamlining of the key process, which involved in moving of terabyte worth of data and also for managing the database environment
• Developed and delivered Disaster Recovery for Business continuity of database system .
• Assisted in running Autosys jobs and also maintaining those jobs
• Data server Server Consolidations
• Managed and Migrated complex Replication system that has 2-way, warm standby replication
• Monitoring, and tuning heterogeneous replication system between Sybase and Oracle
• Tuning the performance of the replication of large tables between Oracle and Sybase Server and vice-versa with and without warm standby load
• Testing high availability features of the Sun hardware cluster
• Upgraded the hardware to Sprac Ultra2/ Sparc4000 and moving from Sun OS to Solaris 2.5
• Setting up Raid System for Box Hill 5300 turbo . Installed Veritas Volume Manager for disk management.
• Performing migration of complex financial data from Sparc 4000 to Sparc 4500
• Performed role of UNIX sys admin ex: setting up printer, file system, user account, creating raw partition etc
• Gained excellent exposure to all the areas of IT by working with many system admins, Sybase and Oracle DBAs, network admin, Project Managers, Senior Managers and Directors

Confidential

Sr Sybase DBA

Responsibilities:

• Managed SYBASE,MSSQL Servers, Initializing/Managing disk space, creating databases, user accounts, granting permissions, configuring/ tuning server, troubleshooting, database recovery, Creating Raw Partitions, Tuning application, database design, monitoring, query tuning and database sizing.
• Designed and Delivered Backup strategy for whole system, includes D/R, HA using Qualix
• Performed Capacity Planning and formal specification, data modeling of DBMS
• Used C & DB library for populators for batch update
• Writing shell scripts to perform various releases, maintain batch programs and managing backups
• Developed screens in power builder for Customer Interface Group for New Automated Lead System
• Managing Users access and provide on - line information to their customers
• Coordinating releases, charting implementation plans and modifications as per user needs
• Creating several executables using PBL, PBD, PBR
• Sybase 10.x, Sun Sparc 1000/2000 Sun Solaris, NCR 3550, Unix, MS Sql Srv, Windows NT, PowerBuilder

Confidential, NJ

Sybase DBA/ Programmer Analyst

Responsibilities:

• Installing Sybase, Db design, configuring/tuning troubleshooting, Db Recovery for Inventory system

Confidential

Programmer / Analyst

Responsibilities:

• Developed various screens to display information about user’s registration, courses completed…etc
• Designed system using DFD, E-R Diagram and CASE Tool such as Excellerator
• Used Huffman coding technique for data compression and simulated operating system calls in C/C++/Unix

Confidential

R &D Engineer

Responsibilities:

• Programming cash transactions and accounts receivable system.
• Coding in C++ to compare the various ways of data storage techniques ex Btree, Hashing, Sequential
• Developing interfacing software in C/Assembly for analog and digital circuitry
• Designing and Developing the cable fault locator
• Coded a two-pass assembler for SIC and SIC/XE machine. Implemented a two-pass linking loader in C