Manager Management

THALIYAKKATTIL VIJAYAN PRASANTH

Oracle Database Consultant & Administrator

Contact:972-***-****

Email:**********@*****.***

Professional Summary

Experience Summary:

Around 17 years of experience as an Oracle Database Administrator providing 24/7 support for production 11g/10g/9i/8i/7.x databases on various platforms of operating systems such as Red Hat Linux, Sun Solaris, HP UX and IBM-AIX.

Formal training in Oracle Database Administration 9i,10g and 11g and education in Master in Computer Applications.

Experience installing, patching and upgrading of Oracle software 9i, 10g and 11g on Unix, Linux and Windows environment.

Experience installing Oracle Real Application Clusters (RAC) databases on Linux and Sun Solaris operating system.

Strong experience configuring, administration, maintenance & recovery of single-instance & Real Application Clusters (RAC) Databases.

Strong experience configuring data guard environments for disaster recovery and high availability, experience setting up physical & logical standby, active data guard.

Experience using Oracle utilities DataPump, SQL Loader, RMAN, Original export/import for database administration and maintenance.

Extensive experience planning and execution of Database Backup and Recovery using RMAN tool.

Strong knowledge of SQL, PL/SQL and Shell scripting for database administration and maintenance.

Performance tuning experience with OEM,STATSPACK/AWR/ADDM.

Strong experience user and database security management.

Experience cloning databases for development/testing environments using traditional backup methods as well as using RMAN tool.

Strong knowledge of Oracle database best practices for administration, high availability, disaster recovery and performance tuning.

Strong knowledge of Systems Development Life Cycle (SDLC).

Understanding of change management principles associated with new technology implementations.

Working knowledge Golden Gate replications.

Well versed with Oracle security features like data masking, redaction, audit vault and database firewall.

Domain knowledge in Telecom Billing & Mediation, Order Management System, Balance Manager, Core Banking and Foreign Exchange operations

Good understanding of Bigdata Administration and Other dbs like PostgreSQL and Maria db.

Skillset

OS: HP-UX, Tru 64 Unix, IBM AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise Linux 6.X, 7.X, and Windows 2003

Languages: SQL and PL/SQL, UNIX Shell, SED/AWK and Perl Scripts, HTML with CSS

Databases (RDBMS): Oracle 9.x, 10.x, 11.x, 12.x. Microsoft SQL Server 2005

NoSQL : MongoDB 3.4, 3.3,Maria DB 10.1.20, Postgresql (EnterpriseDB 9.5.4.9)

Schedulers: Crontab, Oracle Scheduler, OEM, Windows Task Scheduler

Clusters: Oracle Clusterware and OCFS

High Availability: Oracle 10g/11i, 12c, RAC, Standby Database, Clustering and Data Guard Setup, Automatic Storage Management

Replication: Quest Shareplex Replication Queue, Oracle Transactional Replication with Golden Gate Replicator, Oracle Streams

Tools & Utilities: Toad, SQL Navigator

Educational Qualifications: .

Master of Computer Application Madurai Kamaraj University 2000 68%

Bachelor of Science Calicut University 1996 63%

Certifications:

Oracle 9i Certified Associate OCA Database Administrator

Oracle 9i Certified Professional OCP Database Administrator

Appreciations Awards:

Received various appreciations & awards for my exceptional work at onsite and offshore both location. Received spot awards, innovation awards. Receive star associate award by client. Receive quarterly leadership recognition award.

Professional Experience

Client : AT&T

Role : Lead Oracle DBA

Location : Richardson, TX

Duration : Dec 2016 – Till Date

Project : Nitrous Applications, U2L & L2L (Unix to Linux) migration

Responsibilities:

Design solution for enterprise service bus project for client.

Performance analysis using AWR, OEM Grid and tkprof etc Oracle Databases.

Conducted backup/recovery through RMAN or Export & Import.

Implemented the database access security through triggers. Created triggers for job modifications.

Applying Project management knowledge and skills to production and Other environments.

Database support specialist on many project conference calls.

Oracle 11g, 10g,Maria DB & PostgresSQL installation and administration.

Create migration plan and work with different teams for migration of databases.

Oracle Performance tuning expert for 10g and 11g databases.

DB Support specialist for ONCALL, night and weekend projects

Perform database analysis, design, coding, testing and implementation of database structures.

Work with Dev and architecture team to create database design documents.

Capacity planning, monitoring and management.

Manage day-to-day administration on production databases.

Monitor cpu, memory, disk i/o, paging, swapping using various Unix commands.

Use Oracle’s Enterprise Manager (OEM), AWR, ASH reports for database maintenance and performance tuning.

Prepare and maintain project plans and track activities against the plan, providing regular and accurate reports to customers and line management as appropriate.

Raise SR against Oracle to resolve issues.

Configuration and management of standby databases using Data-Guard and perform Failover tests for high availability.

Code and edit shell scripts to automate schedules for database administration and monitoring.

Manage user management for database security.

Applied data masking and redaction technology to protect data.

Resolve end users’ issues with providing 24x7 supports for designated production databases. Ensure data availability as per the service level agreement.

Design develop and implementing process improvements within the database environment.

Provided recommendations for data synchronization between applications.

Working on Maria db & EDB Postgres migration tasks.

Install, maintain and Troubleshoot Golden Gate.

Migration of 11.0.2.4 databases to 12c(12.1.0.2)

Provided assistance for integration of auditing and alert systems in NoSQL databases.

For NoSQL databases, designed storage infrastructure systems and configured database performance systems.

Created comprehensive health check report across all production env. in shell and PowerShell and scheduled it.

Environment: Oracle 11g, 10g, Toad, Data-guard, Golden Gate, RMAN, Remedy, WinScp, SQL*Loader, Windows 2003, RHEL 5.x, ERWIN,EDB PostgreSQL & Maria db.

Client : AT&T

Role : Lead Oracle DBA

Location : Richardson, TX

Duration : Feb 2012 – Nov 2016

Project : Mediation, Balance Manager U2L (Unix to Linux) migration

Responsibilities:

Applying Project management knowledge and skills to production and Oracle data warehouse projects.

Oracle database support specialist on many project conference calls.

Writing Project Management Delivery documents such as Project management ROADMAP, database cloning techniques, Oracle 11gR2 installation step by step, PM issues, risks, and lessons learned. Oracle 11g, 10g, 9i installation and administration.

Oracle Performance tuning expert for oracle 9i, 10g and 11g databases.

Oracle Support specialist for ONCALL, night and weekend projects

Installation/Configuration/Compliance documentation of Oracle Enterprise Manager 12c cloud control on 11.2 databases on Unix/Linux

Suggested and implemented Oracle Best Practice for Red Hat Linux 7 systems for Oracle Performance

Suggested and implemented faster backups with RMAN and incremental backups.

Create and maintain solutions for database software installation, Patching and database creation.

Capacity planning, monitoring and management.

Perform transaction-sizing measurements.

Supporting Oracle Spatial like loading data, indexing and performance tuning.

Install and upgrade oracle spatial feature.

Manage day-to-day administration on production databases.

Monitor cpu, memory, disk i/o, paging, swapping using various Unix commands.

Work with architecture team for server and database configuration.

Use Oracle’s Enterprise Manager (OEM), Statspack Reports, Explain Plan, SQL Trace and TKPROF for database maintenance and performance tuning.

Prepare and maintain project plans and track activities against the plan, providing regular and accurate reports to customers and line management as appropriate.

Raise SR against Oracle to resolve issues.

Configuration and management of standby databases using Data-Guard and perform Failover tests for high availability.

Support/maintain/Trouble shoot Golden Gate

Design, create and maintain design documents for the database changes.

Code and edit shell scripts to automate schedules for database administration and monitoring.

Manage user management for database security.

Applied data masking and redaction technology to protect data.

Resolve end users’ issues with providing 24x7 supports for designated production databases. Ensure data availability as per the service level agreement.

Design develop and implementing process improvements within the database environment. Attend organizing meetings to sort out Capacity planning, Database performance and reliability and Change management issues.

Provided recommendations for data synchronization between applications.

Working on Maria db migration tasks.

Environment: Oracle 11g, 10g, Toad, Data-guard, ERWIN,RMAN, Remedy, WinScp, SQL*Loader, Windows 2003, RHEL 5.x.Oracle Spatial,GoldenGate.

AT&T (Tech Mahindra Ltd.), Richardson, TX

Nov 2008 – Jan 2012

Lead Oracle DBA

Project : ATT Light Speed Project - Billing & Order Management Systems

Responsibilities:

Lead the Planning migrations and upgrades of Oracle Databases to target data centers using backup/restore, exp/imp, SQL Loader, log shipping, TTS etc. and DB/Storage migration tools.

Installation and patching of Oracle database products and components, creating databases, tablespaces, users etc.

Tuning target database environments for better performance and availability.

Coordinate and assign the task to offshore as per release to release basis and day to day basis.

Using Tiger(Amdocs) apply patches and upgrade the systems.

Production support for Enabler, ACS and OMS systems.

Create test data from production after masking the sensitive data.

Work closely with developers to tune SQL queries.

Performing logical backups using Datapump utility

Developed SQL and shell scripts for database monitoring.

Schema management, space management as per the requirements of team.

Assigning appropriate privileges through the use of roles.

Monitoring object usage & allocating space as per requirement.

Creating tables and views and supporting developers.

Implementing a backup policy with incremental backups.

Sizing database objects for effective space management and optimal performance.

SGA tuning including tuning the shared pool, database buffers and redo buffers.

Using shell scripts and SQL scripts to schedule backups.

Utilizing Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports

Cloning production databases for development, test environment with RMAN Duplicate feature.

Environment: Oracle 9i, 10g, Sun Solaris, Windows 2003, SQL developer, Datapump, Remedy.

AT&T (Tech Mahindra Ltd.), MiddleTown, NJ

Jun 2006 – Dec 2008

Oracle DBA

Project : ATT GCP (DBOR)

Responsibilities:

Oracle 10g, 9i installation,upgradation and Configuration.

Apply Patches to existing versions.

Collect database performance statistics from production databases for trend analysis.

Hot Backups & Exports, Restores & Refreshes for regression tests.

Development support, Coding standards, application & database tuning.

Preventive Maintenance & re-orgs.

Ensuring successful & periodical Backup, Restoration & Tuning.

Develop, Implement and administer database policies and procedures

Using Statspack for analyzing database performance and tuning with ADDM suggestions.

Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems.

Perform database analysis, design, coding, testing and implementation of database structures.

Finest granularity approach to Oracle implementation and defragmentation.

Capacity planning, capacity monitoring and management.

Perform transaction-sizing measurements.

Managed day-to-day production databases.

Monitoring CPU, memory, disk I/O, paging, and swapping using various UNIX commands.

Analyze disk space requirements.

Oracle’s Enterprise Manager (OEM), Statspack Reports, Explain Plan, SQL Trace and TKPROF.

Environment: Oracle 10g, 9i, Toad, RMAN, Remedy, WinScp, SQL*Loader, Windows 2003, Solaris5.x

BT (Tech Mahindra Ltd.), Pune, India

Jun 2004 – Jun 2006

Oracle DBA

Project : WAS/RAS / NCRS 2000 systems, BT

Responsibilities:

Installed 9i, 10g, database on Windows 2000 and SUN SOLARIS.

Wrote control files for SQL * loader to load data into data warehouse.

Provided database related services to their development and QA environments.

Was actively involved in constant site enhancements along with developers – code and data push between different servers and testing and moving to production.

Logical and Physical backup procedures.

Data exports from production and staging databases.

Tuned SQL queries to pull data from data warehouse tables.

Tuned production database performances and was instrumental in SQL tuning that improved application response.

Run oracle stats pack to tune the databases.

Wrote SQL scripts for DB monitoring, and online backups.

Implemented database related security measures that proved very effective.

Implemented Oracle Replication to enable database fail over in case of system or database crash.

Backup and recovery using cold, hot and export methods.

Wrote database triggers, functions and procedure by using PL/SQL.

Automated a no. of database related jobs.

Set multiple destinations for archives redo logs for safety

Environment: Oracle 9i/10g, SQL, PL/SQL, Toad, Windows 2000 and SUN Solaris

Sofil Informations System Pvt. Ltd, Chennai, India Dec 2003- Mar 2004

Oracle Consultant

Project : e-filing System for Hitachi Unisia Automotive Ltd, Japan

Zeros and Ones, Tokyo, Japan May 2003- Aug 2003

Project Coordinator & DBA

Project : Calendar Interface System for Morgan and Stanley

Shecom K.K, Kobe, Japan Apr 2002- Apr 2003

DBA

Project : Dejibook Web Interface System for Digital book Inc., Kobe, Japan

Tata Infotech Ltd, Mumbai, India Jan 2000- Mar 2002

Jr.DBA & Developer

Project : Easy Deal, Xnars &

Declaration .

The above statements are true to the best of my knowledge and belief.

Place: McKinney, TX Name: Thaliyakkattil Vijayan Prasanth

Contact this candidate