SUMMARY:

• An IT Professional wif over 13+ years (9 Yrs. offshore & 5+ Yrs. Onsite) of diverse Core experience in teh field of Database engineering along wif open - source DB & cloud technologies.
• Technical proficiency in handling PostgreSQL, SAP SYBASE ASE, IQ, MSSQL majorly Database related Installing, configuring, administering, maintaining, and securing production database servers & Knowledge in Shell Script.
• Extensive experience wif Hot Standby (PostgreSQL (10.x and greater) using repmgr and PgBackrest backup manager.
• Hands on experience as a for MS-SQL & Sybase databases administrator supporting a large and diverse application portfolio of 24×7 critical production systems
• Proficient in leaded multiple teams and worked on multiple projects wif Senior Managers for teh database design and Strategies.
• Proficient in Training New Joiner and good Knowledge on Managerial activities like Team Management, Shift management, resource management etc.
• Proficient in ITIL Management process, Change Management, Incident Management & Excellent communication interpersonal skills wif abilities in resolving complex issues.
• Onsite-Offshore Coordination
• Technical Panelist for DBA
• Change Management Process
• DB migration process
• Handling Service delivery calls
• Document Management Systems
• Mentoring and Training Staff
• Resource Management
• Project Integration

PROFESSIONAL EXPERIENCE:

Confidential

PostgreSQL DB A

Responsibilities:

• Installation and configuration of postgreSQL database, creating cluster instance, connecting to server.
• Creating and Managing databases, schemas, roles and access control.
• Database schema creation and management, Ensuring data integrity.
• Implementation of postgresql procedure, triggers, using pgAdmin III for different administrative tasks as well as command line interface.
• Security Basics such as pg hba.conf configuration, SSL configuration, LDAP autantication etc.
• Implementing backup/recovery strategies, Streaming Replication over TCP/IP and archiving database, Point-In-Time recovery, Replication using replication slots, Cascade replication.
• Logical replication: Using logical replication slot, PUBLICATION/SUBSCRIPTION model, pglogical. pg dump, pg dumpall, pgbasebackup, Database upgrade.
• Routine MaintenanceTasks: Vacuum, Vacuum Full, Reindex, Analyze.
• Performance tuning at sql level, hardware level, sql tuning, Analyzing EXPLAIN plan.
• Postgresql.conf parameters tuning like work mem, maintenance work mem, TEMPeffective cache size, shared buffer, join collapse limit and from collapse limit, default target statistics, seq page cost, random page cost etc.
• Postgresql Server monitoring
• Database lock monitoring, active queries/long running sqls monitoring using pg stat activity,Database cluster (partition) size monitoring, disk read/write, server load monitoring
• Database connection limit monitoring, handling issues like ran out of disk, connection limit reach
• Installing, configuring, managing, monitoring and troubleshooting ASE Server version 12.5X to 15.X and Responsible for working on high severity tickets like 2A, 2B, 2C.Server version upgrade, ESD upgrade. Analyzing database performance issues. CreatingDatabase maintenance Autosys jobs like backup, update statistics, reorg, reindex etc.
• Handling monitoring systems BMC, MON tables and MDA tables. Strong understanding of backup and restore procedures. Configuring and tuning teh sp configure values for performance tuning and troubleshooting operations. Analyzing and monitoring system performances using DBCC Trace on commands, query plan outputs, sp sysmon, optdiag etc. Troubleshooting user and system Database Corruption. Configuration of system databases like sybsecurity, dbccdb for monitoring and dbcc operations.
• Design and implementation of Transaction Log Shipping of system and user databases for high availability systems.
• Installation and configuration of replication setups. Resolving replication server issues. Capacity planning for database servers based on teh metrics available for teh server.
• Taking up ad-hoc requests from users pertaining to variety of database tasks, monitoring system for performance bottlenecks etc.
• Responsible for managing trading data, user/transaction, Homogeneous and heterogeneous Replication on Sybase ASE 15.7, Replication server 15.5,
• Installing Sybase ASE servers Applying EBFÂ’s to Adaptive Server,
• Replication Server Upgrading Adaptive server from 15.5 to 15.7 Configuring server memory, data cache, procedure cache Starting and stopping listener services Adding multiple engines.
• Performing cross platform dump and load Configuring memory pool in data cache, log cache Setting log io size for databases Using system procedures like sp objectstats, sp monitor, sp sysmon, sp lock running update stat, reorg rebuild.
• Installing Sybase auditing as per requirement System monitoring at Sybase ASE level. Monitoring replication system, Installing, Building and Configuring replication server parameters Adding databases to replication system using RCL, rs init Adding, dropping, altering partitions as per requirement Creating rep definitions and subscriptions for table level replication in homo and heterogeneous environment. Alter, drop rep def in test and live as per requirement Marking source tables for replication Enabling and configuring rep agent threads in ASE. Setting table level replication, taking stable queue dump for troubleshooting Purging replication server stable queues if required in test and PROD.
• Monitoring Sybase IQ database, for versioning and temp space full.
• Troubleshoot and resolve production problems involving databases, supporting multiplex in Sybase IQ.
• Resetting Sybase IQ user password and assigning login policy, drop connection as per user request.

MS-SQL DBA

Responsibilities:

• As a production L2 support DBA, responsible for working on service now incident tickets, and handling critical incident.
• Providing SQL server implementation changes requested by PDBA and Application team.
• Responsible for providing SQL server problem resolution and 24*7 production support and server outage.
• Responsible to coordinate wif windows admin team to apply patch and SQL server host and do checkout and health of database.
• Providing DB capacity planning by monitoring file group and drive space growth.
• Responsible to work on production incident like, blocking, tempdb issue, high cpu, DB backup or Netbackup failure.
• Monitoring replication and always on and work on incident created for AG offline issue.
• Responsible for checking weekend autosys jobs like Re-index, Update stat and dbcc, and take necessary action if they fail.

Confidential

Responsibilities:

• Responsible for Sybase ASE, Sybase IQ, Sybase Replication server and Microsoft SQL Server database administartion. Primarly responsible for database design, datawarehouse administartion. Monitor disk space, database health checks, database backups and error log scanning. Configure Servers to achieve teh best performance and writing automated database monitoring scripts.
• Specialized in all aspects of database design and programming wif Sybase Adaptive Server Enterprise, Replication server and Sybase IQ Server and Oracle Data modeling, Database design, Transact SQL programming and Open Client programming performance & tuning issues and troubleshooting and security administration Long-standing experience wif Sybase Adaptive Server enterprise (ASE) covering versions 10.x 11.0, 11.5, 11.9, 12.0, 12.5 and 15.0, starting in 1995.
• Experience wif Sybase IQ database 12.0 and 12.5.Experience wif Sybase Replication Server 12.0, 12.5 and 12.6. Experience wif Open Client versions 10.x, 11.x, 12.0, 12.5 and 15.0 .
• Extensive experience in migration and conversion of data to/from various data sources. Extensive general IT skills covering UNIX shell scripts, PERL scripts, CORN Jobs and various programming languages. Extensive experience in ETL and Data warehouse.
• Experience in ETL
• Experience in Sybase SQL Anywhere and Sybase mobile technology.
• Experience in Microsoft SQL Server 2012/SQL Server 2014 database administration.
• Experice in Sybase IQ Server(data warehouse)

Confidential

Responsibilities:

• Providing L2 support for Sybase ASE related issues. And providing Technical Support to team members & end-users.
• Responsible for working on high severity tickets like 2A, 2B, 2C.
• Responsible for tuning teh server for better performance.
• Periodically check teh Sysmon report and gather teh benchmark.
• Monitoring Memory Usage and CPU Utilization.
• Good experience in troubleshooting, performing RCA of critical incidents and proactively working towards preventing outage.
• Monitoring stack traces and raise Sybase cases and recommending system configuration changes to enhance teh performance.
• Experience in supporting 50+ Sybase data servers for different geographical locations wif user base of more than 1000+ users.
• Installation and configuring of SYBASE 12.5.x/15.xunderwindows, Solaris and AIX platform in production and UAT environment.
• Upgradation of Sybase ASE from 12.5.x to 15.0.3 and 15.5 using in place upgrade and dump load method.
• Performing daily health check of all Production/UAT and development data servers and take necessary action, if found any issue.
• Creating jobs to run optdiag on all prod and UAT server, and run teh reorg based on teh DPCR value for tables.
• Setting up dbccdb to run dbcc checkstorage and after checking teh dbcc report performing teh appropriate dbcc command for fixing teh inconsistency.
• Refreshing development and UAT databases as per client and developers requirements using production backups.
• Setting job to run update statistics based on teh data change value of a table in prod databases.
• Performing Production and UAT releases and deployments as per teh clients request tickets.
• Setting ASE configurations parameters and database options as per client’s requirements.
• Creating sybsecurity database for audit purpose and configuring server for auditing.
• Daily check of Sybase error log and backup server log of all databases server.
• Creating and granting access for database as per teh clients request tickets.
• Configuring, planning and supporting jobs in Job scheduler (Maestro).
• Creation of remedy ticket for DBA related work on production database server.
• Sybase Server Basic Monitoring like Job failure / Space issue / Blocking; Deadlock / Long running process (Open) transaction / Replication / Database failure / SQL Services Extract text and/or show plan for any given process.
• Initialization of devices and database creation / alteration/ deletion / log maintenance.
• Preparing teh database growth report for all prod and non prod databases and coordinate/discuss wif app team for getting teh more space on SAN storage.
• Responsible for creating teh monthly incident and deployment ticket report and present to teh client AVP in monthly touch point meeting.
• Monitoring Replication server and if any thread got down tan work to bring it up by checking teh error log and exception log. Checking teh data synchronization in warm stand by setup using sybcomp utility.

Confidential

Responsibilities:

• Successfully completed CBOP to HDFC bank migration project from oracle to SYBASE.
• Handling about 8 Server having an average 7 Database in each server. Synchronizing teh development databases wif production database to halp developers. Monitoring these servers by accessing remotely and analyzing teh databases of size up to 1 TB.
• Maintaining UAT and development servers, ensure teh availability of teh UAT database to end user and development database to developer.
• Handling various issues rose from teh Users regarding teh Database activities. Implement teh Solution in teh UAT Environment and testing thoroughly.
• Troubleshooting database related problems as and when required.
• Create database and restore database from backup.
• Setting database options, access and permissions. Setting up multiple tempdb.
• Checking and fixing inconsistency of databases using DBCC commands.
• Running update stats and reorg commands.
• Identifying longest running transactions, tempdb usage, analyzing query plan output.
• Creating new user, logins, roles, granting permissions and roles.

Confidential

Responsibilities:-

• Monitoring application database server using app login.
• Generation of health check report of all win and Unix server.
• Monitoring 3D-secure, payment gateway and accossa application, which need to up 24*7.
• Responsible to take teh backup of daily prod application log and provide to teh business team.
• Coordinate wif ATM team and provide teh ATM, IVR, POS log file for further processing.