SUMMARY:

• A Seasoned Database & Guardium consultant wif 15 years of experience in international software industry for variety of customers. Broad experience database & Guardium administration.
• Expert in Audit tool Guardium & jSonar Installation & Configuration.
• Expert in writing *nix, perl, python Script.
• Extensive experience in Auditing tools for Database Management Systems.
• Strong experience in writing stored procedure, triggers, query analysis, query optimization.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Guardium & Sonar G Administrator

Responsibilities:

• JSonar Implementation & Integrating wif HADOOP & Guardium
• Python automation scripts for jSonar DR appliance and other services

Skills: IBM GUARDIUM 10.x, JSonar 3.2.x, python T - SQL, PL/SQL, AIX & Linux, Windows Server

Confidential, TX

Guardium Administrator

Responsibilities:

• Installing and upgrading GIM/STAP/SGATE/CAS.
• Classification and Discovery process configuration
• Entitlement Report generation.
• Integration wif Oracle IDM
• Creating reports on Connection profiling, buffer usage monitor for appliance status.
• Drafting VA policies as per teh client requirement including CAS.
• Defining Correlation Alert for implementing health check, implemented fine-grained access control (Query Rewrite), Dynamic Data Masking (Redact) and Blocking
• External security tool configuration QRadar and Service Now (or Remedy) integration
• Use DIAG utility and doing teh house keeping of file system of Guardium appliance as required.

Skills: IBM GUARDIUM 10, T-SQL, PL/SQL, UNIX Shell Script, C, Teradata, Oracle, Linux, Windows 2008, 2012 Sun Solaris 10, MS Excel, MS Visio

Confidential, TX

Guardium Administrator

Responsibilities:

• Worked auditing product evaluation, implemented, configured & administrated IBM Guardium for auditing database security related regulatory requirements SOX & data encryption, obfuscation.
• Worked on Service-Now integration wif Guardium for DBMS changes
• Installing and upgrading GIM/STAP/SGATE/CAS.
• Creating reports on Connection profiling, buffer usage monitor for appliance status.
• Drafting VA policies as per teh client requirement including CAS.
• Defining Correlation Alert for implementing health check, implemented fine-grained access control (Query Rewrite), Dynamic Data Masking (Redact) and Blocking
• External security tool configuration QRadar and Service Now (or Remedy) integration
• Use DIAG utility and doing teh house keeping of file system of Guardium appliance as required.

Skills: IBM GUARDIUM 7.0/8.0 &9.5 and Password security tool Cyber-Arc, T-SQL, UNIX Shell Script, C, Sybase, SQL Server & Oracle, Linux, Windows 2008, 2012 Sun Solaris 10, MS Excel, Autosys

Confidential, TX

Database Administrator

Responsibilities:

• Worked auditing product evaluation, implemented, configured & administrated IBM Guardium for auditing database security for SOX & data encryption, obfuscation.
• Worked on engineering Sybase EBF rollouts for ASE, IQ & RS server and oracle patches & upgrades.
• Configured Sybase ASE for multiple tempdb, dbcc, sysmon & MDA monitoring queries & Sybase replication server tickets
• Configured Sybase REP AGENT for database table-level, MSA & Warm Standby replication.
• Configured Table Level replication & subscription definitions.
• Optimization analysis on performance metrics for Oracle, SYBASE ASE and SQLServer.
• DBMS performance and tuning on SYBASE ASE & Replication Server.
• Experienced in installing, configuring and upgrading SQL Server 2008 R2, 2012, 2014 and 2016.
• Configured always on Availability groups (AAG) on virtual machines & physical box.
• Experience in deploying SQL Server in virtualized environment and good understanding of Operating system concepts of Windows and Linux.
• Hands on experience in SQL Server 2016, maintaining in memory tables, column store indexes.
• Good knowledge of capacity planning and architecture design for database server deployment.
• Proven experience in working in a mission critical environment wif database size of 20 TB plus.
• Perform routine maintenance on several database environments including application of updates, patches, and hotfixes for oracle DBMS.
• Optimizationand tuning SQL queries usingTRACE FILE,TKPROF,EXPLAIN PLAN.
• Partitioned large tables for better performance and manageability.
• Load and Transform data using SQL Loader and External Tables
• Responsible inconfiguring and backing up database using RMAN, Hot backups, Cold backups and logical backups.
• Creating databases, migrating database objects from non-production to production environment.
• Designing and building data models, schemas, views, and tables to support application requirements
• In-depth knowledge of IT industry database technologies and processes and business applications integrated wif database technologies.
• Provide 24 x 7 Support to Critical production systems.
• Business Recovery (BCP) plan & preparation for support.
• Knowledge of Project Management Methodologies.

Skills: Sybase ASE, Sybase Replication Server, SQL Server & Oracle, ODA, Linux, Windows 2008/2012, MS Excel

Confidential, NY

Database Administrator

Responsibilities:

• Managed large scale environment of 500+ DBMS instances.
• Maintained data integrity & latency between EU, NA & AP region using replication.
• Configured ASE for multiple tempdb and dbcc checkstorage.
• Configured back & recovery for DBMS.
• Configure REP AGENT for database replication.
• Configured data collection for optimization & performance and tuning.
• Implemented performance metric based on business SLA expectation for 100+ production instances.
• Automated script to support developers and business users to view internal queries running on instances.
• Installation and configure Replication Server more than 100+ production servers.
• Configure and maintain replication definition and subscription for multiple migration project support.
• Setup migration scripts for RSSD & replication routes for multiple migration project support.
• Setup database in Multisite availability (MSA).
• MSA maintenance and troubleshooting, MSA re sync, etc.
• Migration of replicated database from one replication Server to another.

Skills: Sybase ASE, Sybase Replication Server, Oracle, UNIX Shell Script, Solaris, Linux, Excel, Autosys

Confidential, Stamford, CT

Developer

Responsibilities:

• Database development project Involved in Level 3 support for CtB-M, CtB-me & RtB projects
• Managed a team of 4 members
• Project steering and Onsite - Offshore team coordination
• Performance evaluation and mentoring team members
• Analyzing existing store procedures and triggers functionality and changed code to prod environment
• Wrapper UNIX shell and/or Perl scripts for store proce in cron jobs for extraction, reconciliation reports

Skills: Sybase ASE, Sybase Replication Server, Oracle, Unix Shell Script, Solaris, Linux, Excel, Autosys

Confidential

Developer

Responsibilities:

• Prepared SDD wif prototype design wif database modeling using power designer
• Managed Team of 4 in designing and coding Sybase TSQL’s
• Performance and Tuning of Sybase ASE before & after implementation to production.
• Wrote Sybase store procedure and triggers for Cost Allocation & Online Financial Adjustment
• Wrote custom made scheduler program prototype which developed using Sybase T-SQL and C TCP socket program.
• Implementation of Sybase objects to Staging, DR and Production.

Skills: Sybase ASE, T-SQL, UNIX Shell Script, Solaris, Linux, Excel, Autosys