Python Security

Joseph Rajiah 713-***-**** - M

*.*************@*****.***

PROFESSIONAL CAREER

A Seasoned Database & Guardium consultant with 15 years of experience in international software industry for variety of customers. Broad experience database & Guardium administration.

Expert in Audit tool IBM Guardium & jSonar (GDBI) 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.

Certificate & Workshops Completed

IBM GUARDIUM Certified.

(SAP) Sybase ASE and Replication Server Administration.

Oracle 11g Admin 1 & 2

PROFESSIONAL EXPERIENCE

JPMC, NY Apr 2019 – Current

Database Admin & Security

Responsibilities:

Database monitoring and audit privilege account using Guardium

Guardium engineering and support.

GDBI (jSonar) implementation with various region guardium collector, aggregator an CM

Automation jSonar DR appliance using custom python script

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

Bemis, WI May 18 – Mar 19

Database Admin & Security

Responsibilities:

Wrote Python and PowerShell script for collecting, storing database audit data for analysis.

Analysis & Implementation on auditing database security for data encryption, obfuscation.

Assisted multiple application related issues to SQL performance.

Worked as primary contact on projects to steer application jobs to follow Bemis support and maintained guidelines.

Skills: MS SQLServer 200/05/08/12/16/17, PowerShell Python T-SQL, Windows Server

BCBS, NY Jun 2018 – Dec 2018

Database Admin & Security

Responsibilities:

Working on JSonar Implementation

Integrating JSonar with HADOOP, Guardium

Automation jSonar DR appliance using custom python script

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

American Airlines, TX Jan 18 – Apr 18

Guardium Administrator

Responsibilities:

Installing and upgrading GIM/STAP/CAS.

Classification and Discovery process configuration

Entitlement Report generation.

Integration with Oracle IDM

Creating reports on Connection profiling, buffer usage monitor for appliance status.

Drafting VA policies as per the 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 QRadar integration

Guardium & change management system ServiceNow (or Remedy) Integration

Configuring CAS for Monitoring the file system and environmental changes.

Use DIAG utility and doing the 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

Invesco AIM, TX Jun 10 – Mar 18

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 with Guardium for DBMS changes

Installing and upgrading GIM/STAP/CAS.

Creating reports on Connection profiling, buffer usage monitor for appliance status.

Drafting VA policies as per the 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 QRadar integration

Guardium & change management system ServiceNow (or Remedy) Integration

Configuring CAS for Monitoring the file system and environmental changes.

Use DIAG utility and doing the 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

Invesco AIM, TX Sep 08 - May 10

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 and dbcc checkstorage.

Configured Sybase ASE sysmon & MDA monitoring queries.

Configured 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 with database size of 20 TB plus.

Perform routine maintenance on several database environments including application of updates, patches, and hotfixes for oracle DBMS.

Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.

Partitioned large tables for better performance and manageability.

Experienced in performing Point-in-Time Recovery.

Load and Transform data using SQL Loader and External Tables

Configured and implemented Oracle Streams

Responsible in configuring 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 with 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

Lehman Brothers, NY Jan 07 - Jul 08

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

UBS, Stamford, CT May 06 - Jan 07

Developer (Sybase, UNIX & Perl Routines)

Responsibilities:

Database development project Involved in Level 3 support for CtB-M, CtB-I & RtB projects

Managed a team of 4 members

Project steering and Onsite – Offshore team coordination

Performance evaluation and mentoring team members

Analyzing existing functionality for change request and support for system, regression, and user acceptance

Testing

Developed multiple store procedures and triggers

Analyzed and wrote UNIX shell scripts and cron jobs for extraction, reconciliation and tax reports

Skills:

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

Polaris Software Lab, Chennai, India Mar 03 - Feb 06

Developer (Sybase, UNIX Routines)

Responsibilities:

Prepared system definition document (SDD) with prototype design with 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.

Designed and developed Sybase store procedure and triggers for Cost Allocation & Online Financial Adjustment

Designed prototype for custom made scheduler program 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

Contact this candidate