Sajan Varughese

*** ****** ** ********, ** - ****5

Tel.: 404-***-**** Email: ad5a1n@r.postjobfree.com

Email: ad5a1n@r.postjobfree.com

PROFESSIONAL SYNOPSIS

•Database professional with 24+ years of experience in designing and implementing OLTP databases and data warehouse environment.

•Worked on large systems that have a size of 1.5 TB that supported up to 25000 online users. Experienced in Logical and physical data modeling using ERWIN and Designer2000. Extensive experience in PLSQL/SQL/Shell scripting as a developer as well as DBA.

•Have substantial experience in Performance tuning database at the instance level and SQL level. Experienced in partition maintenance, database maintenance, Database installation, cloning, database software installation and patching the database software.

•Experience in data modelling for health insurance, manufacturing and telecom domain.

•Experienced in Oracle database version 6 through 11g. Experienced in SQL Server databases from version SQL Server 2000 through SQL server version 2012.

•Experience on migrating database from 10g to 11g and 9i to 10g.

TECHNICAL SKILLS

Databases/Tools: Oracle [7.x, 8i/8.0.x, 9.2.x, 10g, 11g],Oracle 12c,Oracle 19c, Enterprise Manager, TOAD, DB–Artisan, SQL Loader, RMAN

Data Modeling: ERWIN 3.52/4.x, Designer2000

GUI/Programming Languages: Developer2000 [Forms/Reports, PLSQL, SQL, UNIX Shell

Scripts, Forms12c

Operating Systems: ICL UNIX SVR 4.2, AIX 4.x, HP/UX B11.11/9, Sun Solaris, Redhat Linux Advanced Server, Windows NT/Windows XP

EDUCATION/TRAINING/CERTIFICATION

•1991, B. Tech, Mangalore University, India, bachelor's degree Major in Computer Engineering.

Training:

•Oracle Database Administration, Oracle 10g RAC administration, Oracle e-Business Suite 11i/R12.1.x, R12.2.x, Windows NT Administration, UNIX System Administration, Rational Clear Quest, Rational Clear Case, Six Sigma

Client: Kissmetrix

Role: Oracle DBA and Developer

June 2023 - Present

PLSQL DBA performance tuning

Developing PL SQL

insulation on LINUX platform

PROJECTS EXECUTED

Client: Synchrony Financial Role: Application DBA Duration:Dec 2022 – March 2023

Platform: Redhat Linux, Oracle 19c, PLSQL Team Size: 5

Responsible for Performance tuning SQL, PLSQL

Designing Partition schemes in Production databases

Creating database design documents

Client: Radian Inc

Role: Database Administrator

Duration May 2022 – October 2022 Platforms: Oracle 19c, PLSQL, UNIX Team Size: 5

Responsible for development, UAT and production database environments of oracle 19c version running on Linux/AWS environment.

Fine-tuned SQL queries.

Performed archiving of data in production environment.

**Feb 2020- April 2022 – Looking for a job

Client: Anthem Inc. Role: Software developer

Duration: Nov 2019 – Jan 2020 Platforms: UNIX. Oracle 12c, PLSQL,SQL Team Size: 10

Synopsis:

Anthem provides insurance services to Americans in USA. Geodexia provides IT services to fortune 500 clients across USA.

Responsibilities:

•Responsible for SQL and PLSQL development on Oracle 12c database under UNIX platform

**Sep 2017- October 2019 – Looking for a job

Client: State of Indiana thru Deloitte consulting Role: Level 3 Database Administrator

Duration: Feb 2017 - Aug 2017

Platform: Oracle 11g. PLSQL, .SQL, OEM10G, Solaris Team Size: 5

Synopsis:

Deloitte provides IT services to fortune 100 clients across USA. State of Indiana provides services to its.

Responsibilities:

•Worked in IOT department on database projects

•Responsible for making database changes to all database environments

•Supported the client in developing PLSQL code.

•Fine-tuned database and applications developed in PLSQL

•Created database objects

•Installed oem10g on Solaris environment

Client: BOEING thru TATA America Role: Level 3 Database Administrator Duration: Nov 2015 – Jan 2016

Platform: Oracle 11g. PLSQL, .SQL, OEM10G, Solaris, SQL Server Team Size: 10

Synopsis:

Tata America provides IT services to its clients across the globe. Boeing manufactures and sells aircrafts and engines.

Responsibilities:

•Administered Oracle databases

•Applied database changes to SQL Server database environments.

•Installed Oem10g on Solaris

Client: Ever Source thru Infosys technologies Role: Oracle Database Administrator Duration: Feb 2015 – Apr 2015

Platform: Oracle 11g. PLSQL, SQL, Solaris, ASM Team Size: 5

Synopsis:

Infosys provides IT services to its clients across the globe. Ever Source is a electric company serving the customers in state of Connecticut

Responsibilities:

•Responsible for administering oracle databases including ASM on AIX, Solaris 8 platforms

•Fine-tuned and developed PLSQL code

•Migrated database changes to production, test environments.

•Day to day production support of the applications

•Maintained data integrity through out the system during different SDLC phases

•Performed backup using RMAN

•Identified and resolved deadlock issues.

Client: Fidelity Investments Role: Oracle Developer Duration: Sep 2014 – Dec 2014

Platform: Oracle 11g. PLSQL, SQL,Autosys Team Size: 5

Synopsis:

Infosys provides it services to its clients across the globe. Fidelity is a financial services company serving usa and the globe.

Responsibilities:

•Responsible for developing PLSQL

•Fine-tuned PLSQL applications.

•Created data models using ERWIN

•Designed and implemented indexes

•Determine the changes in physical data by studying project requirements or incident ticket, identifying data characteristics.

Client: AT&T Role: Oracle DBA

Duration: April 2014 – May 2014 Platform: Oracle 11g, Red-hat Linux Team Size: 4

Synopsis:

Ignite is a management company serving the clients across USA. AT&T is a phone company servicing the customers in USA.

Responsibilities:

•Responsible for schema refreshes, patching of application and shell script and PLSQL development

•Installed oracle database software, applied patches to oracle home

•Upgraded databases from 10g to 11g

•Fine-tuned PLSQL code

•Created tables, views, indexes and packages

•Use standard methods in all stages including collection, analysis and reporting • Maintains data dictionary by revising and entering definitions.

•Guard and protect the organization's data, making sure that the data repositories produce consistent, reusable data

Client: FEDEX

Role: Database Architect Duration: Sep 2013 – March 2014

Platform: Oracle 11g, PLSQL,ERWIN Team Size: 4

Synopsis:

Infosys serves the customers across the globe. FedEx is a mail servicing company in the USA.

Responsibilities:

•Responsible for database architecture for command center application that is used for monitoring various applications used by FedEx.

•Created database triggers and stored procedures

•Designed and implemented tables and indexes.

Client: JP Morgan Chase Investments Role: Application Developer

Duration: March 2013 – May 2013

Platform: Oracle 11g, PLSQL, Crystal Reports Team Size: 4

Synopsis:

JP Morgan chase is a financial service company serving the clients in USA. Collabra is a consulting company servicing IT services to fortune 100 clients in USA.

Responsibilities:

•Created stored procedures and crystal reports as per the requirements of the client

•Fine-tuned PLSQL applications

•Designed and implemented tables and indexes

Client: GE Aviation Services

Role: Lead Database Administrator Duration: Feb 2012 – Aug 2012

Platform: Oracle 10g,Oracle 9.2.0.8 OEM, Solaris 8 Team Size: 10

Synopsis:

GE Aviation is a aviation service company manufacturing and servicing aircraft engines in USA

Responsibilities:

•Led a team of ten database administrators

•Assisted in performance tuning of oracle based applications.

•Managed databases and installed and patched oracle databases.

•Responsible for creating change requests and follow up with the DBA resources to implement the same into database environments.

•Assisted in design review of applications developed on Oracle RDBMS platforms.

Client: Verizon Wireless

Role: Application Database Administrator Duration: Aug 2011 – Oct 2011

Platform: Oracle 11,PLSQL, Red-hat Linux Team Size: 10

Synopsis:

Verizon wireless is a wireless company serving the USA customers. Worked as a application database administrator

Responsibilities:

•Responsible for performance tuning of Oracle PLSQL packages, data model review.

•Created procedures using PLSQL

•Managed Oracle databases, Installed databases and patched the same

Client: JP Morgan Chase Payment tech Solutions, Tampa, FL Role: Sr. Database Management Analyst

Duration: Oct 2008 – June 2011

Platform: Oracle 11,PLSQL, HP UX, Shell, RMAN, Oracle Streams, Partitioning Team Size: 7

Synopsis:

JP Morgan chase Payment-tech processes credit card transactions across the retailers in USA.

Responsibilities:

•·Managed production Oracle database environments.

•Installed oracle databases using 9i, 10g and 11g versions.

•·Assisted developers and architects with physical data design to meet the performance requirements of application.

•Created shell scripts for backup and database monitoring.

•·Developed PLSQL scripts to compare data between primary and disaster recovery sites.

•·Provided technical support to application teams, business analysts and QA staff.

•Created DR sites using Oracle streams 11g databases.

•Performed backup using RMAN.

•Identified and resolved deadlock issues in the database.

•Migrated database from 10g to 11g on HP Unix platform.

Client: Verizon Wireless

Role: Sr. Systems Analyst / Sr. Oracle DBA Duration: July 2008 – Oct 2008

Platform: PLSQL, Solaris Shell, RMAN, Share-Plex, ERWIN, DM Express, Data Guard

,Partitioning, Oracle 10g, Oracle RAC, Oracle 9i Team Size: 7

Synopsis:

Verizon wireless sells and services wireless phones across the USA. Worked as a oracle dba on Solaris Platform.

Responsibilities:

•Managed production, development and QA databases on Sun Solaris platform.

•Configured the replication environments using shareplex.

•Created standby database using data guard in Test environment.

•Fine-tuned applications developed in JAVA and PLSQL.

•Monitored databases using shell scripts and OEM Grid control.

•Developed SQL loader scripts and shell scripts to load data from flat files to oracle database.

•Installed oracle databases and patched the same using OPatch utility.

•Performed backup using RMAN.

•Identified and resolved deadlock issues in the database.

•Created PLSQL code for IVR and customer care applications.

•Responsible for providing production and development database support of mission critical applications running on Sun Solaris platform.

•Assisted in performance tuning of database environments to support platform upgrade from Sun 15K cluster to Sun 25K. Analyzed several processes using AWR reports.

•Supported Disaster Recovery implementation using Data Guard.

•Performed database migration from 9i to 10g. Analyzed the database for performance.

•Developed PLSQL scripts for data conversion.

•Developed various PLSQL procedures for this client

•Provided technical support for various application development groups.

•Designed and developed ETLs to support several data loads using DM Express.

•Developed shell scripts to automate the ETL jobs and database monitoring

•Performed data modelling both physical and logical for IVR application and customer care system

•Installed Oracle RAC in development environments and performed RAC testing in Production environment

•Developed SQL loader scripts and shell scripts to load data from flat files to oracle database

•Performed platform migration of databases to Sun Fire 25K from Sun 15K OS

Client: Solo cup Company Role: Application DBA

Duration: Nov 2004 – June 2006

Platform: PLSQL HP UX RMAN, ERWIN, Oracle 9i, OEM Team Size: 8

Synopsis:

Worked as a application DBA on performance tuning Oracle PLSQL and PL SQL development

Responsibilities:

•Responsible for supporting mission critical databases and applications of Solo Cup on HP/UX, Windows environment as production and application DBA.

•Built the UAT database environments. Developed utilities to refresh databases from Production to DEV, QA, and UAT using PLSQL, SQL and shell Scripts.

•Assisted in migrating database changes to QA, UAT and Production database environments.

•Performed code-review, capacity planning, security review, and database design review for several OLTP applications and data warehouse.

•Designed and implemented an error handling framework using PLSQL to support OLTP and various batch jobs.

•Assisted in establishing PLSQL development standards and guide-lines.

•Upgraded Oracle database from 9.2.0.3 to 9.2.0.7 and documented the database migration procedures.

•Administered SQL Server databases. Applied changes to SQL Server databases.

•Setup and maintained data replication

•Configured maintenance automation

•Configured Backup and Recovery for sql server

•Troubleshoot SQL Server performance issues as they occur, including after-hours and weekends

•Developed SQL loader scripts and shell scripts to load data from flat files to oracle database

•Managed People soft database environments. Migrated database changes to peoplesoft environments. Performed physical data modelling for sales data warehouse.

•Experienced in working on an application which supports Supply chaing and manufacturing and MRO

Client: Credit Suisse First Boston Role: Production DBA

Duration: Dec 2003 – Nov 2004 Platform: Oracle 8i, 9i, PLSQL Team Size: 30

Synopsis:

Managed Oracle databases on Solaris platform

Responsibilities:

•Primarily responsible for supporting the MANTUS and LCD data warehouse environments used by Credit Suisse on Oracle/Sun Solaris platform. In addition, supported several OLTP databases on Sun Solaris, Linux platforms.

•Performed database upgrade from Oracle 8.1.7.4 to 9.2, and assisted in implementing latest patch set for Oracle 9i database environments

•Supported Production Oracle Database environments on a rotation basis among a team of Database Administrators

•Administered SQL Server databases. Applied changes to SQL Server databases.

•Managed People soft database environments. Created backup procedures for peoplesoft database and cloned production database to UAT. Migrated database changes to peoplesoft environments

Client: GE Power Systems Role: Database Administrator Duration: Feb 2001 – Oct 2003

Platform: Oracle 8i, 9i, PLSQL, EWRIN Team Size: 8

Synopsis:

Managed Oracle databases on Solaris platform

Responsibilities:

•Performed physical data modeling for Several OLTP systems used by GE Power Systems [Contractual Services Division] using ERWIN.

•Designed and implemented the backup/recovery for production database environments using Shell Scripts/SQL. Automated the database backup.

•Designed and Implemented database monitoring using Shell Scripts and SQL.

•Installed and configured database environments on Sun Solaris platforms.

•Assisted the developers in performance tuning of code written in SQL/PLSQL, Java and Visual Basic. Developed stored procedures, packages and database triggers to support Contractual Service modeling System, a Sales forecasting tool used by GE Power Systems.

•Upgraded several database environments to 8.1.7.4. Installed and Configured Oracle 9i database environments.

•Designed and implemented the Replication environment to support the reporting.

•Migrated databases from Sun 4500 to Sun -15K cluster.

•Refreshed the databases from production to UAT and QA environments

•Developed Stored Procedures/Packages and database triggers to support OLTP applications.

•Developed SQL loader scripts and shell scripts to load data from flat files to oracle database

•Experienced in working on an application which supports Supply chaing and manufacturing and MRO

Client: W J Towell & Co Oman Role: Database Administrator Duration: July 1999 – Nov 2000

Platform: Oracle 8.0.4, Designer 2000

Team Size: 4 Synopsis:

Towell computer services is the IT division of W J Towell group in Oman responsible for design and development of ERP solution for Towell Group in Oman.

Responsibilities:

•Led a team of system engineers and database administrators in designing, building and deploying database environments on SVR4.2, Windows NT and Sun Solaris platforms for several clients.

•Supported production, QA and development databases, performed upgrades from Oracle 7.3 databases to Oracle 8. Mentored the other support staff on SQL and database Tuning.

•Assisted the development team in performance tuning of application developed using PLSQL, Oracle Forms and Oracle Reports.

•Performed capacity planning for the database.

•Designed and implemented backup recovery for the database environments using UNIX Shell Scripts/SQL.

Client: Oxford Health Plans Role: Software Engineer Duration: Feb 1997 – April 1999

Platform: Oracle 7.3 Parallel Server, SQL, PLSQL, Shell, Oracle Forms, Oracle reports Team Size: 6

Synopsis

Worked on design and implementation of PULSE a healthcare application used by Oxford Health plans using UNIX Shell, Oracle Forms, PLSQL and Oracle reports

Responsibilities:

•Developed various business processes of PULSE, a health care application used by Oxford Health Plans Inc. using Oracle Forms, Oracle Reports, PLSQL and Shell Scripts.

•Fine-tuned several processes written in PLSQL, Oracle Forms and Reports

•Re-designed several processes to meet the new business requirements of the client.

•Developed stored procedures, packages and PLSQL code to perform data conversion

•Developed PLSQL to support PULSE, a healthcare application

•Prepared UNIT test plans and assisted the QA with integration testing and system testing.

•Developed SQL loader scripts and shell scripts to load data from flat files to oracle database

Client: ORIENT Information Technologies, Bombay, India Role: Systems Analyst

Duration: June 1996 – Sep 1996

Platform: Oracle 7.3 SQL, Sybase 11

Team Size: 6 Synopsis

Worked on a design of a human resource management systems database for one of the clients of ORIENT in Dubai, UAE.

Responsibilities:

•Designed IHRS, Integrated Human Resource System as per the requirements of a manufacturing client. This system was integrated to Business/21 an ERP solution developed using power builder.

•Developed technical specification for Human Resource Module.

•Lead a team of database administrators and Analysts

Client: W J Towell & Co LLC Oman Role: Software Engineer

Duration: Oct 1992 – June 1996

Platform: Oracle 7.1 SQL, Oracle Forms, Reports, PLSQL, UNIX Shell Team Size: 5

Synopsis

Worked on design and development of an ERP solution for W.J.Towell Group companies on Oracle Forms and reports.

Responsibilities:

•Fine-tuned the database and applications developed in SQL Forms and Reports.

•Installed Oracle Software and databases on UNIX, windows and Novell platforms.

•Implemented TIMICS – an ERP application for several customers on UNIX and Novell Netware platforms. Production supported the ERP application for W.J.Towell group companies and external clients.

•Converted data from Concurrent 3210/DMS32 platform to UNIX/Oracle platform. Developed SQL Loader scripts, SQL, P/L SQL scripts.

•Supported Oracle Forms 3.0 to Oracle Forms 4.5 conversion on Windows platform for a insurance company.

•Installed and configured the designer 2000 repository. Used designer2000 repository to generate the DDL for TIMICS application re-architecture project. Sized the tables and indexes. Maintained the designer2000 repository.

•Experienced in working on an application which supports Supply chain and manufacturing and MRO.

Contact this candidate