Resume

Sign in

Oracle DBA

Location:
Los Angeles, CA
Salary:
$75 / hr on C2C
Posted:
February 19, 2020

Contact this candidate

Resume:

RAJAPUSHPAM SUBRAMANIAN

Contact No: +1-469-***-****

Email: adbu2f@r.postjobfree.com

Summary:

10+ years of experience in Oracle PL/SQL, Design, Development & Administration of Oracle Database 10g and 11g

1+ years of experience in Teradata and Teradata utilities

Good knowledge of NoSql Technologies – Have hands on experience on Cassandra, MongoDB

Good knowledge of replication techniques such as Oracle Golden gate and Data Guard.

Good experience in Shell scripting

Experience in Full range Oracle Database Administrative activities like monitoring and issue resolution of production databases, troubleshooting of performance issues, backup and recovery.

Experience in database administration and monitoring using Oracle Enterprise Manager 13c

Good Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning.

Familiar with writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance of data access.

Have extensive experience in developing, implementing and maintaining application systems under Windows/Unix operating systems using SQL, PL/SQL, Oracle Database and have good exposure in Oracle utilities such as Import/Export, SQL*Loader and SQL*Plus.

Experience in working in both Waterfall and Agile methodology for software development

Develop scalable reporting processes and querying data sources to conduct ad hoc analyses

Experience in Telecom domain and well versed with Telecom terminologies

Experience in working on 24*7 environments to provide production support.

Experience in Version Control Tools like CVS and Tortoise SVN.

Clear communication and documentation of technical specifications.

Highly motivated, excellent team player, enthusiastic and quick learner of new technologies. Strong interpersonal and communication skills in dealing with clients

Technical Skills:

Languages and Technologies: SQL/PLSQL, Java

Operating System: UNIX, LINUX

Databases: Oracle 10g,11g,Teradata

Tools: TOAD 12,Sql Developer, Putty, OEM

Version Control: Visual SourceSafe, CVS, SVN

Professional Experience

Oracle Application DBA

Client: AT &T Project: Enterprise Payment System (EPS)

Location: Los Angeles, California Duration: Mar 2019–Present

DTV- EPS application deals with calculation of commissions for distributors, dealers and installers based on business rules using True Comp Rules Engine, preprocessing database and PL- SQL queries to collect and transform data from upstream systems. Working as Application DBA to assist with user management, DB performance tuning and compliance activities.

Responsibilities:

Involved in application database administration, responsible for user security and roles

Highly skilled in Performance tuning - analyzing query plans and SQL tuning using EXPLAIN PLAN and hints.

Involved in analyzing Database reports – AWR, ASH and ADDM to identify performance issues and tune the code accordingly

Worked along with developers to fix or improve database related issues.

Worked on database management activities like reallocating tablespaces, partition maintenance.

Performed database refresh activities using Data Pump utilities (expdp/impdp) and SQL Loader.

Environment: Oracle 11g, 12c, SQL Developer, Putty, Oracle PL/SQL,

Oracle tools: Oracle Enterprise Manager 13c

Oracle Application DBA

Client : AT &T Project : GIS

Location: St. Louis, Missouri Duration: Dec 2015–Feb 2019

AT&T – OVALS GIS project involves providing accurate spatial location and address information to qualify a living unit for AT&T internet services.

Responsibilities:

Involved in application database administration, responsible for user security and roles

Involved in applying oracle patches to the database at periodic intervals

Highly skilled in Performance tuning - analyzing query plans and SQL tuning using EXPLAIN PLAN and hints.

Involved in analyzing Database reports – AWR, ASH and ADDM to identify performance issues and tune the code accordingly

Have good experience in using OEM for database analysis and maintenance

Developed Stored Procedures, Functions and Packages.

Have good experience in materialized views

Provide technical assistance and support to the end user community and application development teams related to database and applications.

Performed database refresh activities using Data Pump utilities (expdp/impdp) and SQL Loader.

Worked along with developers to fix or improve database related issues.

Managing user accounts and security privileges, preparing backup and recovery strategies.

Hands on experience in Oracle application maintenance activities such as trouble shooting user issues and code deployment

Environment: Oracle 11g, 12c, SQL Developer, Putty, Oracle PL/SQL,

Oracle tools: Oracle Enterprise Manager 13c

Oracle Application DBA

Client: AT &T Project: FEI

Location: St. Louis, Missouri Duration: Nov 2014–Dec 2015

AT&T – FEI project includes a web-front and batch processing functionality and provides an automated way to p-commit pairs and assign LS codes prior to lightspeed launch so that living units with qualified pairs are available in FSP (Fiber Service Platform) and used to qualify a customer at launch. This is front –end application hosted in the intranet for usage by SBC C&E Engineers across 22 states where AT&T is supported.

Responsibilities:

Involved in application database administration, responsible for user security and roles

Responsible for migrating database servers from Unix to Linux platform – Managed data migration and handled the server migration without any issues.

Highly skilled in Performance tuning - analyzing query plans and SQL tuning using EXPLAIN PLAN and hints.

Involved in analyzing Database reports – AWR, ASH and ADDM to identify performance issues and tune the code accordingly

Developed Stored Procedures, Functions and Packages.

Have good experience in materialized views

Provide technical assistance and support to the end user community and application development teams related to database and applications.

Performed database refresh activities using Data Pump utilities (expdp/impdp) and SQL Loader.

Worked along with developers to fix or improve database related issues.

Managing user accounts and security privileges, preparing backup and recovery strategies.

Hands on experience in Oracle application maintenance activities such as trouble shooting user issues and code deployment

Environment: Oracle 11g, SQL Developer, Putty, Toad for Oracle, Oracle PL/SQL, Oracle tools: Oracle Enterprise Manager 11g

Oracle PLSQL Developer

Client: AT&T Project: VTS

Location: Chennai, India Duration: Jan 2013- Nov 2014

This is a maintenance/development project which involved application for tracking the AT&T technicians’ vehicles and generating reports for the purpose of indicating where AT&T vehicles were located on the previous day by displaying location information on maps and/or tabular reporting using GPS and GIS technology. This helps to increase productivity in the field by making this information available to field supervisors in an easy – to use format.

Responsibilities:

Involved in system analysis design, coding, data conversions, development and implementation

Created tables, Functions, Triggers, procedures and packages for implementing complex database intensive business rules

Worked on migrating database server from Unix to Linux: managed data migration and replication setup using Oracle Streams.

Developed procedures to run the SQL * Loader to load data from flat files into the target database tables

Developed complex mappings to load data from Source System (Oracle) and flat files

Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.

Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.

Performance tuning of the application programs using EXPLAIN PLAN and SQL TRACE

Increased performance by creating Indexes and Hints.

Support for the development, pre-production and the production databases

Environment: Oracle 10g (SQL, PL/SQL), SQL*Loader, Oracle Streams, TOAD, UNIX

Teradata SQL Developer

Client: Verizon Project: BUSDW

Location: Chennai, India Duration: Mar 2010-Dec 2012

Verizon Business Datawarehouse maintains complete Verizon business data for Enterprise, SMB and Residential customers. Datawarehouse stored key data that is used in making strategic decisions and sales commissioning purposes.

Responsibilities:

Create Entity Relationship (ER) Diagrams to the proposed database

Create database objects such as tables, views, stored procedures, Triggers etc.

Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.

Identify columns for Primary Keys in all the tables at the design time and create them.

Create functions to provide custom functionality as per the requirements.

Developing reporting models, architectures, frameworks and strategies based on business requirements.

Developing technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.

Analyzing and trouble-shoots technical issues related to reporting. .

Developing and maintaining databases, tables, queries, stored procedures, views and changes in the reporting model.

Providing team mentoring and cross-training.

Environment: Teradata

Oracle - Java Developer

Client: Verizon Project: SSP

Location: Chennai, India Duration: Mar 2009 –Feb 2010

Verizon SSP is a common Ordering platform which handles customer’s orders placed by the front desk team. Project includes different application modules that takes care of ordering, provision and billing of the customers.

Responsibilities:

Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems

Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design

Created SQL*Loader scripts to load data into the temporary staging tables.

Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.

Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Created various SQL and PL/SQL scripts for verification of the required functionalities.

Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Developed complex SQL queries for data retrieval from various database objects including tables and views.

Worked on various backend Procedures and Functions using PL/SQL

Used Data dictionaries and DBMS packages very effectively.

Environment: Oracle 11g, PL/SQL, SQL*Plus, Java, Eclipse IDE, SVN



Contact this candidate