Sr Developer/DBA
Resume:
Jyotin Arora
*** * ******** **, ********, Tx.
SUMMARY:
Over 9 years experience as ORACLE DBA (8i/9i/10g/11g) on different Operating systems including: AIX, Linux, Red Hat Enterprise Linux, Unix-AIX, HP-UX, Sun Solaris (5.6/5.7/5.8/5.9) and Windows 2000/NT/XP.
Support of Oracle 9i, 10g and 11g, SQL Server, and DB2 Databases on AIX, HPUX, LINUX, and Windows platforms
Responsible for providing database support and performance tuning on both an online-transactional and online-analytical processing environment
Developed rules and standards for the access and maintenance of shared data resources using Oracle.
Designed technologically advanced solutions to meet customer's mission, objectives, and requirements.
Improved automation, operation stability, and performance by researching new features and functionality with each release.
Ensured database configurations comply with published standards.
Developed transaction logging and backup/recovery facilities.
Participated in defining and implementing data security and logical to physical database mapping and table parameters.
Created database schemas and sub-schemas and Work with application development teams to ensure efficient data access in application programs and to review test benchmarks and statistics.
Reviewed overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirements.
Assisted in technical support in the definition and resolution of database problems.
Tuned and improved application SQL code, database configuration parameters and system disk configurations.
Acted as the primary interface between the Critical Systems team and the middleware/dba team.
Provided complete documentation on developed recommendations and solutions.
Provided technical assistance to IT support staff.
CERTIFICATIONS: Sun Certified Java Programmer (SCJP), OCP 9i/10g.
PROFESSIONAL EXPERIENCE:
Royal Bank of Scotland (RBS) Aug 2010- Jan 2011
Atlanta, GA
Role – Sr Oracle DBA
Responsibilities:
Configured optimal Oracle 10g/11g RAC architecture. and Golden Gate Replication.
Performance Tuning for Oracle Real Application Clusters (RAC).
Prepared plans for upgradation of all critical Production Databases from 10g to 11g on Linux and ACTIVE ACTIVE DATAGUARD implementation with RAC.
Interacting with Vendor support to resolve issues
Worked on changing NLS Character sets
Resolution of production issues which included interacting with Oracle Support as we as Metal ink Usage.
Environment: Oracle 10g R2, 11g R1,RAC,DATAGUARD, ASM, GOLDENGATE, Red Hat Enterprise Linux Windows
Server 2000, UNIX Shell Scripts, VERITAS NET BACKUP,TOAD, Tkprof and SQL*Net/Net8
Golden Living Inc May 2010-July 2010
Fort Smith, AR
Role – Sr Oracle DBA
Responsibilities:
Installation, upgradation and maintenances of Oracle databases on Linux and Windows platforms.
Performed upgrades with the team and upgraded all machines from Oracle 9i to Oracle 11g
Administered Oracle 9i and infrastructure support using Oracle OEM and Oracle 11g OEM.
Responsible to test and implement the new features of Oracle 11g including: working on aspects
of Database Replay, partitioning, Transaction Management, SQL Performance Analyzer, etc.
Explored and worked on innovative new features of Oracle 11g in terms of Automatic Health Monitor, Automatic Diagnostic Repository and other resiliency features
Provided system support for both development and 24/7 production environment.
Strong and extensive use of DDL and DML tools. Maintained database schemas and dictionaries.
Environment: Oracle 9i/11g, AIX 4.3/5L, Sun Solaris (SUNOS 5.9), Toad, WINDOWS NT/2000, RMAN,
ERWIN 3.2, SQL*Plus, UNIX Shell Scripting, SQL*LOADER, Oracle OEM.
Wells Fargo Bank Apr 2008 – Apr 2010
Los Angeles, CA
Role – Sr Oracle DBA
Responsibilities:
Installation, upgradation and maintenances of Oracle databases on Linux and Windows platforms.
Performed upgrades with the team and upgraded all machines from Oracle 10g to Oracle 11g
Responsible to test and implement the new features of Oracle 11g including: working on aspects
of Database Replay, partitioning, Transaction Management, SQL Performance Analyzer, etc.
Explored and worked on innovative new features of Oracle 11g in terms of Automatic Health Monitor, Automatic Diagnostic Repository and other resiliency features.
Backup of database using Logical and Physical (hot and cold) procedures and also RMAN.
Configured optimal Oracle 9i/10g RAC architecture.
Performance Tuning for Oracle Real Application Clusters (RAC).
Performed database monitoring, capacity planning and performance tuning.
Managed database security. Create and assign appropriate roles and privileges to users depending on the user activity.
Performed logical design, modeling, E-R diagram activities using Data Modeling Tools, normalization, indexing, foreign key, and constraints.
Implemented and tested backup strategies.
Ran scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation, etc.
Environment: Oracle 9i, 10g RAC, Red Hat Enterprise Linux Advanced Server, Windows Server 2000, UNIX Shell Scripts, Toad, and SQL*Net/Net8.
Pennsylvania Power & light (PPL) Apr 2007 – Mar 2008
Allen Town, PA
Role - Sr Oracle DBA
Responsibilities:
Set up and maintained Oracle disaster recovery site using DATAGUARD.
Performed performance tuning by using Oracle utilities like Stats Pack, Tkprof for addressing performance bottlenecks.
Utilized RMAN for backup and recovery strategy.
Performed database tuning by using various tools like: Oracle Enterprise Manager and STATSPACK.
Performed daily monitoring of Oracle instances using Oracle Enterprise Manager, TOAD, users, tablespaces, memory structures, rollback segments, logs, and alert.
SQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor.
Installed and configured 10g Enterprise Manager and Grid Control.
Established database backup/recovery strategy for different databases.
Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
Setup and support of Oracle replication (replication and conflict solution).
Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
Developed Shell scripts to monitor the storage usage and object status for daily job.
Environment: Oracle 9i /10g, HP-UX 10.2/11.0,SUNOS 5.8, Windows NT 4.0, Windows Server 2000, Erwin 4.14, Unix Shell Scripts, TOAD and SQL*Net/Net8.
Fannie Mae Mar 2006 – Mar 2007
Reston, VA.
Role – Oracle DBA
Responsibilities:
Administered all database installation, creation, modification, and tuning issues of Oracle.
Database Security Administration involved: creation of users and management of their roles and privileges.
Configured databases using latest features of Oracle 9i like Undo-Tablespace, Locally Managed Tablespace, and Sorting Parameters.
Experience with installing/configuring and maintaining Oracle 9i Real Application Cluster Database for high availability, scalability and performance which included: determining the Cluster architecture, choosing the best MPP RAC servers and hardware and configuring the raw disks for Oracle RAC.
Analyzed the database to allow Oracle optimizer to choose best plan in executing the queries.
Implemented Oracle Replication to enable database fail over incases of system or database crash.
Database activities included: allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
Experienced in using utilities like Export/Import and SQL Loader.
Environment: Oracle 9i/10g RAC, Linux Cent OS, SUNOS 5.7, WINDOWS NT/2000, RMAN, SQL*Plus, SQL*LOADER, Oracle OEM, Import/Export Data pump, STATSPACK.
Reebok International Ltd. Apr 2005 – Feb 2006
Canton, MA.
Role – Oracle DBA
Responsibilities:
Performed Database performance tuning and monitoring.
Designed and implemented security policies.
Utilized Oracle Export and Import utilities to perform logical database backup and recovery, move Oracle data from one machine, database or schemas to another and to detect database corruption
Controlled and monitored user access to the database.
Used File Transfer Protocol to transfer files from one location to another on local disks and across the Internet.
Created schemas with partitioned external tables for a production environment using SQL Plus.
Administered Oracle 9i and infrastructure support using Oracle OEM.
Configured and used Oracle Log miner and Oracle Flash Back for minor recovery of the objects.
Populated Oracle tables with data from external and non- Oracle files using SQL*Loader utility.
Environment: Oracle 9i/10g, AIX 4.3/5L, Sun Solaris (SUNOS 5.9), , Toad, Oracle OEM, RMAN
WINDOWS NT/2000, ERWIN 3.2, SQL*Plus, UNIX Shell Scripting, SQL*LOADER
Tata Consultancy Services Limited Feb 2003 – Mar 2005
Madhapur, Hyderabad, India.
Role – Oracle DBA
Responsibilities:
Responsible for Oracle 8i logical and physical databases design, implementation and maintenance on UNIX.
Installed, upgraded and patched Oracle software. Set up brand new machines including Oracle software installation.
Migrated and upgraded databases from version 7 to 8i.
Developed some UNIX Shell scripts to automate database operation and database monitoring.
Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
Installation and configuration of Statspack and analysis of Statspack performance report and subsequent tuning of production databases.
Environment: ORACLE 8.0/8i, HP-UX, Sun Solaris (SUNOS 5.6) RS 6000, ODBC, TOAD, SQL *PLUS, RMAN, Shell Scripts, Korn Scripts.
Videsh Sanchar Nigam Ltd. (VSNL) Aug 2001– Jan 2003
Hyderabad, India
Role - Junior Oracle DBA
Responsibilities:
Installed and maintained Oracle 9.x/8.x for development, testing and production purposes.
Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
Worked extensively on database sizing, rollback segments and queries.
Created and maintained UNIX scripts for Oracle maintenance and statistics.
Created stored procedures and triggers using PL/SQL for database managing utilizing TOAD developing environment. Worked with SQL queries in the Oracle database.
Oracle installations/upgrades/backup and recovery.
Configured databases for adequate performance and availability.
Helped developer to install Oracle Client, troubleshot and established the connection to Oracle database.
Implemented backup/recovery and database monitoring strategies using Unix Shell scripts and Oracle enterprise manager (OEM).
Environment: Oracle 8.x, 9i, SQL, Sun Solaris, Windows NT/2000, OEM, statspack, Rman, ftp, SQL*Loader, ERWIN.
EDUCATIONAL QUALIFICATIONS:
MS Computer Science (New Jersey Institute of Technology)
MCA (Masters in Computer Applications, IGNOU), India.
Bachelors in English Honors (Delhi University), India.
Contact this candidate