Resume

Sign in

Senior Oracle DBA consultant

Location:
Harrison, New Jersey, United States
Posted:
March 13, 2019

Contact this candidate

Resume:

Ram Narayan Chandrashekar

*** * ****** **, ***# *328, Richardson, TX 75080

+1-469-***-**** ac8rs3@r.postjobfree.com Linkedin Profile DATABASE LEAD

Senior Oracle specialist with 11 years expertise in project management, performance tuning and crisis management. Introduced system efficiencies; maximized productivity; increased reliability through database high availability. Optimized mission critical databases in energy & utility sector and telecom domain. Skills include:

DBA Architect / Consultant

Oracle Database Administration

Performance Tuning & Capacity Monitoring

Data Security, Backup & Recovery

Oracle RAC & ASM Administration

Database-Backed Web Solutions

SQL Tuning in Oracle Environment

Good skills in all Oracle tools

CERTIFICATION:

DBA Workshops : Oracle 11g Release 2 Administration Workshop II

DBA Certifications : Oracle Certified Professional 10g DBA with 93% (1Z0-042) & Sun Certified System Admin for Solaris 9 (Level - 1) PROFESSIONAL EXPERIENCE

International Business Machines (IBM). Dallas, Texas – September 2010 - Till date Oncor Electric Delivery, Dallas, Texas.

Period : September 2010 - Till date

Role : Database Lead / Architect

Responsibilities

Architect and manage Oracle database administration assignments for major energy utility industry client in Texas. Play a lead role in enterprise-wide database optimization and instance and resource monitoring. Perform root cause analysis on failures. Resolve performance tuning related issues, reports, and queries.

Managed a team of 8 DBAs providing production database administration and proactive resolution of issues

Architected a data flow project through multiple applications to process HR data for new joinees

Troubleshot severity 1 or severity 2 issues with production & development database tables which are used for reporting purposes and provide the root cause analysis to the client

Standardized RMAN backup scripts across the enterprise to make consistent and regular backups

Collection of Statistics at object level, user level, Database level to improve database performance.

Patched Oracle database with latest PSU patch at the enterprise level for more than 300 databases

Cloned databases using RMAN Active duplicate procedure.

Developed and tested time-saving techniques like materialized views, table partitioning, indexing

Automated regular maintenance activities like index rebuild, gather stats, data purging and partition creation

Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.

Implemented dataload procedures using sqlldr, external tables.

Worked on Oracle enterprise manager (OEM) configuration

Proficient in database performance tuning using STATSPACK, AWR, Explain plan, TKPROF & performance views

Utilized Data Pump and Export /Import utilities, replication of tables to cross platform and Creating Materialized Views, PL SQL and stored procedures and SQL scripting,

Diagnosed and troubleshot typical SQL Tuning issues

Created and Monitoring the Maintenance plans – scheduling tasks to run daily and/or on weekends tasks like rebuilding indexes, defragmenting Databases

Environment: Oracle 12c / 11g / 10g / 9i RDBMS databases, Sun Solaris 10, IBM AIX servers, Toad for Oracle, JIRA, Quest Spotlight, Oracle Enterprise Manager, BMC Remedy ticket console, Automic and Puppet automation tools. Infosys Technologies Ltd. Pune India -- June 2006 to September 2010 Level 3 technologies, Broomfield, Colorado.

Period : December 2008 to September 2010

Role : Database Administrator

Engineered Oracle databases for an international communications company headquartered in Colorado, USA and operates one of the largest communications and Internet backbones in the world.

Monitored Production databases 24 X 7 administration and support resolution of database issues.

Maintained 100 production and 300 dev and test instances of Data warehousing group application.

Supported very large databases with an average size of 5TB, Largest being 47TB by creating hourly partitions.

Partitioned of large and heavily accessed tables

Performed Cold Backup, Hot Backup and Logical Backup as and when required.

Operated performance runs on production environment, monitoring OEM for detailed analysis of the run being performed to make sure the site holds the predicted load during the peak season load.

Managed and processed user and schema management for clients

Collaborated with multiple team for capacity management to predict growth of databases Environment: Oracle 11g / 10g / 9i RDBMS databases, Sun Solaris 10, IBM AIX servers, Toad for Oracle, Oracle Enterprise Manager, BMC Remedy ticket console

BRITISH TELECOM

Period : October 2006 to November 2008

Role : Junior Database Administrator

Created and maintained all databases required for development and testing of the applications

Performed database re-orgs to assist performance

Catalogued Alert Log file for errors and made necessary actions to rectify them.

Collected Statistics at table level, schema level to improve database performance.

Managed the logical objects of the Databases

Managed space in the mount points and ASM disks.

Audited alert log and trace files for errors.

Environment: Oracle 11g / 10g / 9i RDBMS databases, Sun Solaris 10, IBM AIX servers, Toad for Oracle, Oracle Enterprise Manager, BMC Remedy ticket console

EDUCATION :

Koneru Lakshmaiah College of Engineering (Acharya Nagarjuna University), Bachelor of Technology, Major in Mechanical Engineering



Contact this candidate