Sr. Oracle DBA

Nagesh Allamneni Phone: 703-***-****

Senior Oracle Database Administrator Email: ***************@*****.***

Professional Summary:

Over 8 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.

Extensive knowledge on database administration for Oracle 12c, 11g, 10g, 9i, 8i with experience within very large-scale database environment and mission critical large OLTP and OLAP systems.

Excellent experience in installation, setup and configuration of Oracle in 12c, 11g, 10g, 9i, 8i HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux environment.

Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11g RAC environment.

Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.

Managed very large database (VLDB) of maximum size 5TB with 18 servers including 6 Productions, 6 testing, 6 Development and 3 Standby databases.

Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.

Logical and physical modeling using Erwin. And Expertise using tools like Erwin, ER/Studio and Toad.

Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.

Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL*LOADER.

Good experience of creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.

Database replication using snapshots, materialized views and advanced replication methods.

Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.

Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

Technical Skills:

RDBMS

Oracle 12c/11g/10g/9i/8i, Oracle 11g (RAC, Data Guard & Streams), and DB2.

OPERATING SYSTEMS

OEL 6.x, Red Hat Linux RHEL 6.x 5.x, 4.x, 3.x, HP-UX 11.x, 10.x Sun Solaris 10, 9, 8, 2.6, 2.5 AIX 5.3, 5.2, 5.1.

LANGUAGES

SQL, PL/SQL, T-SQL, C, C++, VB, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS

DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, VCS, Shareplex, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, ERwin, TOAD Data Modeler, Rational Rose, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

WEB TOOLS

HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio.

Professional Experience:

Citigroup, Columbus, OH Oct’14 – Till Date

Sr.Oracle DBA

Citi, the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Citi provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services and wealth management.

Responsibilities:

Installation, configuration, maintenance and tuning of Oracle 12c, 11g and 10g on Red hat 6.x, IBM-AIX 7.1.

Create and Configure a Pluggable Database (PDB) in Oracle Database 12c.

Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7) on IBM-AIX nodes.

Involved in Installation and configuration of Oracle 11g RAC using Cluster ware and ASM.

Responsible for Golden Gate configuration, monitoring, tuning, and capacity planning & security replication and changing the database character set from WE8ISO8859P1 TO WE8MSWIN1252

Responsible for configuration, maintenance including monitoring, performance tuning using Enterprise Manager Cloud Control 12c also provides support for plug-in and connector management

Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.

Experienced in the installation of Oracle Grid Control in Server (OMS Oracle management Server) and installing the Agents in all the production, test and development databases and configuring them.

Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard on both physical/logical standby databases in high availability mode.

Implemented Data guard, creating both Logical and Physical Standby databases in 11g RAC environment for the Production databases.

Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.

SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, EXPLAIN PLAN, AWR, ADDM and monitor the database performance on daily basis.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.

Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.

Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.

Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling and Authentication.

Applying security patches both Server side and Client side and Performed testing.

Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink) and managing database security.

Environment: OEL 6.x, Red Hat Linux 6.x, 5.x and AIX 7.1/6.1 Oracle 12c, 11g and 10g, TOAD 9.7.2.5, Oracle Enterprise Manager (GC), RMAN, RAC, Data Guard, ASM, SCP/SFTP, Shareplex, Erwin 4.0, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader, T-SQL, Bugzilla, Visual Source Safe.

AT&T, Atlanta, GA Sep’12- Oct‘ 14

Role: Sr. Oracle DBA

Description:

This telecommunications company provides Data Services, quality solutions, operations to the various departments.

Worked in AT&T data systems engineering group as Database Administrator for QA/QC engineering team on multiple projects like Mobile Search, Content Search, My Account, RIM and store locator.

Responsibilities:

Responsible for administration and supporting Oracle 12c, 11g and 10g databases.

24x7 Production database administration, support and monitoring to ensure a proactive problem

Recognition and resolution of database issues.

Installation, Upgrade and Configuration of Oracle 12c, 11g, and 10g Databases.

Configure strong authentication for database users using 12c PKI and Kerberos

Export and import wallets/keys between pluggable databases.

Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.

Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.

Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.

Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level.

Implemented backup strategies using hot/cold, exp/imp used on the business req.

Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR) using RMAN.

Implemented Streams replication between RAC and non-RAC database environments.

Installed Oracle 11g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.

Assisted a team of DBA’s in migration of databases from Oracle 10g Release 2 to Oracle 11g Release 2.

Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetrix.

Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack.

Provided database/application tuning including as reducing lock contention, analyzing objects.

Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.

Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.

Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.

Used Oracle Advanced Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.

Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.

Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink) and managing database security.

Environment: OEL 6.x, Red Hat Linux 6.x, 5.x Oracle 12c, 11g and 10g, DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL*Plus, PL/SQL, ASM, J2EE, ToadV9.7 & SQL, Navigator V6.1.

Emigrant Savings Bank, NY July’10 – Aug’12

Role: Oracle DBA

Description:

Our DBA’s are responsible for maintenance of Database Servers behind our online banking website and all of the internal bank applications.

Monitor and report on database application usage and availability.

Design and implement scripts to perform ETL.

Responsibilities:

24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Migration of Oracle databases from windows to Linux.

Applied patches to Oracle Databases and Oracle Applications.

Upgrading development and production databases to Oracle 10g.

Proactive database monitoring using 11g grid monitoring tool.

Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF.

Extensive Performance Tuning, Memory (SGA) Tuning, net backup, EMC (Time finder and SRDF), RAID, RAW Devices.

Performed database cloning to setup test and development databases.

Responsible for optimizing the queries and application tuning.

Performed SQL tuning and assist developers with coding PL/SQL.

Provided support to Application Database Administrators in designing the database.

Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup validations using RMAN.

Management of schemas, objects partitioning the tables & indexes.

Automation of data load using Korn shell scripting and SQL*Loader.

Responsible for setting and managing user accounts, and granting required privileges to users.

Performed other DBA activities like including space management and performance monitoring.

Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.

Environment: Oracle 11g/10g, Sun Solaris 8.0, HP UNIX 11.x, Oracle Enterprise Manager, SQL* Loader,

T-SQL, STATSPACK, TKPROF, EXPLAIN PLAN.

Pryscom Info services, India. Oct’08 – June’10

Role: Oracle Developer/ DBA

Description:

This Project included building, maintaining and testing databases, involved in the entire development life cycle right from development to production,

Supporting and tuning oracle applications.

Responsibilities:

Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.

Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i.

Modified Korn shell scripts as per technical specifications.

Prepared Data Flow Diagrams for existing PL/SQL code.

Involved in coding of data extraction scripts as per technical specifications.

Analyzed the table structures using Analyze command.

Involvement in all phases of the project life cycle.

Designed database tables as per technical specifications.

Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.

Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: Oracle 10g/9i, HP-UX 10.x, PL/SQL, T-SQL, Database Tools/Utilities, OPS, Shell Scripting.

Virtusa Pvt.Limited, INDIA. Oct’07– Sep’08

Role: Oracle Developer/ DBA

Description:

As a Junior Dba mainly writing queries, tuning database, working on hardware design of new database cluster, installing new application for customers

Maintaining of 20 database servers, physical and virtual, Clustered and standalone, with the database that range from few MB to over TB.

Responsibilities:

Collaborated with application developers for tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc.

Installed/Upgrade, and maintained Oracle 10g, 9i on Sun Solaris 5.9, Applied patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.

Contributed in the logical and physical database design using Erwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling.

Wrote UNIX shell scripts to schedule jobs within Oracle environment.

Established database backup/recovery strategy for different databases.

Contributed to management of table space growth, monitoring data files additions, extent growth.

Constantly monitored the performance of the databases and viewed alert log files & trace files.

Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.

Environment: Oracle 10g/9i, Sun Solaris 5.9, T-SQL, Database Tools/Utilities, OPS, Shell Scripting.

EDUCATION:

Bachelors in Computer Science and Information Technology, JNTU, INDIA.

Contact this candidate